| 58567 | 19 Jul 2016 @ 09:58 PDT | dnoeth | Tools | Reply | In List Blues - How to make large In List Queries More Efficient | Yep, this doesn't need to be a Stored Procedure, a Teradata Macro will also work.
But literal strings are limited to 31000 characters in Teradata, you will hit this limit.
You might p... |
| 58566 | 19 Jul 2016 @ 09:45 PDT | feinholz | Tools | Reply | TDCH-TPT Interface--For loading into Hadoop | The use of TDCH by TPT is basically performed by TPT sending a command to the name node of the Hadoop cluster to execute the TDCH command, passing the needed information as command line options to ... |
| 58565 | 19 Jul 2016 @ 09:32 PDT | indra91 | Tools | Topic | Float data type export using Fast Export | Hello everyone,
I am trying to export a table with float data type using FastExport utility.As we know Teradata rounds-off any float values where number of digit is greater than 15. For in... |
| 58564 | 19 Jul 2016 @ 09:21 PDT | feinholz | Tools | Reply | TPT - Scripting | What version of TPT are you using?
That would dictate what type of "template" and "generated schema" features you can use.
It would also dictate whether you can use Easy Loade... |
| 58563 | 19 Jul 2016 @ 09:11 PDT | feinholz | Tools | Reply | Zero records are fetching when using where statement in TPT | For your versiobn of TPT, continue to use SelectStmt.
We are "fixing" TPT to also accept ExportSelectStmt, but that is not completed yet.
I will need to see a complete log (the .out fil... |
| 58562 | 19 Jul 2016 @ 09:10 PDT | ToddAWalter | Tools | Reply | Determine #sessions to set for load / exp jobs | Better yet, let WLM manage the number of sessions and only change the ones that really need exceptions via WLM rules.
|
| 58561 | 19 Jul 2016 @ 09:07 PDT | ToddAWalter | Tools | Reply | In List Blues - How to make large In List Queries More Efficient | What Teradata release is being used?
What does the explain plan look like for the 4500 class case?
On current releases, the Teradata optimizer should be doing this automatically. ... |
| 58560 | 19 Jul 2016 @ 09:07 PDT | feinholz | Tools | Reply | Determine #sessions to set for load / exp jobs | The calculation that is often used in TASM (TDWM, workload management) is:
If number of AMPs <= 20, then use 1 per AMP.
If number of AMP > 20, then use 20 + (#AMPS/20)
But ... |
| 58559 | 19 Jul 2016 @ 07:42 PDT | JustinS | Tools | Reply | In List Blues - How to make large In List Queries More Efficient | What's a "tremendous amount"
The big queries will be 5000- 10,000. Sometimes they will just run them about 4,500 at a time, over and over again.
So if I am getting the gist of your ... |
| 58558 | 19 Jul 2016 @ 07:28 PDT | awenny | Tools | Reply | TPT - Scripting | You can use this perl program: https://github.com/tdawen/td_devel/blob/master/teradata/cptab.pl
But I haven't used it for a long time. Maybe it requires some tweaks.
You can also remove... |
| 58557 | 19 Jul 2016 @ 07:06 PDT | M.Saeed Khurram | Tools | Reply | TPT - Scripting | You can use template and wrtie a macro or SP to take input the table name or loop through list of tables and generate TPT script against each table.
|
| 58556 | 19 Jul 2016 @ 06:36 PDT | CarlosAL | Tools | Reply | TPT - Scripting | Hi.heers.
You can use Templates and Generated Schemas.
Cheers.
Carlos.
|
| 58555 | 19 Jul 2016 @ 06:19 PDT | randy.dycus2 | Tools | Reply | Encryted Password File for FastExport | Andreas,
Thank you very much. I have not had a chance to test yet (reboot the server), but I fully expect this to be the answer I was looking for.
Thanks again for taking to time to ... |
| 58554 | 19 Jul 2016 @ 06:09 PDT | kathir_chaser | Database | Reply | Convert the data in the Table into XML format | Tried that as well. But doesn't help...
|
| 58553 | 19 Jul 2016 @ 06:07 PDT | KN | Tools | Topic | TPT - Scripting | Hello Folks
I have a requirement to move 90 tables totalling up to 200 GB from one Teradata system to an another Teradata system.. While i know there are different options i plan to use TPT t... |
| 58552 | 19 Jul 2016 @ 05:45 PDT | dnoeth | Database | Reply | Function quantile throws a numeric overflow error in a large table | Check if you can avoid two OLAP-steps, SUM(CAST(1 AS BIGINT)) OVER (...) might be ok (if the data is not unique rows with the same value might be assigned to two quantiles)
Btw, TD15.10 fi... |
| 58551 | 19 Jul 2016 @ 04:43 PDT | CarlosAL | Database | Reply | Using Volatile table in stored procedure | Hi.
If you use a cursor as a resulset for returning rows to a user and this cursor selects rows from a volatile table, then you must declare it as a dynamic cursor, because the volatile table does... |
| 58550 | 19 Jul 2016 @ 04:13 PDT | nimish_123 | Database | Topic | SQL Performance issue | Hi All,
I need your input for performance improvement of below SQL (with EXPLAIN PLAN).
This SQL was running fine previously but suddenly having performance issue. We have refreshed the STATS but... |
| 58549 | 19 Jul 2016 @ 03:58 PDT | dnoeth | Database | Reply | Data Dictionary | There's no need to increase the Data Dictionary size.
Teradata's DD are the tables located in dbc and there's usually a large perm space assigned to it (it also includes the Transient ... |
| 58548 | 19 Jul 2016 @ 03:51 PDT | dnoeth | Tools | Reply | In List Blues - How to make large In List Queries More Efficient | What's a "tremendous amount", 100s, 1000s or 10000s of values?
You might investigate usage of STRTOK_SPLIT_TO_TABLE, either as part of the Select or as Insert/Select in a Macro (hope... |
| 58547 | 19 Jul 2016 @ 03:50 PDT | AtardecerR0j0 | Database | Reply | Using Volatile table in stored procedure | There is no problem using volatile tables in a store procedure
I used on a SP where after executing the SP i should review a volatile table, this table sometimes existed previous to the exec... |
| 58546 | 19 Jul 2016 @ 03:02 PDT | mcfabrero | Database | Topic | CHARACTER SET LATIN versus CHARACTER SET UNICODE | Hi All,
I would like to ask for your help on explaining and elaborating the difference between columns having data types set to LATIN and those set to UNICODE.
Currently encountering a spool spac... |
| 58545 | 19 Jul 2016 @ 02:44 PDT | MeenakshiM | Database | Reply | Using Volatile table in stored procedure | Hi,
Even I need help on this topic. I have to create multiple volatile tables inside a stored procedure and use them for returing output to user in the form of cursor. But I am unable to compile t... |
| 58544 | 18 Jul 2016 @ 11:51 PDT | KN | Tools | Topic | Determine #sessions to set for load / exp jobs | Hello Gurus
Is there a rule of thumb that one should follow for determining the number sessions that should be set for a load or fexp jobs?
Suppose if my system is a 4 node system with 40amps/nod... |
| 58543 | 18 Jul 2016 @ 11:37 PDT | awenny | Tools | Reply | Encryted Password File for FastExport | After running a test, the error message shown with items added via "add" after a reboot is:
*** CLI error: CLI2: TDWALLETERROR(543): Teradata Wallet error. The wallet password has not... |
