Converting Hive CLI scripts to Beeline
If you have legacy scripts that run Hive queries from edge nodes using the Hive CLI, you must solve potential incompatibilities with variable substitution in these scripts. CDP supports Beeline instead of Hive CLI. You can use Beeline to run legacy scripts with a few caveats.
In this task, you resolve incompatibilities in legacy Hive CLI scripts and Beeline:
- Configuration variables
- Problem: You cannot refer to configuration parameters in scripts using
the
hiveconf
namespace unless allowed. - Solution: You include the parameter in the HiveServer allowlist (whitelist).
- Problem: You cannot refer to configuration parameters in scripts using
the
- Namespace problems
- Problem: Beeline does not support the
system
andenv
namespaces for variables. - Solution: You remove these namespace references from scripts using a conversion technique described in this task.
- Problem: Beeline does not support the