How Do I Connect to a Kudu Foreign Table When Ranger Is Enabled in Impala 4.3.0?

Question

After Ranger authentication is enabled, an error is reported when the following statement is used to create a foreign table:

CREATE TABLE db.table (id INT, dt TIMESTAMP, PRIMARY KEY(id))
PARTITION BY HASH PARTITIONS 16
STORED AS KUDU
TBLPROPERTIES (
'kudu.master_addresses' = 'master1:7051,master2:7051,master3:7051'
);

The following error is reported.

Click to enlarge

CREATE TABLE db.table STORED AS KUDU
TBLPROPERTIES (
'kudu.table_name' = 'impala::db.table',
'kudu.master_addresses' = 'master1:7051,master2:7051,master3:7051'
);

The following error is reported.

Click to enlarge

Answer

When Ranger authentication is enabled in the current Impala version, Kudu foreign tables cannot be created.

If the current cluster does not have the Kudu service, add --kudu_master_hosts=master1:7051,master2:7051,master3:7051 to the custom configuration of Impalad.

If the current MRS cluster has the Kudu service, you do not need to add this configuration. The default value of --kudu_master_hosts is the address of the KuduMaster in the current cluster.

Create a Kudu inner table.

CREATE TABLE db.table (id INT, dt TIMESTAMP, PRIMARY KEY(id))

PARTITION BY HASH PARTITIONS 16

STORED AS KUDU

Click to enlarge