You need to install Multiple MySQL version. You have knowledge – but need to upgrade MySQL version.You are new in MacOS – need to install MySQL.Note : If your need match one of following criteria you can read the article, if not then, you can skip the article to save your time. Install MySQL in MacOS with Brew | Run Multiple MySQL Version with Separate Database Magento eCommerce Website Development, Website Development Using Php and HTML and Cross-Platform application development using Appcelerator. What you’ll get from it: This course provides hands-on Hadoop with MapReduce, HDFS, Spark, Flink, Hive, HBase, MongoDB, Cassandra, Kafka, etc.Shuvankar Paul Follow Software Engineer, Strativ AB Time taken: 0.248 seconds, Fetched: 2 row(s) Schematool -initSchema -dbType mysql Start Metastore serviceĮnter the hive command directly in the terminal hive> show databases Hdfs://localhost:9000/user/hive/warehouseĬd /usr/local/Cellar/hive/3.1.2_3/libexec/bin Jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true Users/apache-hive-3.1.2-bin/log/hive.log Please note this file does not exist and needs to be created manually. Unzip -> Place the jar “mysql-connector-java-8.0.19.jar” into the /usr/local/Cellar/hive/3.1.2_3/libexec/lib directoryĬreate a file named “hive-site.xml” in the following locations /usr/local/Cellar/hive/3.1.2_3/libexec/conf directory.Select Platform Independent -> Download to your machine.Modify user permissions: $ GRANT ALL PRIVILEGES ON *.* to Refresh privileges: FLUSH PRIVILEGES.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |