Configuring a Cloudera Data Warehouse-Kudu connection

kudu_master_hosts=kudu-master1.sandbox.a.cloudera.site:7051,kudu-master2.sandbox.a.cloudera.site:7051,kudu-master3.sandbox.a.cloudera.site:7051

Existing Virtual Warehouse:

• Click Add Custom Configurations, set kudu_master_hosts to the FQDN of a single master host as shown follows:
  • Configuration Key: kudu_master_hosts
  • Configuration Value: host1:7051
• Select flagfile from the Configuration files drop-down list, and add the FQDNs of other Kudu master hosts to the value of kudu_master_hosts.

When the Virtual Warehouse finishes updating, you can query Kudu tables from Hue, an Impala shell, or an ODBC/JDBC client. For example:

--- First, create an example table
CREATE TABLE my_first_kudu_table
(
  id BIGINT,
  name STRING,
  PRIMARY KEY(id)
)
PARTITION BY HASH PARTITIONS 16
STORED AS KUDU;

--- Next, insert some example data
INSERT INTO my_first_kudu_table VALUES (101,'A'),(102,'B'),(103,'C');

--- Finally, select from the example table to show the above has worked
SELECT * FROM my_first_kudu_table;