How to insert a byte[] into a binary field in vertica
Posted: Mon Sep 30, 2013 12:29 pm
My requirement is to export data in sqlserver to vertica.
Iam able to export the data using COPY from LOCAL command.
Steps which i followed is as follows
1. Get the data from table in .net datareader object
2. loop through the reader object and will create a csv file
3. export the csv file using COPY from LOCAL command.
All these works fine.
My issue is that my one of my column from the table is timestamp and in the reader object iam getting as byte[] and i want to insert this byte[] into a binary field in corresponding table in vertica.
how can i do this ?
Thanks in advance
Sushanth.B
Iam able to export the data using COPY from LOCAL command.
Steps which i followed is as follows
1. Get the data from table in .net datareader object
2. loop through the reader object and will create a csv file
3. export the csv file using COPY from LOCAL command.
All these works fine.
My issue is that my one of my column from the table is timestamp and in the reader object iam getting as byte[] and i want to insert this byte[] into a binary field in corresponding table in vertica.
how can i do this ?
Thanks in advance
Sushanth.B