#DateForumTypeThreadPost
3615 Dec 2015 @ 08:57 PSTDatabaseTopicPerforming transformations in BTEQ vs TPTHi All, Does someone tell me pros and cons of performing Transformations in BTEQ vs TPT? To be more precise, I am looking for what can be and what cannot be done wrt transformation in BTEQ and TP...
3514 Dec 2015 @ 10:08 PSTToolsReplyFASTLAOD on TTU15 - Empty file on read open The "Empty file on read open" can happen because of the following reasons 1) It cannot find the source data file. Make sure the file exists and that the user had read permisisons on the ...
3414 Dec 2015 @ 09:58 PSTToolsTopicTransformations in BTEQ vs TPTHi All, Does someone have a chart that describes the pros and cons of performing Transformations in BTEQ vs TPT? To be more precise, I am looking for what can be and what cannot be done wrt transf...
3314 Dec 2015 @ 09:52 PSTHadoopReplyTeradata Binary file to Hadoop Sequence FileNot sure what you meant by a teradata binary file, but if you have data loaded in a Teradata table, you can use TDCH to import the data into the Hadoop table created as "Sequence file".
3214 Dec 2015 @ 09:49 PSTHadoopReplyTDCH Import command - Export Data from Teradata to HADOOPHanif, When importing data into Hadoop from Teradata, if you were to use a "sourcetable" option in your TDCH job, you have the ability to use either split.by.hash, split.by.value or even...
3120 Nov 2014 @ 03:27 PSTToolsTopicTPT19113 Data length implied by Data Schema (xxx) is not the same as record length (yyy) on TPT loadHi TD Guru's, I am facing an issue where I am trying to load a Fixed width file using TPT load. It has a few FILLER columns that I need to ignore and I am running into the issue as described i...
3028 Jul 2014 @ 10:23 PDTDatabaseReplyhelp with SQLHi, Yes, you are right. I need to group on the first 2 columns (COL1 and TS). Also, another scenario to add   405273444339513690 2014-06-02 00:35:29    ?   &n...
2928 Jul 2014 @ 07:54 PDTDatabaseTopichelp with SQLHi Gurus, Could you please help me with the below SQL? I need to merge the columns from a few rows on the same table based on a different grouping criteria.   This is how the input data loo...
2824 Jul 2014 @ 08:47 PDTDatabaseReplyregexp_substr in TD14.10Thank you Dieter and Vinod. This is exactly what I've wanted. Much appreciated.   Dieter, Can you kindly tell me how you would skip the delimiter within the double-quotes in TPT. I am n...
2723 Jul 2014 @ 09:08 PDTDatabaseReplyregexp_substr in TD14.10Thanks Raja. This does not work, as we are vertical pivoting taking the commas inside the double-qutes into consideration. I need the output to be something I can insert into multiple columns....
2623 Jul 2014 @ 06:34 PDTDatabaseTopicregexp_substr in TD14.10Hi Gurus, Hope all is well with you. I am trying to solve an issue with parsing a text field based on a delimiter and with the same delimiter being part of the double-quotes. I am on DB vers...
2514 May 2014 @ 01:00 PDTDatabaseReplyVertical pivotingHi Dieter, Here is the table structure and the explain plans. Each record on the CAT_ID can have upto 250 values separated by a delimiter.      CREATE SET TABLE common.test ,FAL...
2414 May 2014 @ 12:04 PDTDatabaseReplyVertical pivotingHi Dieter, Thanks again.   This would be a daily load. The table is 26GB with 27M records intially and could go upto 200M. I have about 1.6TB in spool. I've tried both the options above...
2314 May 2014 @ 11:00 PDTDatabaseReplyVertical pivotingHi Dieter, Thank you for your prompt response. Although my DBA has increased my spool big time, I run out of spool implementing your low spool solution. Is there any other to implement this? Pleas...
2214 May 2014 @ 07:18 PDTDatabaseTopicVertical pivotingHello Gurus, Good morning!!   I am facing an issue where I want to vertical pivot a column value with a delimiter in it. I am on DB version 13.0 and hence would not be able to use some of t...
2115 Jan 2014 @ 07:57 PSTAsterTopicHive Views in AsterHi Team, Can someone please tell me if Hive Views are supported in Aster? It throws me an error message and I do not seem to understand it. Executed as Single statement.  Failed [34 : HY000]...
2015 Jan 2014 @ 07:48 PSTAsterReply Connection between Aster and HadoopAccording to my understanding, if you do not use any filters, the whole table will be copied to Aster. The ONLY exception to this is if your table on Hive is Partitioned and you used partition elim...
1913 Jan 2014 @ 07:22 PSTConnectivityReplyMasking Password on the JDBC connectivity from Hadoop to Teradata.I don't think any of them would work here. TDCH has more features than Sqoop.
1812 Jan 2014 @ 06:54 PSTConnectivityReplySqoop Import from Teradata with 30 lines of SQL query using –query is failingcan you paste the entite sqoop command that you were using?
1710 Jan 2014 @ 11:12 PSTConnectivityReplySqoop Import from Teradata with 30 lines of SQL query using –query is failinguse an options file parameter.. "--options-file" and use the "--query" option with the sql in multiple lines with a line concatenation "\" something like..   -...
1610 Jan 2014 @ 06:53 PSTConnectivityReplyMasking Password on the JDBC connectivity from Hadoop to Teradata.Thanks Raja. I unfortunately do not have FTPPWD utility installed on the gateway. Any other suggestions? Sqoop has a password file option, but TDCH does not have one.
1509 Jan 2014 @ 10:32 PSTConnectivityTopicMasking Password on the JDBC connectivity from Hadoop to Teradata.Hello Friends, Can someone share some insights on how I can mask the password when I make a connection from Hadoop to Teradata using the JDBC drivers? I understand that the password can be en...
1403 Apr 2013 @ 11:11 PDTToolsTopicMoving data from Oracle to Teradata using DataDirect ODBC driversHi Gurus, Need  your expertise here.. The challenge that I am faced with is to transfer data from an Oracle Instance into a Teradata system on a regular basis. I understand that DataDirect Or...
1324 Oct 2012 @ 01:44 PDTDatabaseReplyHelp with SQLThank you very much Dieter. This is exactly what I've wanted. I am running out of spool when when run on a table with a couple million records. Can you think of something that can give me a bet...
1224 Oct 2012 @ 11:29 PDTDatabaseReplyHelp with SQLHi Ulrich, For a combination of col1,dt,col4 the record with col3 value "2" is the first (which is record# 1) for dt 9/27. For dt 10/13, record # 5 is the first. In other words, these a...

Pages