Skip to main content

Vertica insertions

  • Feb 6, 2018 1:27 PM UTC
  • 1 reply
  • 8 views
naresh_way2
Forum|alt.badge.img+1

Hi,
I want to insert column wise insertions in vertica via nodejs. Is there any way please let me know.
(or)
this query performs column wise insertion in vertica which is
=> insert into bulk (id) select id from another_table limit 10000;commit;

it performs well.
Now I want to form this query in nodejs to perform column wise bulk insertion.
I want to know the in which format vertica select query returns the data.Please explain me.
Thank in advance.

    1 reply

    sKwa
    Forum|alt.badge.img+1
    • sKwa
    • Participating Frequently
    • Feb 6, 2018 5:51 PM UTC

    Hi!

    I want to insert column wise insertions in vertica via nodejs.

    I want to know the in which format vertica select query returns the data.

    What do you mean? Depends on driver/client, probably as Array or dictionary. Check it by yourself.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement