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
Post a Comment