#DateForumTypeThreadPost
58514 Mar 2013 @ 03:38 PDTToolsReplyTeradata TPT ScriptTry run    tbuild -V   on the command line   if this is not giving you an information at least the installation would be incomplete...
58414 Mar 2013 @ 03:35 PDTAnalyticsReplyconversion of datatypeDon't post many times the same question. Solution was given at Numeric Overflow error in teredata
58314 Mar 2013 @ 03:30 PDTDatabaseReplyNumeric Overflow error in teredatacheck the data types of  data_table_uplink  data_table_downlink data_table_UPLINK data_table_DOWNLINK data_table__DURATION It looks like the sums are exceding the maximum values...
58203 Mar 2013 @ 11:53 PSTGeneralReplyDid 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...
58115 Feb 2013 @ 07:08 PSTDatabaseReplyCan 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...
58014 Feb 2013 @ 03:13 PSTDatabaseReplyCan you join using wild cards col_a like %col_b%try  cards col_a like '%' || col_b || '%'  
57912 Dec 2012 @ 09:59 PSTDatabaseReplyHow 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.  
57812 Dec 2012 @ 09:56 PSTDatabaseReplynumeric overflow occurrence SELECT cast(0 as integer) AS a from (select 'X' as DUMMY) as X UNION ALL SELECT -9999 AS a from (select 'X' as DUMMY) as X The first selects defines the datatype. Try alsoe ...
57705 Dec 2012 @ 01:57 PSTDatabaseReplyUnion vs Group byThe 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...
57605 Dec 2012 @ 01:49 PSTDatabaseReplyHow to find the associated tables or view in teradata?are you looking for this? http://developer.teradata.com/blog/ulrich/2011/11/extract-and-analyse-database-object-dependencies
57504 Dec 2012 @ 10:42 PSTDatabaseReplyWork around to simulate a variable Partition in RANGE_NCan you provide a DDL and some test data as inserts? And explain with the given data your expected results.
57403 Dec 2012 @ 10:49 PSTAnalyticsReplyConnecting to Teradata in R via the teradataR packageJust 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...
57303 Dec 2012 @ 08:07 PSTAnalyticsReplyRandom valuesI 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...
57201 Dec 2012 @ 02:43 PSTExtensibilityReplyTeradata R - create table based on a data frame using JDBCYes, looks like ODBC will do the trick but I would be also very interested in a JDBC solution...
57130 Nov 2012 @ 12:38 PSTExtensibilityReplyTeradata R - create table based on a data frame using JDBCI 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...
57009 Nov 2012 @ 02:30 PSTDatabaseReplySelect Tables created in a previous months onlyUse help table DBC.TABLES and fix your column names. Condition is correct
56909 Nov 2012 @ 12:12 PSTDatabaseReplySelect 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;
56809 Nov 2012 @ 12:08 PSTDatabaseReplyVolatile table troubleIN has two different interpretations  1. LIST of values 2. Subquery 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...
56707 Nov 2012 @ 10:45 PSTConnectivityReplyJDBC works fine but RJDBC failsyou need to specify terajdbc4.jar and tdgssconfig.jar in the ClassPath check http://forums.teradata.com/forum/analytics/connecting-to-teradata-in-r-via-the-teradatar-package
56607 Nov 2012 @ 10:41 PSTConnectivityReplyRODBC fails and teradataR crashes on RHEL6I would try JDBC connect on Linux check http://forums.teradata.com/forum/analytics/connecting-to-teradata-in-r-via-the-teradatar-package  
56505 Nov 2012 @ 10:04 PSTDatabaseReplySlow Left Join queryBut 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? Ulrich
56405 Nov 2012 @ 07:19 PSTDatabaseReplyPurge the work tables cretaed a month before and create report with the list of work tables created last monthhm I mixed the 10 and 50... check also dieters posts in  http://forums.teradata.com/forum/tools/bteq-cannot-write-hexa-character-in-output-file if you have trouble with the newline in the e...
56305 Nov 2012 @ 07:14 PSTDatabaseReplyPurge the work tables cretaed a month before and create report with the list of work tables created last monthtry  SELECT DISTINCT 'DROP TABLE DB1.' || TABLENAME || ' ; ' !! case when row_number() over (order by tablename) mod 10 = 0 then '.hang 50;' else '' end ...
56205 Nov 2012 @ 07:06 PSTDatabaseReplySlow Left Join queryThe skew value of the table is irrelevant as it is reflecting the S_SK,C_SK combination. try  select top 100 hashrow(S_SK), count(*) from spa_usage1 group by 1 order by 2 desc PP...
56105 Nov 2012 @ 04:52 PSTToolsReplyHow to Find Database name using Proxyid/Service idSilence might be related to the fact of unclear understanding of requirements. What are you looking for? "database name using Proxy id/Service id"???????????

Pages