美文网首页
3. Hive安装

3. Hive安装

作者: qdice007 | 来源:发表于2018-04-23 17:45 被阅读0次

qdice007@gmail.com 2018-04-23 15:00

写在前面的废话

我们要基于之前搭建的Hadoop集群上安装,配置和使用Hive.下面对整个环境做个回忆:

集群概况

三台虚拟机(CentOS7): bd-1, bd-2, bd-3

  • bd-1: NameNode主, ResourceManager备
  • bd-2: NameNdoe备, ResourceManager主
  • bd-3: DataNode, NodeManager

启动Hadoop环境

如无特殊说明,下列操作机器均为Hadoop集群中的bd-2主机,操作用户均为之前安装
Hadoop时的libing用户,其家目录是/home/libing

1. 启动ZooKeeper

下面是启动ZooKeeper的脚本内容(就不需要在每个节点上重复操作了)

[libing@bd-1 ~]$ cat zkStartAll.sh 
#!/bin/bash
echo "Start ZooKeeper service ..."
for i in 1 2 3
do
    ssh bd-$i "source /etc/profile ; zkServer.sh start"
done
echo "ZooKeeper started!"

在bd-1上执行该脚本

[libing@bd-1 ~]$ ./zkStartAll.sh 
Start ZooKeeper service ...
ZooKeeper JMX enabled by default
Using config: /home/libing/zookeeper-3.4.10/bin/../conf/zoo.cfg
Starting zookeeper ... STARTED
ZooKeeper JMX enabled by default
Using config: /home/libing/zookeeper-3.4.10/bin/../conf/zoo.cfg
Starting zookeeper ... STARTED
ZooKeeper JMX enabled by default
Using config: /home/libing/zookeeper-3.4.10/bin/../conf/zoo.cfg
Starting zookeeper ... STARTED
ZooKeeper started!

2. 启动HDFS(NameNode, DataNode)

[libing@bd-1 ~]$ /home/libing/hadoop-2.9.0/sbin/start-dfs.sh
Starting namenodes on [bd-1 bd-2]
bd-1: starting namenode, logging to /home/libing/hadoop-2.9.0/logs/hadoop-libing-namenode-bd-1.out
bd-2: starting namenode, logging to /home/libing/hadoop-2.9.0/logs/hadoop-libing-namenode-bd-2.out
bd-3: starting datanode, logging to /home/libing/hadoop-2.9.0/logs/hadoop-libing-datanode-bd-3.out
Starting journal nodes [bd-3]
bd-3: starting journalnode, logging to /home/libing/hadoop-2.9.0/logs/hadoop-libing-journalnode-bd-3.out
Starting ZK Failover Controllers on NN hosts [bd-1 bd-2]
bd-1: zkfc running as process 2026. Stop it first.
bd-2: starting zkfc, logging to /home/libing/hadoop-2.9.0/logs/hadoop-libing-zkfc-bd-2.out

3. 启动YARN(ResourceManager主, NodeManager)

[libing@bd-2 ~]$ /home/libing/hadoop-2.9.0/sbin/start-yarn.sh
starting yarn daemons
starting resourcemanager, logging to /home/libing/hadoop-2.9.0/logs/yarn-libing-resourcemanager-bd-2.out
bd-3: starting nodemanager, logging to /home/libing/hadoop-2.9.0/logs/yarn-libing-nodemanager-bd-3.out

4. 启动YARN(ResourceManager备)

[libing@bd-1 ~]$ /home/libing/hadoop-2.9.0/sbin/yarn-daemon.sh start resourcemanager
starting resourcemanager, logging to /home/libing/hadoop-2.9.0/logs/yarn-libing-resourcemanager-bd-1.out

5. 启动HistoryServer

[libing@bd-2 ~]$ /home/libing/hadoop-2.9.0/sbin/mr-jobhistory-daemon.sh start historyserver
starting historyserver, logging to /home/libing/hadoop-2.9.0/logs/mapred-libing-historyserver-bd-2.out

6. 检查每台虚拟机中的JPS

[libing@bd-1 ~]$ jps
2592 ResourceManager
1747 QuorumPeerMain
2026 DFSZKFailoverController
2191 NameNode
[libing@bd-2 ~]$ jps
2032 JobHistoryServer
1379 QuorumPeerMain
1731 ResourceManager
1607 DFSZKFailoverController
1485 NameNode
[libing@bd-3 ~]$ jps
1408 NodeManager
1299 JournalNode
1095 QuorumPeerMain
1194 DataNode

7. 查看NameNode的HA状态

[libing@bd-1 ~]$ hdfs haadmin -getAllServiceState
bd-1:9000                                          active    
bd-2:9000                                          standby

