Ubuntu 安装hive + mysql

property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://hadoop-senior01.itguigu.com:3306/metastore?createDatabaseIfNotExist=true</value> <description>JDBC connect string for a JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> <description>Driver class name for a JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>root</value> <description>username to use against metastore database</description> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>123456</value> <description>password to use against metastore database</description> </property> <!-- 是否在当前客户端中显示查询出来的数据的字段名称 --> <property> <name>hive.cli.print.header</name> <value>true</value> <description>Whether to print the names of the columns in query output.</description> </property> <!-- 是否在当前客户端中显示当前所在数据库名称 --> <property> <name>hive.cli.print.current.db</name> <value>true</value> <description>Whether to include the current database in the Hive prompt.</description> </property>

 

cp hive-env.sh.template hive-env.sh

1. 　　

   # Set HADOOP_HOME to point to a specific hadoop install directory
   HADOOP_HOME=/soft/hadoop-2.5.0-cdh5.3.6
   
   # Hive Configuration Directory can be controlled by:
   export HIVE_CONF_DIR=/soft/hive-0.13.1-cdh5.3.6/conf
   
   # Folder containing extra ibraries required for hive compilation/execution can be controlled by:
   # export HIVE_AUX_JARS_PATH=
   ubantu@s101:/soft/hive-0.13.1-cdh5.3.

   3. cp hive-exec-log4j.properties.template hive-exec-log4j.properties  显示日志

Ubuntu 安装hive + mysql

标签：exp   div   esc   roo   进入   soft   str   use   option