2678 | 31 Mar 2014 @ 11:59 PDT | Database | Reply | When system write encounters backup read lock | Your scenario is wrong :)
dbc.errortbls is not used by Mload, it records Error Tables for MERGE, i.e. CREATE ERROR TABLE ...
|
2677 | 16 Mar 2014 @ 02:38 PDT | Database | Reply | How is the Node Decided | @HTH:
the Bynet doesn't look at the table header, it simply does a lookup in the Hashmap.
Each system has a so-called Hashmap which is specifically created (during sysinit) for that system an... |
2676 | 09 Mar 2014 @ 09:42 PDT | Database | Reply | finding links between two col values.. | If there are cycles you need to detect them, the only way is to built a materialized path and check if the current value is already included. And if there's no way to find out the actual start ... |
2675 | 08 Mar 2014 @ 02:58 PST | Database | Reply | COMPRESSION for TIMESTAMP field in TD14 | Compression for TIME and TIMESTAMP was introduced in TD14.10
|
2674 | 08 Mar 2014 @ 02:55 PST | Database | Reply | qualify rank() over (partition.....question | Hi John,
some questions:
- is rnk based on the same sort as start and end date, i.e. are the dates for the first row within the group always the lowest?
- is rnk actually a unique number without... |
2673 | 07 Mar 2014 @ 01:48 PST | Database | Reply | utf8TO16 : why is it Latin to unicode conversion function when utf8 itself is unicode encoding? | UTF8TO16? There's no such function built-in.
There's only TransUnicodeToUTF8 and TransUTF8ToUnicode, but those are compression UDFs (changing internal storage from UTF6 to UTF8 to sav... |
2672 | 07 Mar 2014 @ 01:42 PST | Database | Reply | finding links between two col values.. | You just have to find the root level, then i's easy :-)
WITH RECURSIVE match(grp, col1, col2, levl) AS
(
SELECT col1, col1, col2, 0 AS levl
FROM val AS t1
WHERE NOT EXISTS
... |
2671 | 06 Mar 2014 @ 08:28 PST | Database | Reply | Using Teradata in OLTP application | Hi Sri,
how many rows are returned by the 2nd query?
Are there collected stats on that column?
Can you share the Explain?
I would expect 5 sequential "single-AMP retrieve" steps... |
2670 | 06 Mar 2014 @ 08:21 PST | Connectivity | Reply | Can I use the Teradata ODBC Linux drivers with Mac OS X | There's a Teradata Client for OSX including BTEQ, TPT and ODBC.
But it's located on Teradata's patch server, so probably only for customers and not freely available :(
|
2669 | 05 Mar 2014 @ 10:39 PST | Database | Reply | Qualify solution |
SELECT * FROM tab
QUALIFY
ROW_NUMBER()
OVER (PARTITION BY ENT_ID
ORDER BY CASE WHEN PRODUCT_TYPE = 'GHP' THEN 0 ELSE 1 END,
CURRENT_BAL DESC) = 1
&... |
2668 | 05 Mar 2014 @ 10:33 PST | Database | Reply | Join Issues - Need help in most efficient way to solve the problem | Hi Karthik,
imho you can't choose the shop with the maximum number of items, e.g.
shop 1: 2,3,4,5,6,7
shop 2:1,2,3,4
shop 3: 5,6,7,8
shop 1 + 2 or shop 1 + 3 has less items than shop 2+ 3
|
2667 | 05 Mar 2014 @ 05:45 PST | Database | Reply | Join Issues - Need help in most efficient way to solve the problem | Hi Karthik,
i don't think there's a simple solution, especially without Stored Procedures.
As it's only 300 items you might use bit-functions to create a bit-string and then BITO... |
2666 | 05 Mar 2014 @ 05:22 PST | Database | Reply | my confusion about LEFT JOIN | A WHERE-condition on the inner table changes the result of the Outer join to an Inner join. The optimizer is smart enough to know that and when you check explain there's no outer join.
There... |
2665 | 05 Mar 2014 @ 04:30 PST | Tools | Reply | BTEQ losing header comments of view definitions | Hi Matthias,
afaik you can't do that as-is in BTEQ.
The only way i know is to move the comment after the REPLACE, e.g.
REPLACE VIEW SampleDB.TestView AS
/*
Header comment:
This ... |
2664 | 03 Mar 2014 @ 07:11 PST | Database | Reply | Date as Integer | If you seriously want to implement SCD you need the right to create SPs.
The code will mostly be generic, so as a basis you can simply use existing code from any RDBMS.
Or use Teradata's Temp... |
2663 | 03 Mar 2014 @ 03:15 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | Can't be "a few weeks ago", don't use the one on top, scroll down :-)
Version: 14.10.01.01
Released: 28 Feb 2014
|
2662 | 03 Mar 2014 @ 03:02 PST | Database | Reply | Calculate Performance Impact of Secondary Index | If it's the first index on a table:
- a USI will double the number of IOs for Inserts/Update/Deletes and it needs communication between primary and secondary AMP, runtime might be doubled.
- ... |
2661 | 03 Mar 2014 @ 02:52 PST | Connectivity | Reply | Teradata SQL Assistant 13 with Teradata .Net provider | Did you check if PROD is actually resolved to an ip-address?
nslookup prod or nslookup prodcop1
|
2660 | 03 Mar 2014 @ 02:44 PST | Database | Reply | "6706 Untranslatable Character" error caused by character string exceeding a fixed length? | Is this a literal string you're trying to insert?
Then i would expect the limit to be 15500 Unicode characters and a 3738 error:
3738 String is longer than 31000 characters.
Explanation: Quo... |
2659 | 03 Mar 2014 @ 02:34 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | Hi Andy,
there was a new version of TD Express a few days ago, 14.10.01.01, you might try if this includes TPT 14.10.00.03.
Dieter
|
2658 | 03 Mar 2014 @ 02:29 PST | Database | Reply | Query band in procedure. SET QUERY_BAND ';' UPDATE FOR SESSION;" | As the error indicates, you can't set a Queryband on session level in SPs, it's simply not supported. If the question is "why it's not supported?", i don't know, there mig... |
2657 | 27 Feb 2014 @ 08:49 PST | Analytics | Reply | Levenstein Distance Algorithm | Edit Distance and N-Gram string UDFs
In TD14 there's a built-in EditDistance UDF based on the Damerau-Levenshtein Distance algorithm.
|
2656 | 27 Feb 2014 @ 08:09 PST | Tools | Reply | Fast export and mload in vartext mode - Data item too large for field issue | Hi Cheeli,
yes, the first two bytes indicate the length of the VarChar, you need an OutMod or a Unix shell command to strip them off.
The max range of an INT is 10 digits, but there's a sign,... |
2655 | 27 Feb 2014 @ 07:58 PST | Database | Reply | Query regarding Column and row merge | Of course, simply add it, when you need it.
|
2654 | 27 Feb 2014 @ 07:55 PST | UDA | Reply | Cast and format | Hi Pio,
what do you expect?
A DATE minus a DATE results the number of days difference,but you substract a string from a date:
DATE '2033-12-31' - '0131210'
Because this is not d... |