|42967||28 Jul 2014 @ 09:37 PDT||Raja_KT||Analytics||Reply||Generate a automated Nested CASE STATEMENT using entries from a table||I think you are looking for an opportunity to automate the process. I see people get faster response by showing sample , this is what I have and this is the output required. The sentence hiera... |
|42966||28 Jul 2014 @ 08:50 PDT||Raja_KT||Database||Reply||Partition integer date key by month||I was about to comment on posting_dt_key integer declaration in partition. I think you may have something in mind about it when you made it integer, since you know the end reqt and data... |
|42965||28 Jul 2014 @ 07:07 PDT||feinholz||Tools||Reply||TPT in Red Hat Linux - Dumping core ||We do not normally test with client boxes in a cluster.
We are trying to emulate the environment to see if we can duplicate the issue.
|42964||28 Jul 2014 @ 05:14 PDT||goldminer||Database||Reply||Partition integer date key by month||Thank you... yes I did try that but was concerned about the partition being used if a cast is made. Guess there is only one way to find out. I will cast as a date and then see if I can ... |
|42963||28 Jul 2014 @ 02:12 PDT||eejimkos||Database||Reply||Mvc Compression and Collect Stats on TD 14||Hi,
Can i ask oone more thing about sample stats.
I can identify directly the columns where i can have sample on three approaches ,
1) from comparing the uniquevaluecount to rowcount from dbc.... |
|42962||28 Jul 2014 @ 01:50 PDT||Ashwin4tera||Database||Reply||Avoid Product Join Step||Hi Dieter,
The actual rows are not in that range. And the stats on columns CLIENT_NBR and POP_ID are up to date.
Here are the steps for spool 26 and 27.
2) We do a group-... |
|42961||28 Jul 2014 @ 01:40 PDT||manmarirama||Analytics||Topic||Generate a automated Nested CASE STATEMENT using entries from a table||
I have a situation where i am trying to automate a BTEQ script where it has 100ds of conditional statements like
|42960||28 Jul 2014 @ 12:31 PDT||krishaneesh||Database||Reply||hexadecimal--->decimal ||
1,1)) -1) * 16 ) + ((Index('0123456789abcdef',Substr('2... |
|42959||28 Jul 2014 @ 11:51 PDT||Raja_KT||Teradata Applications||Reply||Easyloader data transfer issue||I am not pretty sure. My guess is the length behaviour of tpt. Did you try increasing the length in schema, maybe 3 times. I m not sure.
I remember vaguely about this discussion. It maybe wrong.
|42958||28 Jul 2014 @ 11:20 PDT||Raja_KT||Database||Reply||help with SQL||A quick look at the data it can be thus.
max(case when id is null then 0 else id end) over (partition by id,dt order by id,dt),
max(case when dt is null then 0 else dt end) over ... |
|42957||28 Jul 2014 @ 11:11 PDT||krishaneesh||Database||Reply||help with SQL||Will the COL2, COL3 and COL4 be having multiple values or only a single repetitive value like 75211 mentioned in the example 2. if so the qury given be Glass will work.
|42956||28 Jul 2014 @ 10:56 PDT||Glass||Database||Reply||help with SQL||sel col1,ts,max(col2),max(col3),max(col4),sum(col5) group by 1,2;
note: Max includes only no-null values
|42955||28 Jul 2014 @ 10:47 PDT||Raja_KT||Database||Reply||Identify Set - Multiset Tables in TD 14||In td mode, it will be set table. If you want to change to multiset by default, then it has to be changed to ANSI mode. You may need to MODIFY in dbs control settings in GENERAL , if my memory does... |
|42954||28 Jul 2014 @ 10:45 PDT||krishaneesh||Database||Reply||Complex SQL Scenario||Are the ID's constant, i mean are the rules set based on ID column. is Rule 1 fixed for ID=1 etc..
|42953||28 Jul 2014 @ 10:25 PDT||krishaneesh||Database||Reply||Total Quantity of Items Sold per Month||@Kartheek, Teradata does not support RR format. Also the max timestamp allowed is timestamp(6). If you need to convert RR notation you need to cast that column in character and then add the century... |
|42952||28 Jul 2014 @ 10:23 PDT||td_admirer||Database||Reply||help with SQL||Hi,
Yes, you are right. I need to group on the first 2 columns (COL1 and TS).
Also, another scenario to add
405273444339513690 2014-06-02 00:35:29 ? &n... |
|42951||28 Jul 2014 @ 10:13 PDT||krishaneesh||Database||Reply||Need help on a case scenario||in Table1 how will you be able to identify that the 2nd row pertains to ID1 and 4th row to ID 2 or other ID. if you have the ID in 2nd row to be 1, then what you can do is a row number over date pa... |
|42950||28 Jul 2014 @ 10:06 PDT||NetFx||Connectivity||Reply||Sending dataset(multiple rows and multiple columns ) from .net to teradata ||Yes, it is possible.
|42949||28 Jul 2014 @ 08:51 PDT||comptrtoy1||Database||Reply||Declare and Set then Open and Fetch||Dieter. I'm a newbie so just trying to make sure i dont miss anything. Nothing worse than a newbie talking about something they dont know, then insert foot in mouth. Trying to figure out what t... |
|42948||28 Jul 2014 @ 08:42 PDT||Kishore_1||Database||Reply||HashBufferSize||Sorry for the confusion.It is HashedBufSize
|42947||28 Jul 2014 @ 08:18 PDT||Glass||Database||Reply||help with SQL||What different grouping criteria? It looks like your grouping on the fier 2 columns.
|42946||28 Jul 2014 @ 07:59 PDT||CarlosAL||Database||Reply||HashBufferSize||I think you're a little bit disoriented...
HashBufferSize is a parameter that Oracle uses to reserve memory for the hash tables in the hash joins.
|42945||28 Jul 2014 @ 07:54 PDT||td_admirer||Database||Topic||help with SQL||Hi Gurus,
Could you please help me with the below SQL? I need to merge the columns from a few rows on the same table based on a different grouping criteria.
This is how the input data loo... |
|42944||28 Jul 2014 @ 07:53 PDT||ROZIE||Jobs||Topic||work||Any job in richmond?
|42943||28 Jul 2014 @ 07:49 PDT||abort_session||Database||Reply||ESCAPE with Single Quote ?||SEL * FROM .... WHERE C1 LIKE '%''FOOD''%'
works now, thanks