I have 1. Hive 2. Pig 3. Zookeeper 4.HDFS 5. Hue 6. Oozie 7. Sqoop 8. Yarn 9. Sentry Currently, all of these are deployed on the same host. Now, I would like to add more hosts to it. But I have a few doubts: In production, 1. a node means a server, right? No VM'S ? 2. How many servers I would need to add to have a healthy cluster 3. Which of the above mentioned services should be co-located? 4. What should be the distribution like? Pig is relatively used less but sqoop, Hive , Oozie and Hue most of the times and ofcourse Sentry for authorization part. What should be the distribution like? Which of these services should be moved to new hosts?Which of these should be co located? Which of these should have entirely dedicated server to them? I am new to it and would appreciate if you could give the specifications to establishing a multi-node cluster . ... View more

I installed and configured sentry for hive. However, I keep getting : No databases are available.Permissions could be missing in hive editor. I have createdrole and permission for the user that I used to login into the hue but it does not help at all. Why is it?What could be the reason ? All I see is server1 and nothing else   I tried using user hue that belongs to default group in hue. Also, created a user 'hive' and a group 'hive' and assigned it to the group, created a role but yet nothing ... View more

I have around 15 queries saved in a saved file in hive editor that is integrated in hue. The queries include CREATE TABLE/DROP TABLE and SELECT statement at the end of the file. It seems like I can not execute all of these in one go.   How do I syntactically format or write hive queries so that hive can understand that we have the next query starting after end of one query .It should then finally give results of the select query. ... View more