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

java.io.IOException: While processing file s3://test/abc/request_dt=2021-07-28/someParquetFile. [XYZ] BINARY is not in the store

New Contributor

Hi Team,

 

I am facing an issue "java.io.IOException: While processing file s3://test/abc/request_dt=2021-07-28/someParquetFile. [XYZ] BINARY is not in the store"

 

The things i did before getting the above exception:

 

1. Alter table tableName1 add columns(xyz string);

2. ALTER TABLE tableName1 RECOVER PARTITIONS; -- Recovered the new partitioned equest_dt=2021-07-28

3. INSERT OVERWRITE TABLE tableName2

PARTITION (request_dt)
SELECT old_column_names, XYZ from tableName1

 

And hence the the third command causes the Exception

 

Any suggestions would be of great help.

 

Thanks in Advance!!!

0 REPLIES 0