All forum activity

#DateUserForumTypeThreadPost
5891904 Aug 2016 @ 03:12 PDTkamlesh114DatabaseReplyskew factorA NUPI column with high number of NULL result in high skew factor. if yes then  why ? as NULL cannot be compared with each other.
5891804 Aug 2016 @ 01:45 PDTmk104DatabaseReplyRetrieve Rows where a change in values (intwo columns) occuredHi Dieter, Thank you so much that worked! as mentioned the rows to be retrieved were wrong; these are the correct ones: 1,234 23,528,397 NCC NW0002222 01/02/2015 1,234 23,528,397 NDD NW00...
5891704 Aug 2016 @ 01:31 PDTdnoethDatabaseReplyRetrieve Rows where a change in values (intwo columns) occuredYour example is not showing the correct rows to be returned. You're searching for changes in two columns and two directions (previous/next row), thus you need multiple OLAP functions: quali...
5891604 Aug 2016 @ 01:16 PDTmk104DatabaseTopicRetrieve Rows where a change in values (intwo columns) occuredHi all,I will try to explain this in the best way possible. I have a dataset and I am trying to retrieve the only the rows where a change has occurred. I have tried QUALIFY but I can't get my head...
5891504 Aug 2016 @ 01:13 PDTmanishdasinDatabaseReplyDay Name fuction in TeradataPlease try this:   SELECT CAST(current_date AS DATE FORMAT'e4') (CHAR(9));  
5891403 Aug 2016 @ 11:37 PDTkevinsmokerDatabaseReplyNeed help with interdependent calculation using result from previous rowThe Teradata Ordered Analytics functionality can help you here especially with its windowing feature.   You can code something similar to the following: MAX(sell_date) OVER (PARTITION BY cu...
5891303 Aug 2016 @ 11:36 PDTVidhya Praveen PrabhuGeneralReplyConcatenate Hi, I need to populate Column names that has the values with 1
5891203 Aug 2016 @ 08:07 PDTFredGeneralReplyerror table's are invalid state or table is being loadedThe LOAD operator should truncate oversize strings without an issue. I suspect the problem is that the SCHEMA is being generated based on the table definition, and the error is really com...
5891103 Aug 2016 @ 07:58 PDTFredConnectivityReplyUnable to Connect to Teradata Database from Teradata Studio on iOS (Mac)Can you "ping" ICW_Iberiacop1? What does your connection string look like? (Just in general, mask any sensitive info.)
5891003 Aug 2016 @ 01:16 PDTkbhatt000DatabaseReplyResponse Row size or Constant Row size overflowI had the same issue and I was able to resolve it by changing the charset to ascii from UTF.
5890903 Aug 2016 @ 12:01 PDTSmacGeneralTopicMulti Column Primary Index and Secondary IndexHi All, My 1st post in this Forum. Could you please help me to define a table if table having index as mulit column. acctid and bus date are going to be unique values in the table. i.e., Multi co...
5890803 Aug 2016 @ 11:31 PDTtomnolanToolsReplyTPT with JDBC to Kafka>>> Is it possible to use JDBC with TPT?   No.   >>> Or do I just use JDBC with FastExport?   The Teradata JDBC Driver offers a JDBC FastExport feature; howev...
5890703 Aug 2016 @ 10:52 PDTJaimeHollandHadoopTopicSqoop importing into Hive - supported file formatsHi, I'm new to Hadoop.  We are using CDH5.  I am managing to use sqoop to load from Teradata into Hive as textfile, but that seems to be the only supported option.  It seems like...
5890603 Aug 2016 @ 10:33 PDTdbrownDatabaseTopicNeed help with interdependent calculation using result from previous rowHi all, I've run into a problem that I'm having a hard time solving in Teradata. I have a query that returns a cust_id along with sell_date and a date_span (number). From that one date and ...
5890503 Aug 2016 @ 06:58 PDTsqlcoder9DatabaseTopicsum for trailing 365 days for usersHi  I'm trying to find the sum of amount for an 'ID' trailing 365 days from the 'DT'. Below is a sample from the data I'm working on. The below table consists of dates...
5890403 Aug 2016 @ 06:30 PDTRobertDiehlDatabaseReplyDistibution of Small table (rows less than number of amps) to single amp for Performance Todd,   Thanks for the reply.   Exactly what I wanted to confirm that I is still valid on current architecture.
5890303 Aug 2016 @ 05:59 PDTToddAWalterDatabaseReplyDistibution of Small table (rows less than number of amps) to single amp for Performance If the system has a very large number of AMPs, this technique can remove all-AMP steps from the query plans which access the table. If the queries that access the table are even medium size, the di...
5890203 Aug 2016 @ 05:49 PDTToddAWalterDatabaseReplyKeeps returning zeros for decimal60 is an integer and when column1 is also an integer, integer division is performed which does not result in any fractional portion. Using 60. or casting either column1 or 60 to decimal will resolv...
5890103 Aug 2016 @ 05:44 PDTToddAWalterToolsReplyExport with header using TPTIf the UNION form is used, it is a good idea to use UNION ALL so that the engine is not forced to do a duplicate elimination pass over the combination of the header row and the data.
5890003 Aug 2016 @ 04:06 PDTabhishank18DatabaseTopicError table in multiloadCan someone explain what sort of data issues will be reported in Multiload application error table ? Uniqueness violations and column length are failing in Acquisition phase for me.
5889903 Aug 2016 @ 04:05 PDTM.Saeed KhurramGeneralReplyConcatenate Hi, You want to populate the column names OR column values?  
5889803 Aug 2016 @ 03:23 PDTWinDatabaseReplyHow to find the Object IDs form DBC where it is stored.Hi Sankalp,   The "next system-generated unique identification number available for use by the system" and that is assigned to object(s) last created can be found in DBC."NEXT...
5889703 Aug 2016 @ 02:29 PDTkrishy_tdDatabaseTopicHow to pass uername and password as parameters from a unix shell script to a Fasst Export script?I'm in need of passing username and password from a unix shell script into a Fast Export script. I'm curently using .RUN FILE option to store the username and password in an external file a...
5889603 Aug 2016 @ 01:15 PDTkhawar.ameerDatabaseReplyODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. Oh found the abs() function and it worked. Sum(abs(t2.Event_Amt)) Regards   KAM
5889503 Aug 2016 @ 12:49 PDTkhawar.ameerDatabaseReplyODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. Thank you very much Sir, Your suggested code worked fine. Just need to ask two more things if you can please help. 1. The field Event_Amt contains Negative as well as positive number so their su...

Pages