HiveQL: Using query results as variables

by

Hive substitutes variables as is and does not execute them. Use shell wrapper script to get result into variable and pass it to your Hive script. 

maximo=$(hive -e "set hive.cli.print.header=false; select max(var) from table;")
hive -hiveconf "maximo"="$maximo" -f your_hive_script.hql

And after this inside your script you can use select '${hiveconf:maximo}'

More Related Contents:

  1. How to get variable name?
  2. What’s the difference between placing “mut” before a variable name and after the “:”?
  3. Hive: Best way to do incremetal updates on a main table
  4. When should an Excel VBA variable be killed or set to Nothing?
  5. How to set variables in HIVE scripts
  6. HIVE select count(*) non null returns higher value than select count(*)
  7. Why are variables “i” and “j” used for counters?
  8. Which variable size to use (db, dw, dd) with x86 assembly?
  9. When should I quote CMake variables?
  10. How do I output the results of a HiveQL query to CSV?
  11. setq and defvar in Lisp
  12. What is the difference between a member variable and a local variable?
  13. Is it possible to create a multi-line string variable in a Makefile
  14. Determine variable names dynamically according to a string in Fortran
  15. Why there are two ways of declaring variables in Go, what’s the difference and which to use?
  16. Hive Explode / Lateral View multiple arrays
  17. In MATLAB, are variables REALLY double-precision by default?
  18. Comparing IEEE floats and doubles for equality
  19. Multiple variable assignment in Swift
  20. Why are variables “i” and “j” used for counters?
  21. Find last day of a month in Hive
  22. Dynamic Variable Naming and Reference (ColdFusion)
  23. Windows Batch files: what is variable expansion, and what does EnableDelayedExpansion mean?
  24. gnuplot store one number from data file into variable
  25. What is the order of local variables on the stack?
  26. What is “_,” (underscore comma) in a Go declaration?
  27. Set fact with dynamic key name in ansible
  28. Declaring global variable with php.ini
  29. Why does Go allow compilation of unused function parameters?
  30. Finding out reason of Pyomo model infeasibility

Leave a Comment