|584||14 Mar 2013 @ 03:35 PDT||Analytics||Reply||conversion of datatype||Don't post many times the same question. Solution was given at
Numeric Overflow error in teredata
|583||14 Mar 2013 @ 03:30 PDT||Database||Reply||Numeric Overflow error in teredata||check the data types of
It looks like the sums are exceding the maximum values... |
|582||03 Mar 2013 @ 11:53 PST||General||Reply||Did anyone store RDF data (Resource Description Framework) data on Teradata ?||@Adeel - no it isn't. You can convert it but it is even more generic.
All data is represented as subject predicate objects records.
And yes, I stored RDF data in Teradata. Question is what you... |
|581||15 Feb 2013 @ 07:08 PST||Database||Reply||Can you join using wild cards col_a like %col_b%||Strange data model: Depends on the use case.
Can be very sufficient for specific problems. For example data quality checks ELT processes. Filter out email addresses containing specific patte... |
|580||14 Feb 2013 @ 03:13 PST||Database||Reply||Can you join using wild cards col_a like %col_b%||try
cards col_a like '%' || col_b || '%'
|579||12 Dec 2012 @ 09:59 PST||Database||Reply||How to find the associated tables or view in teradata?||Check the disclaimer of the post ;->
But so far it looks quite complete in the cases I worked with it - which I do regularly.
|578||12 Dec 2012 @ 09:56 PST||Database||Reply||numeric overflow occurrence||
SELECT cast(0 as integer) AS a from (select 'X' as DUMMY) as X
SELECT -9999 AS a from (select 'X' as DUMMY) as X
The first selects defines the datatype.
|577||05 Dec 2012 @ 01:57 PST||Database||Reply||Union vs Group by||The standard answer is that it can depend on your data, the PI and configuration.
So easiest is to run the different options and check the DBQL.
You also forgot the set option of a temp table. Or... |
|576||05 Dec 2012 @ 01:49 PST||Database||Reply||How to find the associated tables or view in teradata?||are you looking for this?
|575||04 Dec 2012 @ 10:42 PST||Database||Reply||Work around to simulate a variable Partition in RANGE_N||Can you provide a DDL and some test data as inserts?
And explain with the given data your expected results.
|574||03 Dec 2012 @ 10:49 PST||Analytics||Reply||Connecting to Teradata in R via the teradataR package||Just to avoid future problems
tdConnect("10.33.2.136","my_uid","my_pwd","EDEE_POC"," jdbc ")
is not getting a connection due to the blanks in &qu... |
|573||03 Dec 2012 @ 08:07 PST||Analytics||Reply||Random values||I guess you are refering to dbms_random?
I have some doubts that you can migrate this function to TD. Main issue is the parallel data distribution and parallel processing.
You clearly don... |
|572||01 Dec 2012 @ 02:43 PST||Extensibility||Reply||Teradata R - create table based on a data frame using JDBC||Yes, looks like ODBC will do the trick but I would be also very interested in a JDBC solution...
|571||30 Nov 2012 @ 12:38 PST||Extensibility||Reply||Teradata R - create table based on a data frame using JDBC||I was also not able to do it.
DBQL states that both operations dbWriteTable and as.td.data.frame start with an BT; before the CREATE table is executed.
And in this case the TMODE=TERA d... |
|570||09 Nov 2012 @ 02:30 PST||Database||Reply||Select Tables created in a previous months only||Use help table DBC.TABLES
and fix your column names.
Condition is correct
|569||09 Nov 2012 @ 12:12 PST||Database||Reply||Select Tables created in a previous months only||
select (current_date - extract(day from current_Date)) as last_day _of_month,
Add_months(last_day _of _month + 1,-1) as first_day _of _month;
|568||09 Nov 2012 @ 12:08 PST||Database||Reply||Volatile table trouble||IN has two different interpretations
1. LIST of values
You mix it which is not working.
The best performance might (in case Orignl_Agent_AAA is not the PI of the VW_Pnr t... |
|567||07 Nov 2012 @ 10:45 PST||Connectivity||Reply||JDBC works fine but RJDBC fails||you need to specify
and tdgssconfig.jar in the ClassPath
|566||07 Nov 2012 @ 10:41 PST||Connectivity||Reply||RODBC fails and teradataR crashes on RHEL6||I would try JDBC connect on Linux
|565||05 Nov 2012 @ 10:04 PST||Database||Reply||Slow Left Join query||But in this case it mean that for each matching S_SK your answer set will generate up to 14144 result rows.
Is that what you expect?
|564||05 Nov 2012 @ 07:19 PST||Database||Reply||Purge the work tables cretaed a month before and create report with the list of work tables created last month||hm I mixed the 10 and 50...
check also dieters posts in
if you have trouble with the newline in the e... |
|563||05 Nov 2012 @ 07:14 PST||Database||Reply||Purge the work tables cretaed a month before and create report with the list of work tables created last month||try
SELECT DISTINCT 'DROP TABLE DB1.' || TABLENAME || ' ;
' !! case when row_number() over (order by tablename) mod 10 = 0 then '.hang 50;' else '' end
|562||05 Nov 2012 @ 07:06 PST||Database||Reply||Slow Left Join query||The skew value of the table is irrelevant as it is reflecting the S_SK,C_SK combination.
select top 100 hashrow(S_SK), count(*)
group by 1
order by 2 desc
|561||05 Nov 2012 @ 04:52 PST||Tools||Reply||How to Find Database name using Proxyid/Service id||Silence might be related to the fact of unclear understanding of requirements.
What are you looking for?
"database name using Proxy id/Service id"???????????
|560||05 Nov 2012 @ 04:50 PST||Database||Reply||Slow Left Join query||some observations -
1. "spa_usage1 contains app 54 million rows" vs. "The size of Spool 2 is estimated with low confidence to be 567,176,439 rows"
which is a 10x di... |