All forum activity

#DateUserForumTypeThreadPost
5831708 Jul 2016 @ 02:30 PDTfgrimmerTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listing@kchinnad, Can you verify the WebHCatalog service is set up correctly. I read from another post that it needs to be on all the Name Nodes? I also found an earlier post that refer to steps to do thr...
5831608 Jul 2016 @ 01:20 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHThanks Steven. I removed the quotes, but it still wouldn't accept them as timestamps. I have talked to the business unit that is going to use this software and they are going to be fine with t...
5831508 Jul 2016 @ 01:06 PDTfeinholzToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHTPT 13.10 does not support quoted data. That went into TPT 14.0. And TPT 13.10 is not a supported release anymore. You will have to upgrade your version of TPT, or pre-process the data to remove...
5831408 Jul 2016 @ 12:41 PDTdkirunchDatabaseTopicoTranslate issueHi, I have a field called TRADE_NAME which is defined as CHAR(70).  There are some weird characters in it and I want to convert them to spaces. I tried using the oTranslate below but the resul...
5831308 Jul 2016 @ 12:19 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHUpdate: VARCHAR QuotedData='optional'  Did not remove the quotes before insert on my TPT version.  I then removed the quotes manually and dictated the exact format of the tim...
5831208 Jul 2016 @ 12:03 PDTGlassGeneralReplyHOW TO GET ODD NUMBER ROWS IN A TABLE IN TERADATAWhat application are you using and what RDBMS version are you on? I'm curious why Carlos' solution did not work for you.   Rglass
5831108 Jul 2016 @ 11:50 PDTGlassViewpointReplyViewpoint SUSE CompatibilityAvot, It is, I've been there. Your CSR should provide you with a matrix, or find on T@YS.   Rglass
5831008 Jul 2016 @ 11:04 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHBTW - This is our tpt version: Teradata Parallel Transporter Version 13.10.00.05
5830908 Jul 2016 @ 11:02 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHOK - tried to change the two fields to TIMESTAMP(6) and QuotedData='optional', but all data fails to insert and in my error table I have all errors 6760. Any additional thoughts?   T...
5830808 Jul 2016 @ 10:48 PDTfeinholzToolsReplyNeed Help regarding TPT ODBC OperatorSince you are using LoadInst as the variable for the file writer, yes you just need to set LoadInst=7.   Yes, Total processor time is the CPU time for that operator.  
5830708 Jul 2016 @ 10:43 PDTfeinholzToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHYes, that is correct.
5830608 Jul 2016 @ 10:20 PDTfeinholzToolsReplyTPT02639 - Conflicting data type error for columnPlease provide the script and version of TPT. Did you use VARCHAR in the schema for that column? If so, then you need to change that to match the source table definition. And with a character se...
5830508 Jul 2016 @ 10:20 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHWhere do i set QuotedData='optional' ? File_Source_Schema? Like:   DEFINE OPERATOR FILE_READER TYPE DATACONNECTOR PRODUCER SCHEMA FILE_SOURCE_SC...
5830408 Jul 2016 @ 10:17 PDTfeinholzToolsReplyTPT output from ODBC includes Indicator Bytes?The schema must match the source. We must know what the data looks like as it comes to TPT. Oracle is a little challenging because of the different formatting of some of the data types. INTEGER ...
5830308 Jul 2016 @ 10:07 PDTfeinholzToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHThe version of TPT is present when you run TPT. As for the timestamp, whether there are quotes or not is very important. Unless you tell us otherwise, every character is considered part of the da...
5830208 Jul 2016 @ 10:07 PDTtdreturnDatabaseReplySQL error using Teradata JDBCNOTE that this SQL works on SQL and Teradata Express but not through the JDBC driver and JNDI.
5830108 Jul 2016 @ 09:45 PDTFredToolsReplyteradata TPT , all rows in error tableYou apparently have non-LATIN data in your UNICODE columns, but are defaulting to ASCII session character set. Specify USING CHARACTER SET UTF16 at the start of your script. Note that in SCHEMA de...
5830008 Jul 2016 @ 08:54 PDTrsilversDatabaseTopicobject logging for view Hi, It is my understanding when object logging is turned on a VIEW does not show the columns that are accessed. Instead they are shown in the underlying table that the view refers to. Do...
5829908 Jul 2016 @ 08:32 PDTgrommelDatabaseReplyTeradata Table Naming MultiLoad and FastLoad aren't exactly obsolete -- they are still present in recent releases of TTU -- but I agree that you should use TPT nowadays. The MultiLoad and FastLoad partitions within ...
5829808 Jul 2016 @ 08:09 PDTArpan.RoyToolsReplyTPT output from ODBC includes Indicator Bytes?Thanks a lot Steve. Just wanted to understand, what will be our focus while defining SCHEMA in tpt control file? Is it Source Table or Target Table? If Source and Target table is having different ...
5829708 Jul 2016 @ 08:01 PDTmcorsiToolsReplytpt conversion from varchar to timestamp(6) DEFINE SCHEMA FILE_SOURCE_SCHEMA ( Main_Id VARCHSteven - Any further thoughts on this issue?  Regards, Mark
5829608 Jul 2016 @ 06:31 PDTRonaldBrayanDatabaseTopicRestore using DSA with NO BUILD option.Hi, I have a large restore around 5 TB, I'm using DSA to Backup and restore. I want to restore with NO BUILD option and BUILD the tables separately using ARCMAIN(Build Data Table (xx.yy) ...
5829508 Jul 2016 @ 05:37 PDTarchana_2016ToolsTopicTPT02639 - Conflicting data type error for columnHi I am trying to export table data to file using TPT script using encoding UTF8 and the column structure is as follows that contains chinese title ex: zone_num char(6) CHARACTER SET LATIN CASESPE...
5829408 Jul 2016 @ 12:26 PDTgera_gGeneralReplyHOW TO GET ODD NUMBER ROWS IN A TABLE IN TERADATAThough you can use below query if you want odd number rows SEL * FROM TBL_NAME QUALIFY SUM(1) OVER(ROWS UNBOUNDED PRECEDING) MOD 2 = 1 ; and for even number rows use beow query SEL * FROM TBL_NA...
5829308 Jul 2016 @ 12:22 PDTgera_gGeneralReplyHOW TO GET ODD NUMBER ROWS IN A TABLE IN TERADATASorry CarlosAL but where clause doesn't support OLAP functions.

Pages