[HIVE-1096] Hive Variables

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Edward Capriolo
• Reporter: Edward Capriolo
• Created: 25/Jan/10 18:57
• Updated: 17/Dec/11 00:00
• Resolved: 08/Dec/10 23:27

Description

From mailing list:
-Amazon Elastic MapReduce version of Hive seems to have a nice feature called "Variables." Basically you can define a variable via command-line while invoking hive with -d DT=2009-12-09 and then refer to the variable via ${DT} within the hive queries. This could be extremely useful. I can't seem to find this feature even on trunk. Is this feature currently anywhere in the roadmap?-

This could be implemented in many places.
A simple place to put this is
in Driver.compile or Driver.run we can do string substitutions at that level, and further downstream need not be effected.

There could be some benefits to doing this further downstream, parser,plan. but based on the simple needs we may not need to overthink this.

I will get started on implementing in compile unless someone wants to discuss this more.

Issue Links

• is duplicated by: HIVE-1604 Patch to allow variables in Hive
• relates to: HIVE-1063 Variable interpolation for testcase qfiles
• relates to: HIVE-2020 Create a separate namespace for Hive variables
• relates to: HIVE-2021 Add a configuration property that sets the variable substitution max depth
• supercedes: HIVE-1063 Variable interpolation for testcase qfiles