Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
1.1.0
-
None
-
Two Virtual Machine (Vmware) with Oracle Linux 7.4.
Columnstore Architecture: Multiserver (Two P.M. and two U.M.) with nfs.
Description
Hi,
I've two table of type Columnstore and i've tried to use cpimport for move all data from c6_messaggio_out_2 to c6_messaggio_out but with two tables columnstore there is an error:
[root@dwh-cstore01 ~]# mcsmysql -q -e 'select * from c6_messaggio_out_2;' -N c6msg | cpimport -n1 -m1 c6msg c6_messaggio_out -s '\t' -f STDIN
2017-10-25 06:48:38 (35279) INFO : Reading input from STDIN to import into table c6msg.c6_messaggio_out...
2017-10-25 06:48:38 (35279) INFO : Running distributed import (mode 1) on all PMs...
ERROR 1815 (HY000) at line 1: Internal error: IDB-2039: Data file does not exist, please contact your system administrator for more information.
2017-10-25 06:49:49 (35279) INFO : For table c6msg.c6_messaggio_out: 5824512 rows processed and 5824512 rows inserted.
2017-10-25 06:49:49 (35279) INFO : Bulk load completed, total run time : 71.3008 seconds
This method with one table Innodb and one table Columnstore it works perfectly.
Best Regards.
Nicola Battista