#DateForumTypeThreadPost
79108 Nov 2015 @ 03:05 PSTDatabaseReplyJoin not working between varchar fieldsIn this case your query is giving the correct result. You need to check why tableB does not contain the value '14-2/324'...
79007 Nov 2015 @ 04:33 PSTDatabaseReplyJoin not working between varchar fieldsand pleas show us the result of select 'xxx' || INV_NBR || 'yyy' from TableA where INV_NBR = '14-2/324'; select 'xxx' || INV_NBR || 'yyy' from TableB whe...
78907 Nov 2015 @ 04:29 PSTDatabaseReplyJoin not working between varchar fieldscan you share the ddl's of the tables? and the explain?
78807 Nov 2015 @ 04:21 PSTDatabaseReplyMinus Vs ExistsMultiset - do you have duplicates? If yes: both scenarios might not give you what you need. Check: create volatile multiset table vt_a (a integer) no primary index; create volatile multiset t...
78731 Oct 2015 @ 06:11 PDTDatabaseReplyComparing table results in BTEQ scriptsExample Java UDF for Table Hash Calculations and the refering post might give you an idea
78620 Oct 2015 @ 11:47 PDTConnectivityReplyConnecting from R via RJDBC and terajdbc4.jar failsHi Uwe, can you try to run the two classpath statements two times. I get sometimes the missing classpath message also. But usually it disapears after I run the class path statements a second time....
78501 Oct 2015 @ 11:31 PDTPrivate Forum
78418 Sep 2015 @ 05:06 PDTAsterReplyAster 6.0 to HDP 2.1 select does not workUpdate: It seems to be an Aster problem as  SELECT * FROM load_from_hcatalog  (USING server('192.168.100.21') port('9083') username('hive') dbname(&#...
78316 Sep 2015 @ 07:19 PDTDatabaseReplyDrop or Delete Which one is better for this scenario?you don't give much information what changes on a weekly basis. Will old data be changed? How long takes your current approach?
78216 Sep 2015 @ 01:59 PDTDatabaseReplycreate table with JSON datatype JSON was introduced at TD15.0 - so it is not available at the 14.0...
78116 Sep 2015 @ 01:26 PDTAsterTopicAster 6.0 to HDP 2.1 select does not workHi, I installed the UDA on a Stick package and run currently some of the examples. TD15.0 and Aster 6.0 are runing and working fine. HDP2.1 is also running. And hive is working on the HDP2.1 - I...
78008 May 2015 @ 04:49 PDTToolsReplyTTU for Mac OS betq is available and works nice on Mac Teradata BTEQ 15.00.00.00 for Mac OS X. PID: 16274 Copyright 1984-2014, Teradata Corporation. ALL RIGHTS RESERVED. Enter your logon or BTEQ command...
77923 Apr 2015 @ 01:37 PDTTeradata StudioReplyFor 15.10 Install how do I respond What Java Runtime Environment? I have the same issue - Windows 8. JRE 1.8 istalled If I give the full path again it still fails...
77825 Mar 2015 @ 03:54 PDTToolsReplyFastExport ISSUE !!!Your logon need to point also to the server. in the host file (/etc/host on Linux) you need to specifiy a cop entriy for the db then you need to specifiy the system .LOGON system/usernname,pwd;
77715 Feb 2015 @ 11:59 PSTToolsReplyFileds shifted in the database using TPTSounds like an UTF8 Problem. Can you share your DDL and TPT script?
77611 Feb 2015 @ 05:12 PSTDatabaseReplyRemove duplicate records and load into another tabletry the following in case all columns are not null Insert into new table select * from oldTable where keyid in ( select key_id from OLD_Table qualify key_id = min(key_id) as key_id ove...
77510 Feb 2015 @ 04:02 PSTDatabaseReplyCompare database between prod and devHi Tdarc1, as stated above: AtanaSuite, good third party tool, offers this functionality. If you are going to use Unity in the future you should also be able overcome this issue. Otherwise comp...
77406 Feb 2015 @ 12:39 PSTDatabaseReplyIdentifying the Target of an IUD (insert/update/delete) Operationdid you consider to parse the SQL itself? Could be a good usecase for a python script function. On which release are you?
77328 Jan 2015 @ 01:31 PSTToolsReplyNeed to load from Table 1 to Table 2. Which utility work well here and WHY?SQL will be your choice of the same Server. It will depend on your environment and the szenario if you call it from BTEQ, Teradata Studio or an Python / Java script. The data will not leave the sy...
77228 Jan 2015 @ 12:30 PSTToolsReplyNeed to load from Table 1 to Table 2. Which utility work well here and WHY?On the same TD DB server?
77127 Jan 2015 @ 01:29 PSTTeradata StudioReplyJRE 8.1.31 not recognized on TD Studio Express InstallationHi, just found http://support.apple.com/kb/DL1572?viewlocale=en_US&locale=en_US and this worked for now...
77027 Jan 2015 @ 01:16 PSTTeradata StudioReplyJRE 8.1.31 not recognized on TD Studio Express InstallationHi, I have a similar issue on a Mac after the Yosemite upgrade. I reverted to java 1.7 host-78-75-113-102:~ ulrich$ java -version java version "1.7.0_75" Java(TM) SE Runtime Environm...
76914 Jan 2015 @ 04:03 PSTDatabaseReplyLowest Child in recusive queryBelow some code which seems to do what you want. The idea is to create first a tmp table with all the leaf (lowest childs) and the complete path to this leave - using a recurisve query Next you c...
76818 Dec 2014 @ 12:19 PSTDatabaseReplyCREATE TABLE AS STATEMENT ERROROK, there is this difference of double quoted names - but what is your concern? "colname" is still refering to the colname... So there is no difference in the actual table definition...
76717 Dec 2014 @ 04:00 PSTDatabaseReplyProblems with "WITH(NOLOCK"LOCK ROW FOR ACCESS is the "dirty read" equivalent. So  LOCK ROW FOR ACCESS  select * from yourtab will give you results even if insert, deletes or updates are ongoing during...

Pages