#DateForumTypeThreadPost
7917 Aug 2014 @ 06:38 PDTTeradata StudioTopicTeradata Studio 15.0 connecting to Hadoop fails with Oozie connectivity failureHello All, I've a desktop Centos installation with Hadoop 2.1, TDCH 1.3.1 and Studio 15.0 installed, (benefits are that everything is on the one OS) and connectivity shouldn't be a problem...
7822 Jul 2014 @ 11:06 PDTTeradata StudioTopicTeradata Studio 15.0 connecting to Hadoop using JDBC failsConnecting to a Hadoop Sandbox or a HDP via JDBC using TDS 15.0 is erroring out after using WebHDFS port 50070 with the following error: java.lang.Exception: Hadoop not configured to run jobs by...
7705 May 2014 @ 04:00 PDTAsterTopicload_from_hcatalog when templeton is not on namenodeHello guys, I have a HDP instance that has templeton on a secondary node and so instead of my connector being: CREATE VIEW aster_view AS SELECT hcat_table.col1, hcat_table.col2 F...
7606 Mar 2014 @ 05:28 PSTToolsTopicError with Teradata connector for Hadoop with HCAT -> TD fastloadI have an HCategory table: CREATE TABLE src.t ( msgtype string , ts string , source string , msgclass int , msgtext string ) PARTITIONED BY (device_range string, device_i...
7516 Jan 2014 @ 05:10 PSTDatabaseTopicwhich standard is used for REGEX regular expression functions in TD14.10I'm want to confirm what regex standard is used for TERADATA's 14.10 database engine, There's POSIX, basic, extended, emacs/perl/python varieties but I couldn't find a good referen...
7416 Jan 2014 @ 05:10 PSTDatabaseTopicwhich standard is used for REGEX regular expression functions in TD14.10I'm want to confirm what regex standard is used for TERADATA's 14.10 database engine, There's POSIX, basic, extended, emacs/perl/python varieties but I couldn't find a good referen...
7327 Apr 2013 @ 01:43 PDTToolsReplyUsing Geospacial Import/Export java toolsOkay it seems I needed to add the JVM flags and per the runit.txt file in the V1.6 download.  java -Xms256m -Xmx512m -classpath .;tdgssconfig.jar;terajdbc4.jar com.teradata.geo.TDGeoImport ...
7226 Apr 2013 @ 12:57 PDTToolsReplyUsing Geospacial Import/Export java toolsAddendum, I've thrown the tool into the SLES TD14 VM Express and I get much the same problem: TDExpress14.0_Sles10:~/td-GeoImportExport-1-6/bin # java -classpath ./*.* com.teradata.geo.TDGeo...
7126 Apr 2013 @ 06:51 PDTToolsTopicUsing Geospacial Import/Export java tools  I hope this is the right forum for this question. I am working through the Orange book(Teradata Spatial Release 13.0 Users Guide) on this and am stumped with the example code on page 25, li...
7012 Mar 2013 @ 05:04 PDTDatabaseReplyProcedures Calling Procedures with Dynamic Result Sets (from TD notes)Okay I discovered the problem. I needed EXECUTE PROCEDURE WITH GRANT privs to daisy chain procedures together. Due to the need to grant access by the procedure to the other procedure as the caller....
6912 Mar 2013 @ 05:02 PDTDatabaseReplyProcedures Calling Procedures with Dynamic Result Sets (from TD notes) Error:3523 temp6 owner referenced by user does not have execute procedure access to MDM_WRK.temp5.
6811 Mar 2013 @ 06:41 PDTDatabaseTopicProcedures Calling Procedures with Dynamic Result Sets (from TD notes)Hello all, I am teaching myself the syntax of stored procedures from your notes. P35 from "SQL Stored Procedures and Embedded SQL" shows the following snippit: REPLACE PROCEDURE alloc00...
6702 Feb 2013 @ 11:01 PSTDatabaseTopicExporting UTF8 column names from DBC, using CHR(26) ^Z SUB char...I'm wanting to export list of UTF column names from DBC.TablesV. I want to ensure valid UTF8 characters that can be used for names within double quotes aren't used as my column delimiter. I...
6608 Nov 2012 @ 05:11 PSTCloud ComputingReplyConnection issues from ALL applications to TD Express 13.10 and 14.00 through VMWareOh funny. Okay, it seems the teradata employee windows VPN somehow conflicted with the NAT networking. (a problem that the externals might have if they are porting into their respective workplaces)...
6508 Nov 2012 @ 02:51 PSTCloud ComputingReplyConnection issues from ALL applications to TD Express 13.10 and 14.00 through VMWareActually I've ended up having a similar problem. I think it's less of a Teradata DB thing within the VMware image, and more of a SLES apache2 issue. I'm not a networking specialist but ...
6421 Oct 2012 @ 07:24 PDTToolsReplySQL Assistant 14.01 download availability?This is an employee internal method through TSS They can be downloaded from this link: http://tssprod.teradata.com:8080/TSFS/home.do To Download: - Click on Teradata Client > Windows and ...
6317 Aug 2012 @ 05:25 PDTDatabaseReplyDynamic SQL with EXECUTE and EXECUTE IMMEDIATE Perfect Fred, - thank you for that clarification regarding argument lists.
6217 Aug 2012 @ 07:47 PDTDatabaseTopicDynamic SQL with EXECUTE and EXECUTE IMMEDIATE What are the differences between EXECUTE and EXECUTE IMMEDITATE, is I can’t see any difference in the supplied documentation... Properties of EXECUTE, EXECUTE IMMEDIATE and dbc.SysExec...
6107 Aug 2012 @ 04:50 PDTAnalyticsReplyhashrow function Thanks Todd, I'll assume that because your "HASHROW" function is proprietary, the properties of it are not able to be discussed right? I mean specifically the relationship of e...
6007 Aug 2012 @ 06:33 PDTAnalyticsReplyhashrow function Addendum: I ran the above statements by teranerd and got the same row hash values actually even the following gave the same: SELECT HASHROW(rowhash_col) FROM rowhash_my UNION ALL SELECT HAS...
5907 Aug 2012 @ 06:02 PDTAnalyticsReplyhashrow function I have a feeling the HASHROW function has changed within the last few versions I'm using 13.10 and now: UNICODE and LATIN values hasH to the same value it will provide varying ...
5804 Aug 2012 @ 07:00 PDTDatabaseReplyCross join V/s Product Join Teradata tends to make a distinction between a join TYPE (INNER OUTER FULL OUTER CROSS) vs a join STRATEGY (MERGE HASH PRODUCT). In this case CROSS & CARTESIAN are TYPEs and PRODUCT is t...
5708 Jul 2012 @ 07:30 PDTDatabaseReplyCopy Views Documentation seems only to have CREATE TABLE in a copy syntax. Unfortunately I can only see that a copy can be done by doing the statements SHOW VIEW and then CREATE VIEW sequentially...
5607 May 2012 @ 03:32 PDTDatabaseReplyHow to call unix commands with in the BTEQ script? Never done that but historically I've done it the other way around: #/bin/ksh bteq << EOF .bt ${shell_var} .et EOF I'm not actually answering your quest...
5530 Apr 2012 @ 03:21 PDTToolsReplyTPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR? Thankyou for your confirmation. Kind regards, R

Pages