New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Error reading Parquet file #13261
Comments
There is a Stack Overflow thread for this problem: Problem: Presto is reading data based on the column indices instead of the column names. Solution: Add |
Thanks @babrar but it still fails:
I can load the file with parquet tools and Python. Not sure why Presto cannot read it. |
Seems like the same issue as before. |
I have made the change and restarted Presto. It is visible in the live session:
|
We figured out with @maugly24. The problem is that Presto cannot read from a table where the table create field order does not match the Parquet field order.
It does not matter what is the value hive.parquet_use_column_names, unless I am missing something. Does this value need to be set on all nodes or only on the coordinator node? |
@babrar and I have set this one up on all nodes, worker and coordinator. |
So the setting has to be set on all node I guess. |
Query:
Output:
Same query runs with Hive or Athena perfectly.
Table create:
Parquet schema:
Version:
The text was updated successfully, but these errors were encountered: