Run Hive Queries - Execute HiveQL with CLI | Online Free DevTools by Hexmos
Execute Hive queries efficiently with HiveQL CLI. Analyze big data, perform ETL operations, and manage data warehouses seamlessly. Free online tool, no registration required.
hive
CLI tool for Apache Hive. More information: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli.
- Start a Hive interactive shell:
hive
- Run HiveQL:
hive -e "{{hiveql_query}}"
- Run a HiveQL file with a variable substitution:
hive {{[-d|--define]}} {{key}}={{value}} -f {{path/to/file.sql}}
- Run a HiveQL with HiveConfig (e.g.
mapred.reduce.tasks=32):
hive --hiveconf {{conf_name}}={{conf_value}}
