You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2016/01/28 01:53:39 UTC
[jira] [Created] (DRILL-4318) Drill hangs with a malformed Tpcds
query
Rahul Challapalli created DRILL-4318:
----------------------------------------
Summary: Drill hangs with a malformed Tpcds query
Key: DRILL-4318
URL: https://issues.apache.org/jira/browse/DRILL-4318
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.5.0
Reporter: Rahul Challapalli
git.commit.id.abbrev=3d0b4b0
The below query causes never completes. The query is malformed as the columns in subquery are im-properly qualified.
{code}
SELECT i.i_manufact_id,
Sum(ss.ss_ext_sales_price) total_sales
FROM store_sales ss,
date_dim dd,
customer_address ca,
item i
WHERE i.i_manufact_id IN (SELECT i.i_manufact_id
FROM item
WHERE i.i_category IN ( 'Books' ))
AND ss.ss_item_sk = i.i_item_sk
AND ss.ss_sold_date_sk = dd.d_date_sk
AND dd.d_year = 1999
AND dd.d_moy = 3
AND ss.ss_addr_sk = ca.ca_address.ss_sk
AND ca.ca_gmt_offset = -5
GROUP BY i.i_manufact_id
{code}
Below is the information from the logs
{code}
2016-01-28 00:45:17,997 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.drill.exec.work.foreman.Foreman - Query text for query id 29569b62-73b4-f270-98db-7eedf1803895: SELECT i.i_manufact_id,
Sum(ss.ss_ext_sales_price) total_sales
FROM store_sales ss,
date_dim dd,
customer_address ca,
item i
WHERE i.i_manufact_id IN (SELECT i.i_manufact_id
FROM item
WHERE i.i_category IN ( 'Books' ))
AND ss.ss_item_sk = i.i_item_sk
AND ss.ss_sold_date_sk = dd.d_date_sk
AND dd.d_year = 1999
AND dd.d_moy = 3
AND ss.ss_addr_sk = ca.ca_address.ss_sk
AND ca.ca_gmt_offset = -5
GROUP BY i.i_manufact_id
2016-01-28 00:45:18,616 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Took 0 ms to get file statuses
2016-01-28 00:45:18,720 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 1 out of 1 using 1 threads. Time: 101ms total, 101.682269ms avg, 101ms max.
2016-01-28 00:45:18,721 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 1 out of 1 using 1 threads. Earliest start: 11.148000 μs, Latest start: 11.148000 μs, Average start: 11.148000 μs .
2016-01-28 00:45:18,721 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Took 104 ms to read file metadata
2016-01-28 00:45:18,909 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Took 0 ms to get file statuses
2016-01-28 00:45:18,936 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 2 out of 2 using 2 threads. Time: 25ms total, 21.543874ms avg, 24ms max.
2016-01-28 00:45:18,937 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 2 out of 2 using 2 threads. Earliest start: 1205.628000 μs, Latest start: 1455.366000 μs, Average start: 1330.497000 μs .
2016-01-28 00:45:18,937 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Took 27 ms to read file metadata
2016-01-28 00:45:18,943 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Took 0 ms to get file statuses
2016-01-28 00:45:18,954 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 1 out of 1 using 1 threads. Time: 10ms total, 10.416335ms avg, 10ms max.
2016-01-28 00:45:18,954 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 1 out of 1 using 1 threads. Earliest start: 1.002000 μs, Latest start: 1.002000 μs, Average start: 1.002000 μs .
2016-01-28 00:45:18,954 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Took 11 ms to read file metadata
2016-01-28 00:45:18,960 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Took 0 ms to get file statuses
2016-01-28 00:45:18,980 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 1 out of 1 using 1 threads. Time: 20ms total, 20.511432ms avg, 20ms max.
2016-01-28 00:45:18,981 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 1 out of 1 using 1 threads. Earliest start: 0.944000 μs, Latest start: 0.944000 μs, Average start: 0.944000 μs .
2016-01-28 00:45:18,981 [29569b62-73b4-f270-98db-7eedf1803895:foreman] INFO o.a.d.exec.store.parquet.Metadata - Took 20 ms to read file metadata
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)