活动介绍

oracle查看PASSWORD_LOCK_TIME

时间: 2025-02-10 15:07:17 浏览: 126
### Oracle 数据库 PASSWORD_LOCK_TIME 参数说明 在 Oracle 数据库中,`PASSWORD_LOCK_TIME` 参数用于指定当账户因多次登录失败而被锁定后,该账户保持锁定状态的时间长度(单位为天)。一旦超过此时间期限,账户将自动解锁[^2]。 对于 `PASSWORD_LOCK_TIME` 的配置与查询操作如下: #### 修改 Password Profile 中的 LOCK TIME 设置 可以利用 SQL 命令来调整特定概要文件下的锁定期限: ```sql ALTER PROFILE <PROFILE_NAME> LIMIT PASSWORD_LOCK_TIME <DAYS>; ``` 这里的 `<PROFILE_NAME>` 是指代具体的安全策略名称;`<DAYS>` 则代表希望设定的具体锁定持续日数。如果想要永久锁定,则可设为 `UNLIMITED`[^1]。 #### 查询当前系统的 Lock Time 配置情况 为了获取现有用户资源限制详情,包括但不限于 `PASSWORD_LOCK_TIME` ,可以通过访问数据字典视图执行以下语句: ```sql SELECT * FROM dba_profiles WHERE resource_name='PASSWORD_LOCK_TIME'; ``` 这会返回所有已定义概要文件里有关于密码锁定时长的相关记录[^5]。
相关问题

oracle PASSWORD_LOCK_TIME

### Oracle `PASSWORD_LOCK_TIME` 参数详解 #### 定义与作用 `PASSWORD_LOCK_TIME` 是用于定义当账户因多次登录失败而被锁定之后保持锁定状态的时间长度。在此期间,任何尝试访问该用户的操作都将被拒绝,直到过了设定的时间间隔后自动解锁[^3]。 #### 默认值及其影响 默认情况下,在许多版本中此参数可能未设置或设为零天表示永久锁住直至管理员手动干预解除封锁;如果指定了具体数值,则按照所给定的小时数来计算等待期。需要注意的是不同版本之间可能存在差异因此建议查阅对应官方文档获取最准确的信息[^5]。 #### 设置方法 可以通过修改概要文件中的相应条目来进行调整: ```sql ALTER PROFILE <PROFILE_NAME> LIMIT PASSWORD_LOCK_TIME <hours>; ``` 这里 `<PROFILE_NAME>` 应替换为目标配置名称,而 `<hours>` 则是要应用的新锁定持续时间(单位为小时)。例如,为了使某特定用户组下的成员在遭遇连续错误认证请求后的冻结期限变为一天半即36个小时可执行如下命令[^1]: ```sql ALTER PROFILE my_custom_profile LIMIT PASSWORD_LOCK_TIME 36; ``` 对于希望更改全局行为的情况,默认概况也可以受到影响: ```sql ALTER PROFILE DEFAULT LIMIT PASSWORD_LOCK_TIME UNLIMITED; -- 或者指定具体的小时数而非 'UNLIMITED' ``` 上述指令将改变整个实例内新创建对象以及那些继承自缺省模板的老实体的行为模式[^2]。

select limit from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LOCK_TIME'查询的结果为.0069什么意思

查询结果 .0069 意味着 PASSWORD_LOCK_TIME 这个资源的限制是 0.0069 天,即约 10 分钟。这意味着,当一个用户在 Oracle 数据库中登录失败多次后,该用户将被锁定一段时间,约为 10 分钟。在这段时间内,该用户将无法登录数据库,直到锁定时间到期。如果需要更改这个限制,您可以使用 ALTER PROFILE 命令修改 PASSWORD_LOCK_TIME 参数的值。例如,要将锁定时间延长到 30 分钟,可以使用以下命令: ``` ALTER PROFILE DEFAULT LIMIT PASSWORD_LOCK_TIME 0.0208; ``` 这将把锁定时间设置为 0.0208 天,即约为 30 分钟。请注意,这个命令将会修改 DEFAULT 配置文件的限制,因此将影响所有使用该配置文件的用户。
阅读全文

相关推荐

