[
https://issues.apache.org/jira/browse/IMPALA-9258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16998386#comment-16998386
]
Tim Armstrong commented on IMPALA-9258:
---------------------------------------
[~wangyx] can you please include an example of results returned by Impala vs
the results you expected?
> 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
> Labels: newbie
> 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: [email protected]
For additional commands, e-mail: [email protected]
