unable to view hive tables in beeline

unable to view hive tables in beeline

[rajarshinandy@gw03 ~]$ beeline
Beeline version 1.2.1000.2.6.5.0-292 by Apache Hive
beeline> !connect jdbc:hive2://gw02.itversity.com:10000/rajtraining_retail_db
Connecting to jdbc:hive2://gw02.itversity.com:10000/rajtraining_retail_db
Enter username for jdbc:hive2://gw02.itversity.com:10000/rajtraining_retail_db:
Enter password for jdbc:hive2://gw02.itversity.com:10000/rajtraining_retail_db:
Connected to: Apache Hive (version 1.2.1000.2.6.5.0-292)
Driver: Hive JDBC (version 1.2.1000.2.6.5.0-292)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://gw02.itversity.com:10000/rajt> !sql show tables;
Error: Error while compiling statement: FAILED: SemanticException MetaException(message:org.apache.hadoop.security.AccessControlException: Permission denied: user=anonymous, access=EXECUTE, inode="/user/rajarshinandy/warehouse
CREATE DATABASE rajtraining/rajtraining_retail_db.db":rajarshinandy:hdfs:drwx------
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:353)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkTraverse(FSPermissionChecker.java:292)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:238)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:190)
at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1950)
at org.apache.hadoop.hdfs.server.namenode.FSDirStatAndListingOp.getFileInfo(FSDirStatAndListingOp.java:108)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getFileInfo(FSNamesystem.java:4146)
at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getFileInfo(NameNodeRpcServer.java:1137)
at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getFileInfo(ClientNamenodeProtocolServerSideTranslatorPB.java:866)
at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java)
at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:640)
at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:982)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2351)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2347)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1869)
at org.apache.hadoop.ipc.Server$Handler.run(Server.java:2347)
) (state=42000,code=40000)
0: jdbc:hive2://gw02.itversity.com:10000/rajt>
➤ [Abnormal Disconnect 21 Nov 2020 at 10:49:30 am]
➤ [Connected 21 Nov 2020 at 10:49:37 am]
Last login: Fri Nov 20 18:19:57 2020 from 172.16.1.113

CentOS Linux 7 (Core)

Linux gw03.itversity.com 3.10.0-693.11.6.el7.x86_64 #1 SMP Thu Jan 4 01:06:37 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

Server : 274218
IPv4 : 149.56.31.128
IPv6 : 2607:5300:61:e80::
Hostname : gw03.itversity.com

Hi @Rajarshi_Nandy,

Please use your lab username and password to connect to hive in beeline.

1 Like

Thanks a lot for the prompt response, really appreciated. It works. I thought we need to leave the username and password as blank

1 Like