@John Smith See this https://community.hortonworks.com/articles/10788/hortonworks-sandbox-setup.html ... View more

Hi @Kuldeep Kulkarni Good question because we don't want user to run hive cli as part of the best practice. One of the things that I suggest is not to install hive client in edge node. I found this thread and I believe this can be done to avoid the hive cli access. ... View more

@niraj nagle Look into the option to create hdfs user in ambari as it will make your life easier. ... View more

@niraj nagle You missed dfs in your Chmod command ... View more

@niraj nagle You have to create the directory. You can use FS view to do that. Create a local user in ambari called hdfs and use hdfs to login to ambari then using FS view you can create /user/admin and change ownership or Follow as @bsaini suggested ... View more

@Ancil McBarnett The tricky part is spof in case san goes down. ... View more

@Ancil McBarnett Yes to 3 environment Dev and Qa does not need to as big as prod. DR is required too and we can use DR for reporting ... View more

@Mehdi TAZI You want low latency and very fast response time. HBASE is the way to go for near realtime. You can build your own UI. Tableau and HBASE - Follow this https://community.tableau.com/thread/146368 1 - what are the most used architectures in order to achieve my goal? Source to destination... You can use Storm or spark streaming. Kafka to Storm to HBASE 2 - does it make sense to use a MPP database as a datamart (loading data according to the business fields from hadoop to mpp)? Yes if there is an option 3 - can a nosql database like cassandra replace an mpp database? If yes, is it better? HBASE is good solution. ... View more