|598||22 May 2013 @ 08:23 PDT||Database||Reply||ACCOUNTING CPU usage fpr UDF||Which TD version do you run?
And which UDF language do you use?
To my knowledge does 13.10 account for C UDFs but I am not sure about JAVA. At least in the past Java UDF CPU usage was not capture... |
|597||21 May 2013 @ 10:00 PDT||Tools||Reply||TPT: Moving tables from One TD box to other TD box using TPT ||You are funny. Harpreet given you the right answer and where to lock for the sample scripts. They are also available in the R13.10 TPT documentation.
If you just wane play arround with it try
|596||16 May 2013 @ 04:43 PDT||Database||Reply||Implicit conversion of Integer to VARCHAR||But as the explain states it will try to do the coversion for all values of order_key in the table.
The message you get is indicating that at least one value of order_key can be converted to a flo... |
|595||15 May 2013 @ 11:33 PDT||Database||Reply||SUBSTR without explicitly coding the length parm||I can't reproduce the issue.
select top 100
substring(myvar from 4),
but as you can see abov... |
|594||15 May 2013 @ 04:54 PDT||Database||Reply||Generating Sequence Number||P.S. read the documentation carefully before using identity columns. There are other issues as well which need to be considered...
|593||15 May 2013 @ 04:52 PDT||Database||Reply||Generating Sequence Number||becaus the increment by 1 is handled vproc local.
Identity columns are not guarantee a sequence - they only quarantee unique ids.
Each vproc request a range of numbers he can assign next. The siz... |
|592||24 Apr 2013 @ 05:31 PDT||Database||Reply||There is another way to remove a volatile table?||you can simply drop the VT table within the SP
|591||24 Apr 2013 @ 02:43 PDT||Analytics||Reply||TeradataR Question about kemans analysis||Can't test it right now as teradataR is not working for R3.0.0 :-(
What should work is that you create a view with your two columns and call td.kmeans with this view.
|590||20 Mar 2013 @ 08:33 PDT||Database||Reply||SQL Syntax||It's like Dieter suggested
replace view test_db _uli.v_test1
select calendar_date as col1,
|589||20 Mar 2013 @ 01:41 PDT||Connectivity||Reply||Only an ET or null statement is legal after a DDL Statement||As you wanne use the query band setting only for the one sql try
SET QUERY_BAND = 'Project=Example2;Report=0315-17.11;MSTRUser=MSTRPORTAL_EXXXX;' FOR transaction;
select * fr... |
|588||20 Mar 2013 @ 01:11 PDT||Database||Reply||SQL Syntax||did you try to create a view like
Create view VW2 as
( sel col1,
where col2 = '... |
|587||19 Mar 2013 @ 12:01 PDT||Database||Reply||RODBC system error 193||try
You need to download the JDBC driver and set the correct path.
|586||14 Mar 2013 @ 05:26 PDT||Analytics||Reply||conversion of datatype||The change might have implicartion on the required space to store the data which need to be considered.
|585||14 Mar 2013 @ 03:38 PDT||Tools||Reply||Teradata TPT Script||Try run
on the command line
if this is not giving you an information at least the installation would be incomplete...
|584||14 Mar 2013 @ 03:35 PDT||Analytics||Reply||conversion of datatype||Don't post many times the same question. Solution was given at
Numeric Overflow error in teredata
|583||14 Mar 2013 @ 03:30 PDT||Database||Reply||Numeric Overflow error in teredata||check the data types of
It looks like the sums are exceding the maximum values... |
|582||03 Mar 2013 @ 11:53 PST||General||Reply||Did anyone store RDF data (Resource Description Framework) data on Teradata ?||@Adeel - no it isn't. You can convert it but it is even more generic.
All data is represented as subject predicate objects records.
And yes, I stored RDF data in Teradata. Question is what you... |
|581||15 Feb 2013 @ 07:08 PST||Database||Reply||Can you join using wild cards col_a like %col_b%||Strange data model: Depends on the use case.
Can be very sufficient for specific problems. For example data quality checks ELT processes. Filter out email addresses containing specific patte... |
|580||14 Feb 2013 @ 03:13 PST||Database||Reply||Can you join using wild cards col_a like %col_b%||try
cards col_a like '%' || col_b || '%'
|579||12 Dec 2012 @ 09:59 PST||Database||Reply||How to find the associated tables or view in teradata?||Check the disclaimer of the post ;->
But so far it looks quite complete in the cases I worked with it - which I do regularly.
|578||12 Dec 2012 @ 09:56 PST||Database||Reply||numeric overflow occurrence||
SELECT cast(0 as integer) AS a from (select 'X' as DUMMY) as X
SELECT -9999 AS a from (select 'X' as DUMMY) as X
The first selects defines the datatype.
|577||05 Dec 2012 @ 01:57 PST||Database||Reply||Union vs Group by||The standard answer is that it can depend on your data, the PI and configuration.
So easiest is to run the different options and check the DBQL.
You also forgot the set option of a temp table. Or... |
|576||05 Dec 2012 @ 01:49 PST||Database||Reply||How to find the associated tables or view in teradata?||are you looking for this?
|575||04 Dec 2012 @ 10:42 PST||Database||Reply||Work around to simulate a variable Partition in RANGE_N||Can you provide a DDL and some test data as inserts?
And explain with the given data your expected results.
|574||03 Dec 2012 @ 10:49 PST||Analytics||Reply||Connecting to Teradata in R via the teradataR package||Just to avoid future problems
tdConnect("10.33.2.136","my_uid","my_pwd","EDEE_POC"," jdbc ")
is not getting a connection due to the blanks in &qu... |