All forum activity

#DateUserForumTypeThreadPost
5811729 Jun 2016 @ 07:49 PDTloafobDatabaseTopicOREPLACE issues between environments Hello,   I have a query using OREPLACE that runs in one environment, but fails in another with:   Executed as Single statement. Failed [7509 : HY000] Result Exceeded maximum length...
5811629 Jun 2016 @ 06:26 PDTsachin.sebastianGeneralReplySome roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS DBC.RoleInfo view provides information of all roles defined (It is derived from DBC.Roles table) DBC.AllRoleRights view provides information about the rights granted to each role You can fi...
5811529 Jun 2016 @ 05:55 PDTarkaprava.chandraGeneralTopicSome roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTSHI All, Could you please tell us, what is the basic difference between DBC.ROLEINFO and DBC.ALLROLERIGHTS? Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS.   Thanks, A...
5811429 Jun 2016 @ 04:08 PDTM.Saeed KhurramExtensibilityReplyurgent : xml conversionHi, This is a very strange issue. I tried to multiple solutions but this problem is something need to be reported to CS. I was able to get only the folowing information from TD docs. 7504 in U...
5811329 Jun 2016 @ 03:27 PDTCarlosALDatabaseReplyDifference between NOT IN() AN NOT(COL1 IN))Hi. The two "IN" expresions are equivalent. Have you experienced any performance difference? If so, post the execution plan. NOT IN is not the same as NOT EXISTS if NULLs are prese...
5811228 Jun 2016 @ 11:03 PDTM.Saeed KhurramToolsReplyLook up in TPTNO. As you will be using two separate operators: FileReader to read the file and export to select data from table. Why dont you load the file in step-1 into a temp table, and use that table  ...
5811128 Jun 2016 @ 10:57 PDTkchinnadTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listingTeradata Workspace Log: 2016-06-29 13:55:18,872 Teradata Datatools [Worker-8] ERROR c.teradata.datatools.hadoop.catalog - null java.lang.NullPointerException: null at com.teradata.datat...
5811028 Jun 2016 @ 10:20 PDTM.Saeed KhurramDatabaseReplyTransaction control in BTEQ scriptIs there a limitation to write this complex logic in BTEQ? Why dont you write a stored procedure and call that SP in BTEQ script?
5810928 Jun 2016 @ 10:17 PDTM.Saeed KhurramAsterReplyusing Teradata Stored Procedures to pull data into AsterOne possible option is to execute the procedure on Teradata and store the results in a table, then use that table as source in load_from_teradata MR function.  
5810828 Jun 2016 @ 10:04 PDTNirubanToolsTopicLook up in TPTHi All, Can anyone kindly let me know is it possible to perform look up in TPT ? I am having around 100K record in a file. I want to load it into a table by looking up another table(by joining a c...
5810728 Jun 2016 @ 09:51 PDTNirubanToolsReplyTPT load failure on Interval datatype - Error code 7452Hi All, Is it possible to join data from a flat file with table in TPT? I am having around 1K records in flat file and I need to look up a column in the file with a table and load it into another ...
5810628 Jun 2016 @ 09:35 PDTssavoyeToolsReplyTPT load failure on Interval datatype - Error code 7452It actually loads if data is formatted without the plus (+).  Negative works.  I am not sure why, but looks like I will have to replace the plus with null when I pull from Oracle.  S...
5810528 Jun 2016 @ 09:04 PDTpushkarcseDatabaseReplyCOLUMNAR TABLE- SELECT TOP N* FROM COLUMNAR TABLE NOT GIVING OUTPUTPlease find the ticket details. RECGVS2J6   Please let me know if any other information is required.
5810428 Jun 2016 @ 08:54 PDTpushkarcseDatabaseReplyCOLUMNAR TABLE- SELECT TOP N* FROM COLUMNAR TABLE NOT GIVING OUTPUTHi Todd, I have created one incident to Teradata support Team. They are still analysing the issue.I will share the ticket as soon as possible.
5810328 Jun 2016 @ 08:45 PDTToddAWalterDatabaseReplyCOLUMNAR TABLE- SELECT TOP N* FROM COLUMNAR TABLE NOT GIVING OUTPUTWas it possible to create an incident for this?   We did some testing and were unable to reproduce the issue.  If there is an incident, please share the incident #. If not, perhaps some...
5810228 Jun 2016 @ 08:14 PDTkchinnadTeradata StudioTopicTerdata Studio - Connection to Hive - Database is not listing OS : Windows 7 Professional system type : 64-bit OS Memory : 4 GB TD Studio version : Teradata Studio nt-x8664 15.10.00.04 - TERADATA_STUDIO_1510_X64_V1_INSTALL Hadoop Distributi...
5810128 Jun 2016 @ 02:46 PDTmm185159ViewpointReplyImpact CPUThank-you for your response. That is fundamentally all I was looking for, a general rule of thumb or best practices guideline. 3x seems fair, although on long running jobs, 2x might be a significan...
5810028 Jun 2016 @ 02:44 PDTfgrimmerTeradata StudioReplyIssue Downloading Studio even After Java installedSince this is a new install, you may want to use the latest version of Studio Express which 15.11. It is available on the Teradata Developer Exchange Download site.
5809928 Jun 2016 @ 02:44 PDTssavoyeToolsTopicTPT load failure on Interval datatype - Error code 7452Any assistance would be welcomed.  I cannot seem to put the Interval in a format that Teradata likes.  The column data looks like "00 02:00:00.000000".  We are extracting i...
5809828 Jun 2016 @ 02:43 PDTfgrimmerTeradata StudioReplyIssue Downloading Studio even After Java installedBecause your system is a 64-bit system, 64-bit applications will go in Program Files and 32-bit applications will go in Program Files (x86). The problem looks like Studio Express is being executed...
5809728 Jun 2016 @ 02:41 PDTmm185159AsterReplyusing Teradata Stored Procedures to pull data into AsterSo, I am trying to call a teradata stored procedure due to complex processing that works best on teradata (push-down). The stored procedure then returns a result set (dynamic data set) which needs ...
5809628 Jun 2016 @ 02:37 PDTemchisholmTeradata StudioReplyIssue Downloading Studio even After Java installedlooks like some sort of issue with TeradataStudioExpress__win64_x86.15.10.01.01 ... TeradataStudio__win64_x86.15.10.00.02 installed and works fine.
5809528 Jun 2016 @ 02:02 PDTdon.brownToolsTopicTDwallet installationI'm new to using Teradata and would like to use tdwallet in some of the scripts I am creating.  The person who installed our client software (RedHat Linux) did not install tdwallet.  ...
5809428 Jun 2016 @ 01:58 PDTemchisholmTeradata StudioReplyIssue Downloading Studio even After Java installedUghh ... I swear from what we determined that is was the 64 bit version ... I got another version and got it to install .. but it installed in the "C:\Program Files" folder and I wou...
5809328 Jun 2016 @ 11:55 PDTboagus1DatabaseTopicDifference between NOT IN() AN NOT(COL1 IN))A developer on our project is using logic that I can't find in any Teradata documentation, so I was hoping for some insight on it's performance. NOT(ORDER_ID IN (2,3,4) is how it's cod...

Pages