Hi,

I'm trying to use Drill with Kudu.
I installed both in docker containers and connect to drill's web interface.
I can select datas from csv files but when I try to create a kudu table
from a csv file, i get an error message :

org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
MasterErrorException: Server[Kudu Master - 172.17.0.2:7051]
INVALID_ARGUMENT[code 4]: Bad schema: Nullable key columns are not
supported: ARCREF_DCO Fragment 0:0 [Error Id:
8eda4fd0-67fc-4296-85da-f62e3274b3dc on 72f9db9510f8:31010]

The query was
create table kudu.`activite` (ARCREF_DCO, DCOREF_ACT, LIGNUM_ACT) as
select columns[0] as ARCREF_DCO, columns[1] as DCOREF_ACT, columns[2] as
LIGNUM_ACT from dfs.`/home/Data/TEST.csv`

and the csv file :
ARCREF_DCO,DCOREF_ACT,LIGNUM_ACT
1600474715002578904,1600501351747171447,3
1600474715002579102,1600501351747171455,1
1600474715002579004,1600501351747171452,1

I can't see anything in the documentation to create table columns with
not null option...

Does anyone have a clue ?
Thanks

Reply via email to