59117 | 12 Aug 2016 @ 12:01 PDT | jainayush007 | General | Reply | Looking for help with regards to nested aggregates | Hello.. 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... |
59116 | 11 Aug 2016 @ 11:59 PDT | jainayush007 | General | Reply | Looking for help with regards to nested aggregates | Hello.. 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... |
59115 | 11 Aug 2016 @ 11:51 PDT | yuvaevergreen | General | Reply | Multi Column Primary Index and Secondary Index | IF its a big table, definitely partition will help....
|
59114 | 11 Aug 2016 @ 11:48 PDT | yuvaevergreen | General | Reply | Improve performance on an analytical query , mulitple columns using same set of partitions | Whats the volume of the data in the table and what is the join type
|
59113 | 11 Aug 2016 @ 11:44 PDT | yuvaevergreen | General | Reply | Looking 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... |
59112 | 11 Aug 2016 @ 11:32 PDT | Johannes Vink | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | SELECT GREATEST(50,100,70)
|
59111 | 11 Aug 2016 @ 11:32 PDT | Johannes Vink | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | WHAT does not work.
Given the example data for id 4 the statement returns 100:
|
59110 | 11 Aug 2016 @ 10:41 PDT | yuvaevergreen | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | It should work..Can you post your data.
|
59109 | 11 Aug 2016 @ 10:18 PDT | Inguva | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | Hi,this solution worked but its giving wrong value for one id 4 alone
|
59108 | 11 Aug 2016 @ 08:41 PDT | sam141988 | Database | Reply | Can 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... |
59107 | 11 Aug 2016 @ 07:55 PDT | jainayush007 | General | Reply | Looking for help with regards to nested aggregates | Hi Dieter... Any help on the above would be helpful....
|
59106 | 11 Aug 2016 @ 05:28 PDT | Naveen_K | Tools | Topic | teradata utilities doesn't work with python on Mac | Hi,
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... |
59105 | 11 Aug 2016 @ 01:35 PDT | Ivyuan | Tools | Reply | Fastload error: I/O Error on File Open 34 | Hi,
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... |
59104 | 11 Aug 2016 @ 11:47 PDT | haridwar | Teradata Applications | Reply | How to install Teradata on UBUNTU | sudo ./studioinstall TeradataStudio-15.11.00.00-1.i86.rpm
This comand is not working in ubuntu-14.04
error - sudo: ./studioinstall: command not found
|
59103 | 11 Aug 2016 @ 10:29 PDT | CarlosAL | Tools | Reply | bteq help needed | Hi.
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... |
59102 | 11 Aug 2016 @ 09:25 PDT | fgrimmer | Teradata Studio | Reply | Why 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.
|
59101 | 11 Aug 2016 @ 08:43 PDT | sd186060 | Connectivity | Reply | Teradata Presto Driver Connectivity INT Datatype Limitation | This 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... |
59100 | 11 Aug 2016 @ 07:38 PDT | Apurba93 | Tools | Reply | TPT load failure - Please suggest | how to invoke command line argument while running mload script in unix system?
|
59099 | 11 Aug 2016 @ 06:18 PDT | AtardecerR0j0 | Database | Reply | Can 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
|
59098 | 11 Aug 2016 @ 05:55 PDT | franceszhu | Database | Reply | How to add a new spatial reference system to SYSSPATIAL.SPATIAL_REF_SYS | I 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.
|
59097 | 11 Aug 2016 @ 03:46 PDT | sam141988 | Database | Topic | Can 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 ... |
59096 | 11 Aug 2016 @ 03:19 PDT | sam141988 | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | Thanks a lot! Its a great solution
|
59095 | 11 Aug 2016 @ 02:52 PDT | sam141988 | Database | Reply | Capturing Versions when there is a Change in a Column Value else keep the Earliest if Consecutive | Thanks Alot!
|
59094 | 11 Aug 2016 @ 02:51 PDT | AtardecerR0j0 | Teradata Applications | Reply | Fast load failure with return code 12 | look up on the fastload documentation for:
DISPLAY_ERRORS and NOSTOP
|
59093 | 11 Aug 2016 @ 02:38 PDT | AtardecerR0j0 | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns |
select greatest(9,35,2)
|