顺便写一下关闭Hadoop环境的步骤

[libing@bd-2 conf]$ mr-jobhistory-daemon.sh stop historyserver
stopping historyserver
[libing@bd-2 conf]$ 
[libing@bd-2 conf]$ stop-yarn.sh
stopping yarn daemons
stopping resourcemanager
bd-3: stopping nodemanager
bd-3: nodemanager did not stop gracefully after 5 seconds: killing with kill -9
no proxyserver to stop
[libing@bd-1 wordcount]$ yarn-daemon.sh stop resourcemanager
stopping resourcemanager
[libing@bd-1 wordcount]$ stop-dfs.sh
Stopping namenodes on [bd-1 bd-2]
bd-2: stopping namenode
bd-1: stopping namenode
bd-3: stopping datanode
Stopping journal nodes [bd-3]
bd-3: stopping journalnode
Stopping ZK Failover Controllers on NN hosts [bd-1 bd-2]
bd-1: stopping zkfc
bd-2: stopping zkfc
[libing@bd-1 wordcount]$ cd
[libing@bd-1 ~]$ ./zkStopAll.sh 
Stop ZooKeeper service ...
ZooKeeper JMX enabled by default
Using config: /home/libing/zookeeper-3.4.10/bin/../conf/zoo.cfg
Stopping zookeeper ... STOPPED
ZooKeeper JMX enabled by default
Using config: /home/libing/zookeeper-3.4.10/bin/../conf/zoo.cfg
Stopping zookeeper ... STOPPED
ZooKeeper JMX enabled by default
Using config: /home/libing/zookeeper-3.4.10/bin/../conf/zoo.cfg
Stopping zookeeper ... STOPPED
ZooKeeper stopped!

开始

准备

1. 启动Hadoop环境至正常使用状态

步骤请参考上面的内容

2. 下载Hive安装包

从Apache Hive官网下载安装包,放入目录/home/libing/softwares下

  • apache-hive-2.3.2-bin.tar.gz

3. 下载MySQL安装包及其JDBC软件包

从MySQL官网下载安装包,放入目录/home/libing/softwares下

  • mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
  • mysql-connector-java-5.1.46.tar.gz

安装MySQL

Hive可以使用内置的Derby数据库来作为其元数据的存储数据库,但也可以使用外部的
数据库来存放其元数据,这里我们使用MySQL数据库.

1. 解压MySQL软件包,并拷贝到/usr/loca/目录下,目录改名为mysql

[libing@bd-2 softwares]$ tar xzf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz 
[libing@bd-2 softwares]$ sudo cp -r mysql-5.7.18-linux-glibc2.5-x86_64 /usr/local/mysql
[libing@bd-2 softwares]$ ll /usr/local/mysql
总用量 36
drwxr-xr-x  2 root root  4096 4月  12 13:53 bin
-rw-r--r--  1 root root 17987 4月  12 13:53 COPYING
drwxr-xr-x  2 root root    55 4月  12 13:53 docs
drwxr-xr-x  3 root root  4096 4月  12 13:53 include
drwxr-xr-x  5 root root   229 4月  12 13:53 lib
drwxr-xr-x  4 root root    30 4月  12 13:53 man
-rw-r--r--  1 root root  2478 4月  12 13:53 README
drwxr-xr-x 28 root root  4096 4月  12 13:53 share
drwxr-xr-x  2 root root    90 4月  12 13:53 support-files

2. 增加mysql组和用户,并修改软件目录的组和属主

[libing@bd-2 softwares]$ sudo groupadd mysql
[libing@bd-2 softwares]$ sudo useradd -r -g mysql mysql
[libing@bd-2 softwares]$ cd /usr/local/mysql
[libing@bd-2 mysql]$ sudo chown -R mysql:mysql ./
[libing@bd-2 mysql]$ ll
总用量 36
drwxr-xr-x  2 mysql mysql  4096 4月  12 13:53 bin
-rw-r--r--  1 mysql mysql 17987 4月  12 13:53 COPYING
drwxr-xr-x  2 mysql mysql    55 4月  12 13:53 docs
drwxr-xr-x  3 mysql mysql  4096 4月  12 13:53 include
drwxr-xr-x  5 mysql mysql   229 4月  12 13:53 lib
drwxr-xr-x  4 mysql mysql    30 4月  12 13:53 man
-rw-r--r--  1 mysql mysql  2478 4月  12 13:53 README
drwxr-xr-x 28 mysql mysql  4096 4月  12 13:53 share
drwxr-xr-x  2 mysql mysql    90 4月  12 13:53 support-files

