Vertica insertions

naresh_way2

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.

sKwa

Hi!

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

• node-vertica - Pure javascript Vertica database client. Except it is written in CoffeeScript.
• npm:vertica
• FYI: Node.js with Vertica

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.