(c)You could also read the raw hive logs which is usually located at /tmp/ user_name/hive.log Logs can be emitted to the bash prompt while running hive by setting to INFO,console. (b) You could also try reading the logs as follows. Mysql > SET GLOBAL binlog_format = 'ROW' Login to your mysql console as root $ mysql -uroot (a) If you get a bin log error saying statement format is not support. Mysql> REVOKE ALTER,CREATE ON metastore.* FROM Further troubleshooting : Revoke few permissions on the mysql metastore $ mysql Hive> create table temp_table temp_col string Ĩ. Add/Edit the following lines in your hive-site.xml $ cd /usr/local/Cellar/hive/ /libexec/conf Note :Please replace with respective hadoop and hbase version downloaded using brew. Mysql> GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE ON metastore.* TO Copy the hive-default-xml template as hive-site.xml Mysql> CREATE USER IDENTIFIED BY 'password' Please go to this link and download the mysql-connector-java file directly $ curl -L '' | tar xzĬopy the jar to your hive lib folder $ sudo cp mysql-connector-java-5.1.15/mysql-connector-java-5.1.22-bin.jar /usr/local/Cellar/hive/ /libexec/lib/ Note :The version might change over time. Save and compile your bash_profile source ~/.bash_profile Now add the following lines to bash_profileĮxport HADOOP_HOME=/usr/local/Cellar/hadoop/Įxport HIVE_HOME=/usr/local/Cellar/hive//libexec If you do have one already then, just add the lines to your existing file vim ~/.bash_profile Note : If you do not have a bash_profile, do not worry just follow the steps below and it will create a new file for you. Add hadoop and hive to your path by editing your bash_profile This will take some time $ brew install hiveĢ. You should have brew which can be installed by : ruby -e "$(curl -fsSkL /mxcl/homebrew/go)ġ. Check my previous post on Hadoop install for help.Ģ. You should have already installed Hadoop. I have till date not found a simple way to install Hive with MySql and not derby as its metastore in Mac, so I decided to brainstorm and figure it out myself.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |