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.
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.
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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot