You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » [resolved] How to do the bulk insert operation with vectorwise db? Thanks.
Post a reply
Topic review (newest first)
- PETER_LG
- 2012-05-23 08:24:08
Hi Pedro,
Appreciate your help, thanks.
Best Regards,
Peter.
- pedro
- 2012-05-23 08:07:17
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
- PETER_LG
- 2012-05-23 07:51:34
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.
- pedro
- 2012-05-23 07:22:46
Hi Peter
This is an error related to the differences between Vectorwise and Ingres.
You might find solution from Vectorwise support.
Regards,
Pedro
- PETER_LG
- 2012-05-23 07:06:50
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.
- pedro
- 2012-05-23 07:01:37
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
- PETER_LG
- 2012-05-23 06:02:35
E_US15B9 MODIFY: 's_csn_ps_nc_comm_cmpv_vw_bulkpoc' is a VectorWise table.
Statement is unsupported.
(Wed May 23 11:06:33 2012)
Thanks.
- pedro
- 2012-05-23 05:29:39
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
- PETER_LG
- 2012-05-23 04:47:55
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.
[statistics] connecting to socket on port 3495
[statistics] 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 sgvectdevdb1::edw_s 0<C:\DOCUME~1\peter_li\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 s_csn_ps_nc_comm_cmpv_vw_bulkpoc TO TRUNCATED;
COPY TABLE "s_csn_ps_nc_comm_cmpv_vw_bulkpoc" (
ID=char(0)comma WITH NULL ('[NULL]') ,
COMPANY=char(0)comma WITH NULL ('[NULL]') ,
EFFDT=char(0)comma WITH NULL ('[NULL]') ,
EFF_STATUS=char(0)comma WITH NULL ('[NULL]') ,
DESCR=char(0)comma WITH NULL ('[NULL]') ,
DESCRSHORT=char(0)comma WITH NULL ('[NULL]') ,
LEGAL_TYPE=char(0)comma WITH NULL ('[NULL]') ,
RUN_PERIOD=char(0)comma WITH NULL ('[NULL]') ,
RUN_DATE=char(0)comma WITH NULL ('[NULL]') ,
src=char(0)nl)
FROM
'C:/Talend/TOS_DI-Win32-r78327-V5.0.2/workspace/ps_nc_comm_cmv_vw_bulkpoc.csv'
WITH
ROLLBACK=ENABLED,
ON_ERROR=TERMINATE,
ERROR_COUNT=1;
COMMIT
Executing . . .
E_US15B9 MODIFY: 's_csn_ps_nc_comm_cmpv_vw_bulkpoc' 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
[statistics] disconnected
Job BULKPOCEXEC ended at 11:06 23/05/2012. [exit code=0]