08-28-2017 08:14 AM
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-
Result: impalad version 2.9.0-cdh5.12.0 RELEASE (build 03c6ddbdcec39238be4f5b14a300d5c4f576097e) Built on Thu Jun 29 04:17:31 PDT 2017
CREATE TABLE my_table
col1 BIGINT PRIMARY KEY,
) PARTITION BY HASH(col1) PARTITIONS 1 */ I have only 2 tablets/*
STORED AS KUDU;
ImpalaRuntimeException: Error creating Kudu table 'impala::impala_kudu.my_table' CAUSED BY: NonRecoverableException: must have at least two hash buckets
Solved! Go to Solution.
08-28-2017 09:15 AM
"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