These entries could also go in a ~/.hiverc file.
Configuration Property | Notes |
---|---|
set hive.cli.print.header=true; | Shows column names at top of query results |
set hive.cli.print.current.db=true; | Shows the current database in the command prompt |
Limiting HS2 Concurrent Connections
load data local inpath '/home/user1/test.txt' into table my_table;
Connecting via Beeline
/usr/hdp/current/hive/bin/beeline
!connect jdbc:hive2://$hive.server.full.hostname:10000 $HIVE_USER password org.apache.hive.jdbc.HiveDriver
beeline -u jdbc:hive2://$HIVE_SERVER_FQDN:10000 -n $HIVE_USER
!q