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

["authur wang (Jira)" <ji...@apache.org>]

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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org