https://community.cloudera.com/t5/Support-Questions/Best-practice-architecture-and-naming-hdfs-path-names-hive/m-p/58358#M49794 <P>Could you please refer the below link , will give you some insight in<BR />creating the HDFS directory structure (best practices)<BR /><BR /><A href="https://www.quora.com/What-is-the-best-directory-structure-to-store-different-types-of-logs-in-HDFS-over-the-time/answer/Eric-Sammer" target="_blank">https://www.quora.com/What-is-the-best-directory-structure-to-store-different-types-of-logs-in-HDFS-over-the-time/answer/Eric-Sammer</A></P><P>&nbsp;</P><P>Also it is always recommended to have odd numbers when you configure Mater nodes. As you will be using HA &nbsp;/ Zookeeper . &nbsp;More of like 3 Master .&nbsp;</P><P>&nbsp;</P><P>You can create database in Hive and create tables underneath as you do in Oracle ,Create / Give permission to the schema Owner. You dont need a seperate Hive Metastore. You can also configure a Shared Metastore where Both Hive / Impala can use em.&nbsp;</P><P>&nbsp;</P> Wed, 02 Aug 2017 16:03:25 GMT csguna 2017-08-02T16:03:25Z