All forum activity

#DateUserForumTypeThreadPost
5884431 Jul 2016 @ 01:42 PDTlokesh_meesalaGeneralTopicerror table's are invalid state or table is being loaded Hi,   we are getting the interminent issue for TPT both easy loader and script as well while uploading file to teradata. the error getting as" error table's are inv...
5884331 Jul 2016 @ 12:35 PDTsakthikrrDatabaseReplyAggregate details into summary - case statementUpdated detailed table with missing column: ID          AWARD_TYPE_CD          GSM     LL      Loyalty Points &nb...
5884230 Jul 2016 @ 11:35 PDTBRIANHDatabaseTopicDBC - CURRENTPERM EXCEEDS MAXPERMI had a power outage and of course Teradata was running.  Teradata - 13.1 I'm running Terdata under VM player and there apparently are no issues with Teradata starting and stopping... I...
5884130 Jul 2016 @ 07:16 PDTjlux33ConnectivityReplyTeradata Birt JDBC datasource creationDid you ever get the JDBC data source for Teradata workign in BIRT?
5884030 Jul 2016 @ 04:36 PDTFredGeneralReplyFinding the Sub String Between < and >In (?<=<) the first < is special (combined with ? and =  makes a lookbehind rather than lookahead) but the second is treated as a literal '<' character based...
5883930 Jul 2016 @ 03:08 PDTahhmedbilalHadoopTopicteradata.connector.plugins.xmlHi,  I am trying to import data to hive (HDP 2.4) from teradata 14.10 using TDCH.  TDCH ver is 1.3.4 as for 1.4.1 the hadoop jar .... command gives invalid jar file error. here is comma...
5883830 Jul 2016 @ 01:25 PDTarsaggGeneralTopicInvalid date supplied for a column - Error code 2666Hi All,     I have a union of two query, when I the SELECTs individually, I am able to execute it properly, however when I run them with UNION, I get the error message as "Failure ...
5883730 Jul 2016 @ 01:15 PDTsakthikrrDatabaseTopicAggregate details into summary - case statement Dears, We need to summarize the below detail data as expected; but somewhere we are missing something and not getting the proper aggregate. Pls help.   Detailed data:  ...
5883630 Jul 2016 @ 05:06 PDTmerohin27TrainingReplyAny best Training Centres you guys know in Hyderabad??Please inbox me ..I will share the details and some meterial I have..   merohin27@gmail.com
5883530 Jul 2016 @ 04:56 PDTM.Saeed KhurramAsterReplyRunning ncluster_export fails with uppercase objectsHi, In order to make the case sensitive use of table name the qoutes should be escaped like below: ./ncluster_export -h 192.168.1.100 -U xxx -w xxx -c \"TesT\" outputFile  
5883429 Jul 2016 @ 03:17 PDTFredToolsReplySQL Assistant 15.00 Cursor lagging problems There is a newer version in the TTU15.10 bundle currently available from the Developer Exchange http://download.teradata.com/downloads page. For patch levels other than the ones on this site, see ...
5883329 Jul 2016 @ 02:28 PDTtmcrouseDatabaseReplyCrosstab query help in TeradataAwesome. Thanks so much I got this to work and posted my code so it might be of help to others   create multiset table dl_qpt_cqe.medicare4 as (select distinct MbrKey, max(case when hedism...
5883229 Jul 2016 @ 12:17 PDTPrivate Forum
5883129 Jul 2016 @ 12:00 PDTdnoethDatabaseReplyCrosstab query help in TeradataTo pivot data you need to apply MAX to the CASEs like MAX(case when HM = 'COAFunctional' then 1 else 0 end) and add a final GROUP BY KeyId. If KeyId is the PI of the table this should be...
5883029 Jul 2016 @ 11:21 PDTPrivate Forum
5882929 Jul 2016 @ 11:21 PDTtmcrouseDatabaseTopicCrosstab query help in TeradataI thought using a case statement would work for what I needed but it did not. I wanted to transpose but that is only in SAS as far as I know and I have a table with 888 million rows and that is jus...
5882829 Jul 2016 @ 09:27 PDTkirthiDatabaseTopicPartition Usage Evaluation on a TableWe have a set of tables in production, created with PPI with partition definded on a CHAR (4) column long time back. Now We receive multiple requests throughout the year to add More values to the p...
5882729 Jul 2016 @ 08:39 PDTGauthJesToolsReplySQL Assistant 15.00 Cursor lagging problems where can I download the latest version "15.00.0.9"? ca't seem to find it on the "download" page. thank you.
5882629 Jul 2016 @ 08:35 PDTmark123ConnectivityReplyQuerying teradata with UDF from Excel Aha, Default Database needs to be set in Excel connection or make sure all names are fully qualified in the query itself
5882529 Jul 2016 @ 04:24 PDTPrivate Forum
5882429 Jul 2016 @ 02:53 PDTIrwingDatabaseTopicExtract and Analyse Database Object DependenciesThis post by Ulrich, was where I started out my search on a way to get a summarised report on a complete listing of all the tables and views within a view: http://developer.teradata.com/blog/ulric...
5882329 Jul 2016 @ 02:42 PDTjan.simeckaAsterTopicRunning ncluster_export fails with uppercase objectsHello, when running the ncluster_export for a database object containing uppercase letters, the object name gets translated to lowercase even if double quotes are used, resulting in a fa...
5882229 Jul 2016 @ 02:07 PDTindra91ConnectivityTopicCloudera Connector Powered By TeradataThe cloudera connector powered by Teradata is used to export the data from teradata systems to Hadoop using Sqoop.I would like to know how it maintains read-consistency while reading the data from ...
5882128 Jul 2016 @ 10:32 PDTaneelkumar04DatabaseReplyhow to handle Null values in FASTloadThank you Fred and saeed
5882028 Jul 2016 @ 10:26 PDTauatospwToolsReplyHELP cannot display long field namesYeah that works. Thanks RGlas!

Pages