E-MapReduce:Integrate Impala with Kudu

On the Impala service's Configure page, add the following configuration items. For more information, see Manage configuration items.

1. On the Impala service's Configure page, click the impalad.flgs tab.

2. On the impalad.flgs tab, click Add Configuration Item. Add a parameter named kudu_master_hosts with a value of master-1-1:7051.

   Note

   kudu_master_hosts specifies the master nodes and port numbers of the Kudu cluster that Impala connects to. If there are multiple master nodes, you can separate them with a comma (,). For example, master-1-1:7051,master-1-2:7051,master-1-3:7051.

3. On the catalogd.flgs tab, click Add Configuration Item. Add a parameter named kudu_master_hosts with a value of master-1-1:7051.

Optional: Log in to the cluster to verify the integration.

1. Connect to Impala. For more information, see Impala shell tool.

2. Run the following command to create a table:

   create table my_first_table
   (
     id bigint,
     name string,
     primary key(id)
   )
   partition by hash partitions 16
   stored as kudu
   tblproperties(
     'kudu.num_tablet_replicas' = '1');

   The message Table has been created. indicates that the table was created successfully.

Connect to Impala. For more information, see Impala shell tool.

Run the following command to create a table.

create table my_first_table
(
   id bigint,
   name string,
   primary key(id)
)
partition by hash partitions 16
stored as kudu
tblproperties(
 'kudu.master_addresses' = 'master-1-1:7051',
 'kudu.num_tablet_replicas' = '1');

Optional: Run the following command to insert data into the table:

insert into my_first_table values(1,"ss");

Optional: Run the following command to query data from the table:

select * from my_first_table;

+----+------+
| id | name |
+----+------+
| 1  | ss   |
+----+------+