Reply
Explorer
Posts: 11
Registered: ‎05-01-2014

Error: Unexpected dictionary page.

I am trying to run a simple query against an External Impala table with Parquet files.  When submitting the statement 'select sum(avgval) from test; I receive the following error: 'Backend 0:Unexpected dictionary page. Dictionary page is only  supported for string types.'  The avgval field is defined as int.  

 

Any ideas why this is happening and how to fix it?

Cloudera Employee
Posts: 27
Registered: ‎09-27-2013

Re: Error: Unexpected dictionary page.

What version of Impala are you running? That error message no longer exists.

Highlighted
Explorer
Posts: 11
Registered: ‎05-01-2014

Re: Error: Unexpected dictionary page.

1.1

Cloudera Employee
Posts: 27
Registered: ‎09-27-2013

Re: Error: Unexpected dictionary page.

Please upgrade to the latest version. You've using a version that does not support the entire parquet file format spec.

 

Out of curiosity, what did you use to generate the parquet files? I suspect it is newer writer.

Explorer
Posts: 11
Registered: ‎05-01-2014

Re: Error: Unexpected dictionary page.

I used the Kite SDK to generate the Parquet files.  I'll try updating the version.  Thanks.