Reply
New Contributor
Posts: 2
Registered: ‎08-28-2017
Accepted Solution

Error during CREATE KUDU table using IMPALA

I am getting error when creating KUDU table uing IMPALA. It is on 3 machine cluister (1 is master other two are being used as Tablets). Below is the required information- 

SELECT VERSION();

Result: impalad version 2.9.0-cdh5.12.0 RELEASE (build 03c6ddbdcec39238be4f5b14a300d5c4f576097e) Built on Thu Jun 29 04:17:31 PDT 2017

CREATE SCRIPT:

CREATE TABLE my_table
(
col1 BIGINT PRIMARY KEY,
col2 STRING,
col3 BOOLEAN
) PARTITION BY HASH(col1) PARTITIONS 1  */ I have only 2 tablets/*
STORED AS KUDU;

 

Error Message:

ImpalaRuntimeException: Error creating Kudu table 'impala::impala_kudu.my_table' CAUSED BY: NonRecoverableException: must have at least two hash buckets

Cloudera Employee J-D
Cloudera Employee
Posts: 55
Registered: ‎07-08-2013

Re: Error during CREATE KUDU table using IMPALA

"PARTITIONS 1" means that you are trying to create a table with 1 hash bucket, you need at least 2 (like the error you're getting says). This is a way to force you to think about how you want to distribute your data.

 

Only 2 tservers won't work with the default replication factor of 3, as per http://kudu.apache.org/docs/known_issues.html#_tables

Highlighted
New Contributor
Posts: 2
Registered: ‎08-28-2017

Re: Error during CREATE KUDU table using IMPALA

It worked, I just made master also as a tablet.

 

Thanks for your reply.

Announcements