You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Jice <bi...@free.fr> on 2017/04/14 09:38:13 UTC
Bad schema: Nullable key columns are not supported: ARCREF_DCO
Fragment
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
Re: Bad schema: Nullable key columns are not supported: ARCREF_DCO Fragment
Posted by Abhishek Girish <ag...@apache.org>.
Refer to
http://mail-archives.apache.org/mod_mbox/drill-user/201704.mbox/%3CCANxXE_LLrYqm140R-hZ%3DO6O5-%3DiUOT9AfPCbGcK24dGwazPcuQ%40mail.gmail.com%3E
If you find out more, please share on the list, so we could have it
documented.
On Fri, Apr 14, 2017 at 2:38 AM, Jice <bi...@free.fr> wrote:
> 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
>