[client] port=3306 [mysql] no-beep default-character-set = utf8mb4 [mysqld] init_connect='SET autocommit=0;' init_file=E:\\MySQL\\init.sql # 基础配置 port=3306 datadir=E:\MySQL\Data default-storage-engine=INNODB server-id=1 lower_case_table_names=1 secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.2/Uploads" # 修复连接问题的关键设置 bind-address=0.0.0.0 # 允许所有IP连接 skip_name_resolve=ON # 禁用DNS反向解析 # 认证策略修复 authentication_policy=mysql_native_password, # 字符集 character-set-server=utf8mb4 collation-server=utf8mb4_0900_ai_ci # SQL模式 sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" # 日志配置 log-output=FILE general-log=0 general_log_file="XIANJH.log" slow-query-log=1 slow_query_log_file="XIANJH-slow.log" long_query_time=3 log-error="XIANJH.err" log-bin="XIANJH-bin" binlog_expire_logs_seconds=604800 # 内存优化 max_connections=300 table_open_cache=5000 table_open_cache_instances=16 temptable_max_ram=2G tmp_table_size=512M max_heap_table_size=512M internal_tmp_mem_storage_engine=TempTable # InnoDB优化 innodb_buffer_pool_size=40G innodb_log_file_size=2G innodb_buffer_pool_instances=16 innodb_log_buffer_size=256M innodb_redo_log_capacity=4G innodb_flush_log_at_trx_commit=2 innodb_autoinc_lock_mode=2 bulk_insert_buffer_size=256M innodb_doublewrite=ON innodb_io_capacity=8000 innodb_io_capacity_max=16000 innodb_use_native_aio=ON innodb_flush_method=normal # 线程优化 innodb_thread_concurrency=0 innodb_parallel_read_threads=10 innodb_read_io_threads=10 innodb_write_io_threads=10 thread_cache_size=50 innodb_purge_threads=4 # 连接与网络 max_allowed_packet=256M net_buffer_length=32K max_connect_errors=1000 wait_timeout=300 interactive_timeout=300 # 文件与缓存 open_files_limit=10000 innodb_open_files=5000 innodb_file_per_table=ON innodb_autoextend_increment=128 # 查询优化 join_buffer_size=4M sort_buffer_size=4M read_buffer_size=1M read_rnd_buffer_size=1M # 性能与安全 performance_schema=ON innodb_checksum_algorithm=0 innodb_old_blocks_time=1000 innodb_stats_on_metadata=0 flush_time=0 # 复制相关 binlog_row_event_max_size=8K sync_source_info=10000 sync_relay_log=10000 # MySQL X Protocol loose_mysqlx_port=33060 这是我目前的my.ini的配置,我电脑是WIN10的操作系统,MYSQL版本是8.2,CPU是10核20线程的E5 2666V3,运存是4通道共64G服务器DD3内存,硬盘是SATA协议的1T SSD

<input type="text" readonly="readonly" autocomplete="off" placeholder="请选择数据中心" class="el-input__inner">X1 <input type="text" disabled="disabled" readonly="readonly" autocomplete="off" placeholder="请选择业务应用" class="el-input__inner"> 无数据 <input type="text" disabled="disabled" readonly="readonly" autocomplete="off" placeholder="请选择子业务应用" class="el-input__inner"> 无数据 <input type="text" readonly="readonly" autocomplete="off" placeholder="请选择资产类别" class="el-input__inner">虚拟服务器物理服务器备份一体机时钟服务器数据库服务器存储网络设备 <input type="text" readonly="readonly" autocomplete="off" placeholder="请选择资产品牌" class="el-input__inner">华为华三中兴迪普锐捷博科同有天融信深信服爱数戴尔 <input type="text" autocomplete="off" placeholder="请选择状态" class="el-input__inner" readonly="readonly"> <input type="text" autocomplete="off" placeholder="请选择所在分区" class="el-input__inner" readonly="readonly"> <button data-v-40b64b12="" type="button" class="el-button el-button--info btn-5 el-button--default el-button--medium"> 条件重置 </button> <input type="text" autocomplete="off" placeholder="请输入资产名称/IP/细分业务进行搜索" class="el-input__inner"> <button data-v-40b64b12="" type="button" class="el-button searchBtn el-button--default el-button--medium"></button> 序号资产名称IP地址监控点名称告警时间重试次数运维单位负责人联系方式详细信息告警状态1mesdb110.10.10.11Oracle行锁争用检查2025-07-17 16:31:050Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 2mesdb110.10.10.11Oracle行锁争用检查2025-07-17 16:31:040Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 3mesdb110.10.10.11Oracle行锁争用检查2025-07-17 16:31:040Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 4mesdb110.10.10.11Oracle行锁争用检查2025-07-17 16:31:030Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 5mesdb110.10.10.11Oracle行锁争用检查2025-07-17 16:31:030Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 6mesdb110.10.10.11Oracle行锁争用检查2025-07-17 16:31:020Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 7mesdb110.10.10.11Oracle行锁争用检查2025-07-17 16:31:011Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 8mesdb110.10.10.11Oracle行锁争用检查2025-07-17 16:31:010Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 9mesdb110.10.10.11Oracle行锁争用检查2025-07-17 16:31:010Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 10mesdb110.10.10.11Oracle行锁争用检查2025-07-17 13:11:050Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 11mesdb110.10.10.11Oracle行锁争用检查2025-07-17 13:11:040Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 12mesdb110.10.10.11Oracle行锁争用检查2025-07-17 13:11:040Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 13mesdb110.10.10.11Oracle行锁争用检查2025-07-17 13:11:030Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 14mesdb110.10.10.11Oracle行锁争用检查2025-07-17 13:11:020Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 15mesdb110.10.10.11Oracle行锁争用检查2025-07-17 13:11:020Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 16mesdb110.10.10.11Oracle行锁争用检查2025-07-17 13:11:011Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 17mesdb110.10.10.11Oracle行锁争用检查2025-07-17 13:11:010Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 18mesdb110.10.10.11Oracle行锁争用检查2025-07-17 13:11:010Not FoundundefinedundefinedCRITICAL - select count(*) from v$session where event ='enq: tx - row lock contention' : 1 严重告警 共 6024 条<button type="button" disabled="disabled" class="btn-prev"></button>123456335<button type="button" class="btn-next"></button>前往<input type="number" autocomplete="off" min="1" max="335" class="el-input__inner"> 爬取这个分页表的全部数据到excel里面

root@hadoop01 ~]# cd /export/servers/apache-hive-3.1.3-bin [root@hadoop01 apache-hive-3.1.3-bin]# bin/schematool -initSchema -dbType mysql -verbose 2025-06-16 19:07:53,311 INFO conf.HiveConf: Found configuration file file:/export/servers/apache-hive-3.1.3-bin/conf/hive-site.xml 2025-06-16 19:07:54,059 INFO tools.HiveSchemaHelper: Metastore connection URL: jdbc:mysql://hadoop01:3306/hive?createDatabaseIfNotExist=true&useSSL=false Metastore connection URL: jdbc:mysql://hadoop01:3306/hive?createDatabaseIfNotExist=true&useSSL=false 2025-06-16 19:07:54,059 INFO tools.HiveSchemaHelper: Metastore Connection Driver : com.mysql.jdbc.Driver Metastore Connection Driver : com.mysql.jdbc.Driver 2025-06-16 19:07:54,059 INFO tools.HiveSchemaHelper: Metastore connection User: root 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://hadoop01:3306/hive?createDatabaseIfNotExist=true&useSSL=false Connected to: MySQL (version 5.7.44) Driver: MySQL Connector Java (version mysql-connector-java-5.1.32 ( Revision: [email protected] )) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:mysql://hadoop01:3306/hive> !autocommit on Autocommit status: true 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */ No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET NAMES utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40103 SET TIME_ZONE='+00:00' */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */ No rows affected (0.008 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.014 seconds) 0: jdbc:mysql://hadoop01:3306/hive> INSERT INTO CTLGS VALUES (1, 'hive', 'Default catalog for Hive', 'TBD') 1 row affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.009 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.03 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.026 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.021 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.023 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.022 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.015 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.014 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.009 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.024 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.019 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.006 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.008 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.006 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.009 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.006 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.hive.metastore.model.MNotificationLog', 1) 1 row affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.008 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.015 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE INDEX MV_UNIQUE_TABLE ON MV_CREATION_METADATA (TBL_NAME, DB_NAME) USING BTREE No rows affected (0.014 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.004 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.027 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.021 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.031 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE INDEX TAB_COL_STATS_IDX ON TAB_COL_STATS (CAT_NAME, DB_NAME, TABLE_NAME, COLUMN_NAME) USING BTREE No rows affected (0.018 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.015 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.02 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.007 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.013 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = @saved_cs_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET @saved_cs_client = @@character_set_client */ No rows affected (0.001 seconds) 0: jdbc:mysql://hadoop01:3306/hive> /*!40101 SET character_set_client = utf8 */ No rows affected (0.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.025 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.02 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.016 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.017 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.01 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.003 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.011 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.002 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE INDEX CONSTRAINTS_PARENT_TABLE_ID_INDEX ON KEY_CONSTRAINTS (PARENT_TBL_ID) USING BTREE No rows affected (0.021 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE INDEX CONSTRAINTS_CONSTRAINT_TYPE_INDEX ON KEY_CONSTRAINTS (CONSTRAINT_TYPE) USING BTREE No rows affected (0.021 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.02 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.033 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.021 seconds) 0: jdbc:mysql://hadoop01:3306/hive> ALTER TABLE WM_RESOURCEPLAN ADD CONSTRAINT WM_RESOURCEPLAN_FK1 FOREIGN KEY (DEFAULT_POOL_ID) REFERENCES WM_POOL(POOL_ID) No rows affected (0.017 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.016 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.025 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.026 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.015 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.032 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE INDEX TC_TXNID_INDEX ON TXN_COMPONENTS (TC_TXNID) No rows affected (0.023 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.021 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE INDEX COMPLETED_TXN_COMPONENTS_IDX ON COMPLETED_TXN_COMPONENTS (CTC_DATABASE, CTC_TABLE, CTC_PARTITION) USING BTREE No rows affected (0.019 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE TABLE NEXT_TXN_ID ( NTXN_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.026 seconds) 0: jdbc:mysql://hadoop01:3306/hive> INSERT INTO NEXT_TXN_ID VALUES(1) 1 row affected (0.009 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.028 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE INDEX HL_TXNID_IDX ON HIVE_LOCKS (HL_TXNID) No rows affected (0.016 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE TABLE NEXT_LOCK_ID ( NL_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.017 seconds) 0: jdbc:mysql://hadoop01:3306/hive> INSERT INTO NEXT_LOCK_ID VALUES(1) 1 row affected (0.006 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.013 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.01 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE TABLE NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT bigint NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 No rows affected (0.007 seconds) 0: jdbc:mysql://hadoop01:3306/hive> INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1) 1 row affected (0.005 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.011 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.01 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.019 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE UNIQUE INDEX TBL_TO_TXN_ID_IDX ON TXN_TO_WRITE_ID (T2W_DATABASE, T2W_TABLE, T2W_TXNID) No rows affected (0.046 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE UNIQUE INDEX TBL_TO_WRITE_ID_IDX ON TXN_TO_WRITE_ID (T2W_DATABASE, T2W_TABLE, T2W_WRITEID) No rows affected (0.022 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.022 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE UNIQUE INDEX NEXT_WRITE_ID_IDX ON NEXT_WRITE_ID (NWI_DATABASE, NWI_TABLE) No rows affected (0.033 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.014 seconds) 0: jdbc:mysql://hadoop01:3306/hive> CREATE INDEX MIN_HISTORY_LEVEL_IDX ON MIN_HISTORY_LEVEL (MHL_MIN_OPEN_TXNID) No rows affected (0.013 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.012 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.018 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.024 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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.023 seconds) 0: jdbc:mysql://hadoop01:3306/hive> 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 Error: Table 'RUNTIME_STATS' already exists (state=42S01,code=1050) Closing: 0: jdbc:mysql://hadoop01:3306/hive?createDatabaseIfNotExist=true&useSSL=false org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! Underlying cause: java.io.IOException : Schema script failed, errorcode 2 org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:594) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:567) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1517) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:328) at org.apache.hadoop.util.RunJar.main(RunJar.java:241) Caused by: java.io.IOException: Schema script failed, errorcode 2 at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1226) at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:1204) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:590) ... 8 more *** schemaTool failed ***

最新推荐

recommend-type

Oracle 11gR2创建PASSWORD_VERIFY_FUNCTION对应密码复杂度验证函数步骤.doc

PASSWORD_LOCK_TIME 1 PASSWORD_GRACE_TIME 10 PASSWORD_VERIFY_FUNCTION verify_function_11G; ``` 3. **创建验证函数(VERIFY_FUNCTION_11G)**: 接下来,你需要编写一个PL/SQL函数,如`verify_function_11...
recommend-type

基于llm的围棋训练应用.zip

基于llm的围棋训练应用.zip
recommend-type

破解dex2jar: Android应用反编译与分析指南

