[root@hadoop102 software]# tar -zxvf apache-hive-3.1.2-bin.tar.gz -C /opt/module/
[root@hadoop102 module]# mv apache-hive-3.1.2-bin/ hive
[root@hadoop102 hive]# pwd /opt/module/hive
[root@hadoop102 /]# vim /etc/profile.d/my_env.sh #HIVE_HOME export HIVE_HOME=/opt/module/hive export PATH=$PATH:$HIVE_HOME/bin
source /etc/profile
[root@hadoop102 /]# mv $HIVE_HOME/lib/log4j-slf4j-impl-2.10.0.jar $HIVE_HOME/lib/log4j-slf4j-impl-2.10.0.bak [root@hadoop102 /]# cd /opt/module/hive/
[root@hadoop102 hive]# bin/schematool -dbType derby -initSchema
[root@hadoop102 hive]# find -name guava-19.0.jar
guava-19.0.jar 存在于 hadoop 中的 /opt/module/hadoop-3.1.3/share/hadoop/common/lib 然后删除较低版本并拷贝较高版本
[root@hadoop102 lib]# ls | grep "guava"
[root@hadoop102 hive]# bin/schematool -dbType derby -initSchema
bin/hive
- 使用 Hive
hive> show databases; OK default Time taken: 3.248 seconds, Fetched: 1 row(s) hive> show tables; OK Time taken: 0.987 seconds hive> create table test(id int); OK Time taken: 4.296 seconds hive> insert into test values(1); hive> select * from test; OK Time taken: 5.875 seconds
OK Time taken: 4.296 seconds hive> insert into test values(1); Query ID = root_20220903201802_f7d0004e-b10e-4b6e-947d-eee466076eef Total jobs = 3 Launching Job 1 out of 3 Number of reduce tasks determined at compile time: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapreduce.job.reduces=<number> Starting Job = job_1662205222295_0001, Tracking URL = http://hadoop103:8088/proxy/application_1662205222295_0001/ Kill Command = /opt/module/hadoop-3.1.3/bin/mapred job -kill job_1662205222295_0001 Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0 2022-09-03 20:19:12,690 Stage-1 map = 0%, reduce = 0% Ended Job = job_1662205222295_0001 with errors Error during job, obtaining debugging information... FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask MapReduce Jobs Launched: Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 FAIL Total MapReduce CPU Time Spent: 0 msec
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.
[root@hadoop102 hive]# cp /opt/software/mysql-connector-java-5.1.27-bin.jar ./lib/
vim hive-site.xml <?xml version="1.0"?> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> <configuration> <!-- jdbc 连接的 URL --> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://hadoop102:3306/metastore?useSSL=false</value> </property> <!-- jdbc 连接的 Driver--> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> </property> <!-- jdbc 连接的 username--> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>root</value> </property> <!-- jdbc 连接的 password --> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>000000</value> </property> <!-- Hive 元数据存储版本的验证 --> <property> <name>hive.metastore.schema.verification</name> <value>false</value> </property> <!--元数据存储授权--> <property> <name>hive.metastore.event.db.notification.api.auth</name> <value>false</value> </property> <!-- Hive 默认在 HDFS 的工作目录 --> <property> <name>hive.metastore.warehouse.dir</name> <value>/user/hive/warehouse</value> </property> </configuration>
[root@hadoop102 software]# tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
- linux 在安装的时候会自带一个 sql
首先需要卸载自带的 sql
[root@hadoop102 software]# rpm -qa | grep mariadb mariadb-libs-5.5.56-2.el7.x86_64
然后卸载
[root@hadoop102 software]# rpm -e --nodeps mariadb-libs
[root@hadoop102 software]# rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
- 查看 mysql 配置信息
cat /etc/my.cnf
- 如果由内容就删除/var/lib/mysql 目录下的所有内容:
[root @hadoop102 mysql]# cd /var/lib/mysql [root @hadoop102 mysql]# sudo rm -rf ./*
- 初始化数据库
mysqld --initialize --user=mysql
- 查看临时生成的 root 用户的密码
cat /var/log/mysqld.log
- 启动 MySQL 服务
systemctl start mysqld
- 登录 MySQL 数据库
mysql -uroot -p
- 必须先修改 root 用户的密码,否则执行其他的操作会报错
mysql> set password = password("新密码");
- 修改 mysql 库下的 user 表中的 root 用户允许任意 ip 连接
mysql> update mysql.user set host='%' where user='root'; mysql> flush privileges;
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.18 sec)
mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables; +---------------------------+ | Tables_in_mysql | +---------------------------+ | columns_priv | | db | | engine_cost | | event | | func | | general_log | | gtid_executed | | help_category | | help_keyword | | help_relation | | help_topic | | innodb_index_stats | | innodb_table_stats | | ndb_binlog_index | | plugin | | proc | | procs_priv | | proxies_priv | | server_cost | | servers | | slave_master_info | | slave_relay_log_info | | slave_worker_info | | slow_log | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +---------------------------+ 31 rows in set (0.01 sec)
mysql> select Host,User from user; +-----------+---------------+ | Host | User | +-----------+---------------+ | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | +-----------+---------------+ 3 rows in set (0.05 sec)
mysql> update mysql.user set host='%' where user='root'; Query OK, 1 row affected (0.17 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.03 sec)
select Host,User from user; +-----------+---------------+ | Host | User | +-----------+---------------+ | % | root | | localhost | mysql.session | | localhost | mysql.sys | +-----------+---------------+ 3 rows in set (0.00 sec)
- 新建 Hive 元数据库
create database metastore; mysql> create database metastore; Query OK, 1 row affected (0.74 sec)
- 新建 Hive 元数据库
schematool -initSchema -dbType mysql -verbose
Metastore connection URL: jdbc:mysql://hadoop102:3306/metastore?useSSL=false Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: root Starting metastore schema initialization to 3.1.0 Initialization script hive-schema-3.1.0.mysql.sql Connecting to jdbc:mysql://hadoop102:3306/metastore?useSSL=false Connected to: MySQL (version 5.7.28) Driver: MySQL Connector Java (version mysql-connector-java-5.1.27 ( Revision: alexander.soklakov@oracle.com-20131021093118-gtm1bh1vb450xipt )) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:mysql://hadoop102:3306/metastore> !autocommit on Autocommit status: true 0: jdbc:mysql://hadoop102:3306/metastore> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT / No rows affected (0.062 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS / No rows affected (0.042 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION / No rows affected (0.022 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET NAMES utf8 / No rows affected (0.024 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE / No rows affected (0.021 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40103 SET TIME_ZONE='+00:00' / No rows affected (0.043 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 / No rows affected (0.07 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 / No rows affected (0.032 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' / No rows affected (0.031 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 / No rows affected (0.037 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.027 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.041 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS BUCKETING_COLS ( SD_ID bigint(20) NOT NULL, BUCKET_COL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, INTEGER_IDX int(11) NOT NULL, PRIMARY KEY (SD_ID,INTEGER_IDX), KEY BUCKETING_COLS_N49 (SD_ID), CONSTRAINT BUCKETING_COLS_FK1 FOREIGN KEY (SD_ID) REFERENCES SDS (SD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.557 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.018 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.017 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS CDS ( CD_ID bigint(20) NOT NULL, PRIMARY KEY (CD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.092 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.062 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.037 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS COLUMNS_V2 ( CD_ID bigint(20) NOT NULL, COMMENT varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, COLUMN_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, TYPE_NAME MEDIUMTEXT DEFAULT NULL, INTEGER_IDX int(11) NOT NULL, PRIMARY KEY (CD_ID,COLUMN_NAME), KEY COLUMNS_V2_N49 (CD_ID), CONSTRAINT COLUMNS_V2_FK1 FOREIGN KEY (CD_ID) REFERENCES CDS (CD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.098 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.017 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.021 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS DATABASE_PARAMS ( DB_ID bigint(20) NOT NULL, PARAM_KEY varchar(180) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PARAM_VALUE varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (DB_ID,PARAM_KEY), KEY DATABASE_PARAMS_N49 (DB_ID), CONSTRAINT DATABASE_PARAMS_FK1 FOREIGN KEY (DB_ID) REFERENCES DBS (DB_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.088 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.023 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE CTLGS ( CTLG_ID BIGINT PRIMARY KEY, NAME VARCHAR(256), DESC VARCHAR(4000), LOCATION_URI VARCHAR(4000) NOT NULL, UNIQUE KEY UNIQUE_CATALOG (NAME) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.28 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> INSERT INTO CTLGS VALUES (1, 'hive', 'Default catalog for Hive', 'TBD') 1 row affected (0.135 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS DBS ( DB_ID bigint(20) NOT NULL, DESC varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, DB_LOCATION_URI varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, OWNER_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, OWNER_TYPE varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, CTLG_NAME varchar(256) NOT NULL DEFAULT 'hive', PRIMARY KEY (DB_ID), UNIQUE KEY UNIQUE_DATABASE (NAME, CTLG_NAME), CONSTRAINT CTLG_FK1 FOREIGN KEY (CTLG_NAME) REFERENCES CTLGS (NAME) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.134 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.032 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS DB_PRIVS ( DB_GRANT_ID bigint(20) NOT NULL, CREATE_TIME int(11) NOT NULL, DB_ID bigint(20) DEFAULT NULL, GRANT_OPTION smallint(6) NOT NULL, GRANTOR varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, GRANTOR_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, DB_PRIV varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, AUTHORIZER varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (DB_GRANT_ID), UNIQUE KEY DBPRIVILEGEINDEX (AUTHORIZER,DB_ID,PRINCIPAL_NAME,PRINCIPAL_TYPE,DB_PRIV,GRANTOR,GRANTOR_TYPE), KEY DB_PRIVS_N49 (DB_ID), CONSTRAINT DB_PRIVS_FK1 FOREIGN KEY (DB_ID) REFERENCES DBS (DB_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.095 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.017 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.02 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.042 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS GLOBAL_PRIVS ( USER_GRANT_ID bigint(20) NOT NULL, CREATE_TIME int(11) NOT NULL, GRANT_OPTION smallint(6) NOT NULL, GRANTOR varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, GRANTOR_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, USER_PRIV varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, AUTHORIZER varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (USER_GRANT_ID), UNIQUE KEY GLOBALPRIVILEGEINDEX (AUTHORIZER,PRINCIPAL_NAME,PRINCIPAL_TYPE,USER_PRIV,GRANTOR,GRANTOR_TYPE) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.123 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.037 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.014 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS IDXS ( INDEX_ID bigint(20) NOT NULL, CREATE_TIME int(11) NOT NULL, DEFERRED_REBUILD bit(1) NOT NULL, INDEX_HANDLER_CLASS varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, INDEX_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, INDEX_TBL_ID bigint(20) DEFAULT NULL, LAST_ACCESS_TIME int(11) NOT NULL, ORIG_TBL_ID bigint(20) DEFAULT NULL, SD_ID bigint(20) DEFAULT NULL, PRIMARY KEY (INDEX_ID), UNIQUE KEY UNIQUEINDEX (INDEX_NAME,ORIG_TBL_ID), KEY IDXS_N51 (SD_ID), KEY IDXS_N50 (INDEX_TBL_ID), KEY IDXS_N49 (ORIG_TBL_ID), CONSTRAINT IDXS_FK1 FOREIGN KEY (ORIG_TBL_ID) REFERENCES TBLS (TBL_ID), CONSTRAINT IDXS_FK2 FOREIGN KEY (SD_ID) REFERENCES SDS (SD_ID), CONSTRAINT IDXS_FK3 FOREIGN KEY (INDEX_TBL_ID) REFERENCES TBLS (TBL_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.106 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.012 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS INDEX_PARAMS ( INDEX_ID bigint(20) NOT NULL, PARAM_KEY varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PARAM_VALUE varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (INDEX_ID,PARAM_KEY), KEY INDEX_PARAMS_N49 (INDEX_ID), CONSTRAINT INDEX_PARAMS_FK1 FOREIGN KEY (INDEX_ID) REFERENCES IDXS (INDEX_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.095 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.014 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS NUCLEUS_TABLES ( CLASS_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, TABLE_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, TYPE varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, OWNER varchar(2) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, VERSION varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, INTERFACE_NAME varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (CLASS_NAME) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.054 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.031 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.032 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS PARTITIONS ( PART_ID bigint(20) NOT NULL, CREATE_TIME int(11) NOT NULL, LAST_ACCESS_TIME int(11) NOT NULL, PART_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, SD_ID bigint(20) DEFAULT NULL, TBL_ID bigint(20) DEFAULT NULL, PRIMARY KEY (PART_ID), UNIQUE KEY UNIQUEPARTITION (PART_NAME,TBL_ID), KEY PARTITIONS_N49 (TBL_ID), KEY PARTITIONS_N50 (SD_ID), CONSTRAINT PARTITIONS_FK1 FOREIGN KEY (TBL_ID) REFERENCES TBLS (TBL_ID), CONSTRAINT PARTITIONS_FK2 FOREIGN KEY (SD_ID) REFERENCES SDS (SD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.074 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.022 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.026 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS PARTITION_EVENTS ( PART_NAME_ID bigint(20) NOT NULL, CAT_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, DB_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, EVENT_TIME bigint(20) NOT NULL, EVENT_TYPE int(11) NOT NULL, PARTITION_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, TBL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (PART_NAME_ID), KEY PARTITIONEVENTINDEX (PARTITION_NAME) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.065 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.025 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.029 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.022 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS PARTITION_KEYS ( TBL_ID bigint(20) NOT NULL, PKEY_COMMENT varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PKEY_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PKEY_TYPE varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, INTEGER_IDX int(11) NOT NULL, PRIMARY KEY (TBL_ID,PKEY_NAME), KEY PARTITION_KEYS_N49 (TBL_ID), CONSTRAINT PARTITION_KEYS_FK1 FOREIGN KEY (TBL_ID) REFERENCES TBLS (TBL_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.074 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS PARTITION_KEY_VALS ( PART_ID bigint(20) NOT NULL, PART_KEY_VAL varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, INTEGER_IDX int(11) NOT NULL, PRIMARY KEY (PART_ID,INTEGER_IDX), KEY PARTITION_KEY_VALS_N49 (PART_ID), CONSTRAINT PARTITION_KEY_VALS_FK1 FOREIGN KEY (PART_ID) REFERENCES PARTITIONS (PART_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.131 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.011 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.012 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.029 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS PARTITION_PARAMS ( PART_ID bigint(20) NOT NULL, PARAM_KEY varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PARAM_VALUE varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (PART_ID,PARAM_KEY), KEY PARTITION_PARAMS_N49 (PART_ID), CONSTRAINT PARTITION_PARAMS_FK1 FOREIGN KEY (PART_ID) REFERENCES PARTITIONS (PART_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.072 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.045 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.014 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.027 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS PART_COL_PRIVS ( PART_COLUMN_GRANT_ID bigint(20) NOT NULL, COLUMN_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, CREATE_TIME int(11) NOT NULL, GRANT_OPTION smallint(6) NOT NULL, GRANTOR varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, GRANTOR_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PART_ID bigint(20) DEFAULT NULL, PRINCIPAL_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PART_COL_PRIV varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, AUTHORIZER varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (PART_COLUMN_GRANT_ID), KEY PART_COL_PRIVS_N49 (PART_ID), KEY PARTITIONCOLUMNPRIVILEGEINDEX (AUTHORIZER,PART_ID,COLUMN_NAME,PRINCIPAL_NAME,PRINCIPAL_TYPE,PART_COL_PRIV,GRANTOR,GRANTOR_TYPE), CONSTRAINT PART_COL_PRIVS_FK1 FOREIGN KEY (PART_ID) REFERENCES PARTITIONS (PART_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.107 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.038 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.007 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS PART_PRIVS ( PART_GRANT_ID bigint(20) NOT NULL, CREATE_TIME int(11) NOT NULL, GRANT_OPTION smallint(6) NOT NULL, GRANTOR varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, GRANTOR_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PART_ID bigint(20) DEFAULT NULL, PRINCIPAL_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PART_PRIV varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, AUTHORIZER varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (PART_GRANT_ID), KEY PARTPRIVILEGEINDEX (AUTHORIZER,PART_ID,PRINCIPAL_NAME,PRINCIPAL_TYPE,PART_PRIV,GRANTOR,GRANTOR_TYPE), KEY PART_PRIVS_N49 (PART_ID), CONSTRAINT PART_PRIVS_FK1 FOREIGN KEY (PART_ID) REFERENCES PARTITIONS (PART_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.08 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.01 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.026 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.014 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS ROLES ( ROLE_ID bigint(20) NOT NULL, CREATE_TIME int(11) NOT NULL, OWNER_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, ROLE_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (ROLE_ID), UNIQUE KEY ROLEENTITYINDEX (ROLE_NAME) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.072 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.022 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.024 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS ROLE_MAP ( ROLE_GRANT_ID bigint(20) NOT NULL, ADD_TIME int(11) NOT NULL, GRANT_OPTION smallint(6) NOT NULL, GRANTOR varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, GRANTOR_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, ROLE_ID bigint(20) DEFAULT NULL, PRIMARY KEY (ROLE_GRANT_ID), UNIQUE KEY USERROLEMAPINDEX (PRINCIPAL_NAME,ROLE_ID,GRANTOR,GRANTOR_TYPE), KEY ROLE_MAP_N49 (ROLE_ID), CONSTRAINT ROLE_MAP_FK1 FOREIGN KEY (ROLE_ID) REFERENCES ROLES (ROLE_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.062 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.021 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.018 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SDS ( SD_ID bigint(20) NOT NULL, CD_ID bigint(20) DEFAULT NULL, INPUT_FORMAT varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, IS_COMPRESSED bit(1) NOT NULL, IS_STOREDASSUBDIRECTORIES bit(1) NOT NULL, LOCATION varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, NUM_BUCKETS int(11) NOT NULL, OUTPUT_FORMAT varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, SERDE_ID bigint(20) DEFAULT NULL, PRIMARY KEY (SD_ID), KEY SDS_N49 (SERDE_ID), KEY SDS_N50 (CD_ID), CONSTRAINT SDS_FK1 FOREIGN KEY (SERDE_ID) REFERENCES SERDES (SERDE_ID), CONSTRAINT SDS_FK2 FOREIGN KEY (CD_ID) REFERENCES CDS (CD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.068 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.012 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.014 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SD_PARAMS ( SD_ID bigint(20) NOT NULL, PARAM_KEY varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PARAM_VALUE MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (SD_ID,PARAM_KEY), KEY SD_PARAMS_N49 (SD_ID), CONSTRAINT SD_PARAMS_FK1 FOREIGN KEY (SD_ID) REFERENCES SDS (SD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.068 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.023 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SEQUENCE_TABLE ( SEQUENCE_NAME varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, NEXT_VAL bigint(20) NOT NULL, PRIMARY KEY (SEQUENCE_NAME) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.054 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.011 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.hive.metastore.model.MNotificationLog', 1) 1 row affected (0.074 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.034 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.026 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SERDES ( SERDE_ID bigint(20) NOT NULL, NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, SLIB varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, DESCRIPTION varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, SERIALIZER_CLASS varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, DESERIALIZER_CLASS varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, SERDE_TYPE integer, PRIMARY KEY (SERDE_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.112 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.038 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.01 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.012 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SERDE_PARAMS ( SERDE_ID bigint(20) NOT NULL, PARAM_KEY varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PARAM_VALUE MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (SERDE_ID,PARAM_KEY), KEY SERDE_PARAMS_N49 (SERDE_ID), CONSTRAINT SERDE_PARAMS_FK1 FOREIGN KEY (SERDE_ID) REFERENCES SERDES (SERDE_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.057 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.023 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SKEWED_COL_NAMES ( SD_ID bigint(20) NOT NULL, SKEWED_COL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, INTEGER_IDX int(11) NOT NULL, PRIMARY KEY (SD_ID,INTEGER_IDX), KEY SKEWED_COL_NAMES_N49 (SD_ID), CONSTRAINT SKEWED_COL_NAMES_FK1 FOREIGN KEY (SD_ID) REFERENCES SDS (SD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.063 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.036 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.01 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.024 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SKEWED_COL_VALUE_LOC_MAP ( SD_ID bigint(20) NOT NULL, STRING_LIST_ID_KID bigint(20) NOT NULL, LOCATION varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (SD_ID,STRING_LIST_ID_KID), KEY SKEWED_COL_VALUE_LOC_MAP_N49 (STRING_LIST_ID_KID), KEY SKEWED_COL_VALUE_LOC_MAP_N50 (SD_ID), CONSTRAINT SKEWED_COL_VALUE_LOC_MAP_FK2 FOREIGN KEY (STRING_LIST_ID_KID) REFERENCES SKEWED_STRING_LIST (STRING_LIST_ID), CONSTRAINT SKEWED_COL_VALUE_LOC_MAP_FK1 FOREIGN KEY (SD_ID) REFERENCES SDS (SD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.111 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.023 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.018 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SKEWED_STRING_LIST ( STRING_LIST_ID bigint(20) NOT NULL, PRIMARY KEY (STRING_LIST_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.032 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.023 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SKEWED_STRING_LIST_VALUES ( STRING_LIST_ID bigint(20) NOT NULL, STRING_LIST_VALUE varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, INTEGER_IDX int(11) NOT NULL, PRIMARY KEY (STRING_LIST_ID,INTEGER_IDX), KEY SKEWED_STRING_LIST_VALUES_N49 (STRING_LIST_ID), CONSTRAINT SKEWED_STRING_LIST_VALUES_FK1 FOREIGN KEY (STRING_LIST_ID) REFERENCES SKEWED_STRING_LIST (STRING_LIST_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.073 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.027 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SKEWED_VALUES ( SD_ID_OID bigint(20) NOT NULL, STRING_LIST_ID_EID bigint(20) NOT NULL, INTEGER_IDX int(11) NOT NULL, PRIMARY KEY (SD_ID_OID,INTEGER_IDX), KEY SKEWED_VALUES_N50 (SD_ID_OID), KEY SKEWED_VALUES_N49 (STRING_LIST_ID_EID), CONSTRAINT SKEWED_VALUES_FK2 FOREIGN KEY (STRING_LIST_ID_EID) REFERENCES SKEWED_STRING_LIST (STRING_LIST_ID), CONSTRAINT SKEWED_VALUES_FK1 FOREIGN KEY (SD_ID_OID) REFERENCES SDS (SD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.067 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.026 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.011 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.023 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS SORT_COLS ( SD_ID bigint(20) NOT NULL, COLUMN_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, ORDER int(11) NOT NULL, INTEGER_IDX int(11) NOT NULL, PRIMARY KEY (SD_ID,INTEGER_IDX), KEY SORT_COLS_N49 (SD_ID), CONSTRAINT SORT_COLS_FK1 FOREIGN KEY (SD_ID) REFERENCES SDS (SD_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.071 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.012 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.027 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.009 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS TABLE_PARAMS ( TBL_ID bigint(20) NOT NULL, PARAM_KEY varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PARAM_VALUE MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (TBL_ID,PARAM_KEY), KEY TABLE_PARAMS_N49 (TBL_ID), CONSTRAINT TABLE_PARAMS_FK1 FOREIGN KEY (TBL_ID) REFERENCES TBLS (TBL_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.063 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.02 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.015 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS MV_CREATION_METADATA ( MV_CREATION_METADATA_ID bigint(20) NOT NULL, CAT_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, DB_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, TBL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, TXN_LIST TEXT DEFAULT NULL, MATERIALIZATION_TIME bigint(20) NOT NULL, PRIMARY KEY (MV_CREATION_METADATA_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.065 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.024 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX MV_UNIQUE_TABLE ON MV_CREATION_METADATA (TBL_NAME, DB_NAME) USING BTREE No rows affected (0.275 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.006 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.025 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS TBLS ( TBL_ID bigint(20) NOT NULL, CREATE_TIME int(11) NOT NULL, DB_ID bigint(20) DEFAULT NULL, LAST_ACCESS_TIME int(11) NOT NULL, OWNER varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, OWNER_TYPE varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, RETENTION int(11) NOT NULL, SD_ID bigint(20) DEFAULT NULL, TBL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, TBL_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, VIEW_EXPANDED_TEXT mediumtext, VIEW_ORIGINAL_TEXT mediumtext, IS_REWRITE_ENABLED bit(1) NOT NULL DEFAULT 0, PRIMARY KEY (TBL_ID), UNIQUE KEY UNIQUETABLE (TBL_NAME,DB_ID), KEY TBLS_N50 (SD_ID), KEY TBLS_N49 (DB_ID), CONSTRAINT TBLS_FK1 FOREIGN KEY (SD_ID) REFERENCES SDS (SD_ID), CONSTRAINT TBLS_FK2 FOREIGN KEY (DB_ID) REFERENCES DBS (DB_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.074 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.021 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.02 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS MV_TABLES_USED ( MV_CREATION_METADATA_ID bigint(20) NOT NULL, TBL_ID bigint(20) NOT NULL, CONSTRAINT MV_TABLES_USED_FK1 FOREIGN KEY (MV_CREATION_METADATA_ID) REFERENCES MV_CREATION_METADATA (MV_CREATION_METADATA_ID), CONSTRAINT MV_TABLES_USED_FK2 FOREIGN KEY (TBL_ID) REFERENCES TBLS (TBL_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.135 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.018 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.014 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS TBL_COL_PRIVS ( TBL_COLUMN_GRANT_ID bigint(20) NOT NULL, COLUMN_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, CREATE_TIME int(11) NOT NULL, GRANT_OPTION smallint(6) NOT NULL, GRANTOR varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, GRANTOR_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, TBL_COL_PRIV varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, TBL_ID bigint(20) DEFAULT NULL, AUTHORIZER varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (TBL_COLUMN_GRANT_ID), KEY TABLECOLUMNPRIVILEGEINDEX (AUTHORIZER,TBL_ID,COLUMN_NAME,PRINCIPAL_NAME,PRINCIPAL_TYPE,TBL_COL_PRIV,GRANTOR,GRANTOR_TYPE), KEY TBL_COL_PRIVS_N49 (TBL_ID), CONSTRAINT TBL_COL_PRIVS_FK1 FOREIGN KEY (TBL_ID) REFERENCES TBLS (TBL_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.066 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.097 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.038 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.033 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS TBL_PRIVS ( TBL_GRANT_ID bigint(20) NOT NULL, CREATE_TIME int(11) NOT NULL, GRANT_OPTION smallint(6) NOT NULL, GRANTOR varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, GRANTOR_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRINCIPAL_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, TBL_PRIV varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, TBL_ID bigint(20) DEFAULT NULL, AUTHORIZER varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (TBL_GRANT_ID), KEY TBL_PRIVS_N49 (TBL_ID), KEY TABLEPRIVILEGEINDEX (AUTHORIZER,TBL_ID,PRINCIPAL_NAME,PRINCIPAL_TYPE,TBL_PRIV,GRANTOR,GRANTOR_TYPE), CONSTRAINT TBL_PRIVS_FK1 FOREIGN KEY (TBL_ID) REFERENCES TBLS (TBL_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.127 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.032 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS TAB_COL_STATS ( CS_ID bigint(20) NOT NULL, CAT_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, DB_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, TABLE_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, COLUMN_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, COLUMN_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, TBL_ID bigint(20) NOT NULL, LONG_LOW_VALUE bigint(20), LONG_HIGH_VALUE bigint(20), DOUBLE_HIGH_VALUE double(53,4), DOUBLE_LOW_VALUE double(53,4), BIG_DECIMAL_LOW_VALUE varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin, BIG_DECIMAL_HIGH_VALUE varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin, NUM_NULLS bigint(20) NOT NULL, NUM_DISTINCTS bigint(20), BIT_VECTOR blob, AVG_COL_LEN double(53,4), MAX_COL_LEN bigint(20), NUM_TRUES bigint(20), NUM_FALSES bigint(20), LAST_ANALYZED bigint(20) NOT NULL, PRIMARY KEY (CS_ID), CONSTRAINT TAB_COL_STATS_FK FOREIGN KEY (TBL_ID) REFERENCES TBLS (TBL_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.783 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX TAB_COL_STATS_IDX ON TAB_COL_STATS (CAT_NAME, DB_NAME, TABLE_NAME, COLUMN_NAME) USING BTREE No rows affected (0.126 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS PART_COL_STATS ( CS_ID bigint(20) NOT NULL, CAT_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, DB_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, TABLE_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PARTITION_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, COLUMN_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, COLUMN_TYPE varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, PART_ID bigint(20) NOT NULL, LONG_LOW_VALUE bigint(20), LONG_HIGH_VALUE bigint(20), DOUBLE_HIGH_VALUE double(53,4), DOUBLE_LOW_VALUE double(53,4), BIG_DECIMAL_LOW_VALUE varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin, BIG_DECIMAL_HIGH_VALUE varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin, NUM_NULLS bigint(20) NOT NULL, NUM_DISTINCTS bigint(20), BIT_VECTOR blob, AVG_COL_LEN double(53,4), MAX_COL_LEN bigint(20), NUM_TRUES bigint(20), NUM_FALSES bigint(20), LAST_ANALYZED bigint(20) NOT NULL, PRIMARY KEY (CS_ID), CONSTRAINT PART_COL_STATS_FK FOREIGN KEY (PART_ID) REFERENCES PARTITIONS (PART_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.041 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX PCS_STATS_IDX ON PART_COL_STATS (CAT_NAME, DB_NAME,TABLE_NAME,COLUMN_NAME,PARTITION_NAME) USING BTREE No rows affected (0.042 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.134 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 / No rows affected (0.024 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS TYPES ( TYPES_ID bigint(20) NOT NULL, TYPE_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, TYPE1 varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, TYPE2 varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (TYPES_ID), UNIQUE KEY UNIQUE_TYPE (TYPE_NAME) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.142 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.053 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET @saved_cs_client = @@character_set_client / No rows affected (0.07 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = utf8 */ No rows affected (0.059 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS TYPE_FIELDS ( TYPE_NAME bigint(20) NOT NULL, COMMENT varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, FIELD_NAME varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, FIELD_TYPE varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, INTEGER_IDX int(11) NOT NULL, PRIMARY KEY (TYPE_NAME,FIELD_NAME), KEY TYPE_FIELDS_N49 (TYPE_NAME), CONSTRAINT TYPE_FIELDS_FK1 FOREIGN KEY (TYPE_NAME) REFERENCES TYPES (TYPES_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.072 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS MASTER_KEYS ( KEY_ID INTEGER NOT NULL AUTO_INCREMENT, MASTER_KEY VARCHAR(767) BINARY NULL, PRIMARY KEY (KEY_ID) ) ENGINE=INNODB DEFAULT CHARSET=latin1 No rows affected (0.052 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS DELEGATION_TOKENS ( TOKEN_IDENT VARCHAR(767) BINARY NOT NULL, TOKEN VARCHAR(767) BINARY NULL, PRIMARY KEY (TOKEN_IDENT) ) ENGINE=INNODB DEFAULT CHARSET=latin1 No rows affected (0.042 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS VERSION ( VER_ID BIGINT NOT NULL, SCHEMA_VERSION VARCHAR(127) NOT NULL, VERSION_COMMENT VARCHAR(255), PRIMARY KEY (VER_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.091 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS FUNCS ( FUNC_ID BIGINT(20) NOT NULL, CLASS_NAME VARCHAR(4000) CHARACTER SET latin1 COLLATE latin1_bin, CREATE_TIME INT(11) NOT NULL, DB_ID BIGINT(20), FUNC_NAME VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_bin, FUNC_TYPE INT(11) NOT NULL, OWNER_NAME VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_bin, OWNER_TYPE VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_bin, PRIMARY KEY (FUNC_ID), UNIQUE KEY UNIQUEFUNCTION (FUNC_NAME, DB_ID), KEY FUNCS_N49 (DB_ID), CONSTRAINT FUNCS_FK1 FOREIGN KEY (DB_ID) REFERENCES DBS (DB_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.071 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS FUNC_RU ( FUNC_ID BIGINT(20) NOT NULL, RESOURCE_TYPE INT(11) NOT NULL, RESOURCE_URI VARCHAR(4000) CHARACTER SET latin1 COLLATE latin1_bin, INTEGER_IDX INT(11) NOT NULL, PRIMARY KEY (FUNC_ID, INTEGER_IDX), CONSTRAINT FUNC_RU_FK1 FOREIGN KEY (FUNC_ID) REFERENCES FUNCS (FUNC_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.044 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS NOTIFICATION_LOG ( NL_ID BIGINT(20) NOT NULL, EVENT_ID BIGINT(20) NOT NULL, EVENT_TIME INT(11) NOT NULL, EVENT_TYPE varchar(32) NOT NULL, CAT_NAME varchar(256), DB_NAME varchar(128), TBL_NAME varchar(256), MESSAGE longtext, MESSAGE_FORMAT varchar(16), PRIMARY KEY (NL_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.077 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS NOTIFICATION_SEQUENCE ( NNI_ID BIGINT(20) NOT NULL, NEXT_EVENT_ID BIGINT(20) NOT NULL, PRIMARY KEY (NNI_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.052 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> INSERT INTO NOTIFICATION_SEQUENCE (NNI_ID, NEXT_EVENT_ID) SELECT * from (select 1 as NNI_ID, 1 as NOTIFICATION_SEQUENCE) a WHERE (SELECT COUNT() FROM NOTIFICATION_SEQUENCE) = 0 1 row affected (0.075 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS KEY_CONSTRAINTS ( CHILD_CD_ID BIGINT, CHILD_INTEGER_IDX INT(11), CHILD_TBL_ID BIGINT, PARENT_CD_ID BIGINT, PARENT_INTEGER_IDX INT(11) NOT NULL, PARENT_TBL_ID BIGINT NOT NULL, POSITION BIGINT NOT NULL, CONSTRAINT_NAME VARCHAR(400) NOT NULL, CONSTRAINT_TYPE SMALLINT(6) NOT NULL, UPDATE_RULE SMALLINT(6), DELETE_RULE SMALLINT(6), ENABLE_VALIDATE_RELY SMALLINT(6) NOT NULL, DEFAULT_VALUE VARCHAR(400), PRIMARY KEY (CONSTRAINT_NAME, POSITION) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.033 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX CONSTRAINTS_PARENT_TABLE_ID_INDEX ON KEY_CONSTRAINTS (PARENT_TBL_ID) USING BTREE No rows affected (0.054 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX CONSTRAINTS_CONSTRAINT_TYPE_INDEX ON KEY_CONSTRAINTS (CONSTRAINT_TYPE) USING BTREE No rows affected (0.029 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS METASTORE_DB_PROPERTIES ( PROPERTY_KEY varchar(255) NOT NULL, PROPERTY_VALUE varchar(1000) NOT NULL, DESCRIPTION varchar(1000), PRIMARY KEY(PROPERTY_KEY) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.045 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS WM_RESOURCEPLAN ( RP_ID bigint(20) NOT NULL, NAME varchar(128) NOT NULL, QUERY_PARALLELISM int(11), STATUS varchar(20) NOT NULL, DEFAULT_POOL_ID bigint(20), PRIMARY KEY (RP_ID), UNIQUE KEY UNIQUE_WM_RESOURCEPLAN (NAME) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.055 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS WM_POOL ( POOL_ID bigint(20) NOT NULL, RP_ID bigint(20) NOT NULL, PATH varchar(767) NOT NULL, ALLOC_FRACTION DOUBLE, QUERY_PARALLELISM int(11), SCHEDULING_POLICY varchar(767), PRIMARY KEY (POOL_ID), UNIQUE KEY UNIQUE_WM_POOL (RP_ID, PATH), CONSTRAINT WM_POOL_FK1 FOREIGN KEY (RP_ID) REFERENCES WM_RESOURCEPLAN (RP_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.097 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> ALTER TABLE WM_RESOURCEPLAN ADD CONSTRAINT WM_RESOURCEPLAN_FK1 FOREIGN KEY (DEFAULT_POOL_ID) REFERENCES WM_POOL(POOL_ID) No rows affected (0.039 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS WM_TRIGGER ( TRIGGER_ID bigint(20) NOT NULL, RP_ID bigint(20) NOT NULL, NAME varchar(128) NOT NULL, TRIGGER_EXPRESSION varchar(1024), ACTION_EXPRESSION varchar(1024), IS_IN_UNMANAGED bit(1) NOT NULL DEFAULT 0, PRIMARY KEY (TRIGGER_ID), UNIQUE KEY UNIQUE_WM_TRIGGER (RP_ID, NAME), CONSTRAINT WM_TRIGGER_FK1 FOREIGN KEY (RP_ID) REFERENCES WM_RESOURCEPLAN (RP_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.037 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS WM_POOL_TO_TRIGGER ( POOL_ID bigint(20) NOT NULL, TRIGGER_ID bigint(20) NOT NULL, PRIMARY KEY (POOL_ID, TRIGGER_ID), CONSTRAINT WM_POOL_TO_TRIGGER_FK1 FOREIGN KEY (POOL_ID) REFERENCES WM_POOL (POOL_ID), CONSTRAINT WM_POOL_TO_TRIGGER_FK2 FOREIGN KEY (TRIGGER_ID) REFERENCES WM_TRIGGER (TRIGGER_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.064 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE IF NOT EXISTS WM_MAPPING ( MAPPING_ID bigint(20) NOT NULL, RP_ID bigint(20) NOT NULL, ENTITY_TYPE varchar(128) NOT NULL, ENTITY_NAME varchar(128) NOT NULL, POOL_ID bigint(20), ORDERING int, PRIMARY KEY (MAPPING_ID), UNIQUE KEY UNIQUE_WM_MAPPING (RP_ID, ENTITY_TYPE, ENTITY_NAME), CONSTRAINT WM_MAPPING_FK1 FOREIGN KEY (RP_ID) REFERENCES WM_RESOURCEPLAN (RP_ID), CONSTRAINT WM_MAPPING_FK2 FOREIGN KEY (POOL_ID) REFERENCES WM_POOL (POOL_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.091 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE TXNS ( TXN_ID bigint PRIMARY KEY, TXN_STATE char(1) NOT NULL, TXN_STARTED bigint NOT NULL, TXN_LAST_HEARTBEAT bigint NOT NULL, TXN_USER varchar(128) NOT NULL, TXN_HOST varchar(128) NOT NULL, TXN_AGENT_INFO varchar(128), TXN_META_INFO varchar(128), TXN_HEARTBEAT_COUNT int, TXN_TYPE int ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.105 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE TXN_COMPONENTS ( TC_TXNID bigint NOT NULL, TC_DATABASE varchar(128) NOT NULL, TC_TABLE varchar(128), TC_PARTITION varchar(767), TC_OPERATION_TYPE char(1) NOT NULL, TC_WRITEID bigint, FOREIGN KEY (TC_TXNID) REFERENCES TXNS (TXN_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.068 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX TC_TXNID_INDEX ON TXN_COMPONENTS (TC_TXNID) No rows affected (0.081 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID bigint NOT NULL, CTC_DATABASE varchar(128) NOT NULL, CTC_TABLE varchar(256), CTC_PARTITION varchar(767), CTC_TIMESTAMP timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL, CTC_WRITEID bigint, CTC_UPDATE_DELETE char(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.031 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX COMPLETED_TXN_COMPONENTS_IDX ON COMPLETED_TXN_COMPONENTS (CTC_DATABASE, CTC_TABLE, CTC_PARTITION) USING BTREE No rows affected (0.009 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE NEXT_TXN_ID ( NTXN_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> INSERT INTO NEXT_TXN_ID VALUES(1) 1 row affected (0.006 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE HIVE_LOCKS ( HL_LOCK_EXT_ID bigint NOT NULL, HL_LOCK_INT_ID bigint NOT NULL, HL_TXNID bigint NOT NULL, HL_DB varchar(128) NOT NULL, HL_TABLE varchar(128), HL_PARTITION varchar(767), HL_LOCK_STATE char(1) not null, HL_LOCK_TYPE char(1) not null, HL_LAST_HEARTBEAT bigint NOT NULL, HL_ACQUIRED_AT bigint, HL_USER varchar(128) NOT NULL, HL_HOST varchar(128) NOT NULL, HL_HEARTBEAT_COUNT int, HL_AGENT_INFO varchar(128), HL_BLOCKEDBY_EXT_ID bigint, HL_BLOCKEDBY_INT_ID bigint, PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID), KEY HIVE_LOCK_TXNID_INDEX (HL_TXNID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.069 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX HL_TXNID_IDX ON HIVE_LOCKS (HL_TXNID) No rows affected (0.023 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE NEXT_LOCK_ID ( NL_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> INSERT INTO NEXT_LOCK_ID VALUES(1) 1 row affected (0.004 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE COMPACTION_QUEUE ( CQ_ID bigint PRIMARY KEY, CQ_DATABASE varchar(128) NOT NULL, CQ_TABLE varchar(128) NOT NULL, CQ_PARTITION varchar(767), CQ_STATE char(1) NOT NULL, CQ_TYPE char(1) NOT NULL, CQ_TBLPROPERTIES varchar(2048), CQ_WORKER_ID varchar(128), CQ_START bigint, CQ_RUN_AS varchar(128), CQ_HIGHEST_WRITE_ID bigint, CQ_META_INFO varbinary(2048), CQ_HADOOP_JOB_ID varchar(32) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.02 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE COMPLETED_COMPACTIONS ( CC_ID bigint PRIMARY KEY, CC_DATABASE varchar(128) NOT NULL, CC_TABLE varchar(128) NOT NULL, CC_PARTITION varchar(767), CC_STATE char(1) NOT NULL, CC_TYPE char(1) NOT NULL, CC_TBLPROPERTIES varchar(2048), CC_WORKER_ID varchar(128), CC_START bigint, CC_END bigint, CC_RUN_AS varchar(128), CC_HIGHEST_WRITE_ID bigint, CC_META_INFO varbinary(2048), CC_HADOOP_JOB_ID varchar(32) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.061 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.041 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1) 1 row affected (0.023 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE AUX_TABLE ( MT_KEY1 varchar(128) NOT NULL, MT_KEY2 bigint NOT NULL, MT_COMMENT varchar(255), PRIMARY KEY(MT_KEY1, MT_KEY2) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.072 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE WRITE_SET ( WS_DATABASE varchar(128) NOT NULL, WS_TABLE varchar(128) NOT NULL, WS_PARTITION varchar(767), WS_TXNID bigint NOT NULL, WS_COMMIT_ID bigint NOT NULL, WS_OPERATION_TYPE char(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.078 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE TXN_TO_WRITE_ID ( T2W_TXNID bigint NOT NULL, T2W_DATABASE varchar(128) NOT NULL, T2W_TABLE varchar(256) NOT NULL, T2W_WRITEID bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.038 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE UNIQUE INDEX TBL_TO_TXN_ID_IDX ON TXN_TO_WRITE_ID (T2W_DATABASE, T2W_TABLE, T2W_TXNID) No rows affected (0.196 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE UNIQUE INDEX TBL_TO_WRITE_ID_IDX ON TXN_TO_WRITE_ID (T2W_DATABASE, T2W_TABLE, T2W_WRITEID) No rows affected (0.068 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE NEXT_WRITE_ID ( NWI_DATABASE varchar(128) NOT NULL, NWI_TABLE varchar(256) NOT NULL, NWI_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.028 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE UNIQUE INDEX NEXT_WRITE_ID_IDX ON NEXT_WRITE_ID (NWI_DATABASE, NWI_TABLE) No rows affected (0.037 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE MIN_HISTORY_LEVEL ( MHL_TXNID bigint NOT NULL, MHL_MIN_OPEN_TXNID bigint NOT NULL, PRIMARY KEY(MHL_TXNID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.021 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX MIN_HISTORY_LEVEL_IDX ON MIN_HISTORY_LEVEL (MHL_MIN_OPEN_TXNID) No rows affected (0.039 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE MATERIALIZATION_REBUILD_LOCKS ( MRL_TXN_ID bigint NOT NULL, MRL_DB_NAME VARCHAR(128) NOT NULL, MRL_TBL_NAME VARCHAR(256) NOT NULL, MRL_LAST_HEARTBEAT bigint NOT NULL, PRIMARY KEY(MRL_TXN_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.024 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE I_SCHEMA ( SCHEMA_ID BIGINT PRIMARY KEY, SCHEMA_TYPE INTEGER NOT NULL, NAME VARCHAR(256), DB_ID BIGINT, COMPATIBILITY INTEGER NOT NULL, VALIDATION_LEVEL INTEGER NOT NULL, CAN_EVOLVE bit(1) NOT NULL, SCHEMA_GROUP VARCHAR(256), DESCRIPTION VARCHAR(4000), FOREIGN KEY (DB_ID) REFERENCES DBS (DB_ID), KEY UNIQUE_NAME (NAME) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.059 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE SCHEMA_VERSION ( SCHEMA_VERSION_ID bigint primary key, SCHEMA_ID BIGINT, VERSION INTEGER NOT NULL, CREATED_AT BIGINT NOT NULL, CD_ID BIGINT, STATE INTEGER NOT NULL, DESCRIPTION VARCHAR(4000), SCHEMA_TEXT mediumtext, FINGERPRINT VARCHAR(256), SCHEMA_VERSION_NAME VARCHAR(256), SERDE_ID bigint, FOREIGN KEY (SCHEMA_ID) REFERENCES I_SCHEMA (SCHEMA_ID), FOREIGN KEY (CD_ID) REFERENCES CDS (CD_ID), FOREIGN KEY (SERDE_ID) REFERENCES SERDES (SERDE_ID), KEY UNIQUE_VERSION (SCHEMA_ID, VERSION) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.064 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE REPL_TXN_MAP ( RTM_REPL_POLICY varchar(256) NOT NULL, RTM_SRC_TXN_ID bigint NOT NULL, RTM_TARGET_TXN_ID bigint NOT NULL, PRIMARY KEY (RTM_REPL_POLICY, RTM_SRC_TXN_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.057 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE TABLE RUNTIME_STATS ( RS_ID bigint primary key, CREATE_TIME bigint NOT NULL, WEIGHT bigint NOT NULL, PAYLOAD blob ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.069 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> CREATE INDEX IDX_RUNTIME_STATS_CREATE_TIME ON RUNTIME_STATS(CREATE_TIME) No rows affected (0.043 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '3.1.0', 'Hive release version 3.1.0') 1 row affected (0.018 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET character_set_client = @saved_cs_client / No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40103 SET TIME_ZONE=@OLD_TIME_ZONE / No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET SQL_MODE=@OLD_SQL_MODE / No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS / No rows affected (0.006 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS / No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT / No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS / No rows affected (0.007 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION / No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> /!40111 SET SQL_NOTES=@OLD_SQL_NOTES */ No rows affected (0.007 seconds) 0: jdbc:mysql://hadoop102:3306/metastore> !closeall Closing: 0: jdbc:mysql://hadoop102:3306/metastore?useSSL=false beeline> beeline> Initialization script completed schemaTool completed
- 启动 Hive
bin/hive [root@hadoop102 hive]# bin/hive
- 使用 Hive
show databases; hive> show tables; create table test (id int); insert into test values(1); select * from test; hive> show databases; OK default Time taken: 2.607 seconds, Fetched: 1 row(s) hive> show tables; OK Time taken: 1.05 seconds hive> create table test (id int); OK Time taken: 3.408 seconds hive> insert into test values(1); Query ID = root_20220903214837_11ed3d2f-fd06-4629-918a-79397829efc3 Total jobs = 3 Launching Job 1 out of 3 Number of reduce tasks determined at compile time: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapreduce.job.reduces=<number> Starting Job = job_1662205222295_0002, Tracking URL = http://hadoop103:8088/proxy/application_1662205222295_0002/ Kill Command = /opt/module/hadoop-3.1.3/bin/mapred job -kill job_1662205222295_0002 Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1 2022-09-03 21:51:43,684 Stage-1 map = 0%, reduce = 0% 2022-09-03 21:52:44,098 Stage-1 map = 0%, reduce = 0% 2022-09-03 21:53:28,113 Stage-1 map = 100%, reduce = 0% 2022-09-03 21:53:30,344 Stage-1 map = 100%, reduce = 100% Ended Job = job_1662205222295_0002 with errors Error during job, obtaining debugging information... Examining task ID: task_1662205222295_0002_m_000000 (and more) from job job_1662205222295_0002 Task with the most failures(4): ----- Task ID: task_1662205222295_0002_m_000000 URL: http://hadoop103:8088/taskdetails.jsp?jobid=job_1662205222295_0002&tipid=task_1662205222295_0002_m_000000 ----- Diagnostic Messages for this Task: [2022-09-03 09:53:11.576]Container [pid=4096,containerID=container_1662205222295_0002_02_000005] is running 219134464B beyond the 'VIRTUAL' memory limit. Current usage: 27.6 MB of 1 GB physical memory used; 2.3 GB of 2.1 GB virtual memory used. Killing container. Dump of the process-tree for container_1662205222295_0002_02_000005 : |- PID PPID PGRPID SESSID CMD_NAME USER_MODE_TIME(MILLIS) SYSTEM_TIME(MILLIS) VMEM_USAGE(BYTES) RSSMEM_USAGE(PAGES) FULL_CMD_LINE |- 4096 4094 4096 4096 (bash) 0 1 9789440 53 /bin/bash -c /opt/module/jdk1.8.0_212/bin/java -Djava.net.preferIPv4Stack=true -Dhadoop.metrics.log.level=WARN -Xmx820m -Djava.io.tmpdir=/opt/module/hadoop-3.1.3/data/nm-local-dir/usercache/root/appcache/application_1662205222295_0002/container_1662205222295_0002_02_000005/tmp -Dlog4j.configuration=container-log4j.properties -Dyarn.app.container.log.dir=/opt/module/hadoop-3.1.3/logs/userlogs/application_1662205222295_0002/container_1662205222295_0002_02_000005 -Dyarn.app.container.log.filesize=0 -Dhadoop.root.logger=INFO,CLA -Dhadoop.root.logfile=syslog org.apache.hadoop.mapred.YarnChild 192.168.10.103 37549 attempt_1662205222295_0002_m_000000_1003 5 1>/opt/module/hadoop-3.1.3/logs/userlogs/application_1662205222295_0002/container_1662205222295_0002_02_000005/stdout 2>/opt/module/hadoop-3.1.3/logs/userlogs/application_1662205222295_0002/container_1662205222295_0002_02_000005/stderr |- 4108 4096 4096 4096 (java) 47 82 2464202752 7007 /opt/module/jdk1.8.0_212/bin/java -Djava.net.preferIPv4Stack=true -Dhadoop.metrics.log.level=WARN -Xmx820m -Djava.io.tmpdir=/opt/module/hadoop-3.1.3/data/nm-local-dir/usercache/root/appcache/application_1662205222295_0002/container_1662205222295_0002_02_000005/tmp -Dlog4j.configuration=container-log4j.properties -Dyarn.app.container.log.dir=/opt/module/hadoop-3.1.3/logs/userlogs/application_1662205222295_0002/container_1662205222295_0002_02_000005 -Dyarn.app.container.log.filesize=0 -Dhadoop.root.logger=INFO,CLA -Dhadoop.root.logfile=syslog org.apache.hadoop.mapred.YarnChild 192.168.10.103 37549 attempt_1662205222295_0002_m_000000_1003 5 [2022-09-03 09:53:21.706]Container killed on request. Exit code is 143 [2022-09-03 09:53:24.354]Container exited with a non-zero exit code 143. FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask MapReduce Jobs Launched: Stage-Stage-1: Map: 1 Reduce: 1 HDFS Read: 0 HDFS Write: 0 FAIL Total MapReduce CPU Time Spent: 0 msec
Ended Job = job_1662205222295_0004 with errors Error during job, obtaining debugging information...
报错了
设置成本地模式来执行任务
set hive.exec.mode.local.auto=true;
insert into test values(1); hive> insert into test values(1); Query ID = root_20220903215934_321f6ae9-3b33-4760-a7e8-caecf993261b Total jobs = 3 Launching Job 1 out of 3 Number of reduce tasks determined at compile time: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapreduce.job.reduces=<number> Starting Job = job_1662205222295_0003, Tracking URL = http://hadoop103:8088/proxy/application_1662205222295_0003/ Kill Command = /opt/module/hadoop-3.1.3/bin/mapred job -kill job_1662205222295_0003 Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0 2022-09-03 22:00:16,509 Stage-1 map = 0%, reduce = 0% Ended Job = job_1662205222295_0003 with errors Error during job, obtaining debugging information... FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask MapReduce Jobs Launched: Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 FAIL Total MapReduce CPU Time Spent: 0 msec hive> show databases; OK default Time taken: 10.97 seconds, Fetched: 1 row(s) hive> show tables; OK test Time taken: 1.876 seconds, Fetched: 1 row(s) hive> select * from test; OK Time taken: 20.687 seconds hive> select * from aa; FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'aa' hive> insert into test values(2); Query ID = root_20220903220349_18c0e219-b910-4ad5-888e-c13e9c29e862 Total jobs = 3 Launching Job 1 out of 3 Number of reduce tasks determined at compile time: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapreduce.job.reduces=<number> Starting Job = job_1662205222295_0004, Tracking URL = http://hadoop103:8088/proxy/application_1662205222295_0004/ Kill Command = /opt/module/hadoop-3.1.3/bin/mapred job -kill job_1662205222295_0004 Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0 2022-09-03 22:05:12,905 Stage-1 map = 0%, reduce = 0% Ended Job = job_1662205222295_0004 with errors Error during job, obtaining debugging information... FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask MapReduce Jobs Launched: Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 FAIL Total MapReduce CPU Time Spent: 0 msec hive> set hive.exec.mode.local.auto=true; hive> insert into test values(1); Automatically selecting local only mode for query Query ID = root_20220903221014_1991c120-bf74-4c1d-8480-e1b864444c9e Total jobs = 3 Launching Job 1 out of 3 Number of reduce tasks determined at compile time: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapreduce.job.reduces=<number> Job running in-process (local Hadoop) 2022-09-03 22:12:08,255 Stage-1 map = 0%, reduce = 0% 2022-09-03 22:13:08,362 Stage-1 map = 0%, reduce = 0% 2022-09-03 22:13:20,677 Stage-1 map = 100%, reduce = 0% 2022-09-03 22:13:29,391 Stage-1 map = 100%, reduce = 100% Ended Job = job_local1918528075_0001 Stage-4 is selected by condition resolver. Stage-3 is filtered out by condition resolver. Stage-5 is filtered out by condition resolver. Moving data to directory hdfs://hadoop102:8020/user/hive/warehouse/test/.hive-staging_hive_2022-09-03_22-10-24_352_8602553054183447750-1/-ext-10000 Loading data to table default.test MapReduce Jobs Launched: Stage-Stage-1: HDFS Read: 0 HDFS Write: 245780425 SUCCESS Total MapReduce CPU Time Spent: 0 msec OK Time taken: 201.902 seconds
- 使用元数据服务的方式访问 Hive
在hive-site.xml文件中添加如下配置信息
<!-- 指定存储元数据要连接的地址 --> <property> <name>hive.metastore.uris</name> <value>thrift://hadoop102:9083</value> </property>
在 sublime 中加载一个 sftp 插件就行了
- 开启 hive 端口服务（他是一个前台进程）
bin/hive --service metastore
- 使用 JDBC 方式访问 Hive
在 hive-site.xml 文件中添加如下配置信息
<!-- 指定 hiveserver2 连接的 host --> <property> <name>hive.server2.thrift.bind.host</name> <value>hadoop102</value> </property> <!-- 指定 hiveserver2 连接的端口号 --> <property> <name>hive.server2.thrift.port</name> <value>10000</value> </property>
- 启动 hiveserver2
bin/hive --service hiveserver2
- 启动 beeline 客户端（需要多等待一会）
bin/beeline -u jdbc:hive2://hadoop102:10000 -n root
- 在现在使用的最新的 hive-2.3.3 版本中：都需要对 hadoop 集群做如下改变，否则无法使用
修改 hadoop 集群的 hdfs-site.xml 配置文件
<property> <name>dfs.webhdfs.enabled</name> <value>true</value> </property>
修改 hadoop 集群的 core-site.xml 配置文件
<property> <name>hadoop.proxyuser.hadoop.hosts</name> <value>*</value> </property> <property> <name>hadoop.proxyuser.hadoop.groups</name> <value>*</value> </property>
重启属性
/opt/module/hadoop-3.1.3/bin/hdfs dfsadmin -refreshSuperUserGroupsConfiguration bin/yarn rmadmin –refreshSuperUserGroupsConfiguration /opt/module/hadoop-3.1.3/bin/yarn rmadmin -refreshSuperUserGroupsConfiguration
结果
[root@hadoop102 hive]# bin/beeline Beeline version 3.1.2 by Apache Hive beeline> !connect jdbc:hive2://hadoop102:10000 Connecting to jdbc:hive2://hadoop102:10000 Enter username for jdbc:hive2://hadoop102:10000: root Enter password for jdbc:hive2://hadoop102:10000: ****** Connected to: Apache Hive (version 3.1.2) Driver: Hive JDBC (version 3.1.2) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://hadoop102:10000>
- 查看日志
cat /tmp/root/hive.log
- 编写脚本来管理服务的启动和关闭
#!/bin/bash HIVE_LOG_DIR=$HIVE_HOME/logs if [ ! -d $HIVE_LOG_DIR ] then mkdir -p $HIVE_LOG_DIR fi #检查进程是否运行正常，参数 1 为进程名，参数 2 为进程端口 function check_process() { pid=$(ps -ef 2>/dev/null | grep -v grep | grep -i $1 | awk '{print$2}') ppid=$(netstat -nltp 2>/dev/null | grep $2 | awk '{print $7}' | cut - d '/' -f 1) echo $pid [[ "$pid" =~ "$ppid" ]] && [ "$ppid" ] && return 0 || return 1 } function hive_start() { metapid=$(check_process HiveMetastore 9083) cmd="nohup hive --service metastore >$HIVE_LOG_DIR/metastore.log 2>&1 &" [ -z "$metapid" ] && eval $cmd || echo "Metastroe 服务已启动" server2pid=$(check_process HiveServer2 10000) cmd="nohup hiveserver2 >$HIVE_LOG_DIR/hiveServer2.log 2>&1 &" [ -z "$server2pid" ] && eval $cmd || echo "HiveServer2 服务已启动" } function hive_stop() { metapid=$(check_process HiveMetastore 9083) [ "$metapid" ] && kill $metapid || echo "Metastore 服务未启动" server2pid=$(check_process HiveServer2 10000) [ "$server2pid" ] && kill $server2pid || echo "HiveServer2 服务未启动" } case $1 in "start") hive_start ;; "stop") hive_stop ;; "restart") hive_stop sleep 2 hive_start ;; "status") check_process HiveMetastore 9083 >/dev/null && echo "Metastore 服务运行 正常" || echo "Metastore 服务运行异常" check_process HiveServer2 10000 >/dev/null && echo "HiveServer2 服务运 行正常" || echo "HiveServer2 服务运行异常" ;; *) echo Invalid Args! echo 'Usage: '$(basename $0)' start|stop|restart|status' ;; esac
ps -ef | grep -v grep | grep HiveMetastore bin/hive --service metastore ps -ef | grep -v grep | grep -i HiveMetastore ps -ef | grep -i HiveMetastore
查看 RunJar 进程
ps -ef | grep -v grep | grep -i HiveMetastore | awk '{print $2}'
netstat -nltp
netstat -nltp | grep -i 9083
netstat -nltp | grep -i 9083 | awk '{print $7}'
netstat -nltp | grep -i 9083 | awk '{print $7}' | cut -d '/' -f 1
netstat -nltp | grep -i 9083 | awk '{print $7}' | cut -d '/' -f 1 | xargs kill
[root@hadoop102 hive]# bin/hive -help usage: hive -d,--define <key=value> Variable subsitution to apply to hive commands. e.g. -d A=B or --define A=B --database <databasename> Specify the database to use -e <quoted-query-string> SQL from command line -f <filename> SQL from files -H,--help Print help information --hiveconf <property=value> Use value for given property --hivevar <key=value> Variable subsitution to apply to hive commands. e.g. --hivevar A=B -i <filename> Initialization SQL file -S,--silent Silent mode in interactive shell -v,--verbose Verbose mode (echo executed SQL to the console)
- “-e”不进入 hive 的交互窗口执行 sql 语句
[root@hadoop102 hive]# bin/hive -e "select id from test;"
- “-f ”执行脚本中 sql 语句
1.在/opt/module/hive/下创建 datas 目录并在 datas 目录下创建 hivef.sql 文件
[root@hadoop102 datas]# touch hivef.sql
2. 文件中写入正确的 sql 语句
select *from test;
3.执行文件中的 sql 语句
[root@hadoop102 hive]# bin/hive -f /opt/module/hive/datas/hivef.sql
4.执行文件中的 sql 语句并将结果写入文件中
[root@hadoop102 hive]# bin/hive -f /opt/module/hive/datas/hivef.sql > /opt/module/datas/hive_result.txt
- 重装
[root@master lib]# cd $HADOOP_HOME [root@master hadoop-2.6.1]# find ./ -name jlin*.jar ./share/hadoop/kms/tomcat/webapps/kms/WEB-INF/lib/jline-0.9.94.jar ./share/hadoop/httpfs/tomcat/webapps/webhdfs/WEB-INF/lib/jline-0.9.94.jar ./share/hadoop/yarn/lib/jline-0.9.94.jar（需要删除）
cp lib/jline-2.12.jar $HADOOP_HOME/share/hadoop/yarn/lib
mv lib/jline-2.12.jar /usr/local/src/hadoop-2.6.1/share/hadoop/yarn/lib/
[root@master src]# tar -zxvf /opt/software/apache-hive-1.2.2-bin.tar.gz -C /usr/local/src/ apache-hive-1.2.2-bin/LICENSE apache-hive-1.2.2-bin/NOTICE apache-hive-1.2.2-bin/README.txt apache-hive-1.2.2-bin/RELEASE_NOTES.txt apache-hive-1.2.2-bin/examples/files/2000_cols_data.csv apache-hive-1.2.2-bin/examples/files/agg_01-p1.txt apache-hive-1.2.2-bin/examples/files/agg_01-p2.txt apache-hive-1.2.2-bin/examples/files/agg_01-p3.txt apache-hive-1.2.2-bin/examples/files/alltypes.txt apache-hive-1.2.2-bin/examples/files/alltypes2.txt apache-hive-1.2.2-bin/examples/files/apache.access.2.log apache-hive-1.2.2-bin/examples/files/apache.access.log apache-hive-1.2.2-bin/examples/files/archive_corrupt.rc apache-hive-1.2.2-bin/examples/files/array_table.txt apache-hive-1.2.2-bin/examples/files/avro_charvarchar.txt apache-hive-1.2.2-bin/examples/files/avro_date.txt apache-hive-1.2.2-bin/examples/files/avro_timestamp.txt apache-hive-1.2.2-bin/examples/files/AvroPrimitiveInList.parquet apache-hive-1.2.2-bin/examples/files/AvroSingleFieldGroupInList.parquet apache-hive-1.2.2-bin/examples/files/binary.txt apache-hive-1.2.2-bin/examples/files/bool.txt apache-hive-1.2.2-bin/examples/files/bool_literal.txt apache-hive-1.2.2-bin/examples/files/cbo_t1.txt apache-hive-1.2.2-bin/examples/files/cbo_t2.txt apache-hive-1.2.2-bin/examples/files/cbo_t3.txt apache-hive-1.2.2-bin/examples/files/cbo_t4.txt apache-hive-1.2.2-bin/examples/files/cbo_t5.txt apache-hive-1.2.2-bin/examples/files/cbo_t6.txt apache-hive-1.2.2-bin/examples/files/char_varchar_udf.txt apache-hive-1.2.2-bin/examples/files/complex.seq apache-hive-1.2.2-bin/examples/files/covar_tab.txt apache-hive-1.2.2-bin/examples/files/create_nested_type.txt apache-hive-1.2.2-bin/examples/files/csv.txt apache-hive-1.2.2-bin/examples/files/customer_address.txt apache-hive-1.2.2-bin/examples/files/data_with_escape.txt apache-hive-1.2.2-bin/examples/files/datatypes.txt apache-hive-1.2.2-bin/examples/files/dec.avro apache-hive-1.2.2-bin/examples/files/dec.parq apache-hive-1.2.2-bin/examples/files/dec.txt apache-hive-1.2.2-bin/examples/files/dec_comp.txt apache-hive-1.2.2-bin/examples/files/decimal.txt apache-hive-1.2.2-bin/examples/files/decimal_10_0.txt apache-hive-1.2.2-bin/examples/files/dept.txt apache-hive-1.2.2-bin/examples/files/dim-data.txt apache-hive-1.2.2-bin/examples/files/dim_shops.txt apache-hive-1.2.2-bin/examples/files/doctors.avro apache-hive-1.2.2-bin/examples/files/docurl.txt apache-hive-1.2.2-bin/examples/files/double.txt apache-hive-1.2.2-bin/examples/files/dynamic_partition_insert.txt apache-hive-1.2.2-bin/examples/files/dynpart_test.txt apache-hive-1.2.2-bin/examples/files/emp.txt apache-hive-1.2.2-bin/examples/files/employee.dat apache-hive-1.2.2-bin/examples/files/employee2.dat apache-hive-1.2.2-bin/examples/files/employee_part.txt apache-hive-1.2.2-bin/examples/files/empty1.txt apache-hive-1.2.2-bin/examples/files/empty2.txt apache-hive-1.2.2-bin/examples/files/episodes.avro apache-hive-1.2.2-bin/examples/files/escapetest.txt apache-hive-1.2.2-bin/examples/files/extrapolate_stats_full.txt apache-hive-1.2.2-bin/examples/files/extrapolate_stats_partial.txt apache-hive-1.2.2-bin/examples/files/extrapolate_stats_partial_ndv.txt apache-hive-1.2.2-bin/examples/files/fact-data.txt apache-hive-1.2.2-bin/examples/files/flights_join.txt apache-hive-1.2.2-bin/examples/files/flights_tiny.txt apache-hive-1.2.2-bin/examples/files/flights_tiny.txt.1 apache-hive-1.2.2-bin/examples/files/futurama_episodes.avro apache-hive-1.2.2-bin/examples/files/grad.avsc apache-hive-1.2.2-bin/examples/files/groupby_groupingid.txt apache-hive-1.2.2-bin/examples/files/grouping_sets.txt apache-hive-1.2.2-bin/examples/files/grouping_sets1.txt apache-hive-1.2.2-bin/examples/files/grouping_sets2.txt apache-hive-1.2.2-bin/examples/files/hive_626_bar.txt apache-hive-1.2.2-bin/examples/files/hive_626_count.txt apache-hive-1.2.2-bin/examples/files/hive_626_foo.txt apache-hive-1.2.2-bin/examples/files/HiveGroup.parquet apache-hive-1.2.2-bin/examples/files/HiveRequiredGroupInList.parquet apache-hive-1.2.2-bin/examples/files/in1.txt apache-hive-1.2.2-bin/examples/files/in2.txt apache-hive-1.2.2-bin/examples/files/in3.txt apache-hive-1.2.2-bin/examples/files/in4.txt apache-hive-1.2.2-bin/examples/files/in5.txt apache-hive-1.2.2-bin/examples/files/in6.txt apache-hive-1.2.2-bin/examples/files/in7.txt apache-hive-1.2.2-bin/examples/files/in8.txt apache-hive-1.2.2-bin/examples/files/in9.txt apache-hive-1.2.2-bin/examples/files/in_file.dat apache-hive-1.2.2-bin/examples/files/infer_const_type.txt apache-hive-1.2.2-bin/examples/files/input.txt apache-hive-1.2.2-bin/examples/files/int.txt apache-hive-1.2.2-bin/examples/files/json.txt apache-hive-1.2.2-bin/examples/files/keystore.jks apache-hive-1.2.2-bin/examples/files/keystore_exampledotcom.jks apache-hive-1.2.2-bin/examples/files/kv1.seq apache-hive-1.2.2-bin/examples/files/kv1.string-sorted.txt apache-hive-1.2.2-bin/examples/files/kv1.txt apache-hive-1.2.2-bin/examples/files/kv1.val.sorted.txt apache-hive-1.2.2-bin/examples/files/kv10.txt apache-hive-1.2.2-bin/examples/files/kv1_broken.seq apache-hive-1.2.2-bin/examples/files/kv1_cb.txt apache-hive-1.2.2-bin/examples/files/kv1_cc.txt apache-hive-1.2.2-bin/examples/files/kv1kv2.cogroup.txt apache-hive-1.2.2-bin/examples/files/kv2.txt apache-hive-1.2.2-bin/examples/files/kv3.txt apache-hive-1.2.2-bin/examples/files/kv4.txt apache-hive-1.2.2-bin/examples/files/kv5.txt apache-hive-1.2.2-bin/examples/files/kv6.txt apache-hive-1.2.2-bin/examples/files/kv7.txt apache-hive-1.2.2-bin/examples/files/kv8.txt apache-hive-1.2.2-bin/examples/files/kv9.txt apache-hive-1.2.2-bin/examples/files/leftsemijoin_mr_t1.txt apache-hive-1.2.2-bin/examples/files/leftsemijoin_mr_t2.txt apache-hive-1.2.2-bin/examples/files/lineitem.txt apache-hive-1.2.2-bin/examples/files/loc.txt apache-hive-1.2.2-bin/examples/files/location.txt apache-hive-1.2.2-bin/examples/files/lt100.sorted.txt apache-hive-1.2.2-bin/examples/files/lt100.txt apache-hive-1.2.2-bin/examples/files/lt100.txt.deflate apache-hive-1.2.2-bin/examples/files/map_null_schema.avro apache-hive-1.2.2-bin/examples/files/map_null_val.avro apache-hive-1.2.2-bin/examples/files/map_table.txt apache-hive-1.2.2-bin/examples/files/mapNull.txt apache-hive-1.2.2-bin/examples/files/MultiFieldGroupInList.parquet apache-hive-1.2.2-bin/examples/files/nested_complex.txt apache-hive-1.2.2-bin/examples/files/nestedcomplex_additional.txt apache-hive-1.2.2-bin/examples/files/NestedMap.parquet apache-hive-1.2.2-bin/examples/files/NewOptionalGroupInList.parquet apache-hive-1.2.2-bin/examples/files/NewRequiredGroupInList.parquet apache-hive-1.2.2-bin/examples/files/non_ascii_tbl.txt apache-hive-1.2.2-bin/examples/files/null.txt apache-hive-1.2.2-bin/examples/files/nullfile.txt apache-hive-1.2.2-bin/examples/files/nulls.txt apache-hive-1.2.2-bin/examples/files/opencsv-data.txt apache-hive-1.2.2-bin/examples/files/orc_create.txt apache-hive-1.2.2-bin/examples/files/orc_create_people.txt apache-hive-1.2.2-bin/examples/files/orc_split_elim.orc apache-hive-1.2.2-bin/examples/files/parquet_array_null_element.txt apache-hive-1.2.2-bin/examples/files/parquet_columnar.txt apache-hive-1.2.2-bin/examples/files/parquet_create.txt apache-hive-1.2.2-bin/examples/files/parquet_external_time.parq apache-hive-1.2.2-bin/examples/files/parquet_partitioned.txt apache-hive-1.2.2-bin/examples/files/parquet_types.txt apache-hive-1.2.2-bin/examples/files/part.rc apache-hive-1.2.2-bin/examples/files/part.seq apache-hive-1.2.2-bin/examples/files/part_tiny.txt apache-hive-1.2.2-bin/examples/files/person age.txt apache-hive-1.2.2-bin/examples/files/person+age.txt apache-hive-1.2.2-bin/examples/files/posexplode_data.txt apache-hive-1.2.2-bin/examples/files/primitive_type_arrays.txt apache-hive-1.2.2-bin/examples/files/ProxyAuth.res apache-hive-1.2.2-bin/examples/files/pw17.txt apache-hive-1.2.2-bin/examples/files/sales.txt apache-hive-1.2.2-bin/examples/files/sample-queryplan-in-history.txt apache-hive-1.2.2-bin/examples/files/sample-queryplan.txt apache-hive-1.2.2-bin/examples/files/sample.json apache-hive-1.2.2-bin/examples/files/SingleFieldGroupInList.parquet apache-hive-1.2.2-bin/examples/files/smallsrcsortbucket1outof4.txt apache-hive-1.2.2-bin/examples/files/smallsrcsortbucket2outof4.txt apache-hive-1.2.2-bin/examples/files/smallsrcsortbucket3outof4.txt apache-hive-1.2.2-bin/examples/files/smallsrcsortbucket4outof4.txt apache-hive-1.2.2-bin/examples/files/smb_bucket_input.rc apache-hive-1.2.2-bin/examples/files/smb_bucket_input.txt apache-hive-1.2.2-bin/examples/files/smbbucket_1.rc apache-hive-1.2.2-bin/examples/files/smbbucket_1.txt apache-hive-1.2.2-bin/examples/files/smbbucket_2.rc apache-hive-1.2.2-bin/examples/files/smbbucket_2.txt apache-hive-1.2.2-bin/examples/files/smbbucket_3.rc apache-hive-1.2.2-bin/examples/files/smbbucket_3.txt apache-hive-1.2.2-bin/examples/files/SortCol1Col2.txt apache-hive-1.2.2-bin/examples/files/SortCol2Col1.txt apache-hive-1.2.2-bin/examples/files/SortDescCol1Col2.txt apache-hive-1.2.2-bin/examples/files/SortDescCol2Col1.txt apache-hive-1.2.2-bin/examples/files/sortdp.txt apache-hive-1.2.2-bin/examples/files/sour1.txt apache-hive-1.2.2-bin/examples/files/sour2.txt apache-hive-1.2.2-bin/examples/files/source.txt apache-hive-1.2.2-bin/examples/files/srcbucket0.txt apache-hive-1.2.2-bin/examples/files/srcbucket1.txt apache-hive-1.2.2-bin/examples/files/srcbucket20.txt apache-hive-1.2.2-bin/examples/files/srcbucket21.txt apache-hive-1.2.2-bin/examples/files/srcbucket22.txt apache-hive-1.2.2-bin/examples/files/srcbucket23.txt apache-hive-1.2.2-bin/examples/files/srcsortbucket1outof4.txt apache-hive-1.2.2-bin/examples/files/srcsortbucket2outof4.txt apache-hive-1.2.2-bin/examples/files/srcsortbucket3outof4.txt apache-hive-1.2.2-bin/examples/files/srcsortbucket4outof4.txt apache-hive-1.2.2-bin/examples/files/store.txt apache-hive-1.2.2-bin/examples/files/store_sales.txt apache-hive-1.2.2-bin/examples/files/string.txt apache-hive-1.2.2-bin/examples/files/StringMapOfOptionalIntArray.parquet apache-hive-1.2.2-bin/examples/files/symlink1.txt apache-hive-1.2.2-bin/examples/files/symlink2.txt apache-hive-1.2.2-bin/examples/files/T1.txt apache-hive-1.2.2-bin/examples/files/T2.txt apache-hive-1.2.2-bin/examples/files/T3.txt apache-hive-1.2.2-bin/examples/files/tbl.txt apache-hive-1.2.2-bin/examples/files/test.dat apache-hive-1.2.2-bin/examples/files/test1.txt apache-hive-1.2.2-bin/examples/files/test2.dat apache-hive-1.2.2-bin/examples/files/text-en.txt apache-hive-1.2.2-bin/examples/files/things.txt apache-hive-1.2.2-bin/examples/files/things2.txt apache-hive-1.2.2-bin/examples/files/ThriftPrimitiveInList.parquet apache-hive-1.2.2-bin/examples/files/ThriftSingleFieldGroupInList.parquet apache-hive-1.2.2-bin/examples/files/tiny_a.txt apache-hive-1.2.2-bin/examples/files/tiny_b.txt apache-hive-1.2.2-bin/examples/files/tjoin1.txt apache-hive-1.2.2-bin/examples/files/tjoin2.txt apache-hive-1.2.2-bin/examples/files/truststore.jks apache-hive-1.2.2-bin/examples/files/ts_formats.txt apache-hive-1.2.2-bin/examples/files/tsformat.json apache-hive-1.2.2-bin/examples/files/type_evolution.avro apache-hive-1.2.2-bin/examples/files/UnannotatedListOfGroups.parquet apache-hive-1.2.2-bin/examples/files/UnannotatedListOfPrimitives.parquet apache-hive-1.2.2-bin/examples/files/union_input.txt apache-hive-1.2.2-bin/examples/files/UserVisits.dat apache-hive-1.2.2-bin/examples/files/v1.txt apache-hive-1.2.2-bin/examples/files/v2.txt apache-hive-1.2.2-bin/examples/files/vc1.txt apache-hive-1.2.2-bin/examples/files/x.txt apache-hive-1.2.2-bin/examples/files/y.txt apache-hive-1.2.2-bin/examples/files/z.txt apache-hive-1.2.2-bin/examples/queries/case_sensitivity.q apache-hive-1.2.2-bin/examples/queries/cast1.q apache-hive-1.2.2-bin/examples/queries/groupby1.q apache-hive-1.2.2-bin/examples/queries/groupby2.q apache-hive-1.2.2-bin/examples/queries/groupby3.q apache-hive-1.2.2-bin/examples/queries/groupby4.q apache-hive-1.2.2-bin/examples/queries/groupby5.q apache-hive-1.2.2-bin/examples/queries/groupby6.q apache-hive-1.2.2-bin/examples/queries/input1.q apache-hive-1.2.2-bin/examples/queries/input2.q apache-hive-1.2.2-bin/examples/queries/input20.q apache-hive-1.2.2-bin/examples/queries/input3.q apache-hive-1.2.2-bin/examples/queries/input4.q apache-hive-1.2.2-bin/examples/queries/input5.q apache-hive-1.2.2-bin/examples/queries/input6.q apache-hive-1.2.2-bin/examples/queries/input7.q apache-hive-1.2.2-bin/examples/queries/input8.q apache-hive-1.2.2-bin/examples/queries/input9.q apache-hive-1.2.2-bin/examples/queries/input_part1.q apache-hive-1.2.2-bin/examples/queries/input_testsequencefile.q apache-hive-1.2.2-bin/examples/queries/input_testxpath.q apache-hive-1.2.2-bin/examples/queries/input_testxpath2.q apache-hive-1.2.2-bin/examples/queries/join1.q apache-hive-1.2.2-bin/examples/queries/join2.q apache-hive-1.2.2-bin/examples/queries/join3.q apache-hive-1.2.2-bin/examples/queries/join4.q apache-hive-1.2.2-bin/examples/queries/join5.q apache-hive-1.2.2-bin/examples/queries/join6.q apache-hive-1.2.2-bin/examples/queries/join7.q apache-hive-1.2.2-bin/examples/queries/join8.q apache-hive-1.2.2-bin/examples/queries/sample1.q apache-hive-1.2.2-bin/examples/queries/sample2.q apache-hive-1.2.2-bin/examples/queries/sample3.q apache-hive-1.2.2-bin/examples/queries/sample4.q apache-hive-1.2.2-bin/examples/queries/sample5.q apache-hive-1.2.2-bin/examples/queries/sample6.q apache-hive-1.2.2-bin/examples/queries/sample7.q apache-hive-1.2.2-bin/examples/queries/subq.q apache-hive-1.2.2-bin/examples/queries/udf1.q apache-hive-1.2.2-bin/examples/queries/udf4.q apache-hive-1.2.2-bin/examples/queries/udf6.q apache-hive-1.2.2-bin/examples/queries/udf_case.q apache-hive-1.2.2-bin/examples/queries/udf_when.q apache-hive-1.2.2-bin/examples/queries/union.q apache-hive-1.2.2-bin/bin/ext/util/ apache-hive-1.2.2-bin/bin/beeline apache-hive-1.2.2-bin/bin/ext/beeline.sh apache-hive-1.2.2-bin/bin/ext/cli.cmd apache-hive-1.2.2-bin/bin/ext/cli.sh apache-hive-1.2.2-bin/bin/ext/debug.cmd apache-hive-1.2.2-bin/bin/ext/debug.sh apache-hive-1.2.2-bin/bin/ext/help.cmd apache-hive-1.2.2-bin/bin/ext/help.sh apache-hive-1.2.2-bin/bin/ext/hiveburninclient.sh apache-hive-1.2.2-bin/bin/ext/hiveserver.cmd apache-hive-1.2.2-bin/bin/ext/hiveserver.sh apache-hive-1.2.2-bin/bin/ext/hiveserver2.cmd apache-hive-1.2.2-bin/bin/ext/hiveserver2.sh apache-hive-1.2.2-bin/bin/ext/hwi.cmd apache-hive-1.2.2-bin/bin/ext/hwi.sh apache-hive-1.2.2-bin/bin/ext/jar.cmd apache-hive-1.2.2-bin/bin/ext/jar.sh apache-hive-1.2.2-bin/bin/ext/lineage.cmd apache-hive-1.2.2-bin/bin/ext/lineage.sh apache-hive-1.2.2-bin/bin/ext/metastore.cmd apache-hive-1.2.2-bin/bin/ext/metastore.sh apache-hive-1.2.2-bin/bin/ext/metatool.sh apache-hive-1.2.2-bin/bin/ext/orcfiledump.cmd apache-hive-1.2.2-bin/bin/ext/orcfiledump.sh apache-hive-1.2.2-bin/bin/ext/rcfilecat.cmd apache-hive-1.2.2-bin/bin/ext/rcfilecat.sh apache-hive-1.2.2-bin/bin/ext/schemaTool.cmd apache-hive-1.2.2-bin/bin/ext/schemaTool.sh apache-hive-1.2.2-bin/bin/ext/util/execHiveCmd.cmd apache-hive-1.2.2-bin/bin/ext/util/execHiveCmd.sh apache-hive-1.2.2-bin/bin/ext/version.sh apache-hive-1.2.2-bin/bin/hive apache-hive-1.2.2-bin/bin/hive-config.sh apache-hive-1.2.2-bin/bin/hiveserver2 apache-hive-1.2.2-bin/bin/metatool apache-hive-1.2.2-bin/bin/schematool apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/ apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/ apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/ apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/ apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/ apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/001-HIVE-972.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/002-HIVE-1068.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/003-HIVE-675.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/004-HIVE-1364.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/005-HIVE-417.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/006-HIVE-1823.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/007-HIVE-78.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/008-HIVE-2246.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/008-REVERT-HIVE-2246.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/009-HIVE-2215.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/010-HIVE-3072.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/011-HIVE-3649.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/012-HIVE-1362.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/013-HIVE-3255.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/014-HIVE-3764.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/016-HIVE-6386.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/017-HIVE-6458.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/018-HIVE-6757.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/019-HIVE-7784.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/020-HIVE-9296.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.10.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.11.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.12.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.13.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.14.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.3.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.4.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.4.1.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.5.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.6.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.7.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.8.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-0.9.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-1.1.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-schema-1.2.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-txn-schema-0.13.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/hive-txn-schema-0.14.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/README apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.10.0-to-0.11.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.11.0-to-0.12.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.12.0-to-0.13.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.13.0-to-0.14.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.14.0-to-1.1.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.5.0-to-0.6.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.6.0-to-0.7.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.7.0-to-0.8.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.8.0-to-0.9.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-0.9.0-to-0.10.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade-1.1.0-to-1.2.0.derby.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/derby/upgrade.order.derby apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/001-HIVE-6862.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/002-HIVE-7784.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/003-HIVE-8239.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/004-HIVE-8550.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/005-HIVE-9296.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/006-HIVE-9456.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/hive-schema-0.11.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/hive-schema-0.12.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/hive-schema-0.13.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/hive-schema-0.14.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/hive-schema-1.1.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/hive-schema-1.2.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/hive-txn-schema-0.13.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/hive-txn-schema-0.14.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/pre-0-upgrade-0.12.0-to-0.13.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/pre-0-upgrade-0.13.0-to-0.14.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/pre-1-upgrade-0.12.0-to-0.13.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/pre-1-upgrade-0.13.0-to-0.14.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/README apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/upgrade-0.12.0-to-0.13.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/upgrade-0.13.0-to-0.14.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/upgrade-0.14.0-to-1.1.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/upgrade-1.1.0-to-1.2.0.mssql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mssql/upgrade.order.mssql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/001-HIVE-972.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/002-HIVE-1068.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/003-HIVE-675.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/004-HIVE-1364.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/005-HIVE-417.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/006-HIVE-1823.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/007-HIVE-78.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/008-HIVE-2246.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/009-HIVE-2215.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/010-HIVE-3072.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/011-HIVE-3649.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/012-HIVE-1362.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/013-HIVE-3255.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/014-HIVE-3764.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/016-HIVE-6386.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/017-HIVE-6458.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/018-HIVE-6757.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/019-HIVE-7784.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/020-HIVE-9296.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.10.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.11.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.12.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.13.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.14.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.3.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.4.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.4.1.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.5.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.6.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.7.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.8.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-0.9.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-1.1.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-schema-1.2.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-txn-schema-0.13.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/hive-txn-schema-0.14.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/README apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.10.0-to-0.11.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.11.0-to-0.12.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.12.0-to-0.13.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.13.0-to-0.14.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.14.0-to-1.1.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.5.0-to-0.6.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.6.0-to-0.7.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.7.0-to-0.8.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.8.0-to-0.9.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-0.9.0-to-0.10.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade-1.1.0-to-1.2.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/mysql/upgrade.order.mysql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/010-HIVE-3072.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/011-HIVE-3649.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/012-HIVE-1362.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/013-HIVE-3255.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/014-HIVE-3764.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/016-HIVE-6386.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/017-HIVE-6458.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/018-HIVE-6757.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/019-HIVE-7118.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/020-HIVE-7784.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/021-HIVE-9296.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-schema-0.10.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-schema-0.11.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-schema-0.12.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-schema-0.13.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-schema-0.14.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-schema-0.9.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-schema-1.1.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-schema-1.2.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/pre-0-upgrade-0.13.0-to-0.14.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/upgrade-0.10.0-to-0.11.0.mysql.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/upgrade-0.10.0-to-0.11.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/upgrade-0.11.0-to-0.12.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/upgrade-0.12.0-to-0.13.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/upgrade-0.13.0-to-0.14.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/upgrade-0.14.0-to-1.1.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/upgrade-0.9.0-to-0.10.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/upgrade-1.1.0-to-1.2.0.oracle.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/oracle/upgrade.order.oracle apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/001-HIVE-972.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/002-HIVE-1068.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/003-HIVE-675.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/004-HIVE-1364.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/005-HIVE-417.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/006-HIVE-1823.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/007-HIVE-78.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/008-HIVE-2246.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/008-REVERT-HIVE-2246.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/009-HIVE-2215.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/010-HIVE-3072.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/011-HIVE-3649.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/012-HIVE-1362.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/013-HIVE-3255.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/014-HIVE-3764.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/016-HIVE-6386.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/017-HIVE-6458.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/018-HIVE-6757.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/019-HIVE-7784.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/020-HIVE-9296.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.10.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.11.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.12.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.13.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.14.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.3.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.4.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.4.1.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.5.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.6.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.7.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.8.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-0.9.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-1.1.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-schema-1.2.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-txn-schema-0.13.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/hive-txn-schema-0.14.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/pre-0-upgrade-0.12.0-to-0.13.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/pre-0-upgrade-0.13.0-to-0.14.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/README apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.10.0-to-0.11.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.12.0-to-0.13.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.13.0-to-0.14.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.14.0-to-1.1.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.5.0-to-0.6.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.6.0-to-0.7.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.7.0-to-0.8.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.8.0-to-0.9.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-0.9.0-to-0.10.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade-1.1.0-to-1.2.0.postgres.sql apache-hive-1.2.2-bin/scripts/metastore/upgrade/postgres/upgrade.order.postgres apache-hive-1.2.2-bin/conf/hive-default.xml.template apache-hive-1.2.2-bin/conf/hive-env.sh.template apache-hive-1.2.2-bin/conf/ivysettings.xml apache-hive-1.2.2-bin/lib/php/ext/ apache-hive-1.2.2-bin/lib/php/ext/thrift_protocol/ apache-hive-1.2.2-bin/lib/php/ext/thrift_protocol/tags/ apache-hive-1.2.2-bin/lib/php/ext/thrift_protocol/tags/1.0.0/ apache-hive-1.2.2-bin/lib/php/packages/ apache-hive-1.2.2-bin/lib/php/packages/fb303/ apache-hive-1.2.2-bin/lib/php/protocol/ apache-hive-1.2.2-bin/lib/php/transport/ apache-hive-1.2.2-bin/lib/php/autoload.php apache-hive-1.2.2-bin/lib/php/ext/thrift_protocol/config.m4 apache-hive-1.2.2-bin/lib/php/ext/thrift_protocol/php_thrift_protocol.cpp apache-hive-1.2.2-bin/lib/php/ext/thrift_protocol/php_thrift_protocol.h apache-hive-1.2.2-bin/lib/php/ext/thrift_protocol/tags/1.0.0/config.m4 apache-hive-1.2.2-bin/lib/php/ext/thrift_protocol/tags/1.0.0/php_thrift_protocol.cpp apache-hive-1.2.2-bin/lib/php/ext/thrift_protocol/tags/1.0.0/php_thrift_protocol.h apache-hive-1.2.2-bin/lib/php/packages/fb303/FacebookService.php apache-hive-1.2.2-bin/lib/php/packages/fb303/fb303_types.php apache-hive-1.2.2-bin/lib/php/protocol/TBinaryProtocol.php apache-hive-1.2.2-bin/lib/php/protocol/TProtocol.php apache-hive-1.2.2-bin/lib/php/Thrift.php apache-hive-1.2.2-bin/lib/php/transport/TBufferedTransport.php apache-hive-1.2.2-bin/lib/php/transport/TFramedTransport.php apache-hive-1.2.2-bin/lib/php/transport/THttpClient.php apache-hive-1.2.2-bin/lib/php/transport/TMemoryBuffer.php apache-hive-1.2.2-bin/lib/php/transport/TNullTransport.php apache-hive-1.2.2-bin/lib/php/transport/TPhpStream.php apache-hive-1.2.2-bin/lib/php/transport/TSocket.php apache-hive-1.2.2-bin/lib/php/transport/TSocketPool.php apache-hive-1.2.2-bin/lib/php/transport/TTransport.php apache-hive-1.2.2-bin/lib/php/packages/serde/org/ apache-hive-1.2.2-bin/lib/php/packages/serde/org/apache/ apache-hive-1.2.2-bin/lib/php/packages/serde/org/apache/hadoop/ apache-hive-1.2.2-bin/lib/php/packages/serde/org/apache/hadoop/hive/ apache-hive-1.2.2-bin/lib/php/packages/serde/org/apache/hadoop/hive/serde/ apache-hive-1.2.2-bin/lib/php/packages/serde/org/apache/hadoop/hive/serde/Types.php apache-hive-1.2.2-bin/lib/php/packages/serde/Types.php apache-hive-1.2.2-bin/lib/php/packages/hive_metastore/metastore/ apache-hive-1.2.2-bin/lib/php/packages/hive_metastore/metastore/ThriftHiveMetastore.php apache-hive-1.2.2-bin/lib/php/packages/hive_metastore/metastore/Types.php apache-hive-1.2.2-bin/lib/php/packages/hive_service/TCLIService.php apache-hive-1.2.2-bin/lib/php/packages/hive_service/ThriftHive.php apache-hive-1.2.2-bin/lib/php/packages/hive_service/Types.php apache-hive-1.2.2-bin/lib/php/packages/queryplan/Types.php apache-hive-1.2.2-bin/lib/py/fb303/ apache-hive-1.2.2-bin/lib/py/fb303_scripts/ apache-hive-1.2.2-bin/lib/py/thrift/ apache-hive-1.2.2-bin/lib/py/thrift/protocol/ apache-hive-1.2.2-bin/lib/py/thrift/reflection/ apache-hive-1.2.2-bin/lib/py/thrift/reflection/limited/ apache-hive-1.2.2-bin/lib/py/thrift/server/ apache-hive-1.2.2-bin/lib/py/thrift/transport/ apache-hive-1.2.2-bin/lib/py/fb303/__init__.py apache-hive-1.2.2-bin/lib/py/fb303/constants.py apache-hive-1.2.2-bin/lib/py/fb303/FacebookBase.py apache-hive-1.2.2-bin/lib/py/fb303/FacebookService-remote apache-hive-1.2.2-bin/lib/py/fb303/FacebookService.py apache-hive-1.2.2-bin/lib/py/fb303/ttypes.py apache-hive-1.2.2-bin/lib/py/fb303_scripts/__init__.py apache-hive-1.2.2-bin/lib/py/fb303_scripts/fb303_simple_mgmt.py apache-hive-1.2.2-bin/lib/py/thrift/__init__.py apache-hive-1.2.2-bin/lib/py/thrift/protocol/__init__.py apache-hive-1.2.2-bin/lib/py/thrift/protocol/fastbinary.c apache-hive-1.2.2-bin/lib/py/thrift/protocol/TBinaryProtocol.py apache-hive-1.2.2-bin/lib/py/thrift/protocol/TProtocol.py apache-hive-1.2.2-bin/lib/py/thrift/reflection/__init__.py apache-hive-1.2.2-bin/lib/py/thrift/reflection/limited/__init__.py apache-hive-1.2.2-bin/lib/py/thrift/reflection/limited/constants.py apache-hive-1.2.2-bin/lib/py/thrift/reflection/limited/ttypes.py apache-hive-1.2.2-bin/lib/py/thrift/server/__init__.py apache-hive-1.2.2-bin/lib/py/thrift/server/THttpServer.py apache-hive-1.2.2-bin/lib/py/thrift/server/TNonblockingServer.py apache-hive-1.2.2-bin/lib/py/thrift/server/TServer.py apache-hive-1.2.2-bin/lib/py/thrift/Thrift.py apache-hive-1.2.2-bin/lib/py/thrift/transport/__init__.py apache-hive-1.2.2-bin/lib/py/thrift/transport/THttpClient.py apache-hive-1.2.2-bin/lib/py/thrift/transport/TSocket.py apache-hive-1.2.2-bin/lib/py/thrift/transport/TTransport.py apache-hive-1.2.2-bin/lib/py/thrift/transport/TTwisted.py apache-hive-1.2.2-bin/lib/py/thrift/TSCons.py apache-hive-1.2.2-bin/lib/py/hive_serde/__init__.py apache-hive-1.2.2-bin/lib/py/hive_serde/constants.py apache-hive-1.2.2-bin/lib/py/hive_serde/ttypes.py apache-hive-1.2.2-bin/lib/py/hive_metastore/__init__.py apache-hive-1.2.2-bin/lib/py/hive_metastore/constants.py apache-hive-1.2.2-bin/lib/py/hive_metastore/ThriftHiveMetastore-remote apache-hive-1.2.2-bin/lib/py/hive_metastore/ThriftHiveMetastore.py apache-hive-1.2.2-bin/lib/py/hive_metastore/ttypes.py apache-hive-1.2.2-bin/lib/py/TCLIService/__init__.py apache-hive-1.2.2-bin/lib/py/TCLIService/constants.py apache-hive-1.2.2-bin/lib/py/TCLIService/TCLIService-remote apache-hive-1.2.2-bin/lib/py/TCLIService/TCLIService.py apache-hive-1.2.2-bin/lib/py/TCLIService/ttypes.py apache-hive-1.2.2-bin/lib/py/hive_service/__init__.py apache-hive-1.2.2-bin/lib/py/hive_service/constants.py apache-hive-1.2.2-bin/lib/py/hive_service/ThriftHive-remote apache-hive-1.2.2-bin/lib/py/hive_service/ThriftHive.py apache-hive-1.2.2-bin/lib/py/hive_service/ttypes.py apache-hive-1.2.2-bin/lib/py/queryplan/__init__.py apache-hive-1.2.2-bin/lib/py/queryplan/constants.py apache-hive-1.2.2-bin/lib/py/queryplan/ttypes.py apache-hive-1.2.2-bin/hcatalog/bin/common.sh apache-hive-1.2.2-bin/hcatalog/bin/hcat apache-hive-1.2.2-bin/hcatalog/bin/hcat.py apache-hive-1.2.2-bin/hcatalog/bin/hcatcfg.py apache-hive-1.2.2-bin/hcatalog/bin/templeton.cmd apache-hive-1.2.2-bin/hcatalog/etc/hcatalog/jndi.properties apache-hive-1.2.2-bin/hcatalog/etc/hcatalog/proto-hive-site.xml apache-hive-1.2.2-bin/hcatalog/etc/webhcat/webhcat-default.xml apache-hive-1.2.2-bin/hcatalog/etc/webhcat/webhcat-log4j.properties apache-hive-1.2.2-bin/hcatalog/libexec/hcat-config.sh apache-hive-1.2.2-bin/hcatalog/sbin/hcat_server.py apache-hive-1.2.2-bin/hcatalog/sbin/hcat_server.sh apache-hive-1.2.2-bin/hcatalog/sbin/hcatcfg.py apache-hive-1.2.2-bin/hcatalog/sbin/update-hcatalog-env.sh apache-hive-1.2.2-bin/hcatalog/sbin/webhcat_config.sh apache-hive-1.2.2-bin/hcatalog/sbin/webhcat_server.sh apache-hive-1.2.2-bin/lib/hive-common-1.2.2.jar apache-hive-1.2.2-bin/lib/hive-shims-1.2.2.jar apache-hive-1.2.2-bin/lib/hive-shims-common-1.2.2.jar apache-hive-1.2.2-bin/lib/commons-logging-1.1.3.jar apache-hive-1.2.2-bin/lib/log4j-1.2.16.jar apache-hive-1.2.2-bin/lib/apache-log4j-extras-1.2.17.jar apache-hive-1.2.2-bin/lib/guava-14.0.1.jar apache-hive-1.2.2-bin/lib/commons-lang-2.6.jar apache-hive-1.2.2-bin/lib/libthrift-0.9.2.jar apache-hive-1.2.2-bin/lib/httpclient-4.4.jar apache-hive-1.2.2-bin/lib/httpcore-4.4.jar apache-hive-1.2.2-bin/lib/commons-codec-1.4.jar apache-hive-1.2.2-bin/lib/curator-framework-2.6.0.jar apache-hive-1.2.2-bin/lib/curator-client-2.6.0.jar apache-hive-1.2.2-bin/lib/zookeeper-3.4.6.jar apache-hive-1.2.2-bin/lib/jline-2.12.jar apache-hive-1.2.2-bin/lib/netty-3.7.0.Final.jar apache-hive-1.2.2-bin/lib/hive-shims-0.20S-1.2.2.jar apache-hive-1.2.2-bin/lib/hive-shims-0.23-1.2.2.jar apache-hive-1.2.2-bin/lib/commons-io-2.4.jar apache-hive-1.2.2-bin/lib/activation-1.1.jar apache-hive-1.2.2-bin/lib/commons-compress-1.4.1.jar apache-hive-1.2.2-bin/lib/xz-1.0.jar apache-hive-1.2.2-bin/lib/commons-cli-1.2.jar apache-hive-1.2.2-bin/lib/commons-collections-3.2.2.jar apache-hive-1.2.2-bin/lib/commons-httpclient-3.0.1.jar apache-hive-1.2.2-bin/lib/junit-4.11.jar apache-hive-1.2.2-bin/lib/hamcrest-core-1.1.jar apache-hive-1.2.2-bin/lib/hive-shims-scheduler-1.2.2.jar apache-hive-1.2.2-bin/lib/joda-time-2.5.jar apache-hive-1.2.2-bin/lib/ant-1.9.1.jar apache-hive-1.2.2-bin/lib/ant-launcher-1.9.1.jar apache-hive-1.2.2-bin/lib/json-20090211.jar apache-hive-1.2.2-bin/lib/hive-serde-1.2.2.jar apache-hive-1.2.2-bin/lib/jsr305-3.0.0.jar apache-hive-1.2.2-bin/lib/avro-1.7.5.jar apache-hive-1.2.2-bin/lib/paranamer-2.3.jar apache-hive-1.2.2-bin/lib/snappy-java-1.0.5.jar apache-hive-1.2.2-bin/lib/opencsv-2.3.jar apache-hive-1.2.2-bin/lib/parquet-hadoop-bundle-1.6.0.jar apache-hive-1.2.2-bin/lib/hive-metastore-1.2.2.jar apache-hive-1.2.2-bin/lib/bonecp-0.8.0.RELEASE.jar apache-hive-1.2.2-bin/lib/derby-10.10.2.0.jar apache-hive-1.2.2-bin/lib/datanucleus-api-jdo-3.2.6.jar apache-hive-1.2.2-bin/lib/datanucleus-core-3.2.10.jar apache-hive-1.2.2-bin/lib/datanucleus-rdbms-3.2.9.jar apache-hive-1.2.2-bin/lib/commons-pool-1.5.4.jar apache-hive-1.2.2-bin/lib/commons-dbcp-1.4.jar apache-hive-1.2.2-bin/lib/jdo-api-3.0.1.jar apache-hive-1.2.2-bin/lib/jta-1.1.jar apache-hive-1.2.2-bin/lib/antlr-runtime-3.4.jar apache-hive-1.2.2-bin/lib/stringtemplate-3.2.1.jar apache-hive-1.2.2-bin/lib/antlr-2.7.7.jar apache-hive-1.2.2-bin/lib/libfb303-0.9.2.jar apache-hive-1.2.2-bin/lib/hive-testutils-1.2.2.jar apache-hive-1.2.2-bin/lib/tempus-fugit-1.1.jar apache-hive-1.2.2-bin/lib/hive-exec-1.2.2.jar apache-hive-1.2.2-bin/lib/hive-ant-1.2.2.jar apache-hive-1.2.2-bin/lib/velocity-1.5.jar apache-hive-1.2.2-bin/lib/oro-2.0.8.jar apache-hive-1.2.2-bin/lib/ST4-4.0.4.jar apache-hive-1.2.2-bin/lib/ivy-2.4.0.jar apache-hive-1.2.2-bin/lib/apache-curator-2.6.0.pom apache-hive-1.2.2-bin/lib/groovy-all-2.1.6.jar apache-hive-1.2.2-bin/lib/calcite-core-1.2.0-incubating.jar apache-hive-1.2.2-bin/lib/calcite-avatica-1.2.0-incubating.jar apache-hive-1.2.2-bin/lib/calcite-linq4j-1.2.0-incubating.jar apache-hive-1.2.2-bin/lib/eigenbase-properties-1.1.5.jar apache-hive-1.2.2-bin/lib/janino-2.7.6.jar apache-hive-1.2.2-bin/lib/commons-compiler-2.7.6.jar apache-hive-1.2.2-bin/lib/pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar apache-hive-1.2.2-bin/lib/stax-api-1.0.1.jar apache-hive-1.2.2-bin/lib/hive-service-1.2.2.jar apache-hive-1.2.2-bin/lib/jpam-1.1.jar apache-hive-1.2.2-bin/lib/jetty-all-7.6.0.v20120127.jar apache-hive-1.2.2-bin/lib/servlet-api-2.5.jar apache-hive-1.2.2-bin/lib/geronimo-jta_1.1_spec-1.1.1.jar apache-hive-1.2.2-bin/lib/mail-1.4.1.jar apache-hive-1.2.2-bin/lib/geronimo-jaspic_1.0_spec-1.0.jar apache-hive-1.2.2-bin/lib/geronimo-annotation_1.0_spec-1.1.1.jar apache-hive-1.2.2-bin/lib/asm-commons-3.1.jar apache-hive-1.2.2-bin/lib/asm-tree-3.1.jar apache-hive-1.2.2-bin/lib/curator-recipes-2.6.0.jar apache-hive-1.2.2-bin/lib/hive-jdbc-1.2.2.jar apache-hive-1.2.2-bin/lib/hive-jdbc-1.2.2-standalone.jar apache-hive-1.2.2-bin/lib/hive-beeline-1.2.2.jar apache-hive-1.2.2-bin/lib/super-csv-2.2.0.jar apache-hive-1.2.2-bin/lib/hive-cli-1.2.2.jar apache-hive-1.2.2-bin/lib/hive-contrib-1.2.2.jar apache-hive-1.2.2-bin/lib/hive-hbase-handler-1.2.2.jar apache-hive-1.2.2-bin/lib/hive-hwi-1.2.2.jar apache-hive-1.2.2-bin/lib/jetty-all-server-7.6.0.v20120127.jar apache-hive-1.2.2-bin/lib/hive-accumulo-handler-1.2.2.jar apache-hive-1.2.2-bin/lib/accumulo-core-1.6.0.jar apache-hive-1.2.2-bin/lib/jcommander-1.32.jar apache-hive-1.2.2-bin/lib/commons-configuration-1.6.jar apache-hive-1.2.2-bin/lib/commons-digester-1.8.jar apache-hive-1.2.2-bin/lib/commons-beanutils-1.7.0.jar apache-hive-1.2.2-bin/lib/commons-beanutils-core-1.8.0.jar apache-hive-1.2.2-bin/lib/accumulo-fate-1.6.0.jar apache-hive-1.2.2-bin/lib/accumulo-start-1.6.0.jar apache-hive-1.2.2-bin/lib/commons-vfs2-2.0.jar apache-hive-1.2.2-bin/lib/maven-scm-api-1.4.jar apache-hive-1.2.2-bin/lib/plexus-utils-1.5.6.jar apache-hive-1.2.2-bin/lib/maven-scm-provider-svnexe-1.4.jar apache-hive-1.2.2-bin/lib/maven-scm-provider-svn-commons-1.4.jar apache-hive-1.2.2-bin/lib/regexp-1.3.jar apache-hive-1.2.2-bin/lib/commons-math-2.1.jar apache-hive-1.2.2-bin/lib/accumulo-trace-1.6.0.jar apache-hive-1.2.2-bin/hcatalog/share/hcatalog/hive-hcatalog-streaming-1.2.2.jar apache-hive-1.2.2-bin/hcatalog/share/hcatalog/hive-hcatalog-core-1.2.2.jar apache-hive-1.2.2-bin/hcatalog/share/hcatalog/hive-hcatalog-pig-adapter-1.2.2.jar apache-hive-1.2.2-bin/hcatalog/share/hcatalog/hive-hcatalog-server-extensions-1.2.2.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jersey-json-1.14.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jettison-1.1.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jaxb-impl-2.2.3-1.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jaxb-api-2.2.2.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/stax-api-1.0-2.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jackson-core-asl-1.9.2.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jackson-jaxrs-1.9.2.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jackson-xc-1.9.2.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jersey-core-1.14.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jersey-server-1.14.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/asm-3.1.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/hive-webhcat-1.2.2.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jersey-servlet-1.14.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/wadl-resourcedoc-doclet-1.4.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/xercesImpl-2.9.1.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/xml-apis-1.3.04.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/commons-exec-1.1.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/svr/lib/jul-to-slf4j-1.7.5.jar apache-hive-1.2.2-bin/hcatalog/share/webhcat/java-client/hive-webhcat-java-client-1.2.2.jar apache-hive-1.2.2-bin/conf/hive-log4j.properties.template apache-hive-1.2.2-bin/conf/hive-exec-log4j.properties.template apache-hive-1.2.2-bin/conf/beeline-log4j.properties.template apache-hive-1.2.2-bin/hcatalog/share/doc/hcatalog/README.txt [root@master src]# mv apache-hive-1.2.2-bin/ hive-1.2.2 [root@master src]# source /root/.bashrc [root@master src]# cd hive-1.2.2/ [root@master hive-1.2.2]# pwd /usr/local/src/hive-1.2.2 [root@master hive-1.2.2]# mv $HIVE_HOME/lib/log4j-1.2.16.jar $HIVE_HOME/lib/log4j-1.2.16.bak [root@master hive-1.2.2]# bin/schematool -dbType derby -initSchema ls: cannot access /usr/local/src/spark-2.0.2-bin-hadoop2.6/lib/spark-assembly-*.jar: No such file or directory Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver Metastore connection User: APP Starting metastore schema initialization to 1.2.0 Initialization script hive-schema-1.2.0.derby.sql Initialization script completed schemaTool completed
[root@master hive-1.2.2]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 22 Server version: 5.7.39 MySQL Community Server (GPL) Copyright (c) 2000, 2022, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database metastore; Query OK, 1 row affected (0.00 sec) mysql> exit; Bye [root@master hive-1.2.2]# schematool -initSchema -dbType mysql -verbose ls: cannot access /usr/local/src/spark-2.0.2-bin-hadoop2.6/lib/spark-assembly-*.jar: No such file or directory 22/09/13 12:32:34 WARN conf.HiveConf: HiveConf of name hive.metastore.event.db.notification.api.auth does not exist Metastore connection URL: jdbc:mysql://master:3306/metastore?useSSL=false Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: root Starting metastore schema initialization to 1.2.0 Initialization script hive-schema-1.2.0.mysql.sql Connecting to jdbc:mysql://master:3306/metastore?useSSL=false Connected to: MySQL (version 5.7.39) Driver: MySQL Connector Java (version mysql-connector-java-5.1.44 ( Revision: b3cda4f864902ffdde495b9df93937c3e20009be )) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:mysql://master:3306/metastore> !autocommit on Autocommit status: true 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */ No rows affected (0.022 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */ No rows affected (0.008 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */ No rows affected (0.006 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET NAMES utf8 */ No rows affected (0.008 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */ No rows affected (0.008 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40103 SET TIME_ZONE='+00:00' */ No rows affected (0.025 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */ No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */ No rows affected (0.017 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */ No rows affected (0.016 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */ No rows affected (0.007 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.032 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.011 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `BUCKETING_COLS` ( `SD_ID` bigint(20) NOT NULL, `BUCKET_COL_NAME` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`SD_ID`,`INTEGER_IDX`), KEY `BUCKETING_COLS_N49` (`SD_ID`), CONSTRAINT `BUCKETING_COLS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.059 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.025 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.005 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `CDS` ( `CD_ID` bigint(20) NOT NULL, PRIMARY KEY (`CD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.013 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.018 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `COLUMNS_V2` ( `CD_ID` bigint(20) NOT NULL, `COMMENT` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TYPE_NAME` varchar(4000) DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`CD_ID`,`COLUMN_NAME`), KEY `COLUMNS_V2_N49` (`CD_ID`), CONSTRAINT `COLUMNS_V2_FK1` FOREIGN KEY (`CD_ID`) REFERENCES `CDS` (`CD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.016 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `DATABASE_PARAMS` ( `DB_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(180) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`DB_ID`,`PARAM_KEY`), KEY `DATABASE_PARAMS_N49` (`DB_ID`), CONSTRAINT `DATABASE_PARAMS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.154 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.012 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `DBS` ( `DB_ID` bigint(20) NOT NULL, `DESC` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `DB_LOCATION_URI` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `OWNER_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `OWNER_TYPE` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`DB_ID`), UNIQUE KEY `UNIQUE_DATABASE` (`NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.014 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.006 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `DB_PRIVS` ( `DB_GRANT_ID` bigint(20) NOT NULL, `CREATE_TIME` int(11) NOT NULL, `DB_ID` bigint(20) DEFAULT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `DB_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`DB_GRANT_ID`), UNIQUE KEY `DBPRIVILEGEINDEX` (`DB_ID`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`DB_PRIV`,`GRANTOR`,`GRANTOR_TYPE`), KEY `DB_PRIVS_N49` (`DB_ID`), CONSTRAINT `DB_PRIVS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.034 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `GLOBAL_PRIVS` ( `USER_GRANT_ID` bigint(20) NOT NULL, `CREATE_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `USER_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`USER_GRANT_ID`), UNIQUE KEY `GLOBALPRIVILEGEINDEX` (`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`USER_PRIV`,`GRANTOR`,`GRANTOR_TYPE`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.017 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.007 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `IDXS` ( `INDEX_ID` bigint(20) NOT NULL, `CREATE_TIME` int(11) NOT NULL, `DEFERRED_REBUILD` bit(1) NOT NULL, `INDEX_HANDLER_CLASS` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `INDEX_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `INDEX_TBL_ID` bigint(20) DEFAULT NULL, `LAST_ACCESS_TIME` int(11) NOT NULL, `ORIG_TBL_ID` bigint(20) DEFAULT NULL, `SD_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`INDEX_ID`), UNIQUE KEY `UNIQUEINDEX` (`INDEX_NAME`,`ORIG_TBL_ID`), KEY `IDXS_N51` (`SD_ID`), KEY `IDXS_N50` (`INDEX_TBL_ID`), KEY `IDXS_N49` (`ORIG_TBL_ID`), CONSTRAINT `IDXS_FK1` FOREIGN KEY (`ORIG_TBL_ID`) REFERENCES `TBLS` (`TBL_ID`), CONSTRAINT `IDXS_FK2` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`), CONSTRAINT `IDXS_FK3` FOREIGN KEY (`INDEX_TBL_ID`) REFERENCES `TBLS` (`TBL_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.036 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `INDEX_PARAMS` ( `INDEX_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`INDEX_ID`,`PARAM_KEY`), KEY `INDEX_PARAMS_N49` (`INDEX_ID`), CONSTRAINT `INDEX_PARAMS_FK1` FOREIGN KEY (`INDEX_ID`) REFERENCES `IDXS` (`INDEX_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.013 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `NUCLEUS_TABLES` ( `CLASS_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TYPE` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `OWNER` varchar(2) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `VERSION` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `INTERFACE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`CLASS_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.014 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.014 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.023 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.012 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `PARTITIONS` ( `PART_ID` bigint(20) NOT NULL, `CREATE_TIME` int(11) NOT NULL, `LAST_ACCESS_TIME` int(11) NOT NULL, `PART_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `SD_ID` bigint(20) DEFAULT NULL, `TBL_ID` bigint(20) DEFAULT NULL, `LINK_TARGET_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`PART_ID`), UNIQUE KEY `UNIQUEPARTITION` (`PART_NAME`,`TBL_ID`), KEY `PARTITIONS_N49` (`TBL_ID`), KEY `PARTITIONS_N50` (`SD_ID`), KEY `PARTITIONS_N51` (`LINK_TARGET_ID`), CONSTRAINT `PARTITIONS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`), CONSTRAINT `PARTITIONS_FK2` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`), CONSTRAINT `PARTITIONS_FK3` FOREIGN KEY (`LINK_TARGET_ID`) REFERENCES `PARTITIONS` (`PART_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.087 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.012 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.026 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `PARTITION_EVENTS` ( `PART_NAME_ID` bigint(20) NOT NULL, `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `EVENT_TIME` bigint(20) NOT NULL, `EVENT_TYPE` int(11) NOT NULL, `PARTITION_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `TBL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`PART_NAME_ID`), KEY `PARTITIONEVENTINDEX` (`PARTITION_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.069 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `PARTITION_KEYS` ( `TBL_ID` bigint(20) NOT NULL, `PKEY_COMMENT` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PKEY_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PKEY_TYPE` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`TBL_ID`,`PKEY_NAME`), KEY `PARTITION_KEYS_N49` (`TBL_ID`), CONSTRAINT `PARTITION_KEYS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.048 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `PARTITION_KEY_VALS` ( `PART_ID` bigint(20) NOT NULL, `PART_KEY_VAL` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`PART_ID`,`INTEGER_IDX`), KEY `PARTITION_KEY_VALS_N49` (`PART_ID`), CONSTRAINT `PARTITION_KEY_VALS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.013 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `PARTITION_PARAMS` ( `PART_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`PART_ID`,`PARAM_KEY`), KEY `PARTITION_PARAMS_N49` (`PART_ID`), CONSTRAINT `PARTITION_PARAMS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.016 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `PART_COL_PRIVS` ( `PART_COLUMN_GRANT_ID` bigint(20) NOT NULL, `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `CREATE_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PART_ID` bigint(20) DEFAULT NULL, `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PART_COL_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`PART_COLUMN_GRANT_ID`), KEY `PART_COL_PRIVS_N49` (`PART_ID`), KEY `PARTITIONCOLUMNPRIVILEGEINDEX` (`PART_ID`,`COLUMN_NAME`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`PART_COL_PRIV`,`GRANTOR`,`GRANTOR_TYPE`), CONSTRAINT `PART_COL_PRIVS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.019 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `PART_PRIVS` ( `PART_GRANT_ID` bigint(20) NOT NULL, `CREATE_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PART_ID` bigint(20) DEFAULT NULL, `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PART_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`PART_GRANT_ID`), KEY `PARTPRIVILEGEINDEX` (`PART_ID`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`PART_PRIV`,`GRANTOR`,`GRANTOR_TYPE`), KEY `PART_PRIVS_N49` (`PART_ID`), CONSTRAINT `PART_PRIVS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.012 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `ROLES` ( `ROLE_ID` bigint(20) NOT NULL, `CREATE_TIME` int(11) NOT NULL, `OWNER_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `ROLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`ROLE_ID`), UNIQUE KEY `ROLEENTITYINDEX` (`ROLE_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.014 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `ROLE_MAP` ( `ROLE_GRANT_ID` bigint(20) NOT NULL, `ADD_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `ROLE_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ROLE_GRANT_ID`), UNIQUE KEY `USERROLEMAPINDEX` (`PRINCIPAL_NAME`,`ROLE_ID`,`GRANTOR`,`GRANTOR_TYPE`), KEY `ROLE_MAP_N49` (`ROLE_ID`), CONSTRAINT `ROLE_MAP_FK1` FOREIGN KEY (`ROLE_ID`) REFERENCES `ROLES` (`ROLE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.016 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SDS` ( `SD_ID` bigint(20) NOT NULL, `CD_ID` bigint(20) DEFAULT NULL, `INPUT_FORMAT` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `IS_COMPRESSED` bit(1) NOT NULL, `IS_STOREDASSUBDIRECTORIES` bit(1) NOT NULL, `LOCATION` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `NUM_BUCKETS` int(11) NOT NULL, `OUTPUT_FORMAT` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `SERDE_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`SD_ID`), KEY `SDS_N49` (`SERDE_ID`), KEY `SDS_N50` (`CD_ID`), CONSTRAINT `SDS_FK1` FOREIGN KEY (`SERDE_ID`) REFERENCES `SERDES` (`SERDE_ID`), CONSTRAINT `SDS_FK2` FOREIGN KEY (`CD_ID`) REFERENCES `CDS` (`CD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SD_PARAMS` ( `SD_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`SD_ID`,`PARAM_KEY`), KEY `SD_PARAMS_N49` (`SD_ID`), CONSTRAINT `SD_PARAMS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SEQUENCE_TABLE` ( `SEQUENCE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `NEXT_VAL` bigint(20) NOT NULL, PRIMARY KEY (`SEQUENCE_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.018 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SERDES` ( `SERDE_ID` bigint(20) NOT NULL, `NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `SLIB` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`SERDE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.009 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SERDE_PARAMS` ( `SERDE_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`SERDE_ID`,`PARAM_KEY`), KEY `SERDE_PARAMS_N49` (`SERDE_ID`), CONSTRAINT `SERDE_PARAMS_FK1` FOREIGN KEY (`SERDE_ID`) REFERENCES `SERDES` (`SERDE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.013 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SKEWED_COL_NAMES` ( `SD_ID` bigint(20) NOT NULL, `SKEWED_COL_NAME` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`SD_ID`,`INTEGER_IDX`), KEY `SKEWED_COL_NAMES_N49` (`SD_ID`), CONSTRAINT `SKEWED_COL_NAMES_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.013 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.013 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SKEWED_COL_VALUE_LOC_MAP` ( `SD_ID` bigint(20) NOT NULL, `STRING_LIST_ID_KID` bigint(20) NOT NULL, `LOCATION` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`SD_ID`,`STRING_LIST_ID_KID`), KEY `SKEWED_COL_VALUE_LOC_MAP_N49` (`STRING_LIST_ID_KID`), KEY `SKEWED_COL_VALUE_LOC_MAP_N50` (`SD_ID`), CONSTRAINT `SKEWED_COL_VALUE_LOC_MAP_FK2` FOREIGN KEY (`STRING_LIST_ID_KID`) REFERENCES `SKEWED_STRING_LIST` (`STRING_LIST_ID`), CONSTRAINT `SKEWED_COL_VALUE_LOC_MAP_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.013 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SKEWED_STRING_LIST` ( `STRING_LIST_ID` bigint(20) NOT NULL, PRIMARY KEY (`STRING_LIST_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.012 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.007 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SKEWED_STRING_LIST_VALUES` ( `STRING_LIST_ID` bigint(20) NOT NULL, `STRING_LIST_VALUE` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`STRING_LIST_ID`,`INTEGER_IDX`), KEY `SKEWED_STRING_LIST_VALUES_N49` (`STRING_LIST_ID`), CONSTRAINT `SKEWED_STRING_LIST_VALUES_FK1` FOREIGN KEY (`STRING_LIST_ID`) REFERENCES `SKEWED_STRING_LIST` (`STRING_LIST_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.018 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.005 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.006 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SKEWED_VALUES` ( `SD_ID_OID` bigint(20) NOT NULL, `STRING_LIST_ID_EID` bigint(20) NOT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`SD_ID_OID`,`INTEGER_IDX`), KEY `SKEWED_VALUES_N50` (`SD_ID_OID`), KEY `SKEWED_VALUES_N49` (`STRING_LIST_ID_EID`), CONSTRAINT `SKEWED_VALUES_FK2` FOREIGN KEY (`STRING_LIST_ID_EID`) REFERENCES `SKEWED_STRING_LIST` (`STRING_LIST_ID`), CONSTRAINT `SKEWED_VALUES_FK1` FOREIGN KEY (`SD_ID_OID`) REFERENCES `SDS` (`SD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.072 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.031 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.009 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `SORT_COLS` ( `SD_ID` bigint(20) NOT NULL, `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `ORDER` int(11) NOT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`SD_ID`,`INTEGER_IDX`), KEY `SORT_COLS_N49` (`SD_ID`), CONSTRAINT `SORT_COLS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `TABLE_PARAMS` ( `TBL_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`TBL_ID`,`PARAM_KEY`), KEY `TABLE_PARAMS_N49` (`TBL_ID`), CONSTRAINT `TABLE_PARAMS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.012 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `TBLS` ( `TBL_ID` bigint(20) NOT NULL, `CREATE_TIME` int(11) NOT NULL, `DB_ID` bigint(20) DEFAULT NULL, `LAST_ACCESS_TIME` int(11) NOT NULL, `OWNER` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `RETENTION` int(11) NOT NULL, `SD_ID` bigint(20) DEFAULT NULL, `TBL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `TBL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `VIEW_EXPANDED_TEXT` mediumtext, `VIEW_ORIGINAL_TEXT` mediumtext, `LINK_TARGET_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`TBL_ID`), UNIQUE KEY `UNIQUETABLE` (`TBL_NAME`,`DB_ID`), KEY `TBLS_N50` (`SD_ID`), KEY `TBLS_N49` (`DB_ID`), KEY `TBLS_N51` (`LINK_TARGET_ID`), CONSTRAINT `TBLS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`), CONSTRAINT `TBLS_FK2` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`), CONSTRAINT `TBLS_FK3` FOREIGN KEY (`LINK_TARGET_ID`) REFERENCES `TBLS` (`TBL_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.017 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.016 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `TBL_COL_PRIVS` ( `TBL_COLUMN_GRANT_ID` bigint(20) NOT NULL, `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `CREATE_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `TBL_COL_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `TBL_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`TBL_COLUMN_GRANT_ID`), KEY `TABLECOLUMNPRIVILEGEINDEX` (`TBL_ID`,`COLUMN_NAME`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`TBL_COL_PRIV`,`GRANTOR`,`GRANTOR_TYPE`), KEY `TBL_COL_PRIVS_N49` (`TBL_ID`), CONSTRAINT `TBL_COL_PRIVS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.012 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.017 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `TBL_PRIVS` ( `TBL_GRANT_ID` bigint(20) NOT NULL, `CREATE_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `TBL_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `TBL_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`TBL_GRANT_ID`), KEY `TBL_PRIVS_N49` (`TBL_ID`), KEY `TABLEPRIVILEGEINDEX` (`TBL_ID`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`TBL_PRIV`,`GRANTOR`,`GRANTOR_TYPE`), CONSTRAINT `TBL_PRIVS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.018 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `TAB_COL_STATS` ( `CS_ID` bigint(20) NOT NULL, `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TBL_ID` bigint(20) NOT NULL, `LONG_LOW_VALUE` bigint(20), `LONG_HIGH_VALUE` bigint(20), `DOUBLE_HIGH_VALUE` double(53,4), `DOUBLE_LOW_VALUE` double(53,4), `BIG_DECIMAL_LOW_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin, `BIG_DECIMAL_HIGH_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin, `NUM_NULLS` bigint(20) NOT NULL, `NUM_DISTINCTS` bigint(20), `AVG_COL_LEN` double(53,4), `MAX_COL_LEN` bigint(20), `NUM_TRUES` bigint(20), `NUM_FALSES` bigint(20), `LAST_ANALYZED` bigint(20) NOT NULL, PRIMARY KEY (`CS_ID`), CONSTRAINT `TAB_COL_STATS_FK` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `PART_COL_STATS` ( `CS_ID` bigint(20) NOT NULL, `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARTITION_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PART_ID` bigint(20) NOT NULL, `LONG_LOW_VALUE` bigint(20), `LONG_HIGH_VALUE` bigint(20), `DOUBLE_HIGH_VALUE` double(53,4), `DOUBLE_LOW_VALUE` double(53,4), `BIG_DECIMAL_LOW_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin, `BIG_DECIMAL_HIGH_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin, `NUM_NULLS` bigint(20) NOT NULL, `NUM_DISTINCTS` bigint(20), `AVG_COL_LEN` double(53,4), `MAX_COL_LEN` bigint(20), `NUM_TRUES` bigint(20), `NUM_FALSES` bigint(20), `LAST_ANALYZED` bigint(20) NOT NULL, PRIMARY KEY (`CS_ID`), CONSTRAINT `PART_COL_STATS_FK` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.011 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE INDEX PCS_STATS_IDX ON PART_COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME,PARTITION_NAME) USING BTREE No rows affected (0.012 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `TYPES` ( `TYPES_ID` bigint(20) NOT NULL, `TYPE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `TYPE1` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `TYPE2` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`TYPES_ID`), UNIQUE KEY `UNIQUE_TYPE` (`TYPE_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.009 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `TYPE_FIELDS` ( `TYPE_NAME` bigint(20) NOT NULL, `COMMENT` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `FIELD_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `FIELD_TYPE` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`TYPE_NAME`,`FIELD_NAME`), KEY `TYPE_FIELDS_N49` (`TYPE_NAME`), CONSTRAINT `TYPE_FIELDS_FK1` FOREIGN KEY (`TYPE_NAME`) REFERENCES `TYPES` (`TYPES_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.009 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `MASTER_KEYS` ( `KEY_ID` INTEGER NOT NULL AUTO_INCREMENT, `MASTER_KEY` VARCHAR(767) BINARY NULL, PRIMARY KEY (`KEY_ID`) ) ENGINE=INNODB DEFAULT CHARSET=latin1 No rows affected (0.009 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `DELEGATION_TOKENS` ( `TOKEN_IDENT` VARCHAR(767) BINARY NOT NULL, `TOKEN` VARCHAR(767) BINARY NULL, PRIMARY KEY (`TOKEN_IDENT`) ) ENGINE=INNODB DEFAULT CHARSET=latin1 No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `VERSION` ( `VER_ID` BIGINT NOT NULL, `SCHEMA_VERSION` VARCHAR(127) NOT NULL, `VERSION_COMMENT` VARCHAR(255), PRIMARY KEY (`VER_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.011 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `FUNCS` ( `FUNC_ID` BIGINT(20) NOT NULL, `CLASS_NAME` VARCHAR(4000) CHARACTER SET latin1 COLLATE latin1_bin, `CREATE_TIME` INT(11) NOT NULL, `DB_ID` BIGINT(20), `FUNC_NAME` VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_bin, `FUNC_TYPE` INT(11) NOT NULL, `OWNER_NAME` VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_bin, `OWNER_TYPE` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_bin, PRIMARY KEY (`FUNC_ID`), UNIQUE KEY `UNIQUEFUNCTION` (`FUNC_NAME`, `DB_ID`), KEY `FUNCS_N49` (`DB_ID`), CONSTRAINT `FUNCS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.009 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `FUNC_RU` ( `FUNC_ID` BIGINT(20) NOT NULL, `RESOURCE_TYPE` INT(11) NOT NULL, `RESOURCE_URI` VARCHAR(4000) CHARACTER SET latin1 COLLATE latin1_bin, `INTEGER_IDX` INT(11) NOT NULL, PRIMARY KEY (`FUNC_ID`, `INTEGER_IDX`), CONSTRAINT `FUNC_RU_FK1` FOREIGN KEY (`FUNC_ID`) REFERENCES `FUNCS` (`FUNC_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.006 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `NOTIFICATION_LOG` ( `NL_ID` BIGINT(20) NOT NULL, `EVENT_ID` BIGINT(20) NOT NULL, `EVENT_TIME` INT(11) NOT NULL, `EVENT_TYPE` varchar(32) NOT NULL, `DB_NAME` varchar(128), `TBL_NAME` varchar(128), `MESSAGE` mediumtext, PRIMARY KEY (`NL_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.011 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE IF NOT EXISTS `NOTIFICATION_SEQUENCE` ( `NNI_ID` BIGINT(20) NOT NULL, `NEXT_EVENT_ID` BIGINT(20) NOT NULL, PRIMARY KEY (`NNI_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.008 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE TXNS ( TXN_ID bigint PRIMARY KEY, TXN_STATE char(1) NOT NULL, TXN_STARTED bigint NOT NULL, TXN_LAST_HEARTBEAT bigint NOT NULL, TXN_USER varchar(128) NOT NULL, TXN_HOST varchar(128) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.005 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE TXN_COMPONENTS ( TC_TXNID bigint, TC_DATABASE varchar(128) NOT NULL, TC_TABLE varchar(128), TC_PARTITION varchar(767), FOREIGN KEY (TC_TXNID) REFERENCES TXNS (TXN_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.04 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID bigint, CTC_DATABASE varchar(128) NOT NULL, CTC_TABLE varchar(128), CTC_PARTITION varchar(767) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.006 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE NEXT_TXN_ID ( NTXN_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.007 seconds) 0: jdbc:mysql://master:3306/metastore> INSERT INTO NEXT_TXN_ID VALUES(1) 1 row affected (0.005 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE HIVE_LOCKS ( HL_LOCK_EXT_ID bigint NOT NULL, HL_LOCK_INT_ID bigint NOT NULL, HL_TXNID bigint, HL_DB varchar(128) NOT NULL, HL_TABLE varchar(128), HL_PARTITION varchar(767), HL_LOCK_STATE char(1) not null, HL_LOCK_TYPE char(1) not null, HL_LAST_HEARTBEAT bigint NOT NULL, HL_ACQUIRED_AT bigint, HL_USER varchar(128) NOT NULL, HL_HOST varchar(128) NOT NULL, PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID), KEY HIVE_LOCK_TXNID_INDEX (HL_TXNID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE INDEX HL_TXNID_IDX ON HIVE_LOCKS (HL_TXNID) No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE NEXT_LOCK_ID ( NL_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.006 seconds) 0: jdbc:mysql://master:3306/metastore> INSERT INTO NEXT_LOCK_ID VALUES(1) 1 row affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE COMPACTION_QUEUE ( CQ_ID bigint PRIMARY KEY, CQ_DATABASE varchar(128) NOT NULL, CQ_TABLE varchar(128) NOT NULL, CQ_PARTITION varchar(767), CQ_STATE char(1) NOT NULL, CQ_TYPE char(1) NOT NULL, CQ_WORKER_ID varchar(128), CQ_START bigint, CQ_RUN_AS varchar(128) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.008 seconds) 0: jdbc:mysql://master:3306/metastore> CREATE TABLE NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.006 seconds) 0: jdbc:mysql://master:3306/metastore> INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1) 1 row affected (0.004 seconds) 0: jdbc:mysql://master:3306/metastore> INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '1.2.0', 'Hive release version 1.2.0') 1 row affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */ No rows affected (0.001 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */ No rows affected (0.002 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */ No rows affected (0.003 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */ No rows affected (0.008 seconds) 0: jdbc:mysql://master:3306/metastore> /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */ No rows affected (0.01 seconds) 0: jdbc:mysql://master:3306/metastore> !closeall Closing: 0: jdbc:mysql://master:3306/metastore?useSSL=false beeline> Initialization script completed schemaTool completed
