#DateForumTypeThreadPost
3503 Aug 2016 @ 10:52 PDTHadoopTopicSqoop importing into Hive - supported file formatsHi, I'm new to Hadoop.  We are using CDH5.  I am managing to use sqoop to load from Teradata into Hive as textfile, but that seems to be the only supported option.  It seems like...
3409 Mar 2016 @ 06:32 PSTDatabaseTopicAm I Fastloading?Hi, is there any way of telling retrospectively whether a table load was done via a fastload? I have some slowly performing loads performed by a 3rd party ETL tool - they're meant to be fastlo...
3304 Jan 2016 @ 03:59 PSTToolsTopicTPT via .NET (C#)Hi, I'm wondering the best way to trigger fastload from a Windows .net platform...  Looks like the TPT API might be the way to go - has anyone ever done a c# wrapper for this?  Or are...
3222 Dec 2015 @ 09:25 PSTToolsReplyTPT Error Message - Delimiter did not immediately follow close quote mark in row 109785, col 8.I recently upgraded to 15.10 from 15 - I don't recall having these issues before, although that might be a coincidence. There aren't any non-ASCII characters in my input file. I get the s...
3121 Dec 2015 @ 05:06 PSTToolsReplyTPT Error Message - Delimiter did not immediately follow close quote mark in row 109785, col 8.Just to confirm - this is expected functionality that I should work around, rather than an issue?
3016 Dec 2015 @ 02:21 PSTToolsReplyTPT Error Message - Delimiter did not immediately follow close quote mark in row 109785, col 8.I'm running on Windows.  However, many of the files which need to be uploaded originate externally from Unix-like systems. LF works 99.9% of the time via Windows TPT.  Actually,...
2915 Dec 2015 @ 09:46 PSTToolsReplyTPT Error Message - Delimiter did not immediately follow close quote mark in row 109785, col 8.Also, I have tried importing the file using the fastload utility, and it works ok - it is just TPT that has the error
2815 Dec 2015 @ 08:55 PSTToolsTopicTPT Error Message - Delimiter did not immediately follow close quote mark in row 109785, col 8.Hi, I get the above error message for a file.  This file has Unix-style line endings (i.e. 'LF') However, if I go into the data (using Notepad++) and change to Windows-style line end...
2701 Dec 2015 @ 07:26 PSTToolsTopicTPT 15.10 templatesHi, it appears that the template files provided with TPT 15.10 differ from those with TPT 15.00; i.e. $FILE_READER used to have variables like @FileReaderFileName, and now they are like @...
2619 Nov 2015 @ 05:17 PSTToolsReplyTPT - Timestamp format error 6760Hi Steve - by 'previously' I meant I thought it was working this way; obviously it never did, but as you say the DBS was being helpful by handling the date formats I sent anyway.  I un...
2519 Nov 2015 @ 05:04 PSTDatabaseTopicRegular ExpressionsHi, is there anyway to specify which Regular Expression capturing group to return when using regexp_substr in TD 14.10?  
2405 Oct 2015 @ 10:23 PDTToolsTopicTPT - Timestamp format error 6760I have a simple load step DEFINE JOB Run_Load ( Step Load_Tables ( APPLY $INSERT TO OPERATOR ( $LOAD() ATTRIBUTES ( ...
2323 Sep 2015 @ 02:49 PDTDatabaseReplyNo Primary Index - skewingThank you, I've learnt something ;-)  It seems that this behaviour can be flexed within TPT by specifying smaller BufferSize, but as you say, if this is only a problem with small tables, t...
2222 Sep 2015 @ 02:02 PDTDatabaseReplyNo Primary Index - skewingFor information, I have loaded this data using TPT.  I have tried loading the same data into new empty tables with the same structure, and the skew is still high but changes each time - 59.44%...
2122 Sep 2015 @ 01:37 PDTDatabaseTopicNo Primary Index - skewingHi,  I have a table with approx 65,000 rows in, which I have defined as having "NO PRIMARY INDEX".  As far as I understood, such tables shouldn't skew, but I am calculating ...
2022 Sep 2015 @ 01:36 PDTDatabaseTopicNo Primary Index - skewingHi,  I have a table with approx 65,000 rows in, which I have defined as having "NO PRIMARY INDEX".  As far as I understood, such tables shouldn't skew, but I am calculating ...
1926 Aug 2015 @ 08:55 PDTToolsReplyTPT Load errors, exit codeI think that would be a good feature, thanks.  My workaround is to parse the TPT output to compare the count of rows sent to the rdbms against the count of rows applied
1820 Aug 2015 @ 09:38 PDTToolsTopicTPT Load errors, exit codeHi, hopefully an easy to answer question; currently TPT is exiting with a status code of 0 even if rows have been sent to one of the error tables during loading.  Can I get TPT to return a non...
1722 Jul 2015 @ 10:17 PDTToolsReplyTPT - Load progress indicationThanks both for your help
1617 Jul 2015 @ 01:15 PDTToolsReplyTPT - Load progress indicationHi, sorry to bump this, but can anybody help?  Should this info be in the logs?
1511 Jul 2015 @ 04:08 PDTToolsTopicTPT - Load progress indicationHi - what is the best way of seeing how many rows a TPT Load operation has processed?   Currently, I get little console output, and for large files it can seem like the job has frozen.  ...
1419 Jun 2015 @ 06:58 PDTToolsReplyTwo minor issues concerning TDSQLA 14.10.0.02 FunctionalityI don't have any answers, but I agree that it is annoying that clicking in the History window overwrites whatever query I was working on; I hope there is some setting for this
1318 Jun 2015 @ 08:42 PDTToolsTopicTPT - $INSERT generation Hi, when using code such as the following:   APPLY $INSERT TO OPERATOR (LOAD_OPERATOR) SELECT * FROM OPERATOR($FILE_READER( DELIMITED  @TargetDatabase || '.' || @Ta...
1218 Jun 2015 @ 05:29 PDTToolsReplyTPT Date format errorOk, thanks, latest version fixed the issue
1117 Jun 2015 @ 02:45 PDTToolsReplyTPT Date format errorThe client is 15.00.00.00 actually, here is more of the log information:        ==========================================================================    ...

Pages