Forum

Discussions specific to version 8.1
Multiple Poster
Offline
User avatar
Posts: 8
Joined: Wed Jan 14, 2015 3:59 pm

Export/import between Version7 to version8

by dinesh4321 » Thu Apr 02, 2015 3:05 pm

Hi,

We need to move some table data from version-7 machine to version-8 machine .

As Version-7 is compatible only with WXEXPORT/WXIMPORT,
Shall we use WXEXPORT in version-7 to extract the data in .wcb format and use WXLOADER to import the data to Version-8 machine?
Or we should use only WXIMPORT to load the data in version-8 machine as we extracted the data using WXEXPORT.
Will there be any issue, if we use WXLOADER ?

I know WXLOADER is much faster than WXIMPORT.
Need clarification for compatibility between V7 and V8 machines when we use these approachs.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Export/import between Version7 to version8

by markc » Thu Apr 02, 2015 4:17 pm

You can use wxloader to load WCB files exported by 7.2.1. As an example, I created a table, test, with 100 bytes of user data per row.

1) export using a DSN with SslEnabled=N took 1m55s

root hp-rack1-enc6-2:/opt/kognitio/wx2 # wxexport -s localhost sys -d -t -f WCB /data2/test.wcb test
Kognitio WX2 Data Export Tool v7.02.01-rel130501
(c)Copyright Kognitio Ltd 1992-2013.

Connected to localhost, user sys, exporting from test to /data2/test.wcb
00:01:55 Bytes read: 2780538796
Completed
Bytes read: 2780538796
Time taken: 00:01:55

2) import with 7.2.1 took 2m46s

root hp-rack1-enc6-2:/opt/kognitio/wx2 # wximport -s localhost sys -d -t -f WCB /data2/test.wcb test2
Kognitio WX2 Data Import Tool v7.02.01-rel130501
(c)Copyright Kognitio Ltd 1992-2013.

Connected to localhost, user sys, importing to test2 from /data2/test.wcb
00:02:46 2780538796 bytes 25739264 records 100%
Updating statistics now (use -ns flag to avoid this)
Completed
Bytes read: 2780538796
Records read: 25739264
Time taken: 00:02:46

3) import with 8.1.0 took 2m49s

root hp-rack1-enc6-2:/opt/kognitio/wx2 # wximport -s localhost sys -d -t -f WCB /data2/test.wcb test3
Kognitio WX2 Data Import Tool v8.01.00-rel150313
(c)Copyright Kognitio Ltd 1992-2015.

Connected to localhost, user sys, importing to test3 from /data2/test.wcb
00:02:49 2780538796 bytes 25739264 records 100%
Updating statistics now (use -ns flag to avoid this)
Completed
Bytes read: 2780538796
Records read: 25739264
Time taken: 00:02:49

4) wxloader with 8.1.0 took 51s

root hp-rack1-enc6-2:/opt/kognitio/wx2 # wxloader -s localhost -u sys --show-timings -t test4 -w /data2/test.wcb
Kognitio WX2 Data Loading Tool v8.01.00-rel150313
(c)Copyright Kognitio Ltd 2010-2015.

Connected to localhost as user sys
Loading into test4 from /data2/test.wcb

25739264 records read 00:00:51 2.59G 51.6MB/s 99%

2779840512 bytes read
25739264 records imported

Time taken: 51.35s
Average speed: 51.6MB/s

Load completed successfully.
root hp-rack1-enc6-2:/opt/kognitio/wx2 #
Reply with quote Top
Multiple Poster
Offline
User avatar
Posts: 8
Joined: Wed Jan 14, 2015 3:59 pm

Re: Export/import between Version7 to version8

by dinesh4321 » Wed Apr 08, 2015 10:58 am

Thanks mark.
So helpful.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron