69 | 24 Aug 2016 @ 12:03 PDT | Tools | Reply | Easyloader Schema Error 15.10 Only | You're best Steve! Once again you came through and I'm so appreciative! Teradata is lucky to have you and thank you for sticking with this through until the end and providing us... |
68 | 24 Aug 2016 @ 11:10 PDT | Tools | Reply | Easyloader Schema Error 15.10 Only | I guess the issue I'm having if we are moving a flat file to Teradata why doesn't Easy Loader assume all VARCHAR?
Does this mean we need to create a job variables files with the proper sch... |
67 | 22 Aug 2016 @ 07:16 PDT | Tools | Reply | Easyloader Schema Error 15.10 Only | Hello Steve:
Again, sorry about the confusion. Below is the error and the private log when running under 15.10. We use the same command line switches for both loads. I would assu... |
66 | 22 Aug 2016 @ 04:16 PDT | Tools | Reply | Easyloader Schema Error 15.10 Only | Thanks Steve: I think I was sent the incorrect private log. I'll get back to you as soon as I can with the correct one. Sorry for the confusion.
|
65 | 22 Aug 2016 @ 01:36 PDT | Tools | Reply | Easyloader Schema Error 15.10 Only | On 15.00 you are correct everything is varchar. Moving the same file on 15.10 is not.
15.00 Private Log - Success
TPT_INFRA: TPT04101: Warning: TMSM failed to initialize
Teradata Paralle... |
64 | 22 Aug 2016 @ 10:53 PDT | Tools | Reply | Easyloader Schema Error 15.10 Only | Sorry about that. It doesn't work with the new DDL. We don't have a problem on 15.00 even with the original DDL where there are float columns. Here is the new test. ... |
63 | 22 Aug 2016 @ 08:09 PDT | Tools | Topic | Easyloader Schema Error 15.10 Only |
Hello:
We're receiving the following error on 15.10 whcih we were not receiving on 15.00. Could you please help? Here's our TD Load command line:
tdload -r... |
62 | 20 Jun 2016 @ 08:44 PDT | Tools | Reply | Easy Loader Skip Column in Flat File | Thank you for the response Steve! Appreciate your help once again!
|
61 | 20 Jun 2016 @ 12:09 PDT | Tools | Topic | Easy Loader Skip Column in Flat File | Hello:
Is there a way to only load specific columns from a flat file using tdload? Say my flat file has five columns, but I only need the last three. Is there anyway to specify the fir... |
60 | 29 May 2016 @ 10:54 PDT | Tools | Topic | TPT Data Streams | Hello:
I have a quick clarification on the TPT Architecture.
I'm executing a TPT script on my local PC which is using the ODBC Operator to pull data from a non-Teradata data source. I... |
59 | 19 Apr 2016 @ 11:33 PDT | Teradata Database on AWS | Reply | QueryGrid Teradata to Hadoop Configuration Issues |
Thanks for the reply!
This is good advice for those who want to set this up the right way and it makes more sense in hindsight. :P
The whole unknow error thing thre... |
58 | 17 Apr 2016 @ 04:31 PDT | Teradata Database on AWS | Reply | QueryGrid Teradata to Hadoop Configuration Issues | A little farther...
We can get data using the following syntax.
SELECT *
FROM SYSLIB.load_from_hcatalog(USING
hosttype('hadoop')
server('sandbox.hortonwork... |
57 | 17 Apr 2016 @ 11:16 PDT | Teradata Database on AWS | Topic | QueryGrid Teradata to Hadoop Configuration Issues | Hello:
I believe I've installed all the functions in the t2t and t2h directories on Teradata.
I'm using the Teradata Base+ instance running on Amazon AWS (single node)
I can query a remo... |
56 | 16 Oct 2015 @ 09:58 PDT | Connectivity | Reply | ODBC driver decimal culture format issue | I also saw that I had Region also set to Norway under the Location tab.
1. Go to Control Panel
2. Under "Clock Language and Region" click on the "Change date, time or numb... |
55 | 16 Oct 2015 @ 09:39 PDT | Connectivity | Topic | ODBC driver decimal culture format issue | Hello:
I'm using the Teradata ODBC driver 15.00.00.01 and testing Norwegian decimal localization in an application. I created a table with a column with data type decimal(7,2). I inserte... |
54 | 09 Jul 2015 @ 03:24 PDT | Tools | Reply | File Writer operator writing out 0 for decimal columns with precision greater than 18. | Thank you Steve! We're working around this by casting, but it is nice to know that it wasn't something we were doing wrong (which is rare). :P
|
53 | 08 Jul 2015 @ 07:40 PDT | Tools | Topic | File Writer operator writing out 0 for decimal columns with precision greater than 18. | Hello:
When exporting data to a flat file we seeing that decimals with over 18 precision are being returned as zero. MaxDecimalDigits is set to 38 so is there something else we are doing inc... |
52 | 21 Apr 2015 @ 09:39 PDT | Tools | Reply | Calling tbuild.exe directly via command prompt (Windows) | As always, thank you Steve!!!
|
51 | 20 Apr 2015 @ 04:19 PDT | Tools | Reply | Calling tbuild.exe directly via command prompt (Windows) | So the trick is when you have tpt installed, but the tbuild command is not calling TPT is to first try uninstall/reinstall. If that doesn't work then the next step would be to add the pat... |
50 | 17 Apr 2015 @ 01:39 PDT | Tools | Reply | Calling tbuild.exe directly via command prompt (Windows) | Hi Martin:
Thank you for the reply!
Our batch file is calling tpt the same way using just tbuild. Our jobs are running fine when we can execute tpt by just type in tbuild. To d... |
49 | 16 Apr 2015 @ 01:04 PDT | Tools | Topic | Calling tbuild.exe directly via command prompt (Windows) |
Hello:
Sorry. I had posted this earlier, but I accidently unpublished it while looking at it.
We would like to be able to call tbuild.exe directly in a batch file. ... |
48 | 16 Apr 2015 @ 12:37 PDT | Tools | Reply | TPT Stream Loader - Create Macro Access error on target database (not working database). | So I guess the restart log table's database will be the target database. Is this correct? I think it is making more sense now (unless my previous statement is incorrect). Than... |
47 | 13 Apr 2015 @ 04:13 PDT | Tools | Reply | TPT Stream Loader - Create Macro Access error on target database (not working database). | Hello Steve:
Thank you for the reply!
The documentation says "the default macro database is the restart log table database" which I believe is the working database correct?
We h... |
46 | 20 Mar 2015 @ 12:35 PDT | Tools | Reply | ODBCOperator: TPT17187: Failed to obtain shared memory segment for for column data buffer, due to error 48. | Hello Steve:
This fixed the issue. Thank you so much!
|
45 | 20 Mar 2015 @ 12:00 PDT | Tools | Topic | TPT Stream Loader - Create Macro Access error on target database (not working database). | Hello:
When trying to use TPT to stream data from SQL Server we're running into the following error.
'The user does not have CREATE MACRO access to database TargetDatabase'.
The Targ... |