Hi, I seem to be having trouble querying orc tables using presto. I have 2 tables in my account: raw_logs and raw_logs_orc. I was testing partitioning and loaded data into both tables. Unfortunately I'm not getting any results for the following query in *presto*. It is working fine in hive however: SELECT * from raw_logs_orc; The table definition is: CREATE EXTERNAL TABLE raw_logs_orc ( message Varchar(1000) ) PARTITIONED BY ( application_id INT, year INT, month INT, day INT ) STORED AS ORC LOCATION 's3n://tera-emr/raw_logs_orc/' TBLPROPERTIES ("orc.compress"="SNAPPY") ; Am I missing something basic here? Thanks for your help.
--
You received this message because you are subscribed to the Google Groups "Qubole Public Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to qubole-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/qubole-users/56be4cb4339eb_39003ffbf3f2ef346371e%40ip-10-145-33-241.mail.
For more options, visit https://groups.google.com/d/optout.
hive.metastore-cache-ttl=0m