[
https://issues.apache.org/jira/browse/IMPALA-9258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16999334#comment-16999334
]
Tim Armstrong commented on IMPALA-9258:
---------------------------------------
I think it's probably a bug in beeline or the hive JDBC driver - Impala
definitely will always return a row for count(*). Do you know what versions of
those you're using.
It would also be useful to have:
* The logs from the impala server you're connected to might also be useful
since they'll have information about progress of the query.
* The impala query profile (you can get this from the impala debug UI after you
run it).
> 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]
