|615||01 Aug 2013 @ 12:43 PDT||Database||Reply||Selecting groups whose member belongs to multiple groups||
select group_id, member_id
qualify count(group_id) over (partition by member_id) > 1
|614||31 Jul 2013 @ 07:14 PDT||Database||Reply||Search for first substring in string with condition||performance depend on your data volumes but at least this does the trick with your data ;-)
I used the volatile table to make it a bit more clearer
First splitt your data into chars and kee... |
|613||31 Jul 2013 @ 06:27 PDT||Database||Reply||Search for first substring in string with condition||which version are you on?
|612||24 Jul 2013 @ 06:45 PDT||Connectivity||Reply||Login OK with teradata Assistant, KO with BTEQ||the message is indicating that BTEQ reached the server but either user or password is wrong.
Are you 100% sure of not having a typo?
|611||24 Jul 2013 @ 06:42 PDT||Database||Reply||Untranslatable character at any position in a field.||did you check the TRANSLATE function and checked the WITH ERROR option?
|610||24 Jul 2013 @ 06:38 PDT||Database||Reply||Can I do select from fallback table?||system will read the fallback data if a node or diskarray is going down but you can't influence this with a SQL.
What would be the benifit if direct accessing it?
|609||24 Jul 2013 @ 06:36 PDT||Database||Reply||Unicode vs Latin||latin is just the system default at your system if you are not specifing something in your ddl.
space savings - an unicode varchar/char will use 2 times the space.
|608||12 Jun 2013 @ 05:55 PDT||Data Modeling||Reply||Effect of reversing the order of columns in mutli-column stats||at least up to 13.10 - I am not 100% sure about 14.0.
Only the 16 bytes of the conc... |
|607||04 Jun 2013 @ 06:00 PDT||Database||Reply||Is there any way to handle single digit's in date?||Try SEL TO_TIMESTAMP('May 10 2013 10:58:04:3934PM', 'Month dd yyyy hh:mi:ss:ssssAM')
|606||04 Jun 2013 @ 04:37 PDT||General||Reply||Same hash for different values||The hashrow has to few bits, so hash collissions are common. It doesn't have the same properties as a SHA1 hash.
|605||30 May 2013 @ 10:59 PDT||Database||Reply||Transposing the data - QUERY||you could do the same with min and the change_log_from column
build two derived tables (one with the max one with the min)
and join the results together and coalesce the max, min... |
|604||30 May 2013 @ 10:58 PDT||Analytics||Reply||teradataR package and R 3.0.0||I know - but why doesn't TD release a new version?
Or release the source code as open source and someone could move this forward?
|603||30 May 2013 @ 08:42 PDT||Database||Reply||Transposing the data - QUERY||Are you looking for something like
substr(max(case when columnname = 'change_col_1' then cast(update_time as char(30)) ... |
|602||30 May 2013 @ 07:11 PDT||Database||Reply||View validity check||its not possible to get this info out of dbc
it can change any time and maybe in 5 min the view is valid again.
try the following bteq script
.set width 500;
|601||29 May 2013 @ 03:36 PDT||Tools||Reply||Unable to open Teradata SQL assistant||Teradata SQL assistant on Mac OS? At least I never saw a Mac version
Teradata SQL assistant is a windows program. Or do you mean Teradata Studio (Express)?
|600||29 May 2013 @ 01:28 PDT||Database||Reply||Transposing the data - QUERY||Hi,
your timestamps values are not valid. As you expect specific results it would be good if you can review the data.
timestamp need to be of format 'YYYY-MM-DD HH:Mi:SS.ssssss' - I guess... |
|599||29 May 2013 @ 01:13 PDT||Tools||Reply||TD utilities and JAVA.||Still very unclear what you want.
In BTEQ you can use the OS command to run scripts on OS level - like rm to remove files.
This could be used to call a java programm as well.
But what woul... |
|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.