hive> create database bclcredits;
2025-06-23 10:54:32,928 INFO conf.HiveConf: Using the default value passed in for log id: a0cb540e-63b3-4c46-b13f-f2a5b6ab7ce2
2025-06-23 10:54:32,929 INFO session.SessionState: Updating thread name to a0cb540e-63b3-4c46-b13f-f2a5b6ab7ce2 main
2025-06-23 10:54:32,930 INFO ql.Driver: Compiling command(queryId=aaa_20250623105432_133779d8-5bc0-4f88-b570-00c704c1efd7): create database bclcredits
2025-06-23 10:54:32,970 INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager
2025-06-23 10:54:32,983 INFO ql.Driver: Semantic Analysis Completed (retrial = false)
2025-06-23 10:54:32,986 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:null, properties:null)
2025-06-23 10:54:32,991 INFO ql.Driver: Completed compiling command(queryId=aaa_20250623105432_133779d8-5bc0-4f88-b570-00c704c1efd7); Time taken: 0.061 seconds
2025-06-23 10:54:32,991 INFO reexec.ReExecDriver: Execution #1 of query
2025-06-23 10:54:32,992 INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager
2025-06-23 10:54:32,992 INFO ql.Driver: Executing command(queryId=aaa_20250623105432_133779d8-5bc0-4f88-b570-00c704c1efd7): create database bclcredits
2025-06-23 10:54:33,003 INFO ql.Driver: Starting task [Stage-0:DDL] in serial mode
2025-06-23 10:54:33,023 INFO sqlstd.SQLStdHiveAccessController: Created SQLStdHiveAccessController for session context : HiveAuthzSessionContext [sessionString=a0cb540e-63b3-4c46-b13f-f2a5b6ab7ce2, clientType=HIVECLI]
2025-06-23 10:54:33,025 WARN session.SessionState: METASTORE_FILTER_HOOK will be ignored, since hive.security.authorization.manager is set to instance of HiveAuthorizerFactory.
2025-06-23 10:54:33,026 INFO metastore.HiveMetaStoreClient: Mestastore configuration metastore.filter.hook changed from org.apache.hadoop.hive.metastore.DefaultMetaStoreFilterHookImpl to org.apache.hadoop.hive.ql.security.authorization.plugin.AuthorizationMetaStoreFilterHook
2025-06-23 10:54:33,027 INFO metastore.HiveMetaStore: 0: Cleaning up thread local RawStore...
2025-06-23 10:54:33,027 INFO HiveMetaStore.audit: ugi=aaa ip=unknown-ip-addr cmd=Cleaning up thread local RawStore...
2025-06-23 10:54:33,027 INFO metastore.HiveMetaStore: 0: Done cleaning up thread local RawStore
2025-06-23 10:54:33,027 INFO HiveMetaStore.audit: ugi=aaa ip=unknown-ip-addr cmd=Done cleaning up thread local RawStore
2025-06-23 10:54:33,029 INFO metastore.HiveMetaStore: 0: Opening raw store with implementation class:org.apache.hadoop.hive.metastore.ObjectStore
2025-06-23 10:54:33,030 WARN metastore.ObjectStore: datanucleus.autoStartMechanismMode is set to unsupported value null . Setting it to value: ignored
2025-06-23 10:54:33,030 INFO metastore.ObjectStore: ObjectStore, initialize called
2025-06-23 10:54:33,033 INFO metastore.MetaStoreDirectSql: Using direct SQL, underlying DB is MYSQL
2025-06-23 10:54:33,033 INFO metastore.ObjectStore: Initialized ObjectStore
2025-06-23 10:54:33,033 INFO metastore.RetryingMetaStoreClient: RetryingMetaStoreClient proxy=class org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ugi=aaa (auth:SIMPLE) retries=1 delay=1 lifetime=0
2025-06-23 10:54:33,037 WARN metastore.ObjectStore: datanucleus.autoStartMechanismMode is set to unsupported value null . Setting it to value: ignored
2025-06-23 10:54:33,037 INFO metastore.ObjectStore: ObjectStore, initialize called
2025-06-23 10:54:33,039 INFO metastore.MetaStoreDirectSql: Using direct SQL, underlying DB is MYSQL
2025-06-23 10:54:33,039 INFO metastore.ObjectStore: Initialized ObjectStore
2025-06-23 10:54:33,040 INFO metastore.RetryingMetaStoreClient: RetryingMetaStoreClient proxy=class org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ugi=aaa (auth:SIMPLE) retries=1 delay=1 lifetime=0
2025-06-23 10:54:33,040 INFO metastore.HiveMetaStore: 0: create_database: Database(name:bclcredits, description:null, locationUri:hdfs://localhost:9000/user/hive/warehouse/bclcredits.db, parameters:null, ownerName:aaa, ownerType:USER, catalogName:hive)
2025-06-23 10:54:33,040 INFO HiveMetaStore.audit: ugi=aaa ip=unknown-ip-addr cmd=create_database: Database(name:bclcredits, description:null, locationUri:hdfs://localhost:9000/user/hive/warehouse/bclcredits.db, parameters:null, ownerName:aaa, ownerType:USER, catalogName:hive)
2025-06-23 10:54:33,045 ERROR metastore.RetryingHMSHandler: AlreadyExistsException(message:Database bclcredits already exists)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_database(HiveMetaStore.java:1311)
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.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:108)
at com.sun.proxy.$Proxy38.create_database(Unknown Source)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createDatabase(HiveMetaStoreClient.java:809)
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.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:212)
at com.sun.proxy.$Proxy39.createDatabase(Unknown Source)
at org.apache.hadoop.hive.ql.metadata.Hive.createDatabase(Hive.java:477)
at org.apache.hadoop.hive.ql.exec.DDLTask.createDatabase(DDLTask.java:4828)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:393)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:205)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:97)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2664)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:2335)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:2011)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1709)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1703)
at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:157)
at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:218)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:188)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:402)
at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:821)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:683)
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:323)
at org.apache.hadoop.util.RunJar.main(RunJar.java:236)
2025-06-23 10:54:33,047 ERROR exec.DDLTask: Failed
org.apache.hadoop.hive.ql.metadata.HiveException: Database bclcredits already exists
at org.apache.hadoop.hive.ql.exec.DDLTask.createDatabase(DDLTask.java:4832)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:393)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:205)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:97)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2664)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:2335)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:2011)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1709)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1703)
at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:157)
at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:218)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:188)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:402)
at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:821)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:683)
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:323)
at org.apache.hadoop.util.RunJar.main(RunJar.java:236)
Caused by: AlreadyExistsException(message:Database bclcredits already exists)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_database(HiveMetaStore.java:1311)
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.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:108)
at com.sun.proxy.$Proxy38.create_database(Unknown Source)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createDatabase(HiveMetaStoreClient.java:809)
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.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:212)
at com.sun.proxy.$Proxy39.createDatabase(Unknown Source)
at org.apache.hadoop.hive.ql.metadata.Hive.createDatabase(Hive.java:477)
at org.apache.hadoop.hive.ql.exec.DDLTask.createDatabase(DDLTask.java:4828)
... 22 more
2025-06-23 10:54:33,048 INFO reexec.ReOptimizePlugin: ReOptimization: retryPossible: false
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Database bclcredits already exists
2025-06-23 10:54:33,049 ERROR ql.Driver: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Database bclcredits already exists
2025-06-23 10:54:33,049 INFO ql.Driver: Completed executing command(queryId=aaa_20250623105432_133779d8-5bc0-4f88-b570-00c704c1efd7); Time taken: 0.057 seconds
2025-06-23 10:54:33,049 INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager
2025-06-23 10:54:33,050 INFO conf.HiveConf: Using the default value passed in for log id: a0cb540e-63b3-4c46-b13f-f2a5b6ab7ce2
2025-06-23 10:54:33,050 INFO session.SessionState: Resetting thread name to main
最新发布