#DateForumTypeThreadPost
455307 Jul 2016 @ 09:09 PDTConnectivityReplyPing Failed - can not connect to Teradata on Linux - awsThere 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...
455207 Jul 2016 @ 08:52 PDTDatabaseReplyHow to find how many mloads triggeredYou can check the queryband in dbc.QryLogV for UTILITYNAME=MULTLOAD, all load sessions share the same value in the LSN column.
455107 Jul 2016 @ 08:36 PDTTeradata StudioReply“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
455007 Jul 2016 @ 04:17 PDTDatabaseReplyMigration CompatibilityI never heard of Tibero before, it seems to be an OLTP system, but Teradata is a Data Warehouse DBMS.
454907 Jul 2016 @ 04:16 PDTConnectivityReplyPing Failed - can not connect to Teradata on Linux - awsWell, 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 (/...
454807 Jul 2016 @ 04:10 PDTDatabaseReplyStored procedureYou need Dynamic SQL to create a matching Select-statement, there's no way to do that outside of a Stored Procedure.
454707 Jul 2016 @ 04:08 PDTDatabaseReplyPossible 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...
454607 Jul 2016 @ 04:01 PDTAnalyticsReplyReplacing missing value with next vaulesAssuming 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...
454507 Jul 2016 @ 03:55 PDTToolsReplyTPT EXPORT OPERATOR job structurehttp://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 ...
454406 Jul 2016 @ 08:41 PDTDatabaseReplyA 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...
454305 Jul 2016 @ 01:36 PDTDatabaseReplyDatabase 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...
454205 Jul 2016 @ 12:47 PDTDatabaseReplyFind position of a character in a stringYou can use oTranslate to remove multiple characters: oTRANSLATE(col, 'ae','')
454105 Jul 2016 @ 12:46 PDTDatabaseReplyPartitoinNo, 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...
454004 Jul 2016 @ 11:56 PDTGeneralReplyUpdate statment is getting failedSAMPLE 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 = '...
453903 Jul 2016 @ 08:26 PDTDatabaseReplyManually generate create tableDefine "manually generate". There's CREATE TABLE newtable AS existingtable..., which allows defining indexes. Or SHOW TABLE and then edit.
453830 Jun 2016 @ 11:20 PDTDatabaseReplyError when trying to create a functionThis 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...
453730 Jun 2016 @ 11:11 PDTDatabaseReplyHow to find Table name, column name, column datatype and Number of row in tabledbc.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...
453630 Jun 2016 @ 11:09 PDTGeneralReplyQuery issueQUALIFY 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...
453528 Jun 2016 @ 03:53 PDTDatabaseReplyleading 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')
453428 Jun 2016 @ 12:36 PDTDatabaseReplyHow to Write the correct syntax for JoinThat'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...
453327 Jun 2016 @ 11:39 PDTDatabaseReplyHow to Write the correct syntax for JoinNobody 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 ...
453227 Jun 2016 @ 11:35 PDTAnalyticsReplyHelp 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...
453126 Jun 2016 @ 11:02 PDTDatabaseReplyHigh Skewfactor inspite of even distributionSince 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...
453026 Jun 2016 @ 04:35 PDTDatabaseReplyNOT NULL still retrieves NULLAre you sure that '?' is actually a NULL and not a literal question mark? I usually display NULLs as <<NUL>> to avoid confusion...
452926 Jun 2016 @ 04:31 PDTDatabaseReplyHigh Skewfactor inspite of even distributionIs the tablename longer than 30 characters? You're using dbc.TableSize instead of dbc.TableSizeV.

Pages