Member since
11-30-2016
85
Posts
7
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
3218 | 03-15-2017 07:33 AM |
06-20-2017
03:45 PM
Hey @Sarath Subramanian, Thank you, can you please let me know any link from where i can get these gremlin queries.
... View more
06-20-2017
11:25 AM
this question might sound stupid, But to validate whether i am creating correct policy in ranger or not, I guess this may be mandatory. I have observed this in ranger 0.7, if we create a policy on a database which is not available in HDFS, policy gets created. Only check is on Group or User for which permission is granted. let me explain more using an example: 1. Database : random (NA in HDFS) 2. Table : random 3. Column : random 4. Group : public (valid linux group) 5. Permission : select policy will get created using these inputs, although Database, table and column are not available. So, In order to validate i would like to access hive metadata (Hive and ranger metadata available in MySQL). and check whether the policy is getting created on correct database or not. Please note that i am creating policies using rest API by feeding in an excel. this excel can be erroneous because it gets created manually. Thank you in Advance, Subash
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Ranger
06-20-2017
09:04 AM
@Ayub Khan, Agreed this can be achieved by code. In Atlas 0.6, I have seen that the length (key value pairs) of tagged entity (hive_column) are 10. Un-tagged column generally used to have 9 key value pairs. We can achieve this using a loop and the process will become time consuming. I was looking for some DSL search query or gremlin query which can give me the list of all untagged columns. I hope this defines my requirement.
... View more
06-20-2017
08:36 AM
How to get the list of all un-tagged hive column/attributes in Atlas using Rest API command Thank you, Subash
... View more
Labels:
- Labels:
-
Apache Atlas
06-13-2017
02:33 PM
Thank you @Sarath Subramanian. Right now i am using DSL for searching the tables in a schema. Let me know which one should be good in terms of performance. Gremlin or DSL.
... View more
06-12-2017
10:10 AM
1 Kudo
Hey @Sharmadha Sainath, I was not able to add comment so adding my reply here, actually i was using space instead of "=" in limit. It is working now. Thanks
... View more
06-12-2017
09:19 AM
hey @Sharmadha Sainath, How to increase the limit of tables, I am getting only 100 tables using this script. I tried using "limit" but limit is not working with 1000, It works when i am limiting the number of tables by giving values below 100.
... View more
06-12-2017
08:25 AM
Bingo, This is what i was looking for ! Thank you @Sharmadha Sainath
... View more
06-12-2017
06:31 AM
Hey @Ashutosh Mestry, I should have mentioned Atlas version as well. I am currently working on Atlas 0.7 and I guess the rest API request which you have mentioned will work on Atlas 0.8. Are there any similar rest API request available for Atlas 0.7 ? Even if i will search on hive_table orderby name , It will list down all the tables from all schema. I am searching a way to list down list of all tables of a particular schema. Thank you, Subash
... View more
06-09-2017
09:27 AM
1 Kudo
How to get the list pf all the tables available in a particular schema. This Rest API command generally gives the GUID and total count of all tables available in Atlas. http://hostname:port/api/atlas/entities?type=hive_table Can we apply some sort of filter on database or schema ? Thank you, Subash
... View more
Labels:
- Labels:
-
Apache Atlas