I. Downloads for mysql-server and mysql-client[Email protected]:/usr/local# sudo apt-get install mysql-server mysql-client (Ubuntu version)Here I am, root password, for rootroot. second, start MySQL Service[Email protected]:/usr/local# sudo/etc/init.d/mysql start (Ubuntu version)* Starting MySQL database server mysqld [OK][Email protected]:/usr/local#Third, enter
;Javax.jdo.option.ConnectionUserNamename> value>Hivevalue> Description>Username to use against Metastore databaseDescription> Property> Property> name>Javax.jdo.option.ConnectionPasswordname> value>Hivevalue> Description>Password to use against Metastore databaseDescription> Property> Property> name>Hive.metastore.localname> value>Truevalue> Description>Description> Property>2.7 Modify the hive-config.sh file under
First step: Prepare hive and MySQL installation package Download Hive 1.1.1 Address: http://www.eu.apache.org/dist/hive/ Download MySQL JDBC 5.1.38 driver: http://dev.mysql.com/downloads/connector/j/ Second step: Install MySQL directly, can be installed with sudo apt-get install
Install hive and hive
Hive installation is relatively simple, because there is no need to modify too many configuration files
1. Download and decompress
I put it in/usr/hadoop/hive
2. Set the environment variable. (It seems that it is not set)
vim /etc/profileexport JAV
Hive is a Hadoop-based data warehouse tool that maps structured data files into a database table and provides simple SQL query functions to convert SQL statements.
Hive is a Hadoop-based data warehouse tool that maps structured data files into a database table and provides simple SQL query functions to convert SQL statements.
Introduction: Hive is a powerful
First, the installation mode introduction:Hive official on-line introduces 3 kinds of hive installation methods, corresponding to different application scenarios. 1, in-line mode (meta data to protect the village in the embedded derby species, allow a session link, try multiple session links will be error) 2. Local mode (install MySQL locally instead of Derby store metadata) 3. Remote mode (remotely
The installation tutorials I've seen on the internet are really a little sad. Many have failed.Sharing, the success of their own experiments can be used for reference to the blog:Recommendation 1 to force Star: Http://www.powerxing.com/install-hadoop/hadoop+spark full reference to his blog, quite to force recommended index of 5 starsHive, I have too many articles to refer to here. No one can use, I do not know whether it is my own wrong or what happen
Environment only needs to be installed on one node 2. Set environment variable vi. bash_profileexportJAVA_HOMEusrlibjvmjava-1.6.0-openjdk-1.6
Install and configure hive 1. download wget http://mirror.mel.bkb.net.au/pub/apache//hive/stable/hive-0.8.1.tar.gz tar zxf hive-0.8.1
Install the data warehouse tool in two Hive modes to convert the raw structured data under Hadoop into tables in Hive. HiveQL, a language almost identical to SQL, supports updates, indexes, and transactions. It can be seen as a er from SQL to Map-Reduce. Provides interfaces such as shell, JDBCODBC, thrift, and Web. I. Embedded Mode
This document describes how to manually install the clouderaHivecdh4.2.0 cluster. For environment setup and Hadoop and HBase installation processes, see the previous article. Install hivehive on desktop1. Note that hive saves metadata using the derby database by default. Replace it with postgresql here. The following describes how to
hive-log4j.propertiesHere I just set the path of the log file2.4 Create the relevant folder, that is, set in 2.2 of the 2.5 in HDFs to establish the relevant folders $HADOOP _home/bin/hadoop FS-mkdir /tmp $HADOOP _home/bin/hadoop FS- mkdir /user/hive/Warehouse $HADOOP _home/bin/hadoop FS-chmod g+w /tmp $HADOOP _home/bin/hadoop FS-chmod g+w /user/hi
the attribute hive. metastore. warehouse. dir in the profile hive-conf.xml.
2. Install hive
(1) decompress, rename, and set Environment Variables
(2) In the directory $ HIVE_HOME/conf/, execute the command mv hive-default.xml.template h
Install and configure hive
1. Prerequisites
To install hadoop first, see the http://blog.csdn.net/hwwn2009/article/details/39889465 for Installation Details
2. Install hive
1) download hive. Note that the
: edit the. bash_profile file in the home directory, add an environment variable, and the warning disappears:
Export hadoop_home_warn_suppress = 1
My situation is: in the computer environment variables have set hadoop_home path, and later in the hadoop-env.sh and set export hadoop_home = E:/hadoop/hadoop-1.0.3, later, I commented out the comment in the file and did not prompt
Install and configure MySQL
Sodu RPT-i
Tags: Install hive (use MySQL connection in standalone mode) 1. Java+hadoop 2 is installed by default. Download the installation package for Hadoop version 3. Unzip the installation package tar ZXVF apache-hive-1.2.1-bin.tar.gz 4. Install MySQL Yu M-y install mysql-server
This document describes how to manually install the cloudera hive cdh4.2.0 cluster. For environment setup and hadoop and hbase installation processes, see the previous article.Install hive
Hive is installed on mongotop1. Note that hive saves metadata using the Derby database
This article describes the Brew install hive and modifies the default Metastore storage scheme, changing the Derby database to the MySQL method and the solution to the problems that may be encountered.1. Installing hive via Homebrew
1
brewinstallhive
2. Add environment variables for Hadoop and
/mysqladmin-u root password ' root '8) Log in to MySQL as the root userMysql-uroot–prootInstalling HiveHive is installed on the master node.1) Create hive users, databases, etc. in MySQLInsert into Mysql.user (Host,user,password) VALUES ("localhost", "Hive", Password ("Hive"));Create DATABASE hive;Grant all on
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.