3. 编辑配置文件my.cnf

[libing@bd-2 mysql]$ ll /etc/my.cnf
-rw-r--r--. 1 root root 570 6月   8 2017 /etc/my.cnf
[libing@bd-2 mysql]$ sudo cp /etc/my.cnf /etc/my.cnf.bak
[libing@bd-2 mysql]$ sudo cat /dev/null>/etc/my.cnf && vim /etc/my.cnf
[libing@bd-2 ~]$ cat /etc/my.cnf
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
character_set_server=utf8
init_connect="SET NAMES utf8"
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid
lower_case_table_names=1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=5000

4. 安装库libaio

[libing@bd-2 mysql]$ sudo yum install libaio
......
软件包 libaio-0.3.109-13.el7.x86_64 已安装并且是最新版本
无须任何处理

5. 创建日志文件mysqld.log

[libing@bd-2 mysql]$ sudo touch /var/log/mysqld.log
[libing@bd-2 mysql]$ sudo chown mysql:mysql /var/log/mysqld.log 
[libing@bd-2 mysql]$ ll /var/log/mysqld.log 
-rw-r--r-- 1 mysql mysql 0 4月  12 14:04 /var/log/mysqld.log

6. 初始化数据库

[libing@bd-2 mysql]$ sudo /usr/local/mysql/bin/mysqld  --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
[libing@bd-2 mysql]$ cat /var/log/mysqld.log 
2018-04-12T06:16:12.818857Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-12T06:16:12.978432Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-04-12T06:16:13.044058Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-04-12T06:16:13.119656Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0013b18d-3e19-11e8-abcc-000c29a0ecc2.
2018-04-12T06:16:13.122469Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-04-12T06:16:13.124245Z 1 [Note] A temporary password is generated for root@localhost: *se<LkQH6opT

注意,最后有个字符串 *se<LkQH6opT 一定要记住,这是MySQL root用户的初始密码,
后面登录MySQL时需要用到它.

7. 配置系统环境

编辑/etc/profile

[libing@bd-2 mysql]$ sudo vim /etc/profile

在文件的最后添加如下内容

# Added for MySQL
PATH=$PATH:/usr/local/mysql/bin
export PATH

使之马上生效

[libing@bd-2 mysql]$ source /etc/profile

8. 启动MySQL服务,并查看其状态,以及停止服务

[libing@bd-2 mysql]$ sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[libing@bd-2 mysql]$ sudo service mysql start
Starting MySQL. SUCCESS! 
[libing@bd-2 mysql]$ sudo service mysql status
 SUCCESS! MySQL running (2530)
[libing@bd-2 mysql]$ sudo service mysql stop
Shutting down MySQL.. SUCCESS! 

9. 将MySQL加入到开机自启动服务,并启动它

[libing@bd-2 mysql]$ sudo chkconfig --add mysql
[libing@bd-2 mysql]$ sudo service mysql start
Starting MySQL. SUCCESS!

10. 使用root用户登录MySQL,并修改其密码和可以在远程主机访问它

[libing@bd-2 mysql]$ mysql -u root -p
Enter password: 
......
mysql> set password = password('root123');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> use mysql
Database changed
mysql> select host,user,authentication_string from user;
+-----------+-----------+-------------------------------------------+
| host      | user      | authentication_string                     |
+-----------+-----------+-------------------------------------------+
| localhost | root      | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 |
| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+-----------+-----------+-------------------------------------------+
2 rows in set (0.00 sec)
mysql> update user set host='%' where user = 'root' ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> commit ;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges ;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye

11. 在MySQL中创建hive_db数据库和hive用户

[libing@bd-2 ~]$ mysql -uroot -p
Enter password: 
......
mysql> create database hive_db ;
Query OK, 1 row affected (0.01 sec)
mysql> show databases ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| hive_db            |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)
mysql> create user hive identified by 'hive123';
Query OK, 0 rows affected (0.02 sec)
mysql> grant all privileges on hive_db.* to 'hive'@'%' identified by 'hive123' ;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> quit
Bye

验证

[libing@bd-2 conf]$ mysql -uhive -p
Enter password: 
......
mysql> use hive_db ;
Database changed
mysql> quit
Bye

安装Hive

1. 解压Hive软件包,并做链接

