Spark shell cannot access products table in database retail_db

#1

i don’t have access permssions to products table

var hiveResult = hc.sql(“select d.department_id, p.product_id, p.product_name, p.product_price, rank() over (partition by d.department_id order by p.product_price) as product_price_rank, dense_rank() over (partition by d.department_id order by p.product_price) as product_dense_price_rank from products p inner join categories c on c.category_id = p.product_category_id inner join departments d on c.category_department_id = d.department_id order by d.department_id, product_price_rank desc, product_dense_price_rank “);
org.apache.hadoop.hive.ql.metadata.HiveException: Unable to fetch table products. org.apache.hadoop.security.AccessControlException: Permission denied: user=daveslaf7, access=EXECUTE, inode=”/user/parulshine92/retail_db/products”:parulshine92: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(ClientNamenodeProto

0 Likes