You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, I am trying to use native DWRF format using Presto 0.273.3 on Kubernetes self hosted cluster with Hive 2 Metastore and PostgreSQL as Metastore DB Backend for creating TPC-H and TPC-DS tables/data sets using native Presto connector, but I am getting error DWRF does not support date format for each table with date type, for example:
CREATETABLEIF NOT EXISTS hive.sf1.orders
WITH (format ='DWRF')
ASSELECT*FROMtpch.sf1.orders
Is there any simple workaround for this? I am interested only and explicitly in DWRF format as Prestissimo and hundred TB scale factors are taken in to future consideration.
I know that it can be hardcoded as simple cast to timestamp but I am looking for a generic solution, like for example session data type infer or casting for all date type fields. Backend storage that I use is all and any of AmazonS3, Alibaba OSS, MinIO.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi, I am trying to use native DWRF format using Presto 0.273.3 on Kubernetes self hosted cluster with Hive 2 Metastore and PostgreSQL as Metastore DB Backend for creating TPC-H and TPC-DS tables/data sets using native Presto connector, but I am getting
error DWRF does not support date format
for each table withdate
type, for example:Is there any simple workaround for this? I am interested only and explicitly in DWRF format as Prestissimo and hundred TB scale factors are taken in to future consideration.
I know that it can be hardcoded as simple cast to
timestamp
but I am looking for a generic solution, like for example session data type infer or casting for alldate
type fields. Backend storage that I use is all and any of AmazonS3, Alibaba OSS, MinIO.Beta Was this translation helpful? Give feedback.
All reactions