---

layout: page title: “Hive Interpreter” description: "" group: manual

{% include JB/setup %}

Hive Interpreter for Apache Zeppelin

Configuration

This interpreter provides multiple configuration with ${prefix}. User can set a multiple connection properties by this prefix. It can be used like %hive(${prefix}).

How to use

Basically, you can use

%hive
select * from my_table;

or

%hive(etl)
-- 'etl' is a ${prefix}
select * from my_table;

You can also run multiple queries up to 10 by default. Changing these settings is not implemented yet.

Apply Zeppelin Dynamic Forms

You can leverage Zeppelin Dynamic Form inside your queries. You can use both the text input and select form parameterization features

%hive
SELECT ${group_by}, count(*) as count 
FROM retail_demo.order_lineitems_pxf 
GROUP BY ${group_by=product_id,product_id|product_name|customer_id|store_id} 
ORDER BY count ${order=DESC,DESC|ASC} 
LIMIT ${limit=10};