|685||16 Apr 2014 @ 07:05 PDT||Third Party Software||Reply||Bi tool cannot read from different databases in teradata?||Hm, not so easy to answer. I am not sure that I understand how the dead lock occurs.
Questions: is the read lock nessesary for you? Would lock row for access be OK?
I would strongly avoid the cre... |
|684||07 Feb 2014 @ 11:38 PST||Analytics||Reply||teradataR package and R 3.0.0||Just verified the package at (see message from nonsleeper above)
git clone https://github.com/Teradata/teradataR/
is just working fine.
What kind of message to you get?
R version 3.0.2 (2013-... |
|683||07 Feb 2014 @ 10:50 PST||Teradata Applications||Reply||TPT export and error code 2595||P.S. the error does not occur at TPT startup. There is already some GB of data retrieved...
|682||07 Feb 2014 @ 12:04 PST||Teradata Applications||Topic||TPT export and error code 2595||Hi,
we are getting with an TPT export the error code 2595.
2595 The FastExport select request has been aborted.
Explanation: The current Select request has been aborted.
|681||07 Feb 2014 @ 01:05 PST||Connectivity||Reply||Load Nulls with R & JDBC Fastload Problem||Ok found it myself:
But thanks again to tomnolan
|680||06 Feb 2014 @ 10:16 PST||Connectivity||Reply||Load Nulls with R & JDBC Fastload Problem||Yes,yes,yes! That works!
Thanks a lot!
As I have to deal with different data types. Do you know where I can find the constanst for other data types?
e.g. Types.String etc.?
I didn't find th... |
|679||06 Feb 2014 @ 12:54 PST||Connectivity||Reply||Load Nulls with R & JDBC Fastload Problem||P.S. I am not a Java programmer.
Does null loads with JDBC Fastload work in a pure Java implementation?
So is this clearly a R problem?
|678||06 Feb 2014 @ 12:38 PST||Connectivity||Reply||Load Nulls with R & JDBC Fastload Problem||Unfortunatly it does not help.
Error message is now:
Fehler in .jcall(ps, "V", "setNull", as.integer(3), 4) :
method setNull with signature (ID)V not found
|677||06 Feb 2014 @ 12:44 PST||General||Reply||Create a macro that chooses from teo different select staments depending on a given parameter.||SP might be the better way but in case there are limitations on SP and both SQLs deliver the same column lists and data types you can try something like
replace macro con_test (test_val char(1))... |
|676||05 Feb 2014 @ 11:51 PST||Connectivity||Reply||Load Nulls with R & JDBC Fastload Problem||Hi,
no thats not the issue.
is.na(x) checks for NA and NaN.
You can change j[i1] <- NA and the error is the same.
The message is
"Fehler in .jcall(ps, "V&qu... |
|675||05 Feb 2014 @ 07:54 PST||Connectivity||Topic||Load Nulls with R & JDBC Fastload Problem||Hi all,
I try to load some data from R directly to Teradata 14.10 via JDBC Fastload.
The data contains some Nulls for numeric values and I have not been able to load this data so far.
The ... |
|674||05 Feb 2014 @ 07:46 PST||Database||Reply||Use of NOT IN for a fact join||What is the PI of the fact table
|673||05 Feb 2014 @ 12:46 PST||Database||Reply||Use of NOT IN for a fact join||I don't get fully what you wanne achive
Can you explain with some data?
also not exists shows better performance
from fact o
where date_col / 100 + 190000 = 201310
and not exi... |
|672||23 Jan 2014 @ 11:58 PST||Database||Reply||Urgent : Latin to Unicode character conversion- Please help||what is your session setting of your BO query? It has to be unicode as well.
|671||23 Jan 2014 @ 04:44 PST||Database||Reply||Urgent : Latin to Unicode character conversion- Please help||Can you explain how you managed to store the unicode data in the latin columns?
Did you check the WITH ERROR option of the translate function?
|670||22 Jan 2014 @ 05:54 PST||Connectivity||Reply||td wallet for jdbc||Hi,
At present, only logon processing that is initiated through Teradata CLIv2 for Network Attached Systems utiliz... |
|669||21 Jan 2014 @ 01:06 PST||Aster||Reply||Aster without a SYS_CALENDAR?||I guess there exists different use cases for a calendar table where system calendar is usually a starting point as it is part of TD default installations.
1. Check if date is a workingdate weekday... |
|668||16 Jan 2014 @ 10:35 PST||Analytics||Reply||Help with SQL to deal with overlapping date range||which release are you on?
|667||14 Jan 2014 @ 11:46 PST||Database||Reply||Connection problem with TD14||They are all on the same machine but quite different - the VM looks like a different computer to your laptop and therefore you need to enable that the VM can be reached from you laptop...
Did you ... |
|666||14 Jan 2014 @ 01:06 PST||Database||Reply||Connection problem with TD14||Did you try to logon with Nexus Chameoleon from the same machine as with Teradata Studio?
Is ODBC installed? Teradata Studio uses JDBC
|665||16 Dec 2013 @ 11:38 PST||Database||Reply||Extractin a QUERY TEXT from a Column and using this output we need to insert the data into another table.||you can export the SQLs (as full Insert/selects) with bteq and can import and call these generated SQLs in the same job.
Check http://forums.teradata.com/forum/general/bteq-script-to-read-and-exec... |
|664||16 Dec 2013 @ 11:31 PST||Analytics||Reply||Fast Load Vs Multiload||Not sure that above answers the orig question.
I guess the number of phases are irrelevant. Usually total time to get things done is what matters.
But both utilites come with limitations.
|663||16 Dec 2013 @ 11:11 PST||Database||Reply||RESERVED WORDS:Query to find Views and macros that reference a particular table or view||check
|662||10 Dec 2013 @ 07:40 PST||Database||Reply||Rewriting the Self join||This should create also the same output an would do the self join only once but comes with a smal prod join
case when c.id = 1 then A.MERGE_ID else B.REM_ID end,
case when c.id = 1 th... |
|661||10 Dec 2013 @ 07:33 PST||Database||Reply||Rewriting the Self join||
hm, try and check the differences in explain and run times