标题中的“dex2jar”指的是一个用于将Android应用程序中的DEX文件(Dalvik可执行文件)转换成Java JAR文件的工具。这个过程被称为“DEX转JAR”,是一个逆向工程的过程,它允许开发者查看和分析Android应用程序的原始Java代码,这通常用于学习、测试和安全分析目的。破解一词在此上下文中可能用于描述不正当手段获取程序的源代码以进行修改或绕过安全机制等行为,但请注意,任何未经授权的修改和使用都可能违反法律和版权。 描述部分提供了使用dex2jar工具的基本步骤。dex2jar通常是一个批处理文件(dex2jar.bat),用于在Windows环境下执行操作。它将DEX文件(classes.dex)作为输入,并生成对应的JAR文件。这个过程需要用户已经下载并解压了dex2jar的压缩包,并将其中的dex2jar.bat文件放在一个可以访问的目录中。然后,用户需要将目标Android应用程序中的classes.dex文件复制到该目录下,并在命令行界面中运行以下命令: dex2jar.bat classes.dex 执行完毕后,会在同一目录下生成名为classes.dex.dex2jar.jar的文件。这个JAR文件实质上是将DEX文件中的类转换成了Java的.class文件,并打包成了JAR格式,供后续的分析或修改使用。 【标签】中的“Android 破解”可能被误解为破解Android应用程序的安全机制,实际上,这个标签更准确的意义是分析和理解Android应用程序的工作原理。而“jar dex”则是指JAR文件与DEX文件之间的转换关系。 【压缩包子文件的文件名称列表】中列举了几个文件名,其中“使用说明.txt”很可能是该工具的官方使用指南,提供更详细的使用说明、安装步骤和常见问题的解答。“dex2jar最新版下载dex2jar下载 2.0官方版_ - pc6下载站.url”则是一个指向PC6下载站上dex2jar工具下载页面的网页链接。“dex2jar-2.0”可能是指特定版本号的dex2jar工具压缩包。 总结以上信息,dex2jar是一个专门用于Android应用安全分析和逆向工程的工具,它将DEX文件转换成Java的JAR文件以便进行代码的查看和分析。尽管这个过程在安全研究和教育目的下是合法且有价值的,但任何使用这一工具的非法破解、侵犯版权或进行恶意行为都是不可接受的。
recommend-type

共享内存与共识算法详解

### 共享内存与共识算法详解 在分布式系统中,共享内存和共识算法是两个核心的概念。共享内存涉及到多个进程对同一数据的读写操作,而共识算法则帮助多个进程在可能存在故障的情况下达成一致的决策。下面将详细介绍这两个方面的相关知识。 #### 共享内存 共享内存的寄存器规范由Lamport在多篇论文中引入,同时定义了安全、规则和原子三种语义。 - **安全寄存器**:在三种寄存器语义中,安全寄存器提供的保证最弱。当读操作与写操作并发时,安全寄存器可能返回任意值,甚至可能是从未被写入或尝试写入的值。在多处理器机器中,进程可能并发访问实现寄存器抽象的底层硬件位置,从而导致返回任意值。在任意故障模型中
recommend-type

计算机专业本科生和研究生就业薪资待遇

<think>好的,我需要回答用户关于计算机专业本科和研究生就业薪资对比的问题。首先,我得先看看用户提供的引用资料,看看里面有没有相关的数据。 引用[4]提到,2019届计算机类本科毕业生的平均月收入是6858元,而高职是4883元。这应该可以作为本科生的参考数据。至于研究生,引用[1]指出重庆大学的计算机和软件硕士就业情况良好,薪资高于行业平均水平,但没有具体数字。不过引用[3]提到,前20名的高校多为985/211,尤其是理工类院校的毕业生薪资更高。这里可能需要结合其他信息来推断研究生的薪资水平。 另外,引用[2]提到计算机专业毕业生薪资一般在万元以上,但不确定这是否特指研究生还是包括
recommend-type

eWebEditor 10.3最新版特性与安全升级指南

从提供的信息来看,我们需要深入了解和探讨的内容主要集中在“eWebEditor最新版”这一主题上。eWebEditor是一款流行的在线HTML编辑器,它支持ASP和ASP.NET环境,并广泛用于Web内容管理。通过给出的标题和描述,以及标签和文件名称列表,我们可以推导出一系列相关的知识点。 ### 标题知识点解析 #### eWebEditor的定义与功能 “eWebEditor最新版”中提到的“eWebEditor”指的是在线HTML编辑器产品,它被广泛应用于需要在线编辑和发布网页内容的场合。编辑器通常包含许多功能,比如文本格式化、图像插入、链接管理等,提供用户友好和接近桌面程序的编辑体验。eWebEditor产品以ASP和ASP.NET作为其主要的技术平台。 #### “最新版”更新内容 “最新版”表明我们正在讨论的是eWebEditor的最新版本更新,该版本很可能是为了增加新功能、提升性能、修复已知问题或改善安全性能。一般来说,软件的更新也可能会引入对新操作系统或浏览器的兼容性,以及对现有API或开发环境的新支持。 ### 描述知识点解析 #### “亲测可用”的含义 从“亲测 可用”的描述中我们可以推断出,发布者可能已经对“eWebEditor最新版”进行了测试,并验证了其在实际使用中的性能和稳定性。该短语传递出一个积极的信号,即该版本值得信赖,用户可以期待它将正常工作,无需担心兼容性或功能缺失的问题。 ### 标签知识点解析 #### eWebEditor的版本标识 “eWebEditor ASPX 10.3 最新版”中的标签指出我们讨论的版本号为10.3,这是一个具体的产品版本,意味着它可能包含了一些特定的更新或新增特性。通过版本号,我们可以推断产品已经经过了多次迭代和改进。 #### ASPX技术框架 在标签中提到的“ASPX”,这表明eWebEditor最新版支持ASP.NET Web Forms技术,ASPX是ASP.NET网页的标准文件扩展名。这一信息指出编辑器适合使用.NET框架的网站开发环境。 ### 文件名称列表知识点解析 #### “升级说明.txt”文件 “升级说明.txt”是一个文本文件,它可能包含了eWebEditor从上一版本升级到最新版本时的变化说明,例如新增功能、改进的地方以及需要注意的变更。开发者或维护人员在升级时应该仔细阅读这些说明,以便于平滑过渡到新版本,并最大化地利用新功能。 #### “安全说明.txt”文件 “安全说明.txt”文件通常提供了关于软件安全性的相关信息,这可能包括了针对最新版的安全补丁、修复的安全漏洞列表以及安全最佳实践的建议。特别是对于在线编辑器这类直接参与网页内容生成的工具,安全尤为重要,因此,安全说明文件对于确保编辑器和整个网站的安全运行至关重要。 #### “ewebeditor”文件夹或组件 “ewebeditor”可能是实际包含eWebEditor编辑器文件的文件夹名称。通常,这类文件夹内会包含用于前端的JavaScript文件、用于后端处理的服务器端代码(ASP.NET或ASP代码),以及相关的样式文件和资源文件。对于开发者来说,了解这些文件和组件的组织结构对于集成和配置编辑器至关重要。 综合以上信息,我们可以了解到eWebEditor的最新版本更新了很多内容,可能包含性能和安全性的提升,并可能对特定的技术平台如ASP.NET提供了更好的支持。用户应该参考升级和安全说明文件,以便正确理解和应用这些更新。对于开发者而言,掌握如何在项目中部署和配置eWebEditor编辑器也是一个重要的技能点。
recommend-type

分布式系统中的时间抽象与故障处理

### 分布式系统中的时间抽象与故障处理 #### 1. 故障检测概述 在分布式系统中,存在三种不同的系统假设:异步系统假设、同步系统假设和部分同步系统假设。异步系统不包含任何时间假设,我们的进程和链路抽象直接体现了这一点。然而,这些抽象不足以定义同步和部分同步系统。 为了添加时间假设,一种方法是用时间保证来扩展进程和链路抽象,但这会导致规范过于复杂。因此,我们引入了故障检测器的抽象概念,它能提供关于哪些进程崩溃、哪些进程正常的信息,不过这些信息不一定准确。 故障检测器抽象相较于直接对进程和链路做时间假设具有以下两个优势: - 减轻了用时间假设扩展进程和链路抽象的需求,保留了这些抽象的简
recommend-type

我发一份参考课程设计目录

