[jira] [Updated] (DRILL-6605) TPCDS-84 Query does not return any rows

["Kunal Khatua (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-6605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kunal Khatua updated DRILL-6605:
--------------------------------
    Summary: TPCDS-84 Query does not return any rows  (was: Query does not return any rows)

> TPCDS-84 Query does not return any rows
> ---------------------------------------
>
>                 Key: DRILL-6605
>                 URL: https://issues.apache.org/jira/browse/DRILL-6605
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Relational Operators
>            Reporter: Robert Hou
>            Assignee: Arina Ielchiieva
>            Priority: Blocker
>             Fix For: 1.14.0
>
>
> Query is:
> Advanced/tpcds/tpcds_sf100/hive/parquet/query84.sql
> This uses the hive parquet reader.
> SELECT c_customer_id   AS customer_id,
> c_last_name
> \|\| ', '
> \|\| c_first_name AS customername
> FROM   customer,
> customer_address,
> customer_demographics,
> household_demographics,
> income_band,
> store_returns
> WHERE  ca_city = 'Green Acres'
> AND c_current_addr_sk = ca_address_sk
> AND ib_lower_bound >= 54986
> AND ib_upper_bound <= 54986 + 50000
> AND ib_income_band_sk = hd_income_band_sk
> AND cd_demo_sk = c_current_cdemo_sk
> AND hd_demo_sk = c_current_hdemo_sk
> AND sr_cdemo_sk = cd_demo_sk
> ORDER  BY c_customer_id
> LIMIT 100
> This query should return 100 rows
> commit id is:
> 1.14.0-SNAPSHOT	a77fd142d86dd5648cda8866b8ff3af39c7b6b11	DRILL-6516: EMIT support in streaming agg	11.07.2018 @ 18:40:03 PDT	Unknown	12.07.2018 @ 01:50:37 PDT



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)