Skip to main content

Copy data inside Vertica

Mike_Gong_1
Forum|alt.badge.img+1
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

    2 replies

    Navin_C
    Forum|alt.badge.img+2
    • Navin_C
    • Participating Frequently
    • July 30, 2013
    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.
    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • July 30, 2013
    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
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement