CREATE a new user: $ CREATE user identified by ‘password123’.$ Source /usr/local/Cellar/hive/3.1.2_3/libexec/scripts/metastore/upgrade/mysql/hive-schema-3.1.0.mysql.sql.Create a database: CREATE database metastore.After installing the Mysql follow the next steps to initialize the metadata database. # HIVE env variablesĮxport HIVE_HOME=/usr/local/Cellar/hive/3.1.2_3/libexecĮxport PATH=$PATH:/usr/local/mysql-8.0.12-macos10.13-x86_64/bin Setup Mysql databaseĭownload Mysql database by going to the following Mysql site. Install Hive with below command $ brew install hive Setup Hive & Mysql Environment VariablesĮnter vim ~/.bash_profile in the terminal to configure the hive path statement in the blank line. Setup Mysql / Derby database: Hive need this database (called Metastore) to store the Hive metadata.Setup Hive & Mysql Environment Variables.

Please follow the steps to perform the installation. HDFS (Hadoop) setup : This step is need to completed first place before Hive installation.The installation of Hadoop is divided into these steps: In this article, I will take you through how to Install Hive on Mac with Homebrew using Terminal. This is a mechanism that can store, query, and analyze large-scale data stored in Hadoop. Hive is a data warehouse tool based on Hadoop for data extraction, transformation, and loading.

Download derby database for mac