Forum

General discussion on using the Kognitio Analytical Platform.
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

How can I efficiently copy a table between Kognitio systems?

by markc » Wed Feb 12, 2014 12:17 pm

I want to transfer a table from a production system to a test one.

I know I could export it from the AP on the production system, then transfer the resulting file to the AP on the test system, then use import to load it, but is there an easier way?

In particular, is there a way which just transfers the data between the systems without requiring intermediate storage? I don't want to have one or more large staging areas just to facilitate these data transfers.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: How can I efficiently copy a table between Kognitio syst

by markc » Wed Feb 12, 2014 12:25 pm

What you want to do here is run an export to unload the data, then pipe the resulting information into an import to load it to the second system. That will work with all software versions using a command like this (note this is using keyed authentication, so no password details are supplied to the export or import tool):

wxexport -s prod sys -f WCB -n - SYS.MILLION | wximport -n -s test sys -t -iw -f WCB -d - SYS.MILLIONCOPY
Kognitio WX2 Data Import Tool v8.01.00-rel140121
(c)Copyright Kognitio Ltd 1992-2014.

Initialising...
Connected to test, user sys, importing to SYS.MILLIONCOPY from -
Completed
Bytes read: 16004132
Records read: 1000000
Time taken: 00:00:04

Note that with versions of the software that support wxloader and wxunloader, those tools should be used rather than wximport/wxexport. Also, with later versions, using external table connectivity might be a better way forward - see the version 8 release notes and full documentation for details.
Reply with quote Top

Who is online

Users browsing this forum: Majestic-12 [Bot] and 1 guest

cron