commands_beeline.txt

[root@pvillard ~]# su test
[test@pvillard root]$ beeline
Beeline version 1.2.1000.2.5.3.0-37 by Apache Hive
beeline> !connect jdbc:hive2://pvillard:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Connecting to jdbc:hive2://pvillard:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Enter username for jdbc:hive2://pvillard:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: test
Enter password for jdbc:hive2://pvillard:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: ********
Connected to: Apache Hive (version 1.2.1000.2.5.3.0-37)
Driver: Hive JDBC (version 1.2.1000.2.5.3.0-37)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://pvillard> show tables;
+-----------+--+
| tab_name  |
+-----------+--+
| student   |
+-----------+--+
1 row selected (0.199 seconds)
0: jdbc:hive2://pvillard> select * from student;
+---------------+--+
| student.name  |
+---------------+--+
+---------------+--+
No rows selected (0.599 seconds)
0: jdbc:hive2://pvillard> insert into table student values ('test');
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [test] does not have [SELECT] privilege on [default/values__tmp__table__1/tmp_values_col1] (state=42000,code=40000)
0: jdbc:hive2://pvillard>