Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement