[teiid-issues] [JBoss JIRA] (TEIID-4348) Querying with the OVER clause throws NPE
Steven Hawkins (JIRA)
issues at jboss.org
Mon Oct 31 09:35:02 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-4348.
---------------------------------
> Querying with the OVER clause throws NPE
> ----------------------------------------
>
> Key: TEIID-4348
> URL: https://issues.jboss.org/browse/TEIID-4348
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Steve Tran
>
> I'm not sure if the OVER clause is valid syntax in the ANSI dialect of Teiid, but trying so gives me a NullPointerException. It looks like it almost runs though.
> {code}
> select DERVD_COT_ID D_COT , SUPPLIER_PAR_ID, SUM(AVG_DDD_DOL_AMT) TOT_dollars,
> SUM(AVG_DDD_DOL_AMT) OVER (partition by DERVD_COT_ID)
> from PBI_ZIP_DCOT_CNFDTY_2
> GROUP BY DERVD_COT_ID,SUPPLIER_PAR_ID;
> {code}
> Here's the stack trace
> {code}
> 17:11:00,775 INFO [org.teiid.PLANNER] (Worker45_QueryProcessorQueue654)
> ============================================================================
> USER COMMAND:
> SELECT PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID AS D_COT, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID) FROM PBIPR.PBI_ZIP_DCOT_CNFDTY_2 GROUP BY PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID
> ----------------------------------------------------------------------------
> OPTIMIZE:
> SELECT PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID AS D_COT, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID) FROM PBIPR.PBI_ZIP_DCOT_CNFDTY_2 GROUP BY PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID
> ----------------------------------------------------------------------------
> GENERATE CANONICAL:
> SELECT PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID AS D_COT, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID) FROM PBIPR.PBI_ZIP_DCOT_CNFDTY_2 GROUP BY PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID
> CANONICAL PLAN:
> Project(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)], HAS_WINDOW_FUNCTIONS=true})
> Group(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={GROUP_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID], SYMBOL_MAP={anon_grp0.gcol0=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, anon_grp0.gcol1=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, anon_grp0.agg0=SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT)}})
> Source(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2])
> ============================================================================
> EXECUTING PlaceAccess
> AFTER:
> Project(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)], HAS_WINDOW_FUNCTIONS=true})
> Group(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={GROUP_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID], SYMBOL_MAP={anon_grp0.gcol0=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, anon_grp0.gcol1=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, anon_grp0.agg0=SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT)}})
> Access(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2], props={SOURCE_HINT=null, MODEL_ID=Schema name=PBIPR, nameInSource=null, uuid=mmuuid:eecf1a36-0a54-430f-a51c-e3839c8abd29})
> Source(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2])
> ============================================================================
> EXECUTING RaiseAccess
> LOW Relational Planner Aggregate function pushdown not supported by source PBIPR - SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) was not pushed
> AFTER:
> Project(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)], HAS_WINDOW_FUNCTIONS=true})
> Group(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={GROUP_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID], SYMBOL_MAP={anon_grp0.gcol0=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, anon_grp0.gcol1=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, anon_grp0.agg0=SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT)}})
> Access(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2], props={SOURCE_HINT=null, MODEL_ID=Schema name=PBIPR, nameInSource=null, uuid=mmuuid:eecf1a36-0a54-430f-a51c-e3839c8abd29})
> Source(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2])
> ============================================================================
> EXECUTING PushAggregates
> AFTER:
> Project(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)], HAS_WINDOW_FUNCTIONS=true})
> Group(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={GROUP_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID], SYMBOL_MAP={anon_grp0.gcol0=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, anon_grp0.gcol1=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, anon_grp0.agg0=SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT)}})
> Access(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2])
> Source(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2])
> ============================================================================
> EXECUTING AssignOutputElements
> AFTER:
> Project(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)], HAS_WINDOW_FUNCTIONS=true, OUTPUT_COLS=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)]})
> Group(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={GROUP_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID], SYMBOL_MAP={anon_grp0.gcol0=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, anon_grp0.gcol1=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, anon_grp0.agg0=SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT]})
> Access(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2], props={SOURCE_HINT=null, MODEL_ID=Schema name=PBIPR, nameInSource=null, uuid=mmuuid:eecf1a36-0a54-430f-a51c-e3839c8abd29, OUTPUT_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT]})
> Source(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2], props={OUTPUT_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT]})
> ============================================================================
> EXECUTING CalculateCost
> AFTER:
> Project(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)], HAS_WINDOW_FUNCTIONS=true, OUTPUT_COLS=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)], EST_CARDINALITY=65418.0, EST_COL_STATS={anon_grp0.gcol0 AS D_COT=[21806.0, -1.0], anon_grp0.gcol1 AS SUPPLIER_PAR_ID=[21806.0, -1.0], anon_grp0.agg0 AS TOT_dollars=[21806.0, -1.0], SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)=[-1.0, -1.0]}})
> Group(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={GROUP_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID], SYMBOL_MAP={anon_grp0.gcol0=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, anon_grp0.gcol1=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, anon_grp0.agg0=SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT], EST_CARDINALITY=65418.0, EST_COL_STATS={anon_grp0.gcol0=[21806.0, -1.0], anon_grp0.gcol1=[21806.0, -1.0], anon_grp0.agg0=[21806.0, -1.0], PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT=[-1.0, -1.0]}})
> Access(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2], props={SOURCE_HINT=null, MODEL_ID=Schema name=PBIPR, nameInSource=null, uuid=mmuuid:eecf1a36-0a54-430f-a51c-e3839c8abd29, OUTPUT_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT], EST_CARDINALITY=130836.0, EST_COL_STATS={PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID=[-1.0, -1.0], PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID=[-1.0, -1.0], PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT=[-1.0, -1.0]}})
> Source(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2], props={OUTPUT_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT], EST_COL_STATS={PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID=[-1.0, -1.0], PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID=[-1.0, -1.0], PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT=[-1.0, -1.0]}, EST_CARDINALITY=130836.0})
> ============================================================================
> EXECUTING PlanSorts
> AFTER:
> Project(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0])
> Group(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0], props={GROUP_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID], SYMBOL_MAP={anon_grp0.gcol0=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, anon_grp0.gcol1=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, anon_grp0.agg0=SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT], EST_CARDINALITY=65418.0, EST_COL_STATS={anon_grp0.gcol0=[21806.0, -1.0], anon_grp0.gcol1=[21806.0, -1.0], anon_grp0.agg0=[21806.0, -1.0], PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT=[-1.0, -1.0]}})
> Access(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2])
> Source(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2])
> ============================================================================
> EXECUTING CollapseSource
> AFTER:
> Project(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0])
> Group(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2, anon_grp0])
> Access(groups=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2], props={SOURCE_HINT=null, MODEL_ID=Schema name=PBIPR, nameInSource=null, uuid=mmuuid:eecf1a36-0a54-430f-a51c-e3839c8abd29, OUTPUT_COLS=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT], EST_CARDINALITY=130836.0, EST_COL_STATS={PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID=[-1.0, -1.0], PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID=[-1.0, -1.0], PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT FROM PBIPR.PBI_ZIP_DCOT_CNFDTY_2})
> ============================================================================
> CONVERTING PLAN TREE TO PROCESS TREE
> PROCESS PLAN =
> ProjectNode(1) output=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)] [anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)]
> WindowFunctionProjectNode(2) output=[SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0), anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT]
> GroupingNode(3) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT] [PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID]{anon_grp0.gcol0=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, anon_grp0.gcol1=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, anon_grp0.agg0=SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT)}
> AccessNode(4) output=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT] SELECT PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT FROM PBIPR.PBI_ZIP_DCOT_CNFDTY_2
> ============================================================================
> ----------------------------------------------------------------------------
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> ProjectNode(1) output=[anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)] [anon_grp0.gcol0 AS D_COT, anon_grp0.gcol1 AS SUPPLIER_PAR_ID, anon_grp0.agg0 AS TOT_dollars, SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0)]
> WindowFunctionProjectNode(2) output=[SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT) OVER (PARTITION BY anon_grp0.gcol0), anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT]
> GroupingNode(3) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT] [PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID]{anon_grp0.gcol0=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, anon_grp0.gcol1=PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, anon_grp0.agg0=SUM(PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT)}
> AccessNode(4) output=[PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT] SELECT PBIPR.PBI_ZIP_DCOT_CNFDTY_2.DERVD_COT_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.SUPPLIER_PAR_ID, PBIPR.PBI_ZIP_DCOT_CNFDTY_2.AVG_DDD_DOL_AMT FROM PBIPR.PBI_ZIP_DCOT_CNFDTY_2
> ============================================================================
> 17:11:00,785 ERROR [org.teiid.PROCESSOR] (Worker45_QueryProcessorQueue654) TEIID30019 Unexpected exception for request Z87J+n4LbJTu.0: java.lang.NullPointerException
> at org.teiid.query.processor.relational.GroupingNode.initialize(GroupingNode.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:94) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:100) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:100) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:89) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_66]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_66]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_66]
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
More information about the teiid-issues
mailing list