Vertica to Parquet

 dbadmin=> EXPORT TO PARQUET(directory = '/home/dbadmin/parquet') AS SELECT * from public.inventory_fact;

dbadmin=> \! ls parquet

1f9bb7b6-v_partner11db_node0001-140068793460480-0.parquet  339c587d-v_partner11db_node0001-140068810245888-0.parquet

dbadmin=> CREATE EXTERNAL TABLE inv (detail ROW(date_key int, product_key int, product_version int, warehouse_key int, qty_in_stock int)) as copy from '/home/dbadmin/parquet/1f9bb7b6-v_partner11db_node0001-140068793460480-0.parquet' PARQUET;

CREATE TABLE

dbadmin=> select * from inv;

Comments

Popular posts from this blog