Full log is pasted below as well as connection and timeout settings from standalone-teiid.xml. Query runs fine in the database and rows are ready to return to client but Teiid cancels at that point.
<pool>
<min-pool-size>0</min-pool-size>
<max-pool-size>100</max-pool-size>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<timeout>
<set-tx-query-timeout>true</set-tx-query-timeout>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>10</idle-timeout-minutes>
<query-timeout>600</query-timeout>
<allocation-retry>3</allocation-retry>
<allocation-retry-wait-millis>1000</allocation-retry-wait-millis>
</timeout>
21:50:08,169 INFO [org.teiid.COMMAND_LOG] (New I/O worker #2) | START USER COMMAND: | startTime=2016-02-03 21:50:08.169 | requestID=oWyjQD36adh3.0 | txID=null | sessionID=oWyjQD36adh3 | applicationName=JDBC | principal=appuser@teiid-security | vdbName=Warehouse | vdbVersion=1 | sql=select sum(T172081."num_items") as c1, |
sum(T172081."pub_comm_base") as c2,
T139712."month_year_name" as c3,
case when T172081."sku_number" is null then 'Unmeasured' else T172081."sku_number" end as c4,
T139818."publisher_key" as c5,
T139818."publisher_name" as c6,
T139712."date_key" as c7,
T172081."u1" as c8,
T172081."orderid" as c9,
T139712."year_month" as c10
from
"Warehouse"."warehouse"."dim_publisher" T139818,
"Warehouse"."warehouse"."dim_date" T139712,
"Warehouse"."warehouse"."dim_network" T139705,
"Warehouse"."warehouse"."fact_transaction_consumer_trans_date_detail" T172081
where ( T139705."network_key" = T172081."network_key" and T139705."network_name" = 'US Network' and T139712."date_key" = T172081."process_date_key" and T139818."publisher_key" = T172081."publisher_key" and T172081."advertiser_key" = 2291 and T139818."publisher_key" <> -1 and case when T172081."sku_number" is null then 'Unmeasured' else T172081."sku_number" end <> 'Unmeasured' and T139712."date_key" between {d '2015-12-01'} and {d '2016-12-31'} and T172081."process_date_key" between {d '2015-12-01'} and {d '2016-12-31'} )
group by T139712."date_key", T139712."month_year_name", T139712."year_month", T139818."publisher_key", T139818."publisher_name", T172081."orderid", T172081."u1", case when T172081."sku_number" is null then 'Unmeasured' else T172081."sku_number" end
21:50:08,169 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156124) Request Thread oWyjQD36adh3.0 with state NEW
21:50:08,169 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156124) oWyjQD36adh3.0 Command has no cache hint and result set cache mode is not on.
21:50:08,169 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156124) oWyjQD36adh3.0 executing select sum(T172081."num_items") as c1,
sum(T172081."pub_comm_base") as c2,
T139712."month_year_name" as c3,
case when T172081."sku_number" is null then 'Unmeasured' else T172081."sku_number" end as c4,
T139818."publisher_key" as c5,
T139818."publisher_name" as c6,
T139712."date_key" as c7,
T172081."u1" as c8,
T172081."orderid" as c9,
T139712."year_month" as c10
from
"Warehouse"."warehouse"."dim_publisher" T139818,
"Warehouse"."warehouse"."dim_date" T139712,
"Warehouse"."warehouse"."dim_network" T139705,
"Warehouse"."warehouse"."fact_transaction_consumer_trans_date_detail" T172081
where ( T139705."network_key" = T172081."network_key" and T139705."network_name" = 'US Network' and T139712."date_key" = T172081."process_date_key" and T139818."publisher_key" = T172081."publisher_key" and T172081."advertiser_key" = 2291 and T139818."publisher_key" <> -1 and case when T172081."sku_number" is null then 'Unmeasured' else T172081."sku_number" end <> 'Unmeasured' and T139712."date_key" between {d '2015-12-01'} and {d '2016-12-31'} and T172081."process_date_key" between {d '2015-12-01'} and {d '2016-12-31'} )
group by T139712."date_key", T139712."month_year_name", T139712."year_month", T139818."publisher_key", T139818."publisher_name", T172081."orderid", T172081."u1", case when T172081."sku_number" is null then 'Unmeasured' else T172081."sku_number" end
21:50:08,182 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156124) ProcessTree for oWyjQD36adh3.0 AccessNode(1) output=[anon_grp0.agg0 AS c1, anon_grp0.agg1 AS c2, anon_grp0.gcol1 AS c3, anon_grp0.gcol7 AS c4, anon_grp0.gcol3 AS c5, anon_grp0.gcol4 AS c6, anon_grp0.gcol0 AS c7, anon_grp0.gcol6 AS c8, anon_grp0.gcol5 AS c9, anon_grp0.gcol2 AS c10] SELECT SUM(v_0.c_8), SUM(v_0.c_9), v_0.c_1, v_0.c_7, v_0.c_3, v_0.c_4, v_0.c_0, v_0.c_6, v_0.c_5, v_0.c_2 FROM (SELECT g_1.date_key AS c_0, g_1.month_year_name AS c_1, g_1.year_month AS c_2, g_0.publisher_key AS c_3, g_0.publisher_name AS c_4, g_3.orderid AS c_5, g_3.u1 AS c_6, CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END AS c_7, g_3.num_items AS c_8, g_3.pub_comm_base AS c_9 FROM warehouse.dim_publisher AS g_0 INNER JOIN (warehouse.dim_date AS g_1 INNER JOIN (warehouse.dim_network AS g_2 INNER JOIN warehouse.fact_transaction_consumer_trans_date_detail AS g_3 ON g_2.network_key = convert(g_3.network_key, long)) ON g_1.date_key = g_3.process_date_key) ON g_0.publisher_key = g_3.publisher_key WHERE (g_0.publisher_key <> -1) AND (g_1.date_key >= '2015-12-01') AND (g_1.date_key <= '2016-12-31') AND (g_2.network_name = 'US Network') AND (g_3.advertiser_key = 2291) AND (CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END <> 'Unmeasured') AND (g_3.process_date_key >= '2015-12-01') AND (g_3.process_date_key <= '2016-12-31') AND (g_3.publisher_key <> -1)) AS v_0 GROUP BY v_0.c_0, v_0.c_1, v_0.c_2, v_0.c_3, v_0.c_4, v_0.c_5, v_0.c_6, v_0.c_7
21:50:08,183 DEBUG [org.teiid.CONNECTOR] (Worker648_QueryProcessorQueue156124) oWyjQD36adh3.0.1.577 Create State
21:50:08,183 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156124) Request Thread oWyjQD36adh3.0 - processor blocked
21:50:08,183 DEBUG [org.teiid.PROCESSOR] (Worker649_QueryProcessorQueue156125) Running task for parent thread Worker648_QueryProcessorQueue156124
21:50:08,183 DEBUG [org.teiid.CONNECTOR] (Worker649_QueryProcessorQueue156125) oWyjQD36adh3.0.1.577 Processing NEW request: SELECT SUM(v_0.c_8), SUM(v_0.c_9), v_0.c_1, v_0.c_7, v_0.c_3, v_0.c_4, v_0.c_0, v_0.c_6, v_0.c_5, v_0.c_2 FROM (SELECT g_1.date_key AS c_0, g_1.month_year_name AS c_1, g_1.year_month AS c_2, g_0.publisher_key AS c_3, g_0.publisher_name AS c_4, g_3.orderid AS c_5, g_3.u1 AS c_6, CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END AS c_7, g_3.num_items AS c_8, g_3.pub_comm_base AS c_9 FROM warehouse.dim_publisher AS g_0 INNER JOIN (warehouse.dim_date AS g_1 INNER JOIN (warehouse.dim_network AS g_2 INNER JOIN warehouse.fact_transaction_consumer_trans_date_detail AS g_3 ON g_2.network_key = convert(g_3.network_key, long)) ON g_1.date_key = g_3.process_date_key) ON g_0.publisher_key = g_3.publisher_key WHERE (g_0.publisher_key <> -1) AND (g_1.date_key >= '2015-12-01') AND (g_1.date_key <= '2016-12-31') AND (g_2.network_name = 'US Network') AND (g_3.advertiser_key = 2291) AND (CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END <> 'Unmeasured') AND (g_3.process_date_key >= '2015-12-01') AND (g_3.process_date_key <= '2016-12-31') AND (g_3.publisher_key <> -1)) AS v_0 GROUP BY v_0.c_0, v_0.c_1, v_0.c_2, v_0.c_3, v_0.c_4, v_0.c_5, v_0.c_6, v_0.c_7
21:50:09,194 DEBUG [org.teiid.CONNECTOR] (Worker649_QueryProcessorQueue156125) oWyjQD36adh3.0.1.577 Obtained execution
21:50:09,194 DEBUG [org.teiid.COMMAND_LOG] (Worker649_QueryProcessorQueue156125) | START DATA SRC COMMAND: | startTime=2016-02-03 21:50:09.194 | requestID=oWyjQD36adh3.0 | sourceCommandID=1 | executionID=577 | txID=null | modelName=warehouse | translatorName=impala | sessionID=oWyjQD36adh3 | principal=appuser@teiid-security | sql=SELECT SUM(v_0.c_8), SUM(v_0.c_9), v_0.c_1, v_0.c_7, v_0.c_3, v_0.c_4, v_0.c_0, v_0.c_6, v_0.c_5, v_0.c_2 FROM (SELECT g_1.date_key AS c_0, g_1.month_year_name AS c_1, g_1.year_month AS c_2, g_0.publisher_key AS c_3, g_0.publisher_name AS c_4, g_3.orderid AS c_5, g_3.u1 AS c_6, CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END AS c_7, g_3.num_items AS c_8, g_3.pub_comm_base AS c_9 FROM warehouse.dim_publisher AS g_0 INNER JOIN (warehouse.dim_date AS g_1 INNER JOIN (warehouse.dim_network AS g_2 INNER JOIN warehouse.fact_transaction_consumer_trans_date_detail AS g_3 ON g_2.network_key = convert(g_3.network_key, long)) ON g_1.date_key = g_3.process_date_key) ON g_0.publisher_key = g_3.publisher_key WHERE (g_0.publisher_key <> -1) AND (g_1.date_key >= '2015-12-01') AND (g_1.date_key <= '2016-12-31') AND (g_2.network_name = 'US Network') AND (g_3.advertiser_key = 2291) AND (CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END <> 'Unmeasured') AND (g_3.process_date_key >= '2015-12-01') AND (g_3.process_date_key <= '2016-12-31') AND (g_3.publisher_key <> -1)) AS v_0 GROUP BY v_0.c_0, v_0.c_1, v_0.c_2, v_0.c_3, v_0.c_4, v_0.c_5, v_0.c_6, v_0.c_7 |
21:50:09,194 DEBUG [org.teiid.CONNECTOR] (Worker649_QueryProcessorQueue156125) Source-specific command: SELECT SUM(v_0.c_8), SUM(v_0.c_9), v_0.c_1, v_0.c_7, v_0.c_3, v_0.c_4, v_0.c_0, v_0.c_6, v_0.c_5, v_0.c_2 FROM (SELECT g_1.`date_key` AS c_0, g_1.`month_year_name` AS c_1, g_1.`year_month` AS c_2, g_0.`publisher_key` AS c_3, g_0.`publisher_name` AS c_4, g_3.`orderid` AS c_5, g_3.`u1` AS c_6, CASE WHEN g_3.`sku_number` IS NULL THEN 'Unmeasured' ELSE g_3.`sku_number` END AS c_7, g_3.`num_items` AS c_8, g_3.`pub_comm_base` AS c_9 FROM warehouse.dim_network g_2 JOIN warehouse.fact_transaction_consumer_trans_date_detail g_3 ON g_2.`network_key` = cast(g_3.`network_key` AS bigint) JOIN warehouse.dim_date g_1 ON g_1.`date_key` = g_3.`process_date_key` JOIN warehouse.dim_publisher g_0 ON g_0.`publisher_key` = g_3.`publisher_key` WHERE g_0.`publisher_key` <> -1 AND g_1.`date_key` >= '2015-12-01' AND g_1.`date_key` <= '2016-12-31' AND g_2.`network_name` = 'US Network' AND g_3.`advertiser_key` = 2291 AND CASE WHEN g_3.`sku_number` IS NULL THEN 'Unmeasured' ELSE g_3.`sku_number` END <> 'Unmeasured' AND g_3.`process_date_key` >= '2015-12-01' AND g_3.`process_date_key` <= '2016-12-31' AND g_3.`publisher_key` <> -1) v_0 GROUP BY v_0.c_0, v_0.c_1, v_0.c_2, v_0.c_3, v_0.c_4, v_0.c_5, v_0.c_6, v_0.c_7
21:50:18,774 DEBUG [org.teiid.PROCESSOR] (SessionMonitor) cancelQuery for requestID=oWyjQD36adh3.0
21:50:18,775 DEBUG [org.teiid.CONNECTOR] (SessionMonitor) oWyjQD36adh3.0.1.577 Processing CANCEL request
21:50:18,775 DEBUG [org.teiid.COMMAND_LOG] (SessionMonitor) | CANCEL SRC COMMAND: | endTime=2016-02-03 21:50:18.775 | requestID=oWyjQD36adh3.0 | sourceCommandID=1 | executionID=577 | txID=null | modelName=warehouse | translatorName=impala | sessionID=oWyjQD36adh3 | principal=appuser@teiid-security | finalRowCount=-1 |
21:50:20,103 DEBUG [org.teiid.CONNECTOR] (Worker649_QueryProcessorQueue156125) oWyjQD36adh3.0.1.577 Executed command
21:50:20,103 DEBUG [org.teiid.CONNECTOR] (Worker649_QueryProcessorQueue156125) oWyjQD36adh3.0.1.577 Processing MORE request
21:50:20,103 DEBUG [org.teiid.CONNECTOR] (Worker649_QueryProcessorQueue156125) oWyjQD36adh3.0.1.577 Getting results from connector
21:50:20,104 DEBUG [org.teiid.COMMAND_LOG] (Worker649_QueryProcessorQueue156125) | ERROR SRC COMMAND: | endTime=2016-02-03 21:50:20.104 | requestID=oWyjQD36adh3.0 | sourceCommandID=1 | executionID=577 | txID=null | modelName=warehouse | translatorName=impala | sessionID=oWyjQD36adh3 | principal=appuser@teiid-security | finalRowCount=null |
21:50:20,104 DEBUG [org.teiid.CONNECTOR] (Worker649_QueryProcessorQueue156125) Connector worker process failed for atomic-request=oWyjQD36adh3.0.1.577
21:50:20,104 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156126) Request Thread oWyjQD36adh3.0 with state PROCESSING
21:50:20,105 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156126) QueryProcessor: closing processor
21:50:20,105 DEBUG [org.teiid.CONNECTOR] (Worker648_QueryProcessorQueue156126) oWyjQD36adh3.0.1.577 Processing CANCEL request
21:50:20,105 DEBUG [org.teiid.CONNECTOR] (Worker648_QueryProcessorQueue156126) oWyjQD36adh3.0.1.577 Remove State
21:50:20,105 DEBUG [org.teiid.CONNECTOR] (Worker648_QueryProcessorQueue156126) oWyjQD36adh3.0.1.577 Processing Close : SELECT SUM(v_0.c_8), SUM(v_0.c_9), v_0.c_1, v_0.c_7, v_0.c_3, v_0.c_4, v_0.c_0, v_0.c_6, v_0.c_5, v_0.c_2 FROM (SELECT g_1.date_key AS c_0, g_1.month_year_name AS c_1, g_1.year_month AS c_2, g_0.publisher_key AS c_3, g_0.publisher_name AS c_4, g_3.orderid AS c_5, g_3.u1 AS c_6, CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END AS c_7, g_3.num_items AS c_8, g_3.pub_comm_base AS c_9 FROM warehouse.dim_publisher AS g_0 INNER JOIN (warehouse.dim_date AS g_1 INNER JOIN (warehouse.dim_network AS g_2 INNER JOIN warehouse.fact_transaction_consumer_trans_date_detail AS g_3 ON g_2.network_key = convert(g_3.network_key, long)) ON g_1.date_key = g_3.process_date_key) ON g_0.publisher_key = g_3.publisher_key WHERE (g_0.publisher_key <> -1) AND (g_1.date_key >= '2015-12-01') AND (g_1.date_key <= '2016-12-31') AND (g_2.network_name = 'US Network') AND (g_3.advertiser_key = 2291) AND (CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END <> 'Unmeasured') AND (g_3.process_date_key >= '2015-12-01') AND (g_3.process_date_key <= '2016-12-31') AND (g_3.publisher_key <> -1)) AS v_0 GROUP BY v_0.c_0, v_0.c_1, v_0.c_2, v_0.c_3, v_0.c_4, v_0.c_5, v_0.c_6, v_0.c_7
21:50:20,106 DEBUG [org.teiid.CONNECTOR] (Worker648_QueryProcessorQueue156126) oWyjQD36adh3.0.1.577 Closed execution
21:50:20,107 DEBUG [org.teiid.CONNECTOR] (Worker648_QueryProcessorQueue156126) oWyjQD36adh3.0.1.577 Closed connection
21:50:20,107 DEBUG [org.teiid.COMMAND_LOG] (Worker648_QueryProcessorQueue156126) | END SRC COMMAND: | endTime=2016-02-03 21:50:20.107 | requestID=oWyjQD36adh3.0 | sourceCommandID=1 | executionID=577 | txID=null | modelName=warehouse | translatorName=impala | sessionID=oWyjQD36adh3 | principal=appuser@teiid-security | finalRowCount=0 | cpuTime(ns)=37122973 |
21:50:20,107 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156126) Request Thread oWyjQD36adh3.0 - error occurred after cancel: org.teiid.core.TeiidProcessingException: TEIID30160 The request oWyjQD36adh3.0 has been cancelled.
| at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:344) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:271) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.0.CR1.jar:8.12.0.CR1] |
| 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] |
21:50:20,107 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156126) Removing tuplesource for the request oWyjQD36adh3.0
21:50:20,108 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156126) oWyjQD36adh3.0 Finished Processing
21:50:20,108 DEBUG [org.teiid.PROCESSOR] (Worker648_QueryProcessorQueue156126) org.teiid.core.TeiidProcessingException: TEIID30160 The request oWyjQD36adh3.0 has been cancelled. Sending error to client oWyjQD36adh3.0
21:50:20,109 INFO [org.teiid.COMMAND_LOG] (Worker648_QueryProcessorQueue156126) | END USER COMMAND: | endTime=2016-02-03 21:50:20.108 | requestID=oWyjQD36adh3.0 | txID=null | sessionID=oWyjQD36adh3 | principal=appuser@teiid-security | vdbName=Warehouse | vdbVersion=1 | finalRowCount=0 | plan=AccessNode |
+ Relational Node ID:1
+ Output Columns:
0: c1 (long)
1: c2 (bigdecimal)
2: c3 (string)
3: c4 (string)
4: c5 (long)
5: c6 (string)
6: c7 (string)
7: c8 (string)
8: c9 (string)
9: c10 (long)
+ Statistics:
0: Node Output Rows: 0
1: Node Next Batch Process Time: 0
2: Node Cumulative Next Batch Process Time: 0
3: Node Cumulative Process Time: 0
4: Node Next Batch Calls: 1
5: Node Blocks: 1
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Query:SELECT SUM(v_0.c_8), SUM(v_0.c_9), v_0.c_1, v_0.c_7, v_0.c_3, v_0.c_4, v_0.c_0, v_0.c_6, v_0.c_5, v_0.c_2 FROM (SELECT g_1.date_key AS c_0, g_1.month_year_name AS c_1, g_1.year_month AS c_2, g_0.publisher_key AS c_3, g_0.publisher_name AS c_4, g_3.orderid AS c_5, g_3.u1 AS c_6, CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END AS c_7, g_3.num_items AS c_8, g_3.pub_comm_base AS c_9 FROM warehouse.dim_publisher AS g_0 INNER JOIN (warehouse.dim_date AS g_1 INNER JOIN (warehouse.dim_network AS g_2 INNER JOIN warehouse.fact_transaction_consumer_trans_date_detail AS g_3 ON g_2.network_key = convert(g_3.network_key, long)) ON g_1.date_key = g_3.process_date_key) ON g_0.publisher_key = g_3.publisher_key WHERE (g_0.publisher_key <> -1) AND (g_1.date_key >= '2015-12-01') AND (g_1.date_key <= '2016-12-31') AND (g_2.network_name = 'US Network') AND (g_3.advertiser_key = 2291) AND (CASE WHEN g_3.sku_number IS NULL THEN 'Unmeasured' ELSE g_3.sku_number END <> 'Unmeasured') AND (g_3.process_date_key >= '2015-12-01') AND (g_3.process_date_key <= '2016-12-31') AND (g_3.publisher_key <> -1)) AS v_0 GROUP BY v_0.c_0, v_0.c_1, v_0.c_2, v_0.c_3, v_0.c_4, v_0.c_5, v_0.c_6, v_0.c_7
+ Model Name:warehouse