HIVE_BAD_DATA with Parquet BINARY

0

Hi,

I saved some Parquet files (with Spark), and some of the fields were converted to Timestamp types. That appears to be saved as INT96, or BINARY, inside Parquet.

When I declare the columns as TIMESTAMP in Amazon Athena, and then try to invoke them, I receive this error message:

HIVE_BAD_DATA: Field scheduled_content_start_time's type BINARY in parquet is incompatible with type bigint defined in table schema

However, if I try to declare the column as type BINARY, it tells be that BINARY is not supported for Parquet file format.

How can I resolve this?

Thanks,
Michael

msjg
已提问 7 年前1875 查看次数
2 回答
0

you could use string

已回答 7 年前
0

Hi,

Good day.

But can you query a string as you would a timestamp tough?

Regards
JJ

已回答 6 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则