Run Hive Script File Passing Parameter and Working Example

  • Post author:
  • Post last modified:February 27, 2018
  • Post category:BigData
  • Reading time:2 mins read

Hive is used for batch and interactive SQL queries. Variable Substitution allows for tasks such as separating environment-specific configuration variables from code. The variable substitution is very important when you are calling the HQL scripts from shell or Python. You can pass the values to query that you are calling.

Run Hive Script File Passing Parameter

In this article, we will see how to run Hive script file passing parameter to it. We also see the working examples.

Run Hive Script File Passing Parameter

You can use the set and use that variable within the script. Below is the sample syntax that you can use to run Hive script file passing parameter.

For example:

$ hive --hiveconf var=value -e 'set var; set hiveconf:var;
 select * from table where col = ${hiveconf:var}'

Above statement will set the dept variable to 100.

Run Hive Script File Passing Parameter Example

Below is the working example to run Hive script file passing parameter:

$ hive --hiveconf dept=100 -e 'set dept; set hiveconf:dept;
 select * from test where dep_id = ${hiveconf:dept}'

Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties
dept=100
hiveconf:dept=100
OK
1 abc 100
Time taken: 7.872 seconds, Fetched: 1 row(s)

You can use the any scripting program to dynamically pass the parameter to the hive HQL script.

Read:

Tags: ,