All forum activity

#DateUserForumTypeThreadPost
5941924 Aug 2016 @ 02:02 PDTsiddarthyDatabaseReplyBest way to generate the Sequential numbers : CSUM or IDENTITY columns?sriteradata88,   Use the below query.   SELECT      start_date   , SUM(amt) OVER (ORDER BY start_date             &nbs...
5941824 Aug 2016 @ 01:18 PDTwgfagundesDatabaseTopicODBC TimeStamp Hi Guys,   It's my first topic here, I'm new on Teradata and we are facing a problem with ODBC with Timestamp. Let me explain the situation:   We have a Oracle ...
5941724 Aug 2016 @ 01:05 PDTmarlon.howard@shawinc.comHadoopTopicWhat is the best way to import multiple tables into Hive from Teradata using TDCH?Using TDCH, What is the best way to import multiple tables into Hive from Teradata? Is there an option to move an entire database from Teradata to Hive?
5941624 Aug 2016 @ 01:04 PDTwgfagundesDatabaseTopicODBC TimeStamp Hi Guys, It's my first topic here, I'm new on Teradata and we are facing a problem with ODBC with Timestamp. Let me explain the situation: We have a Oracle GoldenGate running on IBM AIX r...
5941524 Aug 2016 @ 01:04 PDTdlcookToolsReplyEasyloader Schema Error 15.10 Only   Adding --SourceFormat delimited and --SourceFormat "delimited" both produce identical results to above.   Adding --SourceFormat 'delimited' produces: ...
5941424 Aug 2016 @ 12:26 PDTjohnhrschusterConnectivityTopicTeradata ODBC 15.10 32bit and MSAccess 2016 32 bit Cannot find Terasso libraryI am doing some testing on Windows 10 with Access 2016. Both are 32 bit installations The Teradata ODBC DSN works fine with SQLAssistant 15.10.00.02 The Teradatra ODBC DSN works fine with Bi-QUE...
5941324 Aug 2016 @ 12:03 PDTtoadrwToolsReplyEasyloader Schema Error 15.10 OnlyYou'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...
5941224 Aug 2016 @ 11:53 PDTfeinholzToolsReplyEasyloader Schema Error 15.10 OnlyOk, another update. Yes we have a regression. We were doing an EasyLoader overhaul and introduced a bug (that is currently being fixed). If you add --SourceFormat delimited (I do not remember whet...
5941124 Aug 2016 @ 11:39 PDTfeinholzToolsReplyfastload cannot start with error "The request exceeds the length limit, The maximum length is 1048500."I believe the issue *might* be related to the delimiter. The use of "\t" does not mean use the TAB character. We will look for the characters "\" followed by "t", and...
5941024 Aug 2016 @ 11:34 PDTfeinholzToolsReplyEasyloader Schema Error 15.10 OnlyWell, I could have edited the previous comment but did not in case someone read the old one. I checked with the developer to make sure no regressions have occurred and I was assured no regressions...
5940924 Aug 2016 @ 11:25 PDTfeinholzToolsReplyEasyloader Schema Error 15.10 OnlyIf you are loading data from a flat file to the Teradata Database, the schema will be taken from the target table. However, it looks like we may have a bug/regression from when EasyLoader was intr...
5940824 Aug 2016 @ 11:10 PDTtoadrwToolsReplyEasyloader Schema Error 15.10 OnlyI 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...
5940724 Aug 2016 @ 11:01 PDTtnshankarGeneralTopicTeradata Partition table used in Informatica - TPT (update) Hi ,   I am getting the below error when i try to run the Teradata partition table (Case_N) in Informatica -TPT connectivity .    Error : Target [TABLE_NAME] is an invalid databa...
5940624 Aug 2016 @ 08:01 PDTfgrimmerTeradata StudioReplyTDStudio stopped working after Java updateThe latest version of Studio does not place the JRE location in the .ini if you are using the default location. Can you upgrade to 15.11? 
5940524 Aug 2016 @ 07:44 PDTGhaliaDatabaseReplyLockingHi, After using LOCK TABLE MY_TABLE EXCLUSIVE I have an update Then , I want to add something like RELASE LOCK from MY_TABLE after the update, in case of fail. Is it possible in Teradata...
5940424 Aug 2016 @ 07:44 PDTdlcookToolsReplyEasyloader Schema Error 15.10 Only I may be running into this issue as well. How does tdload determine the source Schema?   I'm following along with the setup here: http://developer.teradata.com/database/art...
5940324 Aug 2016 @ 07:43 PDTGhaliaAnalyticsReplyRelease Lock from a TableHi Dieter,   After using LOCK TABLE MY_TABLE EXCLUSIVE I have an update Then , I want to add something like RELASE LOCK from MY_TABLE after the update,  in case of fail. Is it possib...
5940224 Aug 2016 @ 07:29 PDTArpan.RoyAsterReplyload_from_hcatalog --- error while selecting Varchar,Date,Timestamp columnHi All, Can you please help us om load_from_hcatalog issue we are facing? Thanks in advance. Arpan.
5940124 Aug 2016 @ 06:54 PDTtomnolanConnectivityReplyUsing RJDBC and connected successfully, I get errors when trying to write using "as.td.data.frame" or "dbWriteTable"...@jknife What problem are you encountering? Please post details of your code and what error you are seeing.
5940024 Aug 2016 @ 06:51 PDTdnoethDatabaseReplyInsert records in bulk into a Teradata TableNo, SQL Assistant, everything is faster than this. Better do it Teradata Studio (if you prefer a GUI, it will use the JDBC FastLoad protocol if the target table is empty) or switch to TPT (If it&#...
5939924 Aug 2016 @ 06:48 PDTsharonnToolsTopicHow can I load files into TD tables using .NET (C#)Hi, I'm writing a program that connects to TD. During execution i'm creating a class structure that i need to move to TD DB. In .net i can use Bulk Copy or write the data into text files...
5939824 Aug 2016 @ 06:47 PDTtomnolanConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityThe Teradata JDBC Driver's ResultSetMetaData.isNullable method has worked the way it does for several years, and we need to preserve its current behavior for applications that expect it.  ...
5939724 Aug 2016 @ 06:45 PDTindra91DatabaseTopicInsert records in bulk into a Teradata TableI have to insert some 50 million rows into a teradata table.The insert data will be generated by shell script.I know we can import data from a file using the IMPORT data option in the sql assisstan...
5939624 Aug 2016 @ 05:56 PDTjingguoToolsReplyfastload cannot start with error "The request exceeds the length limit, The maximum length is 1048500."  SESSIONS 4;  /* optional ,total number of sessions to be allotted for the script */ ERRLIMIT 1000; /* optional */   logon td/user,pass;    DATABAS...
5939524 Aug 2016 @ 05:55 PDTjingguoToolsReplyfastload cannot start with error "The request exceeds the length limit, The maximum length is 1048500."   SESSIONS 4;  /* optional ,total number of sessions to be allotted for the script */ ERRLIMIT 1000; /* optional */   logon td/user,pass;    DATA...

Pages