topic Re: How to do the bulk insert operation with vectorwise db? Thanks. in Talend Studio

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

Anonymous — Wed, 23 May 2012 03:47:55 GMT

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.

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

Anonymous — Wed, 23 May 2012 04:29:39 GMT

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

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

Anonymous — Wed, 23 May 2012 05:02:35 GMT

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

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

Anonymous — Wed, 23 May 2012 06:01:37 GMT

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

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

Anonymous — Wed, 23 May 2012 06:06:50 GMT

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.

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

Anonymous — Wed, 23 May 2012 06:22:46 GMT

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

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

Anonymous — Wed, 23 May 2012 06:51:34 GMT

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.

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

Anonymous — Wed, 23 May 2012 07:07:17 GMT

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

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

Anonymous — Wed, 23 May 2012 07:24:08 GMT

Hi Pedro,
Appreciate your help, thanks.

Best Regards,
Peter.