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
