hive与mysql安装配置
来源:互联网 发布:超级淘宝系统王铁柱 编辑:程序博客网 时间:2024/06/05 01:02
sudo apt-get install mysql-server
可能还要
sudo apt-get install mysq
首先用root登陆给hive用户赋予权限
$mysql -u root -p111111
mysql> GRANT ALL PRIVILEGES ON *.* TO hive@localhost IDENTIFIED BY "hive123";
2,安装hive;
$ tar zxvf hive-0.8.1.tar.gz
在/etc/profile中添加;
export HADOOP_HOME=/home/sina/hadoop/
export HIVE_HOME=/home/sina/hive/
export PATH=$PATH:$HADOOP_HOME/bin:$HIVE_HOME/bin
. /etc/profile生效(.与/etc/profile之间用空格哦)
启动hive,可以用起来了吧;、
hive> create table hive1(id int ,name string)ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
OK
Time taken: 10.865 seconds
hive> show tables;
OK
hive1
Time taken: 0.586 seconds
hive> desc hive1;
OK
id int
name string
Time taken: 0.317 seconds
hive> show tables;
OK
hive1
Time taken: 0.182 seconds
hive>
三,拷贝mysql-connector-java-5.1.13.jar到hive的lib目录下
四,修改配置hive-site.xml
主要修改点:
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?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>hive</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>111111</value>
<description>password to use against metastore database</description>
</property>
好了推出hive,在起启动hive
创建表:
hive> create table hivetest(id int,name string);
OK
Time taken: 0.25 seconds
hive> show tables;
OK
hivetest
Time taken: 0.139 seconds
hive>
进入mysql:
mysql> SELECT *FROM TBLS\G;
*************************** 1. row ***************************
TBL_ID: 1
CREATE_TIME: 1357308618
DB_ID: 1
LAST_ACCESS_TIME: 0
OWNER: sina
RETENTION: 0
SD_ID: 1
TBL_NAME: hivetest
TBL_TYPE: MANAGED_TABLE
VIEW_EXPANDED_TEXT: NULL
VIEW_ORIGINAL_TEXT: NULL
*************************** 2. row ***************************
TBL_ID: 6
CREATE_TIME: 1357309812
DB_ID: 1
LAST_ACCESS_TIME: 0
OWNER: sina
RETENTION: 0
SD_ID: 6
TBL_NAME: zjz
TBL_TYPE: MANAGED_TABLE
VIEW_EXPANDED_TEXT: NULL
VIEW_ORIGINAL_TEXT: NULL
*************************** 3. row ***************************
TBL_ID: 7
CREATE_TIME: 1357311283
DB_ID: 1
LAST_ACCESS_TIME: 0
OWNER: sina
RETENTION: 0
SD_ID: 7
TBL_NAME: mytest
TBL_TYPE: EXTERNAL_TABLE
VIEW_EXPANDED_TEXT: NULL
VIEW_ORIGINAL_TEXT: NULL
3 rows in set (0.00 sec)
ERROR:
No query specified
在此之前建立了几个表:
hive> CREATE EXTERNAL TABLE MYTEST(num INT, name STRING)
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' //分隔符 ‘\t’
> ;
OK
Time taken: 0.142 seconds
hive> load data local inpath '/tmp/hive.txt' overwrite into table MYTEST;
Copying data from file:/tmp/hive.txt
Copying file: file:/tmp/hive.txt
Loading data to table default.mytest
Deleted hdfs://localhost:9000/user/hive/warehouse/mytest
OK
Time taken: 0.402 seconds
hive> SELECT * FROM MYTEST;
OK
NULL NULL
22 world
33 hive
Time taken: 0.089 seconds
hive>
再来看看hive.txt
sina@ubuntu:~/hive/conf$ cat /tmp/hive.txt
11,hello
22 world
33 hive
sina@ubuntu:~/hive/conf$
- hive与mysql安装配置
- hive&mysql安装配置
- hive安装与配置
- hive 安装与配置
- Hive安装与配置
- hive安装与配置
- Hive安装与配置
- HIVE 安装与配置
- Hive安装与配置
- Hive安装与配置
- Hive安装与配置
- 安装MySQL与安装Hive
- apache-hive-1.2.1 安装与MYSQL配置
- hive安装及mysql配置
- hive安装与mysql对接
- hive的安装与配置
- HIVE的安装与配置
- hive安装配置与调试
- 怎样解决Java Web项目更改项目名后报错
- Java缺点之我见
- uva11538
- 利用数据库函数生成不重复的订单号
- join命令用法
- hive与mysql安装配置
- LDA算法入门
- 学生成绩管理系统--开发实录
- 2013-01-04
- 2010北邮上机真题——哈夫曼树
- 什么是SAP供应商主数据
- 利用package包管理安装emacs插件
- glibc内存碎片问题【转】
- 描述在视频播放时来电话的解决方案。