[jira] [Commented] (DRILL-1092) 'IN' operator causing problems when used with order by on a hive table backed by avro data

["Weiwei Hsieh (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-1092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14051731#comment-14051731 ] 

Weiwei Hsieh commented on DRILL-1092:
-------------------------------------

Hi,

I will take a vacation from June 3rd until July 2nd.    If you need assistance while I’m away, please contact my manager Paul Mansfield.   

Thanks!  

weiwei   




> '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
>          Components: Execution - Operators, Storage - Hive
>            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)