authur wang created IMPALA-9258:
-----------------------------------
Summary: 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
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]
