Install Setup For Hive On Mac Brew

пятница 06 марта22.08.2017admin

About Windows Media Player for MacWindows Media Player (WMP) is a digital media player and media library application developed by Microsoft that is used for playing audio, video and images on personal computers running the Microsoft Windows operating system, as well as on Pocket PC and Windows Mobile-based devices.

file2.txt

$ tar zxvf mysql-connector-java-5.1.44.tar.gz

$ sudo cp mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar /usr/local/Cellar/hive/2.1.1/libexec/lib/

Step 1

How do I install beeline client? Mine is Mac OS. I tried 'brew install beeline', looks like thats not right. Let me know if someone has same setup. You can use below command to install hive and use beeline brew install hive. I will be installing Hive 1.2.x, as that's the version of Hive that seems to be well. This can be done using brew edit hive, that opens up with the.

$ brew update

$ brew install hadoop

$ brew install hive

$ brew install mysql

Step 2.txt

# ~/.bashrc

export HADOOP_HOME=/usr/local/Cellar/hadoop/2.8.1

export HIVE_HOME=/usr/local/Cellar/hive/2.1.1/libexec

Step 4.txt

$ cd /usr/local/Cellar/hive/4.1.1/libexec/conf

$ cp hive-default.xml.template hive-site.xml

Step 5.txt

<name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://localhost/metastore</value>

</property>

<name>javax.jdo.option.ConnectionDriverName</name>

<value>com.mysql.jdbc.Driver</value>

</property>

<name>javax.jdo.option.ConnectionUserName</name>

<value>hiveuser</value>

</property>

<name>javax.jdo.option.ConnectionPassword</name>

<value>password</value>

</property>

<name>datanucleus.fixedDatastore</name>

<value>false</value>

</property>

<name>hive.exec.local.scratchdir</name>

<description>Local scratch space for Hive jobs</description>

</property>

<name>hive.downloaded.resources.dir</name>

<description>Temporary local directory for added resources in the remote file system.</description>

</property>

<name>hive.querylog.location</name>

<description>Location of Hive run time structured log file</description>

</property>

`<name>hive.metastore.schema.verification</name>`

<value>false</value>

<description>Some Description</description>

</property>

Step 6.txt

run the schematool so that hive will use mysql

./schematool -initSchema -dbType mysql

$hive

hive > show tables;

Step3.txt

start My sql with below command:

brew services start mysql

$ mysql

mysql> CREATE DATABASE metastore;

mysql> USE metastore;

mysql> CREATE USER 'hiveuser'@'localhost' IDENTIFIED BY 'password';

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE, REFERENCES, INDEX ON metastore.* TO 'hiveuser'@'localhost';

commented Jan 16, 2020

step 2

export HADOOP_HOME=/usr/local/Cellar/hadoop/2.8.1
export HIVE_HOME=/usr/local/Cellar/hive/2.1.1/libexec