Copy data inside Vertica

Hi, I'm wondering what the best way is to load data from one table to another table in the same Vertica database. I'm currently loading data from staging table to target DW table using SELECT INSERT. It seems to be very slow. Is there any faster approach or I just need to tune the database? Thanks

Comments

  • Navin_CNavin_C Vertica Customer
    Hello Mike I think you need to tune the database. Check with your target table projections, If there are many projections, this can be time consuming as the data has to be loaded into all projections. Hope this helps.
  • Hey all, Navin, thanks for the reply! I'd agree, INSERT SELECT is the fastest way to do this, time to tune this database. A specific bit of tuning: Do your staging and target tables have exactly the same projections? (Exact same sort order, segmentation, partitioning, etc.) That one detail makes a big difference -- it means INSERT SELECT already has all the data on the same node in the right format, rather than having to re-sort it and ship it around the network. Adam

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file