Cloudera Community
SK1
user rank
Guru

hive jdbc in zeppelin throwing permission error to...

by Guru in Community Articles
‎11-22-2017 02:23 PM
‎11-22-2017 02:23 PM
When users run hive query in zeppelin via jdbc interperator then it is going to some anonymous user not an actual user. INFO [2017-11-02 03:18:20,405] ({pool-2-thread-2} RemoteInterpreter.java[pushAngularObjectRegistryToRemote]:546) – Push local angular object registry from ZeppelinServer to remote interpreter group 2CNQZ1ES5:shared_process WARN [2017-11-02 03:18:21,825] ({pool-2-thread-2} NotebookServer.java[afterStatusChange]:2058) – Job 20171031-075630_2029577092 is finished, status: ERROR, exception: null, result: %text org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException Unable to fetch table ushi_gl. org.apache.hadoop.security.AccessControlException: Permission denied: user=anonymous, access=EXECUTE, inode=”/apps/hive/warehouse/adodb.db/ushi_gl”:hive:hdfs:drwxr-x— at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:319) at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkTraverse(FSPermissionChecker.java:259) at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:205) at org.apache.ranger.authorization.hadoop.RangerHdfsAuthorizer$RangerAccessControlEnforcer.checkDefaultEnforcer(RangerHdfsAuthorizer.java:381) at org.apache.ranger.authorization.hadoop.RangerHdfsAuthorizer$RangerAccessControlEnforcer.checkPermission(RangerHdfsAuthorizer.java:338) at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:190) at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1955) at org.apache.hadoop.hdfs.server.namenode.FSDirStatAndListingOp.getFileInfo(FSDirStatAndListingOp.java:109) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getFileInfo(FSNamesystem.java:4111) at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getFileInfo(NameNodeRpcServer.java:1137) at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getFileInfo(ClientNamenodeProtocolServerSideTranslatorPB.java:854) RootCause: It is bug in zeppelin 0.7.0.2 and is going to fix in newer version of zeppelin. Resolution: Add your username and password in credential option in zeppelin. ... View more

Re: in HDP 2.6.1 ambari metrics store data in hbas...

by Guru in Support Questions
‎11-08-2017 12:25 PM
‎11-08-2017 12:25 PM
Thanks a lot @Jay Kumar SenSharma ... View more

Re: Can someone explain with example difference be...

by Super Collaborator Super Collaborator in Support Questions
‎10-23-2017 12:16 PM
‎10-23-2017 12:16 PM
You can configure a machine to be a Knox edge node by installing Knox on it and blocking access to the rest of the nodes in your cluster via firewall rules. The only part of your cluster that will be accessible externally (by end users) is the Knox port on the edge node(s) you setup. Knox will first authenticate the user, and after successful authentication forward the user's request to the appropriate node in the cluster for processing. ... View more

Re: show create table view_name not showing comple...

by Guru in Support Questions
‎10-30-2017 12:13 PM
‎10-30-2017 12:13 PM
@Saurabh It happens sometimes because of limitation of no of lines displayed in CLI. try this --> hive -e "show create table sample_db.i0001_ivo_hdr;" > ddl.txt ... View more

Re: delete user REST API in ranger 0.7 is not dele...

by Guru in Support Questions
‎09-23-2017 03:45 AM
‎09-23-2017 03:45 AM
thanks @vperiasamy. I used forceDelete=true and its deleted user from ranger. curl -u admin:admin -v -i -s -X DELETE -H "Content-Type: application/json" http://m1.hdp22:6080/service/xusers/users/416?forceDelete=true ... View more

Re: do we have this functionality https://hadoop.a...

by Guru Guru in Support Questions
‎09-02-2017 12:41 PM
‎09-02-2017 12:41 PM
@Saurabh This is the jar : /usr/hdp/current/hadoop-mapreduce-client/hadoop-rumen.jar ... View more

Re: select * from table is not returning any rows ...

by Guru in Support Questions
‎09-01-2017 06:26 AM
‎09-01-2017 06:26 AM
I have resolved it by setting up following property: SET mapred.input.dir.recursive=true; Root Cause: Actually we ran insert overwrite which replaced all part files to same name dir and created files under those dirs. And as we are aware mr execution does not search recursively and thats why it was not returning any result in case of mr execution engine. [s0998dnz@m1.hdp22 ~]$ hadoop fs -ls hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/ Found 50 items drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:08 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000000_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:08 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000001_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:08 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000002_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:08 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000003_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:09 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000004_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:09 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000005_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:09 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000006_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:09 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000007_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:10 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000008_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:10 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000009_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:10 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000010_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:10 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000011_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:11 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000012_0 drwxr-x--- - dmcraig hdfs 0 2017-08-23 12:11 hdfs://m1.hdp22:8020/apps/hive/warehouse/test_db.db/table1/000013_0 ... View more

Re: can we change transactional'='false' from tran...

by New Contributor in Support Questions
‎11-03-2017 07:16 PM
‎11-03-2017 07:16 PM
According to the documentation the Hive table property "transactional" cannot be set to 'false' once you set it to 'true'. https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-TableProperties The solution I found is to re-create the table without that property. Before re-creating the table be aware that "DROP TABLE <table_name>" will erase both Hive metadata and HDFS data, so you have to back up your data first. ... View more

Re: Do we have tag carry forward in atlas hdp2.6.1...

by Expert Contributor Expert Contributor in Support Questions
‎09-13-2017 05:47 PM
‎09-13-2017 05:47 PM
@Laura Ngo, this is work in progress and we will be adding functionality to restrict certain tags from propagation using relationships. For more information on relationships: ATLAS-1690 ... View more

Re: Upgrade window does not have OK or Finished bu...

by Guru in Support Questions
‎05-13-2017 06:54 AM
‎05-13-2017 06:54 AM
Thanks @Jay SenSharma ... View more
Contact Me
Online
Offline
Last Visited
‎01-15-2021 02:12 AM
Community Statistics
Member Since ‎05-29-2017 06:13 AM
Last Visited ‎01-15-2021 02:12 AM
Posts 408
Kudos received 123