Vertica Folder Management on DB creation
--force-cleanup-on-failure removes existing directories when create_db fails. --force-removal-at-creation removes existing directories before attempting to create the database.
Posts
Vertica to Parquet
- Get link
- Other Apps
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;