Member since
05-16-2018
43
Posts
1
Kudos Received
0
Solutions
01-14-2019
06:19 AM
Can I add description for a hive table through Atlas
... View more
Labels:
- Labels:
-
Apache Atlas
-
Apache Hive
12-28-2018
08:11 AM
I have to user spark. But ranger policies are not getting applied on spark.
... View more
Labels:
- Labels:
-
Apache Ranger
-
Apache Spark
12-26-2018
09:44 AM
1 Kudo
I want to apply ranger policies on databases which are access thriugh spark. so apply policy on spark.
... View more
Labels:
- Labels:
-
Apache Ranger
08-16-2018
10:46 AM
@subash sharma Same question. In which ranger version dynamic masking is integrated with tag based policies.
... View more
08-16-2018
10:46 AM
@subash sharma Same question. In which ranger version dynamic masking is integrated with tag based policies.
... View more
08-16-2018
10:38 AM
I can not see two options in tag based policy i.e. Access level and Masking.
... View more
Labels:
- Labels:
-
Apache Ranger
08-10-2018
09:13 AM
Hi @Jonathan Sneep cluster is deployed through Ambari. HDP and Ambari version is 2.6.0.3 & 2. 6.1.
... View more
08-10-2018
08:23 AM
Hi all, I am facing a issue in ranger row level filter. I have add a IN query in RLF. It gives error like Query: du_id IN
(select b.cucode from tbl_pts_empentityrolemapping a
inner join tbl_pts_customerunitmaster b on a.entityid = b.cuid
inner join tbl_pts_employeemaster e on a.empid=e.employeeid and e.username = current_user()
where globalroleid IN (3,49)) INFO : Dag submit failed due to Invalid TaskLaunchCmdOpts defined for Vertex Map 4 : Invalid/conflicting GC options found, cmdOpts="-server -Djava.net.preferIPv4Stack=true -Dhdp.version=2.6.4.0-91 -XX:+PrintGCDetails -verbose:gc -XX:+PrintGCTimeStamps -XX:+UseNUMA -XX:+UseG1GC -XX:+ResizeTLAB -server -Djava.net.preferIPv4Stack=true -XX:NewRatio=8 -XX:+UseNUMA -XX:+UseParallelGC -XX:+PrintGCDetails -verbose:gc -XX:+PrintGCTimeStamps -Dlog4j.configuratorClass=org.apache.tez.common.TezLog4jConfigurator -Dlog4j.configuration=tez-container-log4j.properties -Dyarn.app.container.log.dir=<LOG_DIR> -Dtez.root.logger=INFO,CLA " stack trace: [org.apache.tez.dag.api.DAG.createDag(DAG.java:934), org.apache.tez.client.TezClientUtils.prepareAndCreateDAGPlan(TezClientUtils.java:680), org.apache.tez.client.TezClient.submitDAGSession(TezClient.java:444), org.apache.tez.client.TezClient.submitDAG(TezClient.java:411), org.apache.hadoop.hive.ql.exe
... View more
Labels:
- Labels:
-
Apache Ranger
07-26-2018
11:06 AM
Ranger policy on user working fine but on group it doesn't work.
... View more
Labels:
- Labels:
-
Apache Ranger
07-19-2018
08:26 AM
@Bhanu Pamu I am also facing the same issue. Is there any solution?
... View more
07-17-2018
05:23 AM
Hi @Vinicius Higa Murakami I have tried row number() but it gives error. This error is because of HIve version. for particular version row number is not working. Dag submit failed due to Invalid TaskLaunchCmdOpts defined for Vertex Map 1 :
... View more
07-16-2018
09:09 AM
I want to use offset and limit function in hive. Its working on SQL. Is there any other option/ cmd for offset and limit on hive.
... View more
Labels:
- Labels:
-
Apache Hive
07-11-2018
06:21 AM
@Eric Leme If I use Hive cli then I can see all Dbs. But Ranger doesn't support or doesn't work with Hive CLI. Ranger policies only work with Beeline. Is there is any requirement of Ranger that ranger should need a particular HDP version?
... View more
07-09-2018
09:33 AM
I am using 2 clusters cluster1 and cluster2. I have all the process on both. on cluster1 its working fine. But on second cluster there is issue. On second cluster Ranger and hive version is same as on cluster1 only the difference is cluster version is different.
... View more
07-09-2018
09:28 AM
@ssanthosh No the cluster is not kerberized. Is it necessary that cluster should be kerberized?
... View more
07-05-2018
10:16 AM
@ Aditya Sirna Yes I am sure that I am connecting to the right hiveserver. Still there is same issue.
... View more
07-05-2018
09:30 AM
@Sindhu Yes I have a ranger policy for hive and login user has all permissions on all databases. And I have also checked on hive cli show databases its working it gives us all databases.
... View more
07-05-2018
09:15 AM
When try to open hive through beeline it connects properly to beeline-hiveserver2, but if I use any query on that then it does not give response. for ex. if I hit query show databases then give just empty list (no database is shown). Ideally it should show the list of databases present on that cluster.
... View more
Labels:
- Labels:
-
Apache Hive
07-05-2018
04:45 AM
@geoffrey Shelton Okot I have created ranger policy as you said. I gave all access to the Anjali user. I tried to access through hive. the result is, when I hit query ' use testh3;' no error. But when I hit query ' show tables;' then there is empty list(NO tables found).
... View more
07-04-2018
12:14 PM
@Geoffrey Shelton Okot sc3.png O/P $ hdfs dfs -ls /apps/hive/warehouse
... View more
07-04-2018
11:09 AM
@Geoffrey Shelton Okot Yes I have created test databases and show databases from beeline doesn't show newly created databases also. sc11.png in this screenshot I have created test databases on hive. On hive it's working fine. sc2.png in this I have used 'show databases' query on beeline. It gave empty list. Beeline does not work. I have created DB on beeline also and again hit the query ' show databases' still it does not show any DB.
... View more
07-04-2018
09:11 AM
@Geoffrey Shelton Okot I have done this also, I have open 2 windows hive cli and beeline (beeline UN: hive, pass:hive). But I can not see any database when I used ' show databases'. Now I have disabled the plugin then it showed all databases.
... View more
07-04-2018
08:33 AM
@Gonçalo Cunha I have checked , I have given all the access for all database ,all coloum , all tables to the user still there is a same issue.
... View more
07-04-2018
05:18 AM
I am trying to connect beeline it gives me error like 'Error: Could not open client transport with JDBC Uri: jdbc:hive2://<ip>:10000: java.net.ConnectException: Connection refused (state=08S01,code=0) 0: jdbc:hive2://<ip>:10000 (closed)> '
... View more
07-04-2018
04:47 AM
I am using Ranger 0.7.0 on cluster. I have enabled the Ranger plugin and hive, hdfs plugins. When I was login to the hive through beeline to check that the policy is working or not, that time I have use the ' show databases' query and it does not show any database. There is a empty list of dbs. If I disable the plugins then all it gave the list of databases.
... View more
Labels:
- Labels:
-
Apache Ranger
07-03-2018
07:58 AM
@Sindhu I have create a policy for all DB,all tables,all columns and gave access to the user, still I can't see the DB. There is DB list but that list is from another cluster. I have login on cluster2 and it shows all the DBs from cluster1 and from cluter2.
... View more
06-22-2018
05:38 AM
I want to import Ranger policies from one cluster to another. It gives error while import the policies in ranger of another cluster. (0) Validation failure: error code[3006], reason[Another policy already exists for this name: policy-id=[1], service=[EIS_DEV_Hive]], field[policy name], subfield[null], type[semantically incorrect] (1) Validation failure: error code[3022], reason[Invalid access type: access type=[read], valid access types=[[drop, all, select, update, create, index, lock, alter]]], field[policy item access type], subfield[null], type[semantically incorrect] (2) Validation failure: error code[3022], reason[Invalid access type: access type=[write], valid access types=[[drop, all, select, update, create, index, lock, alter]]], field[policy item access type], subfield[null], type[semantically incorrect]
... View more
Labels:
- Labels:
-
Apache Ranger