|560||05 Nov 2012 @ 04:50 PST||Database||Reply||Slow Left Join query||some observations -
1. "spa_usage1 contains app 54 million rows" vs. "The size of Spool 2 is estimated with low confidence to be 567,176,439 rows"
which is a 10x di... |
|559||24 Oct 2012 @ 11:07 PDT||Database||Reply||Help with SQL||I guess rule 1 is not correct
sel COL1,dt,col3,col4 from vt_test
group by 1,3,4,2
having count(*) > 1;
gives null rows.
-> all rows are first occurance...
So try to explain it i... |
|558||24 Oct 2012 @ 07:21 PDT||Database||Reply||Reverse string search (right to left)?||select cast((current_date (format 'DD-MM-YYYY'))as char(10)) as txt, substring(txt from characters(txt) - 3 for 4);
|557||08 Oct 2012 @ 12:18 PDT||Database||Reply||Is mload delete faster than the Bteq delete?||Yes, it is faster due to the reason you already mentioned: It doesn't use a journal.
It scans and deletes...
But did you consider to
1. copy the 2% of data which remains into a new table
|556||08 Oct 2012 @ 12:14 PDT||Database||Reply||How to Use Round Function In Teradata||The keyword is RoundHalfwayMagUp
its a dbscontroll setting and defines how Teradata is handling the rounding.
Default is FALSE
from the manuals:
Indicates how rounding should be perfo... |
|555||08 Oct 2012 @ 06:12 PDT||Database||Reply||Error Code 6706: The string contains an untranslatable character.||its likely to be -
check Dieters reply on http://forums.teradata.com/forum/database/implicit-data-type-conversion-to-char-ends-up-in-unicode
you can validate by
create volatile table sql_... |
|554||08 Oct 2012 @ 12:25 PDT||Database||Reply||Table Level Checksums||Yes there is.
Come and join Partners 2012
Sunday 09:30 AM EST, Room: Baltimore 3-5
How to Compare Tables between Teradata Systems in a Dual Active Environment?
|553||04 Oct 2012 @ 11:49 PDT||Database||Reply||convert string to date format||see my last comment on http://forums.teradata.com/forum/general/a-wish-list-for-future-versions-of-teradata
|552||04 Oct 2012 @ 06:19 PDT||Database||Reply||Compile Stored Procedures in Batch||If I understand your question correctly the answer would be no:
see Carries comment in
|551||03 Oct 2012 @ 09:31 PDT||Database||Reply||DBQlogTbl statementtype is null?||Hm, the DBQL is indicating that the query was executed 8 times - 6 queries plans had been used from cache -> parsingCPUTime = 0.
So maybe your code is not doing what you expect...
In the cases I saw this happen the query was only executed once - you can validate this on your own by checking the totalIO and AmpCPUTime values. They should be &g... |
|549||03 Oct 2012 @ 12:52 PDT||Database||Reply||DBQlogTbl statementtype is null?||Can you share your Java connection settings - without username and password? Do you connect with multiple sessions?
|548||03 Oct 2012 @ 12:48 PDT||Tools||Reply||Using FastExport with Teradata JDBC Driver||And which number is correct?
I don't fully get what you wanne do. Do you export the data or do you only wanne know the row count?
|547||26 Sep 2012 @ 12:36 PDT||Database||Reply||Help in Recursive query required||alternative code avoiding recurisve query
CREATE volatile TABLE T1
row_id INT NOT NULL,
text VARCHAR(991) NOT NULL
) unique primary index (row_id)
on commit preserve rows;
|546||25 Sep 2012 @ 07:25 PDT||Database||Reply||Help in Recursive query required||Consider the udfs you could directly use them to extract your infos.
Otherwise - I guess A,B,C etc are examples. So these strings can be of variable lenght?
How long is your sour... |
|545||25 Sep 2012 @ 05:55 PDT||Database||Reply||Help in Recursive query required||I still don't get what you wane achive
But also check http://developer.teradata.com/blog/madmac/2010/03/a-few-basic-scalar-string-udfs
These are quite usefull - for you the list function... |
|544||24 Sep 2012 @ 05:41 PDT||Teradata Applications||Reply||Query to convert Decimal(15) to date format 'yyyy-mm-dd'||Asuming your decimal column has alwys dates in the format yyyymmdd
the following should work
select cast(19890523 as decimal(15,0)) as dt_in,
cast((dt_in - 190... |
|543||21 Sep 2012 @ 08:00 PDT||Database||Reply||Determine Average Count by Day of Week ||
casT(d.CountbyDayofWeek as decimal(15,3)) / w.num_of_days as AVG_COUNT
select day_of _week,
CASE day_of _week
|542||21 Sep 2012 @ 07:57 PDT||Database||Topic||Implicit data type conversion to char ends up in Unicode||Hi all,
I am on 13.10.
Why is an implicit decimal or integer to char conversion with coalesce resulting in character set unicode?
create volatile table vt_a (a decimal(3,0), b integer, c date)... |
|541||21 Sep 2012 @ 06:59 PDT||Database||Reply||Determine Average Count by Day of Week ||So, what is your actual requirement?
Why not sort by
((CMTMT_DT - Date '1900-01-01') Mod 7) + 1
|540||20 Sep 2012 @ 06:09 PDT||Database||Reply||Oreplace limitation||From the manual:
3577 Row size or Sort Key size overflow.
Explanation: The user request generated a row of
data or a sort key that exceeded internal Teradata database
limitations (prese... |
|539||20 Sep 2012 @ 02:51 PDT||Database||Reply||restoring tables from older TD releases deliver strange messages||This thread might explain the what and why.
I found the script in
|538||20 Sep 2012 @ 12:28 PDT||Database||Reply||Determine Average Count by Day of Week ||As you see here you need to be very precise in the desciption of your problem as you might get different results.
The main difference in the two solutions from Dieter and me is that Dieter is coun... |
|537||20 Sep 2012 @ 12:19 PDT||General||Reply||Wish list for forum development||One more wish:
The default language in the Code editor is JAVA.
At least I post in > 90% SQL in a database forum.
Can the default be changed to SQL?
|536||20 Sep 2012 @ 12:12 PDT||Database||Reply||Determine Average Count by Day of Week ||you need to count the number of days per weekday separatly and join this to your result set.
casT(d.CountbyDayofWeek as decim... |