Database Reference
In-Depth Information
In both interactive and noninteractive mode, Hive will print information to standard error
— such as the time taken to run a query — during the course of operation. You can sup-
press these messages using the
-S
option at launch time, which has the effect of showing
only the output result for queries:
%
hive -S -e 'SELECT * FROM dummy'
X
Other useful Hive shell features include the ability to run commands on the host operating
system by using a
!
prefix to the command and the ability to access Hadoop filesystems
using the
dfs
command.