Hive command line

Hive command line


Hive command line example? Execute the specified SQL statement from the command line
? $ Hive_home/bin/hive-e 'select A. Col from tab1'
? Run the specified SQL statement with the specified hive environment variable
? $ Hive_home/bin/hive-e 'select A. Col from tab1 a'-hiveconf hive.exe C. scratchdir =/home/My/hive_scratch-hiveconf mapred. Reduce. Tasks = 32
? Run the specified SQL statement in silent mode and export the execution result to the specified file hive_home/bin/hive-e 'select A. Col from tab1 a'> a.txt.
? Execute SQL files in non-interactive mode
? Hive_home/bin/hive-f/home/My/hive-script. SQL
? Run the initialization SQL file before entering the interactive mode.
? Hive_home/bin/hive-I/home/My/hive-init. SQL