Hive安装部署

Hive安装部署

进入hadoop用户目录
下载hive
wget http://mirrors.cnnic.cn/apache/hive/hive-1.2.1/apache-hive-1.2.1-bin.tar.gz hadoop-1.2.1.tar.gz
解压hive
tar -zxvf apache-hive-1.2.1-bin.tar.gz
修改环境变量
vim /etc/profile

export JAVA_HOME=/usr/lib/jvm/java-7-openjdk-amd64
export JRE_HOME= JAVAHOME/jreexportHADOOPHOME=/home/hadoop/hadoop2.6.0exportHIVEHOME=/home/hadoop/apachehive1.2.1binexportHADOOPCONFDIR= HADOOP_HOME/etc/hadoop
export CLASSPATH= JAVAHOME/lib: JRE_HOME/lib: CLASSPATHexportPATH= JAVA_HOME/bin: JREHOME/bin: HADOOP_HOME/bin: HIVEHOME/bin: HADOOP_HOME/sbin:$PATH

source /etc/profile
chown –R hadoop:hadoop /home/hadoop

安装mysql
apt-get intsall mysql
创建Hive用户
create user ‘hive’@’%’ identified by ‘password’;
grant all on . to ‘hive’@’%’ identified by ‘password’;
flush privileges;

修改hive配置文件
cd /apache-hive-1.2.1-bin/conf
cp hive-default.xml.template hive-site.xml
vim hive-site.xml

<configuration>
    <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://master:3306/hive?createDatabaseInfoNotExist=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>hive</value>
            <description>Username to use against metastore database</description>
      </property>
    <property>
            <name>javax.jdo.option.ConnectionPassword</name>
            <value>password</value>
            <description>password to use against metastore database</description>
      </property>
</configuration>

下载java操作mysql的驱动
wget https://cdn.mysql.com//Downloads/Connector-J/mysql-connector-java-5.1.41.tar.gz

tar –zxvf mysql-connector-java-5.1.41.tar.gz

cd mysql-connector-java-5.1.41

mv mysql-connector-java-5.1.41-bin.jar /home/hadoop/apache-hive-1.2.1-bin/lib

启动hive
如果报错

java.lang.IncompatibleClassChangeError: Found class jline.Terminal, but interface was expected
at jline.TerminalFactory.create(TerminalFactory.java:101)
at jline.TerminalFactory.get(TerminalFactory.java:158)
at jline.console.ConsoleReader.<init>(ConsoleReader.java:229)
at jline.console.ConsoleReader.<init>(ConsoleReader.java:221)
at jline.console.ConsoleReader.<init>(ConsoleReader.java:209)
at org.apache.hadoop.hive.cli.CliDriver.getConsoleReader(CliDriver.java:773)
at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:715)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:615)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

需要删除 hadoop/share/hadoop/yarn/lib/jline-0.9.94.jar

再启动就好了

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值