2978 | 02 Aug 2014 @ 01:09 PDT | Database | Reply | Rank with Qualify not giving the exact results. | Hi Amit,
you probably need to partition by your part column, PARTITION BY FROM_ID?
|
2977 | 31 Jul 2014 @ 03:14 PDT | Database | Reply | Distribution in amps | The table header is not always 1 KB, in fact it's usually larger, might be up to 1 MB per AMP
The actual size per AMP depends on the number of columns & indexes, multi value compression, e... |
2976 | 31 Jul 2014 @ 03:12 PDT | Database | Reply | Avoid Product Join Step | You need to show the actual query plus explain to find out.
|
2975 | 31 Jul 2014 @ 03:08 PDT | Database | Reply | number of rows per AMP - BEFORE RECONFIGURATION | Hi Piotr,
I don't know if I understood you correctly, but if the reconfig didn't run yet, the new AMPs are unknown to the system. So you run the same query as before...
|
2974 | 31 Jul 2014 @ 02:25 PDT | Database | Reply | Deferred name resolution | If you check the message it should be a Warning instead of an error and the SP should be created.
|
2973 | 31 Jul 2014 @ 02:23 PDT | Database | Reply | Timestamp format on teradata retrieval | How does your input data look like? Is there a formatting rule?
Based on yor actual needs you might use a Regular Expression in TD14 to check for valid date/time.
|
2972 | 31 Jul 2014 @ 02:20 PDT | Database | Reply | concatenate timestamp with char | There's no automatic typecast for Timestamps, you need to cast them explicitly:
cast(current_timestamp as varchar(32))||'abc'
|
2971 | 31 Jul 2014 @ 02:17 PDT | Database | Reply | filter numeric letters from combination of alpha numeric letters and numeric letters | Hi Satvik,
what's your TD release?
In TD14 you can utilize a Regular Expression:
regexp_substr(col, '[0-9]+')
This will extract the first seqence of digits.
|
2970 | 31 Jul 2014 @ 02:14 PDT | Database | Reply | How to sleep/pause in a Stored Procedure? | It's probably not filling the Query Log or Access Log, but it's a waste of resources, it's a loop possibly consuming 100% CPU during the sleep.
|
2969 | 29 Jul 2014 @ 01:31 PDT | Database | Reply | remove line feed, carriage return from column | '0D0A'XB returns a binary string, you need to change it to '0D0A'XC.
And instead of oReplace you better use oTranslate to remove both characters independently:
oTranslate(col... |
2968 | 29 Jul 2014 @ 01:10 PDT | Database | Reply | Avoid Product Join Step | Both steps show no confidence, are you sure that the necessary stats exist?
|
2967 | 29 Jul 2014 @ 01:03 PDT | Database | Reply | Declare and Set then Open and Fetch | Standard SQL's LAG and LEAD functions are not implemented in TD, but it easy to rewrite.
E.g. get the previous row's value
min(gpi10)
over (partition by memberId
order by ... |
2966 | 27 Jul 2014 @ 07:35 PDT | Database | Reply | Declare and Set then Open and Fetch | The logic can be easily be ported to a Teradata Stored Procedure.
Most of the syntax is the same, e.g. declare cursor/while/fetch/set, but some has to be adjusted, e.g.
- TD doesn't allo... |
2965 | 27 Jul 2014 @ 02:42 PDT | Database | Reply | Secondary Index and No PI table | There's no difference for a NUSI on PI vs. NoPI tables, each row in a NoPI table still has a RowID:
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/Database_Management/B035_... |
2964 | 27 Jul 2014 @ 02:35 PDT | Database | Reply | hexadecimal--->decimal | It would be nice to actually pose a question.
16hex = binary|string?
result = binary|string|numeric?
|
2963 | 26 Jul 2014 @ 08:55 PDT | Database | Reply | Avoid Product Join Step | As there's a good join-condition the product join was choosen by the optmizer cause it's the best way to get the result.
Did you check in DBQL if the estimated number of rows is actually i... |
2962 | 26 Jul 2014 @ 02:24 PDT | Tools | Reply | TPT : Suppress or Redirect stdout/stderr logs | Hi Tarun,
I don't think you can switch off the output to stdout within TPT.
The TRACELEVEL option controlling what is written to the log is set to NONE by default, setting it to a higher... |
2961 | 26 Jul 2014 @ 02:11 PDT | Database | Reply | Teradata Reports are running very slow | Hi Mahendra,
the way you describe it, the TASM settings don't look optimal :-)
But there's no way to deal with that doing a post here on DevEx.
|
2960 | 26 Jul 2014 @ 02:09 PDT | Database | Reply | Date_Insert_error | There are two issues with that timestamp (only Oracle calls a timestamp a date) string:
9 digits for fractional seconds, Teradata allows only up to 6. You need to strip of the addition... |
2959 | 25 Jul 2014 @ 01:36 PDT | General | Reply | MAX() OVER () function producing inconsistent results | Without ORDER BY the result is random, based on you expected result you probably need:
, MAX(GOVT_ID) over (partition by AGREEMENT_ID, PDCR_ID
ORDER BY OWNR... |
2958 | 25 Jul 2014 @ 07:21 PDT | Tools | Reply | TPT : Suppress or Redirect stdout/stderr logs | "level of IO"? For a few lines? You're joking :-)
if you don't want that output redirect to /dev/null
|
2957 | 25 Jul 2014 @ 05:44 PDT | Database | Reply | Problem with Polish special characters in WHERE clause | LATIN can't store polish characters, you must use UNICODE and use UTF8 or UTF16 sessions.
After inserting those polish characters in an ASCII session you should select them. You'll notice ... |
2956 | 25 Jul 2014 @ 03:03 PDT | Tools | Reply | Issues with loading date field using BTEQ script | - when you define VARTEXT all fields must be defined as VARCHAR in USING
- a FLOAT is a FLOAT and not a DATE
|
2955 | 25 Jul 2014 @ 02:08 PDT | Database | Reply | error in UPDATE statement | Hi Carlos,
of course you're right :-)
I didn't read your anwer before my post and also didn't notice the bad syntax.
|
2954 | 25 Jul 2014 @ 01:25 PDT | Database | Reply | Identify Multicolumn Foreign key on TD 14 | It's an easy task to provide the info about multicolumn FKs using the dbc views as each column of a multicolumns FK is stored as a row in those views (similar to dbc.IndicesV).
|