[jira] [Created] (DRILL-6605) Query does not return any rows

["Robert Hou (JIRA)" <ji...@apache.org>]

Robert Hou created DRILL-6605:
---------------------------------

             Summary: 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
    Affects Versions: 1.13.0
            Reporter: Robert Hou
            Assignee: Pritesh Maker
             Fix For: 1.15.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)