#DateForumTypeThreadPost
4420 Feb 2014 @ 06:00 PSTToolsReplyCHAR(n) CHAR SET UNICODE/LATIN define schema in 14.xx - multiply by 2 or 3I double-checked the above observation against the auto-generated schema, and it confirms that "CHAR(n) CHAR SET LATIN" will be estimated as "CHAR(n x 2)" in TPT definition when...
4320 Feb 2014 @ 12:48 PSTToolsReplyCHAR(n) CHAR SET UNICODE/LATIN define schema in 14.xx - multiply by 2 or 3According to 2436.pdf - TPT Reference Use of UNICODE Affects Column Width Requirements When specifying a UTF8 character set in a Teradata PT script the output schema definition mu...
4219 Feb 2014 @ 05:53 PSTToolsTopicCHAR(n) CHAR SET UNICODE/LATIN define schema in 14.xx - multiply by 2 or 3In TPT script that "USING CHARACTER SET UTF8" in 13.10 We multiply char_length() of a CHAR & VARCHAR column by 3, so for example, CHAR(2) in DDL = CHAR(6) in TPT VARCHA...
4119 Feb 2014 @ 11:09 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesValidated. 14.10.00.02 has the "GetPos" issue even after removing "-z 60" option 14.10.00.03 works fine without "-z 60" option The multiple gzip named...
4018 Feb 2014 @ 11:29 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesPost the shell commands again: if [[ -z "$TWB_ROOT" ]] then TWB_ROOT=`find /opt/teradata/client -type d -name tbuild | sort -n | head -1` LD_LIBRARY_PATH=$TWB_ROOT/lib fi d...
3918 Feb 2014 @ 05:47 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final files /opt/teradata/client/14.10/tbuild/lib $ ls -l total 8404 drwxr-xr-x 2 root root 4096 Feb 18 17:01 gcc_3.x -r--r--r-- 1 root root 1511843 Dec 10 13:49 libdataconop.so -r--r--r-- 1 root root...
3818 Feb 2014 @ 05:26 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final files Teradata Parallel Transporter Version 14.10.00.03 Job log: /opt/teradata/client/14.10/tbuild/logs/fmcs-2014021817-7.out Job id is fmcs-2014021817-7, running on xxxxxx Teradata Parallel Trans...
3718 Feb 2014 @ 12:55 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesnamed pipe access module can be used for READER only. it does not work with WRITER. my 14.10.00.02 clearly has problem of "getpos" against named pipe. I will ask DBA to get the latest TT...
3618 Feb 2014 @ 10:29 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesHi Steven, It will be great for TPT to generate files like below (instead of abc.gz-3, abc.gz-12, ...) abc.1.gz abc.3.gz abc.8.gz I will look forward to a fix in 14.10.00.07...
3517 Feb 2014 @ 10:32 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesHi Steven, When I "APPLY TO OPERATOR (FILE_WRITER[@DataFileCount])" and use -C to generate multiple output files, all the files will have ***.gz-n as extension, but the actual file conte...
3417 Feb 2014 @ 09:09 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final files ┌nmon─12c──────[H for help]───Hostname=xxxx-xxxxx───Refresh= 2secs ───21:03.35───────────────────────────...
3317 Feb 2014 @ 09:06 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesIt seems that gzip file can be generated if I write to a single outpuf file with ".gz" file extension. But I need to generate multiple *.gz files, in order to: utilize multiple C...
3217 Feb 2014 @ 08:43 PSTToolsReplyZip/GZip Support in TTU 14?TDCH can read from compressed HDFS files such as part-*.gz and part-*.deflate directly. "internal.fastlaod" is only subject to the session limit of workload management.
3117 Feb 2014 @ 08:13 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesHi Steven, The original goal is to generate *.gz files directly to save disk space and transportation network overhead later. Generally, *.gz files are 3~5x smaller than the plain FASTLOAD output....
3017 Feb 2014 @ 08:08 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesOh, I have an old wrapper shell script to compress TPT output. Just upgrade to 14.10 TTU lately, it did not work anymore. How to WRITE to *.gz directly? I tried to specify FileName = xxx.gz but th...
2917 Feb 2014 @ 05:12 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final files TPT_INFRA: TPT03720: Error: Checkpoint command failed with 48 !ERROR! Can't position pipe NOT returning position for file=/var/tmp/fact_abc_segment.fifo-5 FILE_WRITER: TPT19424 p...
2817 Feb 2014 @ 05:07 PSTToolsTopicTPT 14.10 output to named pipe and then gzip to final filesI tried to write TPT output to named pipe, and then use gzip to compress the stream into final files. gzip < /var/tmp/fact_abc_segment.fifo-1 > ~/data/fact_abc_segment.1.fastload.gz gzip &l...
2701 Oct 2013 @ 09:16 PDTToolsReplyFast Export Binary Format file - Binary to ASCII conversion and load in HDFShttps://github.com/xlfe/dwhwrapper is by far the cloest option you have. TPT 14.** support CSV export as long as you come up the SQL to convert everything to VARCHAR/CHAR.
2601 Oct 2013 @ 12:30 PDTToolsTopicWhat is the root casue for TPT02019 in TPT 14.00Where there are several TPT Load jobs running at the same time, the TPT will randomly fail with the following error(s). But once we rerun the job again, the TPT just succeeds. We try to let TPT fi...
2516 Jun 2013 @ 01:13 PDTDatabaseReplyHow to efficiently join GEO IP RANGE data - How to avoid product JOINAny suggestion?
2407 May 2013 @ 05:07 PDTToolsReplyTeradata query parserMy XML explain plan output seems to be truncated in 13.10 still. It might be safe for me to establish the session in ASCII mode.
2303 May 2013 @ 11:24 PDTDatabaseTopicHow to efficiently join GEO IP RANGE data - How to avoid product JOINProblem Description A typical lookup kind of JOIN between FACT table with hundreds of millions of web clicks, and DIM table with 55M IP ranges in numeric style (e.g. downloaded from MaxMind). The...
2213 Apr 2013 @ 01:00 PDTToolsReplyTeradata query parser"EXPLAIN IN XML" may return a very long XML encoded in UTF16, which is longer than 64K bytes, then the output is truncated. Then we can't use such XML. Is there fix or workaround for...
2108 Apr 2013 @ 11:07 PDTDatabaseTopicIs the full TTU 14.10 available for download yet?The 14.10's documents have been fully published in info.teradata.com but the download media for "BCD0-1560-0000" seems not fully available. I can only find the following files so far...
2018 Mar 2013 @ 10:08 PDTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definitionHi Steven, Thanks for the reply. Let me clarify my question: NET_ID defined as Decimal(38,0) in DDL, but what should I define in TPT file schema? when MaxDecimalDigits = 18Ma...

Pages