2778 | 22 May 2014 @ 08:06 PDT | Tools | Reply | Need Help in Teradata Functions | Hi Satya,
what's your TD release?
For this task there's a STRTOK function In TD14 (which is a bit easier to use than a regular expression or INSTR):
STRTOK(col, '|',... |
2777 | 22 May 2014 @ 08:01 PDT | Database | Reply | Recommendation on varhar - char columns | CHAR(n) always need exactly n bytes for LATIN or n*2 bytes for UNICODE while VARCHARs need 1 or two bytes for each character stored. But VARCHARs also need two byte additional overhead (a word indi... |
2776 | 19 May 2014 @ 01:04 PDT | Tools | Reply | Teradata Express 7z file complaining of corrupted sda.vmdk | I've seen similar errors when trying to extract to a FAT32 filesystem, after extracting the first two GBs :-)
|
2775 | 19 May 2014 @ 01:02 PDT | Database | Reply | fast load quotes field | Hi John,
yep, you're using a 13.10 FastLoad against a 14.10 TD, which is definitely causing that problem.
The solution is simple: upgrade FastLoad, simply ask your DBA, he should support this... |
2774 | 19 May 2014 @ 12:39 PDT | Database | Reply | fast load quotes field | Hi John,
you said you're using TD14, but did you check your FastLoad version if it supports DELIMITER/QUOTE?
SHOW VERSIONS; should return 14, too.
|
2773 | 16 May 2014 @ 08:07 PDT | Database | Reply | Output of script will be a set of select queries | Hi Arindam,
when you work with Oracle you need to have some knowledge of the basic metadata views :-)
ALL_TAB_COLUMNS is similar to dbc.ColumnsV
|
2772 | 16 May 2014 @ 02:58 PDT | General | Reply | Installation of Teradata on Linux | Hi Achyuth,
for testing purposes there's only the TD Express VM, so you have to install VMWare Player.
Btw, the VM runs the same OS as the "real" TD, Suse Enterprise Linux 11.
|
2771 | 16 May 2014 @ 02:26 PDT | Database | Reply | Single slot in throttle for multiple requests | Hi Asim,
the parser and so TASM work on a REQUEST level, so the only way to get all ten Inserts in a single unit of work in TASM is a Multi Statement Request.
|
2770 | 15 May 2014 @ 05:59 PDT | Database | Reply | How to calulate Skew on Join Index | Hi Peter,
you're welcome, I know it's confusing :-)
COLLECT DEMPGRAPHICS FOR mytable INTO myDatabase;
where myDatabase is the name of the database where DataDemographics has been creat... |
2769 | 15 May 2014 @ 04:09 PDT | Database | Reply | How to calulate Skew on Join Index | Hi Peter,
you don't specify the table name (always DataDemographics), it's the databasename, where DataDemographics is created :-)
|
2768 | 15 May 2014 @ 12:30 PDT | Database | Reply | Find position of a character in a string | Hi Sangeeta,
it's not failing when you copied it exactly :-)
If you're not on TD14 (STRTOK function) i'm promoting the Ebay functions again:
http://developer.teradata.com/blog/madmac... |
2767 | 15 May 2014 @ 12:22 PDT | General | Reply | How do I split a column between quantity and unit of measure | If you can install a UDF (talk to your DBA) the eCStrSpn from Ebay will be helpfull:
eCStrSpn(size,'0123456789.') will return the position of the last digit, based on that you can eas... |
2766 | 14 May 2014 @ 02:08 PDT | Database | Reply | Numeric or non-numeric values | I just remembered the Ebay UDFs, there's a eIsDecimal UDF which should be exactly what you need:
http://developer.teradata.com/blog/madmac/2010/03/a-few-basic-scalar-string-udfs
|
2765 | 14 May 2014 @ 01:47 PDT | Database | Reply | Vertical pivoting | Hi Kim,
"up to 250", lets assume only 25 in average * 27,000,000 = 675,000,000 rows, when it's finally up to 8 times as much you get a few billion rows a day, ouch.
But this should ... |
2764 | 14 May 2014 @ 12:15 PDT | General | Reply | Stats can be collected on Global temporary tables but not on volatile table why? | You must be runing a quite old version.
This restriction has been removed in TD13.
|
2763 | 14 May 2014 @ 12:11 PDT | Database | Reply | Vertical pivoting | Hi Kim,
what's the exact definition of that table and how many values are returned per row in average?
Can you show the current explain of both versions?
|
2762 | 14 May 2014 @ 11:38 PDT | Tools | Reply | TPT script : syntax error at "VARCHAR"; | It's UserPassword instead of Password.
|
2761 | 14 May 2014 @ 11:28 PDT | Database | Reply | Vertical pivoting | Hi Kim,
assuming this is a one time load you might split the data in multiple parts ('a' to 'e', 'f' to 'j', etc) and repeat the query for each part.
What's th... |
2760 | 14 May 2014 @ 07:46 PDT | Database | Reply | Vertical pivoting | Hi Kim,
for a "couple hundred million" rows recursion is not really recommended :-)
I posted a recursive query for that some time ago, the last query should avoid the spool problem (and... |
2759 | 14 May 2014 @ 07:20 PDT | Database | Reply | How to calulate Skew on Join Index | Hi Peter,
you don't need any special access right (beside SELECT on the base table) to submit a COLLECT DEMPGRAPHICS.
But the result is inserted into the DataDemographics table, wh... |
2758 | 14 May 2014 @ 04:58 PDT | Tools | Reply | TPT script : syntax error at "VARCHAR"; | Should be a different error :-)
You need to escape the single quotes names within your INSERTs, too, e.g.
('INSERT INTO tduser.Source_Emp_Table
(1,''joe'');'),
&nbs... |
2757 | 14 May 2014 @ 04:55 PDT | Database | Reply | How to calulate Skew on Join Index | Hi Peter,
if you need this for a "what if this was my new PI" you have to use the HASHAMP calculation, although skew on JIs is of less concern as they might prefer performance over distr... |
2756 | 14 May 2014 @ 04:37 PDT | Database | Reply | creating C UDF - issue with float output | I'm not a C-programmer, but when you define the result datatype as FLOAT within the C-code and as DECIMAL(38,9) within the CREATE FUNCTION this will never match.
|
2755 | 13 May 2014 @ 06:40 PDT | General | Reply | default character set in teradata | Could you please post new questions as a new topic?
You need to use ALTER TABLE, the syntax is a bit weird as you actually modify the definition of an existing column:
ALTER TABLE tab ADD colna... |
2754 | 13 May 2014 @ 05:10 PDT | Database | Reply | Numeric or non-numeric values | What's your TD release?
In TD14 there are regular expressions, e.g. this will return 1 for any kind of decimal like ' 24', '-23.66', '+2.98'
regexp_instr(trim(col), ... |