Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

has an Invalid parquet version number:017

avatar
New Contributor

Hi Team,

 

We are running some Hive, and Impala queries and getting the below error for the job. 
It was running fine earlier, but now it's failing. 

RamuAnnamalai_0-1662929677561.png

We tried multiple ways, like re-created the tables and then tested with the REFRESH command for the table. 
Whenever the job executes then automatically permission is changed with the user. It was like impala: hive
Could you please suggest how we can w take it forward? 
Note: We recently upgraded the cluster to CDP.

2 REPLIES 2

avatar
Master Collaborator

@RamuAnnamalai It looks similar to https://issues.apache.org/jira/browse/IMPALA-10042

Please check what's the value of "Maximum Cached File Handles" under Impala Configuration in CM UI? Set that to Zero(0) and see if the issue still reappears. 

 

How do you write to the table? Is there a chance, the data is getting corrupted during the insert? 

avatar
Cloudera Employee

May i know if the table was created from the data that was exported in some other format like 'txt' format or something ? if this is true then, starting from CDP 7.x versions, the default file format is parquet. So, when the table is imported, it will be created in parquet format, but its original files will in 'txt' format.