[GitHub] [hudi] creactiviti edited a comment on issue #1670: Error opening Hive split: Unknown converted type TIMESTAMP_MICROS

[GitBox <gi...@apache.org>]

creactiviti edited a comment on issue #1670:
URL: https://github.com/apache/hudi/issues/1670#issuecomment-635504343


   And as far as querying the parquet table using Presto I first created the table in Hive like so:
   
   ```
   create external table orders_parquet (
     order_id                int,
     order_qty               int,
     updated_at              bigint,
     created_at              bigint,
     op                      string,
     customer_name           string
   )
   stored as parquet location 's3://my-test-bucket/output.parquet/';
   ```
   
   And when I tried to query with Presto I got:
   
   ```
   presto:default> select * from orders_parquet;
   
   Query 20200528_175631_00007_uptfd, FAILED, 2 nodes
   Splits: 17 total, 0 done (0.00%)
   0:00 [0 rows, 0B] [0 rows/s, 0B/s]
   
   Query 20200528_175631_00007_uptfd failed: The column updated_at is declared as type bigint, but the Parquet file declares the column as type INT96
   ```
   
   So I guess I just need to avoid the TIMESTAMP type then?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org