@Riaz Lala Okay, I have got two options for you that you can try: Option#11) Using xpath builtin function: You might have to do some data transformations to your input file to break down the book nodes to individual records. My input data looks like below: <catalog><book><id>11</id><genre>Computer</genre><price>44</price></book></catalog> <catalog><book><id>45</id><genre>Fantasy</genre><price>5</price></book></catalog> hive> select * from books_xml; OK <catalog><book><id>11</id><genre>Computer</genre><price>44</price></book></catalog> <catalog><book><id>45</id><genre>Fantasy</genre><price>5</price></book></catalog> Time taken: 0.483 seconds, Fetched: 2 row(s) Then you can use xpath function like below to access individual columns: hive> select xpath_int(xmldata, '/catalog/book/id'), xpath_string(xmldata, '/catalog/book/genre') as genre, xpath_int(xmldata, '/catalog/book/price') from books_xml; OK 11 Computer 44 45 Fantasy 5 Time taken: 0.508 seconds, Fetched: 2 row(s) You can do insert overwrite to load into any other external table you want with regular column names Option#2) Use of external UDF function that parses the xml data into an array and use explode function to select the indivudual values and load them to any target table you have. Let me know if this helps ... View more

@Roland Simonis The below documentation has explanation on how to manage permissions they the Ranger --> Settings -->Permissions https://cwiki.apache.org/confluence/display/RANGER/Apache+Ranger+0.5+-+User+Guide#ApacheRanger0.5-UserGuide-PermissionsModule I would say this is a different level of access related grouping from the Ranger operations perspective. To answer your questions: - What does each level of Permissions mean in detail? Permissions tab option allows any user with Admin privileges to control the level of Ranger Admin UI accessibility for Ranger modules to the non-admin users. For example, You can control the Admin access in Ranger if you add/remove users from the Permissions --> Users/Groups tab Resource Based policies option will have a group of users who currently have Resource based policies. You can restrict the access to Resource based policy tab by adding/removing users. If you have Ranger admin access as admin user as well as your user(with admin access), please try logging in as your user user id and try removing yourself and you can see that you wont be able to access the Resource based policies tab after a re-login. You can always add back your access once you log in as admin user. The other options are self explanatory. Let me know if this helps. - How are Users granted permissions automatically? Is there a way to change this, e.g. to stop Ranger from granting all new users permissions on "Resource Based Policies" or "Audit"? Ideally, with User level privileges, you should not be able to see Audit tab, unless admin level access is granted to the user from another admin login. Resource based policies tab will be granted for every user by default, but the users wont be able to see other's policies and they will be able to see only those policies that were exclusively granted for the user thru user level or group level accesses. Again, if you want the users with User level permissions to be restricted to see the Resource Based policy tab at all, you can control that from the Settings --> Permissions --> Resource Based policies option. Let me know if this helps. ... View more

@AnjiReddy Anumolu Hive transactions are supported starting hive 0.13. However, the integration was completely done for ORC file format for the first release. Look below from the wiki: Only ORC file format is supported in this first release. The feature has been built such that transactions can be used by any storage format that can determine how updates or deletes apply to base records (basically, that has an explicit or implicit row id), but so far the integration work has only been done for ORC. Source: https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions ... View more