Support Questions
Find answers, ask questions, and share your expertise

How to fix Parquet schema: optional int64 amount [i:10 d:1 r:0]?

Explorer

I have a table and when I am trying to query it through imapala it throws me this error:

File 'hdfs:/path/table/1_data.0.parq' has an incompatible Parquet schema for column 'db.table.parameter_11'. Column type: STRING, Parquet schema: optional int64 amount [i:10 d:1 r:0] 

But when I query it through hive it returns results correctly. How can I fix it?

0 REPLIES 0
; ;