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)