Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (2)
8 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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

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.
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

Hi Pedro,
Appreciate your help, thanks.

Best Regards,
Peter.