[jira] [Resolved] (IMPALA-9258) impala and hive query result are different

["Tim Armstrong (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-9258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Armstrong resolved IMPALA-9258.
-----------------------------------
    Resolution: Cannot Reproduce

> impala and hive query result are different 
> -------------------------------------------
>
>                 Key: IMPALA-9258
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9258
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Clients
>    Affects Versions: Impala 3.2.0
>         Environment: CDH6.2.1
>            Reporter: authur wang
>            Priority: Major
>         Attachments: user_inf.zip
>
>
> After we use mapreduce to generate rcfiles, we find that the results between hive and impala are different. The hive query will generate the right result while impala will get wrong result.
>  
> the attachment is the data files.
>  
> the ddl of the table is :
> CREATE EXTERNAL TABLE user_inf (
>  id BIGINT,
>  user_id STRING,
>  cert_id STRING,
>  name STRING,
>  mobile STRING,
>  access_id STRING,
>  status STRING,
>  channel STRING,
>  rec_crt_ts STRING,
>  rec_upd_ts STRING,
>  ver INT
>  )
>  STORED AS RCFILE
>  LOCATION '/user_inf'



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org