With a root install, there are some additional steps to run cpimport as a

non root user with mode 1. The simplest is to setuid root the cpimport

process:

sudo chmod +s /usr/local/mariadb/columnstore/bin/cpimport

or you can broaden the privileges of each pm data directory, for example:

cd /usr/local/mariadb/columnstore

chmod 777 -R data1

The reason it works in mode 2 is because the cpimport invocation is actually

triggering a local cpimport process invocation on each pm which is launched

as root.