Hive - Variable Substitution

About

Language - Variable substitution in Hive.

substitution can be used in Hive commands or queries.

Type

Type Substitution
Configuration variable ${hiveconf:var}
Hive - Variable (hivevar) ${var}
System ${system:var}
Env ${env:var}

Configuration

conf Hive - Configuration (Variable)

--default
set hive.variable.substitute=true; 
-- or
set hive.variable.substitute=false;

Example

Conf Variable

Example

set hive.exec.scratchdir;
+-------------------------------------------------+--+
|                       set                       |
+-------------------------------------------------+--+
| hive.exec.scratchdir=hdfs://mycluster/tmp/hive  |
+-------------------------------------------------+--+
  • Within a query and with substitution
 select '${hiveconf:hive.exec.scratchdir}';
+------+
| hdfs://mycluster/tmp/hive |
+------+
| hdfs://mycluster/tmp/hive |
+------+
1 row selected (0.517 seconds)

hivevar

Example with SQL - SQLLine (SQL at the command line) and a URL

sqlline -u "jdbc:hive2://HiveServer/db;#foo=bar" 
  • Select with substituion
select '${foo}';
+-----+
| bar |
+-----+
| bar |
+-----+
1 row selected (0.368 seconds)

Documentation / Reference


Powered by ComboStrap