#DateForumTypeThreadPost
1226 Aug 2013 @ 09:17 PDTAnalyticsTopicAJI ignored with analytic function's usage I am testing AJI usage on a query and am trying to understand why the using the analytics would ignore the AJI…. The following query snapshot uses the JI (JI3_TRANS_DETAIL_GL) SELECT...
1122 Apr 2013 @ 09:36 PDTDatabaseReplyDivision by zero ErrorWell, i can do the following without errors 1> SELECT * from (Query) 2> SELECT C0,C1, C2 from (Query) But, when i try to do a SELECT C0, C1, AVG(C2) OVER (PARTITION BY C0,C1), it ...
1022 Apr 2013 @ 09:03 PDTDatabaseReplyDivision by zero ErrorIt's failing on the AVG() function. SELECT DISTINCT C0, C1, AVG(C2) OVER (PARTITION BY C0,C1) AS C5
922 Apr 2013 @ 08:47 PDTDatabaseTopicDivision by zero ErrorI'm trying to execute a query which fails on divide by zero error. Can't use a NULLIFZERO because the AJI would be ignored. Following is the query which fails on "SELECT Failed. 26...
813 Mar 2013 @ 09:09 PDTDatabaseReplyOptimizer's inability to resolve variables for partitioningThanks Dieter.. much appreciated.
713 Mar 2013 @ 08:29 PDTDatabaseReplyOptimizer's inability to resolve variables for partitioning:) Thanks Dieter... but i should have mentioned that the dates are passed as parameters into a table and we create a view on that table. The view cannot be created on hard coded dates. I used t...
613 Mar 2013 @ 07:31 PDTDatabaseReplyOptimizer's inability to resolve variables for partitioningThanks for the response Dieter. I tried creating the view, but that doesn't seem to change the plan. CREATE VIEW SSURI.V_CDC1 (BATCH_START, BATCH_END) AS SELECT     CAST(BA...
504 Mar 2013 @ 09:19 PSTDatabaseReplyOptimizer's inability to resolve variables for partitioningDB VERSION 13.10.05.02 I'm attempting to understand how does the optimizer resolve (if at all) dynamic variables (subquery) for partition elimination. Here is an example, CREATE TABLE SSURI....
404 Mar 2013 @ 09:19 PSTDatabaseTopicOptimizer's inability to resolve variables for partitioningDB VERSION 13.10.05.02 I'm attempting to understand how does the optimizer resolve (if at all) dynamic variables (subquery) for partition elimination. Here is an example, CREATE TABLE SSURI....
301 Mar 2013 @ 09:10 PSTDatabaseReplyTable partitioning on TIMESTAMP(3) in Teradata 13CREATE TABLE SSURI.PPI_TEST (TRACKINGNUM INTEGER, AUD_TIME TIMESTAMP) PRIMARY INDEX PPI_TEST_PR (TRACKINGNUM) PARTITION BY RANGE_N(CAST((AUD_TIME) AS DATE AT LOCAL) BETWEEN '2009-12-31'...
204 Dec 2012 @ 10:25 PSTAnalyticsTopicall-AMPs STATS FUNCTIONI am trying to understand the following steps from an explain of a massively skewed query. The "no confidence" is because of the calculations and functions applied to the columns. Wou...
109 May 2011 @ 11:11 PDTDatabaseTopicTemporals and Outer JoinsOne of the caveats (if i may say so) of temporals is that apart from inner joins, you DO NOT have the liberty of doing anything with it...ofcourse outside the scope of usual temporal commands. For ...