3003 | 08 Aug 2014 @ 03:07 PDT | Data Modeling | Reply | Calendar dimension | Hi Mahesh,
assuming that 2013 Week52 was a typo and should be 53, too?
This is based on the built-in sys_calendar, so you can easily adjust it to your calendar:
SELECT
-- Jan 1st = (... |
3002 | 07 Aug 2014 @ 12:20 PDT | Database | Reply | What is mean by STAT FUNCTION in Teradata | Ask the developer team if they got DBQL information or an old Explain for this query, then you can spot differences and start investigating.
|
3001 | 07 Aug 2014 @ 12:14 PDT | Database | Reply | coalesce function | Assuming that AP.RECORD_DATE is a date, you're trying to combine a DATE and a VARCHAR.
As you can't turn 'Not yet recorded' into a valid date you must cast the date to a VarCh... |
3000 | 07 Aug 2014 @ 09:37 PDT | General | Reply | Query to update the sequence number of duplicate rows | You can get the count using a
ROW_NUMBER() OVER (PARTITION BY field1, field,2, field3, field4 ORDER BY 1)
But there's no way to use this in an UPDATE.
You could INSERT SELECT those rows wi... |
2999 | 07 Aug 2014 @ 09:22 PDT | Database | Reply | What is mean by STAT FUNCTION in Teradata | What do you mean by "Previously this query was running fine"?
Exactly the same query, similar data?
Can you check if DBQL step/explain information is available for the previous run?
Is... |
2998 | 07 Aug 2014 @ 09:14 PDT | Database | Reply | Create Table Syntax Error | There's no display width for INT in Teradata, this looks like MySQL syntax.
Simply remove it (int (1) -> int), if it's actually less digits you might consider 1, 2, 4 or 8 byte integers... |
2997 | 07 Aug 2014 @ 06:36 PDT | Data Modeling | Reply | Calendar dimension | Your current calendar is an Oracle calendar :-)
What about 2013-12-30 and 2013-12-31, should it be 2014 Week 01, too, or 2013 Week 53?
|
2996 | 07 Aug 2014 @ 06:07 PDT | Database | Reply | What is mean by STAT FUNCTION in Teradata | Step 7 is one of the ROW_NUMBERs, both are a bit strange as they PARTITION and ORDER BY the same columns. You might simply change the ORDER BY to ORDER BY 1 instead.
And you might not need them at... |
2995 | 07 Aug 2014 @ 06:03 PDT | Database | Reply | BTEQ Import going to DELAYED state | Using PACK you still get delayed by TASM, but instead of inserting a single row PACK rows are processed, so all 400 should be inserted at once.
You might also talk to your DBA the exclude short wo... |
2994 | 07 Aug 2014 @ 02:44 PDT | Database | Reply | Tactical queries | dbc.QryLogV.CacheFlag
Value Description
T Query is found in step cache.
S Query is a parameterized query and a specific plan is generated.
G Query is parameterized query and a gener... |
2993 | 07 Aug 2014 @ 02:42 PDT | Database | Reply | User not listed in DBC.UsersV | You need to be an owner of a user or the DROP USER right to see them in dbc.UsersV
|
2992 | 07 Aug 2014 @ 02:39 PDT | Training | Reply | Need Teradata TE0-123 Physical implementation materials and dumps. | Well, did you know that you sign a "TCPP Candidate Agreement" including non-disclosure of test questions when you do a certification test? So if there are actual dumps they would be illeg... |
2991 | 07 Aug 2014 @ 02:21 PDT | Database | Reply | Why did the numeric value search in the varchar field fail; and a date format display question | That's it, a binary '00' is not a blank '20'.
If it's supposed to be a VARCHAR you probably need to remove the trailing 00 using TRIM(TRAILING '00'xc FROM new_txt)
... |
2990 | 06 Aug 2014 @ 02:44 PDT | Database | Reply | Determine how much space a Global Temporary Table is using - TD 13.10/14.10 | Hi Robin,
afaik there's no info about temp space usage in DBQL.
But you can get the combined size of all GTTs within a session using
SELECT VProc, CurrentTemp
FROM dbc.diskspaceV
... |
2989 | 06 Aug 2014 @ 02:24 PDT | Database | Reply | Sybase to Terdata | Unless the ampersand has a special meaning it's exactly the same in Teradats, simply remove the ampersand or replace it with a valid character, e.g.
case when mx_as_of_dt0 > #as_of_dt the... |
2988 | 06 Aug 2014 @ 02:20 PDT | Database | Reply | Why did the numeric value search in the varchar field fail; and a date format display question | Any trailing blank will be ignored during comparison ('1' = '1 '), only a leading blank will not be equal ('1' <> ' 1'), but TRIM removes both leading an... |
2987 | 06 Aug 2014 @ 02:14 PDT | Database | Reply | Front-end object does not exist error | As goldminer said, different users might have different default databases (if there's no default set on user level it's the user himself). so you need to qualify the tablename in your... |
2986 | 06 Aug 2014 @ 09:33 PDT | Database | Reply | BTEQ Import going to DELAYED state | You might try using a high PACK (e.g. PACK 10000) for the import, then it will be a single request.
But if the PACK number is too high you will get an error, so check for Failure 5966 Too man... |
2985 | 05 Aug 2014 @ 06:54 PDT | Database | Reply | Problem with ANSI TIME type and ODBC driver | Hi Sachen,
please post totally unrelated questions as a new topic.
|
2984 | 04 Aug 2014 @ 11:54 PDT | Database | Reply | What is mean by STAT FUNCTION in Teradata | What's the remaining text of this step?
STAT FUCTION step might be TOP or a Windowed Aggregate Function like RANK or SUM OVER.
|
2983 | 03 Aug 2014 @ 04:06 PDT | Analytics | Reply | Python in Database | As for any new feature, check the Release Summary for this version.
The SCRIPT table operator is not for implementing Python functions, but Phyton/Perl/etc. scripts, i.e. TD pipes rows as strings ... |
2982 | 03 Aug 2014 @ 03:56 PDT | Tools | Reply | BTEQ REPORT EXPORT AND IMPORT | Hi Jugal,
your CASTs still don't match, you use DeptId twice:
CAST(EmpId AS CHAR(3)),EmpName,CAST(DeptId AS CHAR(10)),CAST(DeptId AS CHAR(3)).
Regarding the error this looks like you didn... |
2981 | 02 Aug 2014 @ 03:56 PDT | Tools | Reply | BTEQ REPORT EXPORT AND IMPORT | When you export in report format there's a .SEPERATOR (by default 2 blanks).
Your number of column and length in EXPORT don't match your IMPORT definition:
CAST(EmpId AS CHAR(3)),EmpName,... |
2980 | 02 Aug 2014 @ 03:48 PDT | Training | Reply | Where can I get the Advanced Teradata SQL pdf document | Course #25966 is a Teradata instructor-led training, a PDF copy would not be available in a legal way :-)
|
2979 | 02 Aug 2014 @ 03:44 PDT | Database | Reply | Teradata Table Naming | Btw, the "lowest common denominator" is not Teradata, even Oracle 12c still supports only 30 characters for object names and 8 characters for database names :-)
|