I created hive tables on top of tpch parquet data. (Attached the hive ddl script). Since hive does not support date in parquet serde, I regenerated the parquet files for orders and lineitem to use string for the date fields. Remaining files do not have a date column.
When I executed query 10 in the tpch suite, it failed with a system error.
I tried running the above query using dfs instead of hive and it worked as expected.
I attached the newly generated parquet files and the hive ddl for creating hive tables. Let me know if you need anything