[libing@bd-2 ~]$ cd /home/libing/softwares
[libing@bd-2 softwares]$ ll
总用量 808360
-rw-rw-r--  1 libing libing 231740978 4月  12 14:50 apache-hive-2.3.2-bin.tar.gz
-rw-rw-r--. 1 libing libing 366744329 12月 20 12:36 hadoop-2.9.0.tar.gz
-rw-rw-r--. 1 libing libing 189784266 12月 21 15:25 jdk-8u152-linux-x64.tar.gz
drwxr-xr-x  3 libing libing       178 2月  26 21:28 mysql-connector-java-5.1.46
-rw-rw-r--  1 libing libing   4434926 4月  12 14:48 mysql-connector-java-5.1.46.tar.gz
-rw-rw-r--. 1 libing libing  35042811 12月 20 12:36 zookeeper-3.4.10.tar.gz
[libing@bd-2 softwares]$ cp apache-hive-2.3.2-bin.tar.gz ../
[libing@bd-2 softwares]$ cd ../
[libing@bd-2 ~]$ tar xzf apache-hive-2.3.2-bin.tar.gz 
[libing@bd-2 ~]$ ll
总用量 226348
drwxrwxr-x  10 libing libing       184 4月  12 14:51 apache-hive-2.3.2-bin
......
[libing@bd-2 ~]$ sudo ln -s /home/libing/apache-hive-2.3.2-bin/ /usr/local/hive
[libing@bd-2 ~]$ ll /usr/local
......
lrwxrwxrwx   1 root  root   35 4月  12 14:53 hive -> /home/libing/apache-hive-2.3.2-bin/

2. 将MySQL JDBC包解压,并拷贝jar文件到Hive软件目录中的lib子目录下

[libing@bd-2 ~]$ cd /home/libing/softwares
[libing@bd-2 softwares]$ tar xzf mysql-connector-java-5.1.46.tar.gz 
[libing@bd-2 softwares]$ ll
......
drwxr-xr-x  3 libing libing       178 2月  26 21:28 mysql-connector-java-5.1.46
[libing@bd-2 softwares]$ ll mysql-connector-java-5.1.46
......
-rw-r--r-- 1 libing libing 1004840 2月  26 21:28 mysql-connector-java-5.1.46-bin.jar
-rw-r--r-- 1 libing libing 1004838 2月  26 21:28 mysql-connector-java-5.1.46.jar
......
[libing@bd-2 softwares]$ cp mysql-connector-java-5.1.46/mysql-connector-java-5.1.46*.jar ~/apache-hive-2.3.2-bin/lib

3. 配置系统环境

[libing@bd-2 ~]$ sudo vim /etc/profile

在文件的最后增加如下内容

# Added for Hive
HIVE_HOME=/usr/local/hive
export HIVE_HOME
PATH=$PATH:${HIVE_HOME}/bin
export PATH

使之马上生效

[libing@bd-2 ~]$ source /etc/profile

配置Hive

1. 在HDFS中创建一些目录

