All forum activity

#DateUserForumTypeThreadPost
5911611 Aug 2016 @ 11:59 PDTjainayush007GeneralReplyLooking for help with regards to nested aggregatesHello.. Cant have a sub query.. actually this needs to be executed on a reporting solution and it cant allow sub queries. Also,  when you we do AVG(D) OVER (PARTITION BY A,C ORDER BY A RO...
5911511 Aug 2016 @ 11:51 PDTyuvaevergreenGeneralReplyMulti Column Primary Index and Secondary IndexIF its a big table, definitely partition will help....
5911411 Aug 2016 @ 11:48 PDTyuvaevergreenGeneralReplyImprove performance on an analytical query , mulitple columns using same set of partitionsWhats the volume of the data in the table and what is the join type
5911311 Aug 2016 @ 11:44 PDTyuvaevergreenGeneralReplyLooking for help with regards to nested aggregates Is this what you are expecting? SEL A,COUNT(DISTINCT B),COUNT(DISTINCT C),SUM (SM1) FROM (SEL A,B,C, CAST(AVG(D) OVER (PARTITION BY A,C ORDER BY A ROWS BETWEEN UNBOUNDED PRECEDING AND UNB...
5911211 Aug 2016 @ 11:32 PDTJohannes VinkDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsSELECT GREATEST(50,100,70)
5911111 Aug 2016 @ 11:32 PDTJohannes VinkDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsWHAT does not work. Given the example data for id 4 the statement returns 100:  
5911011 Aug 2016 @ 10:41 PDTyuvaevergreenDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsIt should work..Can you post your data.
5910911 Aug 2016 @ 10:18 PDTInguvaDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsHi,this solution worked but its giving wrong value for one id 4 alone
5910811 Aug 2016 @ 08:41 PDTsam141988DatabaseReplyCan we find out Column Level Mismatches between 2 Tables in Terdata?Hi AtardecerR0j0, Yes that way came to my mind too but the challenge here it will be when i am dealing with a table with more number of columns. Isn't it? Any other way can it be achive...
5910711 Aug 2016 @ 07:55 PDTjainayush007GeneralReplyLooking for help with regards to nested aggregatesHi Dieter... Any help on the above would be helpful....
5910611 Aug 2016 @ 05:28 PDTNaveen_KToolsTopicteradata utilities doesn't work with python on MacHi, I installed TTU 14.10 on my Mac. When I execute the command from shell like bteq, tbuild etc., it works fine. When I invoke the same command from python, it fails.   >>> my_cmd...
5910511 Aug 2016 @ 01:35 PDTIvyuanToolsReplyFastload error: I/O Error on File Open 34Hi, Glad to know that it worked after correcting the syntax error. It would be nice for FastLoad not to issue the misleading message which leads to a Teradata DataConnector related error. Teradata...
5910411 Aug 2016 @ 11:47 PDTharidwarTeradata ApplicationsReplyHow to install Teradata on UBUNTUsudo ./studioinstall TeradataStudio-15.11.00.00-1.i86.rpm This comand is not working in ubuntu-14.04 error - sudo: ./studioinstall: command not found
5910311 Aug 2016 @ 10:29 PDTCarlosALToolsReplybteq help neededHi. Look for "here document" in the net. Your line is the first of a "here document" script executing in bteq with the stdout and stderr redirected to a trace file based on the date and time...
5910211 Aug 2016 @ 09:25 PDTfgrimmerTeradata StudioReplyWhy is the first dynamic result set in a procedure is empty?Sharon, This problem has been fixed in our upcoming 15.12 release. The problem was that the database was returning an empty result set if there were no out parameters. 
5910111 Aug 2016 @ 08:43 PDTsd186060ConnectivityReplyTeradata Presto Driver Connectivity INT Datatype LimitationThis issue has been resolved and will be available in the August, 2016 release of Presto 148t. Here is a seak peak at the release notes for data types: http://teradata.github.io/presto/docs/1...
5910011 Aug 2016 @ 07:38 PDTApurba93ToolsReplyTPT load failure - Please suggesthow to invoke command line argument while running mload script in unix system?
5909911 Aug 2016 @ 06:18 PDTAtardecerR0j0DatabaseReplyCan we find out Column Level Mismatches between 2 Tables in Terdata?To do that you should use full outer join way so you can join using key columns and compare the atribute columns one by one
5909811 Aug 2016 @ 05:55 PDTfranceszhuDatabaseReplyHow to add a new spatial reference system to SYSSPATIAL.SPATIAL_REF_SYSI figured it out myself. The SRID here is the internal Teradata SRID number. So for adding a new spatial reference system, it will be the next available sequencial number.
5909711 Aug 2016 @ 03:46 PDTsam141988DatabaseTopicCan we find out Column Level Mismatches between 2 Tables in Terdata?I mean to Say when we do a MINUS on TD it returns the Entire Row where the Mismacth is Found. My Question is is there any possibilty where we can find the Column Where Mismatch has Occured and not ...
5909611 Aug 2016 @ 03:19 PDTsam141988DatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsThanks a lot! Its a great solution
5909511 Aug 2016 @ 02:52 PDTsam141988DatabaseReplyCapturing Versions when there is a Change in a Column Value else keep the Earliest if ConsecutiveThanks Alot!
5909411 Aug 2016 @ 02:51 PDTAtardecerR0j0Teradata ApplicationsReplyFast load failure with return code 12look up on the fastload documentation for: DISPLAY_ERRORS and NOSTOP
5909311 Aug 2016 @ 02:38 PDTAtardecerR0j0DatabaseReplyCapturing MAX marks for Each Student when the MArks are in Columns select greatest(9,35,2)
5909211 Aug 2016 @ 02:32 PDTAtardecerR0j0DatabaseReplyCapturing Versions when there is a Change in a Column Value else keep the Earliest if ConsecutiveVery important: Read the documentation to understand Row_Number and min functions http://www.info.teradata.com/htmlpubs/DB_TTU_15_10/index.html#page/SQL_Reference/B035_1145_151K/ROW_NUMBER.html A...

Pages