About
Language - Variable substitution in Hive.
substitution can be used in Hive commands or queries.
Articles Related
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)