<think>好的,用户之前问过关于高校实验室安排系统的数据库课程设计,现在他需要一份参考的课程设计目录。首先,我需要回顾之前的对话,确保目录结构和他之前的问题相关,并且覆盖他提到的核心需求、ER模型、表结构、业务逻辑等内容。 用户现在要目录,可能是在进行课程设计的结构规划,需要明确的章节安排。我需要考虑课程设计通常包含的部分,比如需求分析、系统设计、数据库设计、实现、测试等。同时,结合之前给出的内容,比如ER图、表结构、冲突检测算法等,确保这些部分在目录中有体现。 还要注意用户可能希望目录足够详细,包含各个关键部分,比如摘要、需求分析、数据库设计(包括概念结构、逻辑结构、物理结构)、系统
recommend-type

惠普AMTBrand深度解析与技术特点

标题和描述中提到的“惠普AMTBrand”,可能是指惠普(Hewlett-Packard,简称HP)公司旗下的AMTBrand相关产品或技术。然而,由于给出的信息非常有限,我们可以先从惠普公司以及AMT(Active Management Technology,主动管理技术)两个方面进行展开。惠普是全球知名的IT企业,提供多种计算机硬件、软件、云服务和解决方案,而AMT是英特尔(Intel)研发的一种硬件级别的远程管理技术。 首先,我们来了解惠普公司: 惠普(Hewlett-Packard Enterprise,简称HPE),是全球领先的信息技术解决方案提供商。成立于1939年,由Bill Hewlett和David Packard在一间车库里创立,如今已经成为全球范围内提供广泛IT产品与服务的企业。惠普的产品和服务包括但不限于个人计算机(PC)、打印设备、工作站、服务器、网络设备、存储解决方案以及软件和服务。 惠普在IT服务管理、云计算、大数据和分析等领域均有涉猎,并为各种规模的企业提供从基础架构到应用管理的全方位解决方案。随着数字化转型的不断深入,惠普也在不断地通过研发新技术和收购相关企业来拓展其产品和服务的范围。 接着,我们探索AMT技术: AMT是英特尔推出的一种基于硬件的管理解决方案,它允许IT部门远程管理企业中的个人计算机和其他设备。AMT是一种集成在商用英特尔处理器中的技术,能够在个人电脑关机或者操作系统失效的情况下,提供网络访问以及硬件级别的远程管理功能。这项技术最初由英特尔在2006年发布,历经数代更新,为IT运维人员提供了众多功能,如远程开机、远程维护、软件部署、系统监控等。 AMT的优势主要体现在以下几个方面: 1. 远程访问:即使目标设备没有开机或操作系统出现故障,AMT也可以实现远程访问和管理。 2. 安全性:它提供比传统软件解决方案更为深入的硬件级别安全机制,确保数据传输的安全。 3. 节约成本:通过减少现场支持的需要,AMT能够帮助公司节约维护成本。 4. 提高效率:快速远程解决问题,从而提高IT部门的工作效率和响应速度。 然而,由于AMT技术基于特定的硬件和软件,这意味着用户需要购买带有AMT功能的英特尔处理器和相应的支持软件,同时可能需要来自惠普或其他OEM厂商的相应硬件。 最后,提到“压缩包子文件的文件名称列表”中的“AMTBrand”,这可能意味着提供或关联惠普AMTBrand技术的文件压缩包。考虑到文件名称的单一性和没有其他文件描述提供进一步信息,不能确定这个压缩包内具体包含哪些内容。不过,可以推测该压缩包内可能包含了介绍惠普AMTBrand技术的文档、演示、驱动程序、更新或管理工具等。 综合来看,文件中提到的“惠普AMTBrand”可能是指惠普公司与英特尔AMT技术结合后形成的产品或服务品牌,旨在为用户提供更为高效和安全的远程管理解决方案。考虑到惠普公司自身在IT领域的深厚积累和AMT技术的先进性,惠普AMTBrand很可能为企业级客户提供了重要价值。
recommend-type

分布式编程抽象:概念、应用与挑战

# 分布式编程抽象:概念、应用与挑战 ## 1. 引言 分布式编程抽象旨在解决分布式系统中多进程合作的难题,为分布式程序开发提供模块化策略。通过特定的应用程序编程接口(API),可以利用这些抽象来简化开发过程。 ## 2. 分布式计算的动机 ### 2.1 分布式系统的特点 分布式计算涉及一组寻求合作的进程。部分进程可能会因崩溃或断开连接而停止运行,这就是分布式系统的部分故障特性。正如Leslie Lamport所说:“分布式系统中,一台你甚至不知道存在的计算机故障,可能会使你自己的计算机无法使用。” ### 2.2 合作的挑战 当部分进程失败或断开连接时,仍在运行的进程需要以一致的方式