[root@c2649-node2 ~]# beeline
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.1.1-1.cdh7.1.1.p0.3266817/jars/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.1.1-1.cdh7.1.1.p0.3266817/jars/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'log4j2.debug' to show Log4j2 internal initia
lization logging.
WARNING: Use "yarn jar" to launch YARN applications.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.1.1-1.cdh7.1.1.p0.3266817/jars/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.1.1-1.cdh7.1.1.p0.3266817/jars/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Connecting to jdbc:hive2://c2649-node2.coelab.cloudera.com:2181,c2649-node3.coelab.cloudera.com:2181,c2649-node4.coelab.cloudera.com:2181/default;serviceDiscoveryMode=zooKeeper;zooKeepe
rNamespace=hiveserver2
Enter username for jdbc:hive2://c2649-node2.coelab.cloudera.com:2181,c2649-node3.coelab.cloudera.com:2181,c2649-node4.coelab.cloudera.com:2181/default: hive
Enter password for jdbc:hive2://c2649-node2.coelab.cloudera.com:2181,c2649-node3.coelab.cloudera.com:2181,c2649-node4.coelab.cloudera.com:2181/default: ****
22/08/05 08:39:15 [main-EventThread]: ERROR imps.EnsembleTracker: Invalid config event received: {server.1=c2649-node4.coelab.cloudera.com:3181:4181:participant, version=0, server.3=c26
49-node3.coelab.cloudera.com:3181:4181:participant, server.2=c2649-node2.coelab.cloudera.com:3181:4181:participant}
22/08/05 08:39:15 [main-EventThread]: ERROR imps.EnsembleTracker: Invalid config event received: {server.1=c2649-node4.coelab.cloudera.com:3181:4181:participant, version=0, server.3=c26
49-node3.coelab.cloudera.com:3181:4181:participant, server.2=c2649-node2.coelab.cloudera.com:3181:4181:participant}
22/08/05 08:39:15 [main]: INFO jdbc.HiveConnection: Connected to c2649-node2.coelab.cloudera.com:10000
Connected to: Apache Hive (version 3.1.3000.7.1.1.0-565)
Driver: Hive JDBC (version 3.1.3000.7.1.1.0-565)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.3000.7.1.1.0-565 by Apache Hive
0: jdbc:hive2://c2649-node2.coelab.cloudera.c> CREATE TABLE IF NOT EXISTS `alter_test` (a string,b string) STORED AS ORC TBLPROPERTIES("transactional"="false");
INFO  : Compiling command(queryId=hive_20220805084028_4957520b-7b89-4b07-8a80-b397e81b5d01): CREATE TABLE IF NOT EXISTS `alter_test` (a string,b string) STORED AS ORC TBLPROPERTIES("tra
nsactional"="false")
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Created Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20220805084028_4957520b-7b89-4b07-8a80-b397e81b5d01); Time taken: 0.054 seconds
INFO  : Executing command(queryId=hive_20220805084028_4957520b-7b89-4b07-8a80-b397e81b5d01): CREATE TABLE IF NOT EXISTS `alter_test` (a string,b string) STORED AS ORC TBLPROPERTIES("tra
nsactional"="false")
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20220805084028_4957520b-7b89-4b07-8a80-b397e81b5d01); Time taken: 0.083 seconds
INFO  : OK
No rows affected (0.24 seconds)
0: jdbc:hive2://c2649-node2.coelab.cloudera.c>
0: jdbc:hive2://c2649-node2.coelab.cloudera.c>
0: jdbc:hive2://c2649-node2.coelab.cloudera.c> show create table alter_test;
INFO  : Compiling command(queryId=hive_20220805084037_a7ea599c-9d5f-488b-9764-91f991627368): show create table alter_test
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null)
INFO  : Completed compiling command(queryId=hive_20220805084037_a7ea599c-9d5f-488b-9764-91f991627368); Time taken: 0.059 seconds
INFO  : Executing command(queryId=hive_20220805084037_a7ea599c-9d5f-488b-9764-91f991627368): show create table alter_test
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20220805084037_a7ea599c-9d5f-488b-9764-91f991627368); Time taken: 0.049 seconds
INFO  : OK
+----------------------------------------------------+
|                   createtab_stmt                   |
+----------------------------------------------------+
| CREATE EXTERNAL TABLE `alter_test`(                |
|   `a` string,                                      |
|   `b` string)                                      |
| ROW FORMAT SERDE                                   |
|   'org.apache.hadoop.hive.ql.io.orc.OrcSerde'      |
| STORED AS INPUTFORMAT                              |
|   'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'  |
| OUTPUTFORMAT                                       |
|   'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' |
| LOCATION                                           |
|   'hdfs://c2649-node2.coelab.cloudera.com:8020/warehouse/tablespace/external/hive/alter_test' |
| TBLPROPERTIES (                                    |
|   'TRANSLATED_TO_EXTERNAL'='TRUE',                 |
|   'bucketing_version'='2',                         |
|   'external.table.purge'='TRUE',                   |
|   'transient_lastDdlTime'='1659688828')            |
+----------------------------------------------------+
16 rows selected (0.202 seconds)
0: jdbc:hive2://c2649-node2.coelab.cloudera.c> ALTER TABLE alter_test SET TBLPROPERTIES('external'='false');
INFO  : Compiling command(queryId=hive_20220805084044_68f11c47-6c85-46b8-aabc-c7b9fb3c4a34): ALTER TABLE alter_test SET TBLPROPERTIES('external'='false')
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Created Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20220805084044_68f11c47-6c85-46b8-aabc-c7b9fb3c4a34); Time taken: 0.061 seconds
INFO  : Executing command(queryId=hive_20220805084044_68f11c47-6c85-46b8-aabc-c7b9fb3c4a34): ALTER TABLE alter_test SET TBLPROPERTIES('external'='false')
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20220805084044_68f11c47-6c85-46b8-aabc-c7b9fb3c4a34); Time taken: 0.136 seconds
INFO  : OK
No rows affected (0.23 seconds)
0: jdbc:hive2://c2649-node2.coelab.cloudera.c> show create table alter_test;
INFO  : Compiling command(queryId=hive_20220805084047_5f20b253-9201-4ceb-89e5-3aa7704ae16b): show create table alter_test
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null)
INFO  : Completed compiling command(queryId=hive_20220805084047_5f20b253-9201-4ceb-89e5-3aa7704ae16b); Time taken: 0.061 seconds
INFO  : Executing command(queryId=hive_20220805084047_5f20b253-9201-4ceb-89e5-3aa7704ae16b): show create table alter_test
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20220805084047_5f20b253-9201-4ceb-89e5-3aa7704ae16b); Time taken: 0.072 seconds
INFO  : OK
+----------------------------------------------------+
|                   createtab_stmt                   |
+----------------------------------------------------+
| CREATE EXTERNAL TABLE `alter_test`(                |
|   `a` string,                                      |
|   `b` string)                                      |
| ROW FORMAT SERDE                                   |
|   'org.apache.hadoop.hive.ql.io.orc.OrcSerde'      |
| STORED AS INPUTFORMAT                              |
|   'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'  |
| OUTPUTFORMAT                                       |
|   'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' |
| LOCATION                                           |
|   'hdfs://c2649-node2.coelab.cloudera.com:8020/warehouse/tablespace/external/hive/alter_test' |
| TBLPROPERTIES (                                    |
|   'TRANSLATED_TO_EXTERNAL'='TRUE',                 |
|   'bucketing_version'='2',                         |
|   'external'='false',                              |
|   'external.table.purge'='TRUE',                   |
|   'last_modified_by'='hive',                       |
|   'last_modified_time'='1659688844',               |
|   'transient_lastDdlTime'='1659688844')            |
+----------------------------------------------------+
19 rows selected (0.179 seconds)
0: jdbc:hive2://c2649-node2.coelab.cloudera.c> ALTER TABLE alter_test RENAME TO alter_test_bak;
INFO  : Compiling command(queryId=hive_20220805084114_48b8f3fc-0b88-4a11-b083-d036b71191bf): ALTER TABLE alter_test RENAME TO alter_test_bak
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Created Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20220805084114_48b8f3fc-0b88-4a11-b083-d036b71191bf); Time taken: 0.121 seconds
INFO  : Executing command(queryId=hive_20220805084114_48b8f3fc-0b88-4a11-b083-d036b71191bf): ALTER TABLE alter_test RENAME TO alter_test_bak
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20220805084114_48b8f3fc-0b88-4a11-b083-d036b71191bf); Time taken: 0.171 seconds
INFO  : OK
No rows affected (0.327 seconds)
0: jdbc:hive2://c2649-node2.coelab.cloudera.c>
0: jdbc:hive2://c2649-node2.coelab.cloudera.c>
0: jdbc:hive2://c2649-node2.coelab.cloudera.c> show create table alter_test_bak;
INFO  : Compiling command(queryId=hive_20220805084121_0d0280e3-3d40-4090-ba87-30bf5512fb63): show create table alter_test_bak
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null)
INFO  : Completed compiling command(queryId=hive_20220805084121_0d0280e3-3d40-4090-ba87-30bf5512fb63); Time taken: 0.062 seconds
INFO  : Executing command(queryId=hive_20220805084121_0d0280e3-3d40-4090-ba87-30bf5512fb63): show create table alter_test_bak
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20220805084121_0d0280e3-3d40-4090-ba87-30bf5512fb63); Time taken: 0.067 seconds
INFO  : OK
+----------------------------------------------------+
|                   createtab_stmt                   |
+----------------------------------------------------+
| CREATE EXTERNAL TABLE `alter_test_bak`(            |
|   `a` string,                                      |
|   `b` string)                                      |
| ROW FORMAT SERDE                                   |
|   'org.apache.hadoop.hive.ql.io.orc.OrcSerde'      |
| STORED AS INPUTFORMAT                              |
|   'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'  |
| OUTPUTFORMAT                                       |
|   'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' |
| LOCATION                                           |
|   'hdfs://c2649-node2.coelab.cloudera.com:8020/warehouse/tablespace/external/hive/alter_test' |
| TBLPROPERTIES (                                    |
|   'TRANSLATED_TO_EXTERNAL'='TRUE',                 |
|   'bucketing_version'='2',                         |
|   'external'='false',                              |
|   'external.table.purge'='TRUE',                   |
|   'last_modified_by'='hive',                       |
|   'last_modified_time'='1659688874',               |
|   'transient_lastDdlTime'='1659688874')            |
+----------------------------------------------------+
19 rows selected (0.166 seconds)
0: jdbc:hive2://c2649-node2.coelab.cloudera.c>