[
https://issues.apache.org/jira/browse/DRILL-6605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16545180#comment-16545180
]
Vitalii Diravka edited comment on DRILL-6605 at 7/16/18 1:02 PM:
-----------------------------------------------------------------
[~rhou] [~agirish] I can't get a reproduce, since a link for TPC-DS SF100 is
broken. Please check:
[https://github.com/mapr/drill-test-framework/tree/master/framework/resources/Advanced]
I get:
{code}
<Error>
<Code>NoSuchKey</Code>
<Message>The specified key does not exist.</Message>
<Key>tpcds/sf100/parquet/tpcds_sf100_parquet.tgz</Key>
<RequestId>AC2E57D76F0B1E02</RequestId>
<HostId>
Maog/V5gt5eL6sPnf+aQ7pe9rCN8lyznsRax4mS7u3jZsp82TTROdgi3w11t6rNa2KBGBxnALVc=
</HostId>
</Error>
{code}
was (Author: vitalii):
[~rhou] [~agirish] I can't get a reproduce, since a link for TPC-DS SF100 is
broken. Please check
> 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: Vitalii Diravka
> Priority: Blocker
> Fix For: 1.14.0
>
>
> Query is:
> Advanced/tpcds/tpcds_sf100/hive/parquet/query84.sql
> This uses the hive parquet reader.
> {code:sql}
> 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
> {code}
> 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)
