[
https://issues.apache.org/jira/browse/DRILL-1092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rahul Challapalli updated DRILL-1092:
-------------------------------------
Attachment: plan_success.txt
plan_failure.txt
When we get rid of the IN operator, the query successfully returns the data
select seqno from hive.trade order by seqno;
I also attached the submit plans for the query with and without the 'IN'
operator. Let me know if more information is needed.
> 'IN' operator causing problems when used with order by on a hive table backed
> by avro data
> ------------------------------------------------------------------------------------------
>
> Key: DRILL-1092
> URL: https://issues.apache.org/jira/browse/DRILL-1092
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Rahul Challapalli
> Priority: Blocker
> Attachments: error.log, plan_failure.txt, plan_success.txt, trade
> (3).ddl
>
>
> git.commit.id.abbrev=a1a6144
> build# 26266
> the below query fails to execute and the details of the error are present in
> the attached log file. The hive table is backed by avro data. The hive ddl
> used is also attached.
> select seqno from hive.trade where symbol in ('TZA', 'INDL') order by seqno;
> Tested the same query on a different data set using parquet and it has no
> issues
> select adRevenue from uservisits where countryCode in ('NLD', 'FRA') order by
> adRevenue;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
