How to do the bulk insert operation with vectorwise db? Thanks.

One Star

How to do the bulk insert operation with vectorwise db? Thanks.

Hi All,

Now, I need to do the bulk insert (load) data into to vectorwise db, I tried to use the Ingres drive and its bulk components, but failed, any experts can help me? Please help, thanks.
Talend version: 5.0.2
Regards,
Peter.

============Below is the information:
Starting job BULKPOCEXEC at 11:06 23/05/2012.
connecting to socket on port 3495
connected
C:\Talend\TOS_DI-Win32-r78327-V5.0.2>set II_TM_ON_ERROR=NOCONTINUE
C:\Talend\TOS_DI-Win32-r78327-V5.0.2>set II_TM_SWITCH=true
C:\Talend\TOS_DI-Win32-r78327-V5.0.2>sql xxx::xxxx0<C:\DOCUME~1\xxx\LOCALS~1\Temp\ingres_sql_20120523110631.sql
INGRES TERMINAL MONITOR Copyright 2010 Ingres Corporation
Ingres Microsoft Windows Version II 10.0.0 (int.w32/132) login
Wed May 23 11:06:33 2012
Enter \g to execute commands, "help help\g" for help, \q to quit
continue
* * * go
* * *
SET AUTOCOMMIT OFF
Executing . . .
continue
* * *
SET NOJOURNALING
Executing . . .
continue
* * *
SET SESSION AUTHORIZATION CURRENT_USER
Executing . . .
continue
* * * * * * * * * * * * * * * * * * * * * * *
MODIFY xxx TO TRUNCATED;
COPY TABLE "xxxx" (
xxx=char(0)comma WITH NULL ('') ,
...
xxx=char(0)nl)
FROM
'C:/Talend/TOS_DI-Win32-r78327-V5.0.2/workspace/xxx.csv'
WITH
ROLLBACK=ENABLED,
ON_ERROR=TERMINATE,
ERROR_COUNT=1;
COMMIT
Executing . . .
E_US15B9 MODIFY: 'xxx' is a VectorWise table.
Statement is unsupported.
(Wed May 23 11:06:33 2012)
continue
* * *
ROLLBACK
Executing . . .
continue
* *
Ingres Version II 10.0.0 (int.w32/132) logout
Wed May 23 11:06:33 2012
1859 milliseconds
disconnected
Job BULKPOCEXEC ended at 11:06 23/05/2012.
One Star

Re: How to do the bulk insert operation with vectorwise db? Thanks.

Hi Peter
tIngresOutputBulkExec: Writes data to an output file and efficiently loads it to database using Ingres COPY TABLE command.
Please show us the error log.
Regards,
Pedro
One Star

Re: How to do the bulk insert operation with vectorwise db? Thanks.

E_US15B9 MODIFY: 'xxx' is a VectorWise table.
Statement is unsupported.
(Wed May 23 11:06:33 2012)
Thanks.
One Star

Re: How to do the bulk insert operation with vectorwise db? Thanks.

Hi
This error shows that 's_csn_ps_nc_comm_cmpv_vw_bulkpoc' is a VectorWise table which is different from the standard structure of Ingres.
Two choices:
No. 1: Change this table into Ingres.
No. 2: Use tVectorWiseOutput instead.
Regards,
Pedro
One Star

Re: How to do the bulk insert operation with vectorwise db? Thanks.

Hi Pedro,
For the two choices:
No. 1: Change this table into Ingres.
No. 2: Use tVectorWiseOutput instead.

No.2 is not bulk operation, so will be slow. And for No.1, change this table into Ingres, do u mean let me use the Ingres db and not the vectorwise db?
So, does talend support the bulk operation for vectorwise db? And vectorwise support said, could use the Ingres, so sorry, it confuses me.
Thanks.
Regards,
Peter.
One Star

Re: How to do the bulk insert operation with vectorwise db? Thanks.

Hi Peter
This is an error related to the differences between Vectorwise and Ingres.
You might find solution from Vectorwise support.
Regards,
Pedro
One Star

Re: How to do the bulk insert operation with vectorwise db? Thanks.

Hi Pedro,
Ok.
So, back to my question, hope get confirmation from talend.
Does Talend support the bulk operation for vectorwise? Thanks.
Best Regards,
Peter.
One Star

Re: How to do the bulk insert operation with vectorwise db? Thanks.

Hi
It should work with tIngresOutputBulkExec.
I found a topic about E_US15B9 MODIFY issue. http://community.actian.com/forum/36357-post10.html
Hope this will help you.
Regards,
Pedro
One Star

Re: How to do the bulk insert operation with vectorwise db? Thanks.

Hi Pedro,
Appreciate your help, thanks.

Best Regards,
Peter.