|698||30 Jun 2014 @ 12:23 PDT||Database||Reply||Skewfactor||Values < 1 are OK. You might not getting better even if you use a UPI - depending on your number of rows and number of vprocs.
But as so often there are no fix numbers to say what is acce... |
|697||30 Jun 2014 @ 12:16 PDT||General||Reply||In BTEQ if we want to go forward we use condititional logic (if ..then GO TO .Label name).By using BTEQ can we go backward?||Hi,
no, you can't go backwards with an .goto statement.
|696||26 Jun 2014 @ 02:51 PDT||General||Reply||If hash collision occurs,how can we rectify this issue.||Hi,
can you provide some more details of your problem? What is the issue with the hash collision?
|695||24 Jun 2014 @ 11:48 PDT||Database||Reply||Types of Tablekind||your can run a
select tablekind from dbc.tables group by tablekind order by tablekind;
so see which are currently existing in your system.
By the way tablekind is very much misslea... |
|694||05 Jun 2014 @ 02:26 PDT||Database||Reply||How to calculate a character occurance in a string in teradata||which version are you on?
|693||15 May 2014 @ 11:24 PDT||General||Reply||Number of bytes-BIGINT||There is no doubt - 8 bytes
from the manuals - SQL Data Types and Literals
"BIGINT values are stored as eight bytes with the least significant byte first."
|692||14 May 2014 @ 01:01 PDT||Database||Reply||How to calulate Skew on Join Index||The join index is created by an SQL therfore using this SQL as a derived table should give you the right info.
SELECT HASHAMP(HASHBUCKET(HA... |
|691||13 May 2014 @ 04:46 PDT||Database||Reply|| incremental planning and execution (IPE)||yes, I used "only" 1 Mio rows on the PPI table.
But the SSI queries also contained a UPI access so should be pretty fast. I was wondering where to draw the line and was therefor asking f... |
|690||13 May 2014 @ 12:19 PDT||Database||Topic|| incremental planning and execution (IPE)||Hi all,
I am exploring the new IPE feature on 14.10. Very nice!
But sometimes the explain is showing
"This request is eligible for incremental planning and execution (IPE)
|689||06 May 2014 @ 12:52 PDT||Database||Reply||Identifying Temporal Tables||In 14.10 the dbc documentation states that tables views should have the column
Further down you find the following description:
The TemoralPrope... |
|688||29 Apr 2014 @ 02:35 PDT||Tools||Reply||Can we use where clause in TPT Export selector||try to replace all ' with '' within the select. Something like
|687||28 Apr 2014 @ 12:20 PDT||Tools||Reply||Loading carriage returns with TPT Load Operator||sad, sad...
|686||26 Apr 2014 @ 12:50 PDT||Tools||Reply||Loading carriage returns with TPT Load Operator||Will it make in 15.0?
It creates so much overhead if you have to deal with it in preprosessing. These social network sources are full of this as it all about free text fields...
|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