[libing@bd-2 ~]$ hadoop fs -mkdir /tmp
mkdir: `/tmp': File exists
[libing@bd-2 ~]$ hadoop fs -mkdir -p /user/hive/warehouse
[libing@bd-2 ~]$ hadoop fs -chmod 777 /tmp
[libing@bd-2 ~]$ hadoop fs -chmod 777 /user/hive/warehouse

2. 创建Hive配置文件,并编辑

[libing@bd-2 conf]$ cd /usr/local/hive/conf
[libing@bd-2 conf]$ ll
总用量 288
-rw-r--r-- 1 libing libing   1596 11月 10 00:25 beeline-log4j2.properties.template
-rw-r--r-- 1 libing libing 257573 11月 10 01:11 hive-default.xml.template
-rw-r--r-- 1 libing libing   2365 11月 10 00:25 hive-env.sh.template
-rw-r--r-- 1 libing libing   2274 11月 10 00:25 hive-exec-log4j2.properties.template
-rw-r--r-- 1 libing libing   2925 11月 10 00:26 hive-log4j2.properties.template
-rw-r--r-- 1 libing libing   2060 11月 10 00:25 ivysettings.xml
-rw-r--r-- 1 libing libing   2719 11月 10 00:26 llap-cli-log4j2.properties.template
-rw-r--r-- 1 libing libing   7041 11月 10 00:26 llap-daemon-log4j2.properties.template
-rw-r--r-- 1 libing libing   2662 11月 10 00:25 parquet-logging.properties
[libing@bd-2 conf]$ cp hive-env.sh.template hive-env.sh
[libing@bd-2 conf]$ cp hive-default.xml.template hive-site.xml
[libing@bd-2 conf]$ cp hive-log4j2.properties.template hive-log4j2.properties
[libing@bd-2 conf]$ cp hive-exec-log4j2.properties.template hive-exec-log4j2.properties

其中 hive-env.sh, hive-log4j2.properties, hive-exec-log4j2.properties内容可以保持默认,暂时不必改动.
重点是 hive-site.xml 文件的修改

启动Hive

1. 初始化

[libing@bd-2 ~]$ /usr/local/hive/bin/schematool -dbType mysql -initSchema
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/libing/apache-hive-2.3.2-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/libing/hadoop-2.9.0/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Metastore connection URL:    jdbc:mysql://localhost/hive_db?createDatabaseIfNotExist=true
Metastore Connection Driver :    org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User:   hive
Fri Apr 13 10:30:18 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Starting metastore schema initialization to 2.3.0
Initialization script hive-schema-2.3.0.mysql.sql
Fri Apr 13 10:30:19 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Initialization script completed
Fri Apr 13 10:30:21 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
schemaTool completed

2. 使用hive客户端,并简单创建一个表

[libing@bd-2 ~]$ hive
which: no hbase in (/home/libing/zookeeper-3.4.10/bin:/usr/local/jdk//bin:/home/libing/zookeeper-3.4.10/bin:/usr/local/jdk//bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/libing/hadoop-2.9.0/bin:/home/libing/hadoop-2.9.0/sbin:/usr/local/mysql/bin:{/usr/local/hive}/bin:/home/libing/.local/bin:/home/libing/bin:/home/libing/hadoop-2.9.0/bin:/home/libing/hadoop-2.9.0/sbin:/usr/local/mysql/bin:/usr/local/hive/bin)
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/libing/apache-hive-2.3.2-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/libing/hadoop-2.9.0/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]

Logging initialized using configuration in file:/home/libing/apache-hive-2.3.2-bin/conf/hive-log4j2.properties Async: true
Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
hive> create table test(id int, name string);
OK
Time taken: 10.034 seconds
hive> show tables;
OK
test
Time taken: 0.577 seconds, Fetched: 1 row(s)
hive> quit;

可以到MySQL中查看Hive的元数据(以刚创建的test表为例)

[libing@bd-2 conf]$ mysql -uhive -p
Enter password: 
......
mysql> use hive_db;
Database changed
mysql> select * from tbls;
+--------+-------------+-------+------------------+--------+-----------+-------+----------+---------------+--------------------+--------------------+--------------------+
| TBL_ID | CREATE_TIME | DB_ID | LAST_ACCESS_TIME | OWNER  | RETENTION | SD_ID | TBL_NAME | TBL_TYPE      | VIEW_EXPANDED_TEXT | VIEW_ORIGINAL_TEXT | IS_REWRITE_ENABLED |
+--------+-------------+-------+------------------+--------+-----------+-------+----------+---------------+--------------------+--------------------+--------------------+
|      1 |  1523589322 |     1 |                0 | libing |         0 |     1 | test     | MANAGED_TABLE | NULL               | NULL               |                    |
+--------+-------------+-------+------------------+--------+-----------+-------+----------+---------------+--------------------+--------------------+--------------------+
2 rows in set (0.00 sec)
mysql> quit
Bye

SQL实验

结束

相关文章

  • 3. Hive安装

    qdice007@gmail.com 2018-04-23 15:00 写在前面的废话 我们要基于之前搭建的Ha...

  • ubuntu16.04 配置hiveserver2 让其他服务可

    1.hive安装 2.配置添加hadoop配置 3.配置hive 4.启动hive 5.测试 localhost:...

  • ubuntu16.04 本地安装hive

    前提条件 安装hadoop 1.下载hive2.3.3 2.创建hive文件夹 3.解压hive 4.下载mysq...

  • Hive安装与配置

    Hive安装与配置 Hive安装配置 Hive官网:http://hive.apache.org[http://h...

  • Hive安装教程

    先安装好hadoop,再安装Hive 下载地址Index of /dist/hive/hive-3.1.2 (ap...

  • 【Hive】

    Hive的安装 Hive官网地址 http://hive.apache.org/[http://hive.apac...

  • Hive的安装与配置

    一、安装与配置hive 安装hive之前需要到官网查询hive与Hadoop版本的兼容性。这里我所选的hive和H...

  • Hive | Hive 安装详解

    一、Hive 介绍 二、准备工作 三、Hive下载 四、Hive 安装 五、Hive 启动 一、Hive 介绍 H...

  • Hive开发环境搭建

    1. 安装Hive 1.1准备工作 Hive官网:https://hive.apache.org/ 下载hive,...

  • Hive安装Version2.1.0

    Hive安装,基于版本2.1.0,使用apache-hive-2.1.0-bin.tar.gz安装包。 1.安装规...

网友评论

      本文标题:3. Hive安装

      本文链接:https://www.haomeiwen.com/subject/dfkllftx.html