[ 
https://issues.apache.org/jira/browse/IMPALA-10042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kishorekumar kuruguntla updated IMPALA-10042:
---------------------------------------------
    Description: 
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!

 

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*

 

 

  was:
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*

 

 


> 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
>            Priority: Major
>         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!
>  
> 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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to