[ https://issues.apache.org/jira/browse/DRILL-6605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-6605: ------------------------------------ Affects Version/s: (was: 1.13.0) > 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: Pritesh Maker > 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)