4553 | 07 Jul 2016 @ 09:09 PDT | Connectivity | Reply | Ping Failed - can not connect to Teradata on Linux - aws | There should be messages when & why Teradata restarts, search for entires following "#TPA START".
To fix it you might start the Database Window (xdbw) and then "start vp... |
4552 | 07 Jul 2016 @ 08:52 PDT | Database | Reply | How to find how many mloads triggered | You can check the queryband in dbc.QryLogV for UTILITYNAME=MULTLOAD, all load sessions share the same value in the LSN column.
|
4551 | 07 Jul 2016 @ 08:36 PDT | Teradata Studio | Reply | “Teradata Studio.pkg” can’t be opened because it is from an unidentified developer. | This is due to Gatekeeper, see https://support.apple.com/en-us/HT202491
|
4550 | 07 Jul 2016 @ 04:17 PDT | Database | Reply | Migration Compatibility | I never heard of Tibero before, it seems to be an OLTP system, but Teradata is a Data Warehouse DBMS.
|
4549 | 07 Jul 2016 @ 04:16 PDT | Connectivity | Reply | Ping Failed - can not connect to Teradata on Linux - aws | Well, there's no Parsing Engine, no way to logon.
There were several crashes of the PE during the restarts, which finally lead to a FATAL state.
You can investigate what caused the crashes (/... |
4548 | 07 Jul 2016 @ 04:10 PDT | Database | Reply | Stored procedure | You need Dynamic SQL to create a matching Select-statement, there's no way to do that outside of a Stored Procedure.
|
4547 | 07 Jul 2016 @ 04:08 PDT | Database | Reply | Possible loop usage in SQL? | There's no need for loops, you can utilize an OLAP-function plus RESET WHEN:
SELECT ...
SUM(t1.amt)
OVER (ORDER BY t1.dt DESC
RESET WHEN t2.dt IS NOT NULL)
FROM table1 AS... |
4546 | 07 Jul 2016 @ 04:01 PDT | Analytics | Reply | Replacing missing value with next vaules | Assuming that the rows are sorted by date it's a simple MAX(Attmpt_dt) OVER (ORDER BY sortcolumn).
Otherwise you need LAST_VALUE (Attmpt_dt IGNORE NULLS) OVER (ORDER BY sortc... |
4545 | 07 Jul 2016 @ 03:55 PDT | Tools | Reply | TPT EXPORT OPERATOR job structure | http://www.info.teradata.com/HTMLPubs/DB_TTU_13_10/index.html#page/Load_and_Unload_Utilities/B035_2445_020A/2445appA.32.26.html#ww10737921
I don't know if the location changed, but the sample ... |
4544 | 06 Jul 2016 @ 08:41 PDT | Database | Reply | A problem with 'where' | Well, this is exactly what you wrote: No data from the year 2004 and no data from any august :-)
You want either a.num_month<>8 OR a.num_year<>2004 or NOT(a.num_month = 8 AND a.num_yea... |
4543 | 05 Jul 2016 @ 01:36 PDT | Database | Reply | Database per object type -- Best practice or over engineered? | @gerald.waters:
IMHO Tom Nolan already answered the "DB names follow no pattern" part, there are naming conventions, of course.
It is also common practice to seperate tables from user a... |
4542 | 05 Jul 2016 @ 12:47 PDT | Database | Reply | Find position of a character in a string | You can use oTranslate to remove multiple characters: oTRANSLATE(col, 'ae','')
|
4541 | 05 Jul 2016 @ 12:46 PDT | Database | Reply | Partitoin | No, you can't add partitions when you use CASE_N.
This should have been RANGE_N from the beginning like this:
RANGE_N (SYR BETWEEN 201501 AND 201504 EACH 1,
201601 A... |
4540 | 04 Jul 2016 @ 11:56 PDT | General | Reply | Update statment is getting failed | SAMPLE is not allowed in subqueries (probably because this might be a correlated subquery), but in Derived Tables:
UPDATE TABLE_NM SET EFF_STRT_DT = '2016-07-04'
WHERE EFF_END_DT = '... |
4539 | 03 Jul 2016 @ 08:26 PDT | Database | Reply | Manually generate create table | Define "manually generate".
There's CREATE TABLE newtable AS existingtable..., which allows defining indexes.
Or SHOW TABLE and then edit.
|
4538 | 30 Jun 2016 @ 11:20 PDT | Database | Reply | Error when trying to create a function | This is Oracle source code, of course it's not working as-is on Teradata.
See http://forums.teradata.com/forum/general/convert-13-digit-epoch-time-to-date#comment-148179 for an example to cast... |
4537 | 30 Jun 2016 @ 11:11 PDT | Database | Reply | How to find Table name, column name, column datatype and Number of row in table | dbc.TablesV -> table metadata
dbc.columnsV -> column metadata
If an approximate count is ok you might simply query dbc.StatsV, otherwise you need Dynamic SQL in a Stored Procedure to do the... |
4536 | 30 Jun 2016 @ 11:09 PDT | General | Reply | Query issue | QUALIFY must be moved out of the WHERE:
-- move the closing paren
WHERE (snap_dt = ADD_MONTHS(CURRENT_DATE,0)-EXTRACT(DAY FROM ADD_MONTHS(CURRENT_DATE,0))
and PMORTG.BDE_TFCLSTEP_P... |
4535 | 28 Jun 2016 @ 03:53 PDT | Database | Reply | leading zeroes | + is a numeric operator, only SQL Server uses it for string concat.
But you don't need any fancy calculation, simply use LPAD(ID_FD, 3, '0')
|
4534 | 28 Jun 2016 @ 12:36 PDT | Database | Reply | How to Write the correct syntax for Join | That's the same query you already got on StackOverflow:
SELECT COUNT(DISTINCT a.sku),COUNT(DISTINCT b.sku),COUNT(DISTINCT c.sku)
FROM skuinfo a
JOIN skstinfo b
ON a.sku=b.sku
JOIN tr... |
4533 | 27 Jun 2016 @ 11:39 PDT | Database | Reply | How to Write the correct syntax for Join | Nobody will tell that this query is right (otherwise they don't know about SQL).
You join three tables but the second ON is missing.
And when you explicit join syntax the ON is mandatory, so ... |
4532 | 27 Jun 2016 @ 11:35 PDT | Analytics | Reply | Help extracting select time period records ( rank / any other way) | Ops, the ROWS part was missing:
select COLA, COLB, COLC,
min(COLB)
over (partition by COLA
order by COLC
rows between 1 following and 1 following) as nextCOLB... |
4531 | 26 Jun 2016 @ 11:02 PDT | Database | Reply | High Skewfactor inspite of even distribution | Since TD12 all dbc-views without V/VX were legacy because they return CHAR(30) LATIN instead of the new VARCHAR(128) UNICODE, i.e. compatibilty views.
TD14.10 finally enabled long object names, so... |
4530 | 26 Jun 2016 @ 04:35 PDT | Database | Reply | NOT NULL still retrieves NULL | Are you sure that '?' is actually a NULL and not a literal question mark?
I usually display NULLs as <<NUL>> to avoid confusion...
|
4529 | 26 Jun 2016 @ 04:31 PDT | Database | Reply | High Skewfactor inspite of even distribution | Is the tablename longer than 30 characters?
You're using dbc.TableSize instead of dbc.TableSizeV.
|