How big is your access database? and why are you trying to migrate? It sounds like you will be better served my moving to MySql - here are the steps to migrate from access to mysql - https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-export.html If you want to explore Bigadata, then you can perhaps move to Hive using Sqoop.. but can't really recommend with certainty without knowing the size or use cases. ... View more

Have you explored json serde - https://github.com/rcongiu/Hive-JSON-Serde ?? I would write a utility script that will convert your dataset to json (inclusive of serNo, Country, cities, date) and then load them into hive using json serde For more details on Hive Serde, refer to https://cwiki.apache.org/confluence/display/Hive/DeveloperGuide#DeveloperGuide-HiveSerDe ... View more

Thanks to @nate cole and @David Schorow curl call that returns a response: http://localhost:8080/api/v1/clusters/c1/services/ZOOKEEPER/components/ZOOKEEPER_CLIENT?format=client_config_tar ... View more

Because this is the question that I get asked most often times from enterprise customers in the field, here is the answer: Ranger currently supports resource based and tag based policies for Hive (HDFS files, HBase, etc...), where you can specify a column to be un-authorized for a specific user or user group. This will fail the query by that user/group altogether. However, there is a work in progress to make queries involving the un-authorized columns to simply mask (redact) the data instead of failing altogether. Here is the jira number https://hortonworks.jira.com/browse/RMP-3705 ... View more

Only Atlas 0.5 is packaged into HDP 2.4. If you want to manually upgrade, you have to first remove the component from Ambari, and then manage atlas by yourself. ... View more