[jira] [Created] (IMPALA-10042) ERROR: File has an invalid version number: This could be due to stale metadata. Try running "refresh ".

["kishorekumar kuruguntla (Jira)" <ji...@apache.org>]

kishorekumar kuruguntla created IMPALA-10042:
------------------------------------------------

             Summary: ERROR: File has an invalid version number:  This could be due to stale metadata. Try running "refresh <Table_name>".
                 Key: IMPALA-10042
                 URL: https://issues.apache.org/jira/browse/IMPALA-10042
             Project: IMPALA
          Issue Type: Bug
          Components: Backend, Catalog
    Affects Versions: Impala 3.2.0
            Reporter: kishorekumar kuruguntla
         Attachments: image-2020-08-03-10-31-37-405.png

Hi,

I am performing etl and loading Parquet table in Hive .

Ran invalidate metadata <db_name.table_name> in impala.

While trying to run "compute stats <db_name.table_name>" or running "Select count(*) from <db_name.table_name>" ,getting File has Invalid  Version Number.

*Full Error :*

ERROR: File '<full_hdfs_path>' has an invalid version number: <Random_number>
This could be due to stale metadata. Try running "refresh <db_name.table_name>".

 

!image-2020-08-03-10-31-37-405.png!

 

I ran tried running "refresh <db_name.table_name>"  multiple times ,still  "Select count(*)" or "Compute stats " not working.

 

I am able to run "Select count(*) from <db_name.table_name> " in hive beeline successfully ,but in impala it is not working.

 

Seems like this issue is fixed in https://issues.apache.org/jira/browse/IMPALA-2477  in impala 2.3.0 . 

 But still we are facing this issue in *version 3.2.0-cdh6.2.1*

 

 



--
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