You are viewing a plain text version of this content. The canonical link for it is here.
Posted to gitbox@hive.apache.org by "ayushtkn (via GitHub)" <gi...@apache.org> on 2025/06/16 21:26:29 UTC
[PR] HIVE-29022: Schematool fails while initializing hive schema. [hive]
ayushtkn opened a new pull request, #5876:
URL: https://github.com/apache/hive/pull/5876
### What changes were proposed in this pull request?
Add JDK-17 related exports to make schematool work
### Why are the changes needed?
To make schematool work
### Does this PR introduce _any_ user-facing change?
Yes, you can init Hive schema via schematool
### How was this patch tested?
Locally
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
Re: [PR] HIVE-29022: Schematool fails while initializing hive schema. [hive]
Posted by "ayushtkn (via GitHub)" <gi...@apache.org>.
ayushtkn merged PR #5876:
URL: https://github.com/apache/hive/pull/5876
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
Re: [PR] HIVE-29022: Schematool fails while initializing hive schema. [hive]
Posted by "kokila-19 (via GitHub)" <gi...@apache.org>.
kokila-19 commented on PR #5876:
URL: https://github.com/apache/hive/pull/5876#issuecomment-2978912353
I can repro the issue in postgres and derby before the fix and the stack trace is as follows
```
$HIVE_HOME/bin/schematool -dbType hive -metaDbType postgres -initSchema
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/Users/kokila/cdp/upstream/up_hive/hive/packaging/target/apache-hive-4.1.0-SNAPSHOT-bin/apache-hive-4.1.0-SNAPSHOT-bin/lib/log4j-slf4j-impl-2.24.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/Users/kokila/Downloads/apache-tez-0.10.4-bin/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/Users/kokila/cdp/upstream/hadoop/hadoop-3.4.1/share/hadoop/common/lib/slf4j-reload4j-1.7.36.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]
2025-06-17T04:25:04.353035Z main WARN The use of package scanning to locate Log4j plugins is deprecated.
Please remove the `packages` attribute from your configuration file.
See https://logging.apache.org/log4j/2.x/faq.html#package-scanning for details.
2025-06-17T04:25:04.451104Z main INFO Starting configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@5d066c7d...
2025-06-17T04:25:04.451227Z main INFO Start watching for changes to jar:file:/Users/kokila/cdp/upstream/up_hive/hive/packaging/target/apache-hive-4.1.0-SNAPSHOT-bin/apache-hive-4.1.0-SNAPSHOT-bin/lib/hive-common-4.1.0-SNAPSHOT.jar!/hive-log4j2.properties every 0 seconds
2025-06-17T04:25:04.451302Z main INFO Configuration org.apache.logging.log4j.core.config.properties.PropertiesConfiguration@5d066c7d started.
2025-06-17T04:25:04.453019Z main INFO Stopping configuration org.apache.logging.log4j.core.config.DefaultConfiguration@7c24b813...
2025-06-17T04:25:04.453196Z main INFO Configuration org.apache.logging.log4j.core.config.DefaultConfiguration@7c24b813 stopped.
Initializing the schema to: 4.1.0
Metastore connection URL: jdbc:hive2://?hive.conf.restricted.list=;hive.security.authorization.sqlstd.confwhitelist=.*;hive.security.authorization.sqlstd.confwhitelist.append=.*;hive.security.authorization.enabled=false;hive.metastore.uris=;hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdConfOnlyAuthorizerFactory;hive.support.concurrency=false;hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager;hive.metastore.rawstore.impl=org.apache.hadoop.hive.metastore.ObjectStore
Metastore connection Driver : org.apache.hive.jdbc.HiveDriver
Metastore connection User: kokila
Hive Session ID = e6720256-f9d5-49a2-9d86-c2140248f00a
Exception in thread "main" java.lang.ExceptionInInitializerError
at org.apache.hadoop.hive.ql.plan.TableDesc.setProperties(TableDesc.java:132)
at org.apache.hadoop.hive.ql.plan.TableDesc.<init>(TableDesc.java:69)
at org.apache.hadoop.hive.ql.exec.Utilities.<clinit>(Utilities.java:709)
at org.apache.hadoop.hive.ql.session.SessionState.createRootHDFSDir(SessionState.java:865)
at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:806)
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:730)
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:683)
at org.apache.hadoop.hive.ql.DriverUtils.setUpSessionState(DriverUtils.java:110)
at org.apache.hadoop.hive.ql.DriverUtils.setUpAndStartSessionState(DriverUtils.java:98)
at org.apache.hadoop.hive.ql.DriverUtils.setUpAndStartSessionState(DriverUtils.java:94)
at org.apache.hive.service.cli.CLIService.applyAuthorizationConfigPolicy(CLIService.java:133)
at org.apache.hive.service.cli.CLIService.init(CLIService.java:120)
at org.apache.hive.service.cli.thrift.EmbeddedThriftBinaryCLIService.init(EmbeddedThriftBinaryCLIService.java:41)
at org.apache.hive.jdbc.EmbeddedCLIServicePortal.get(EmbeddedCLIServicePortal.java:36)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:387)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:316)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:292)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:94)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:229)
at org.apache.hadoop.hive.metastore.tools.schematool.HiveSchemaHelper.getConnectionToMetastore(HiveSchemaHelper.java:88)
at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.getConnectionToMetastore(MetastoreSchemaTool.java:253)
at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.testConnectionToMetastore(MetastoreSchemaTool.java:338)
at org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:53)
at org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:484)
at org.apache.hive.beeline.schematool.HiveSchemaTool.main(HiveSchemaTool.java:204)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.hadoop.util.RunJar.run(RunJar.java:330)
at org.apache.hadoop.util.RunJar.main(RunJar.java:245)
Caused by: java.lang.reflect.InaccessibleObjectException: Unable to make field private volatile java.lang.String java.net.URI.string accessible: module java.base does not "opens java.net" to unnamed module @74ad2091
at java.base/java.lang.reflect.AccessibleObject.checkCanSetAccessible(AccessibleObject.java:354)
at java.base/java.lang.reflect.AccessibleObject.checkCanSetAccessible(AccessibleObject.java:297)
at java.base/java.lang.reflect.Field.checkCanSetAccessible(Field.java:178)
at java.base/java.lang.reflect.Field.setAccessible(Field.java:172)
at org.apache.hadoop.hive.common.StringInternUtils.<clinit>(StringInternUtils.java:57)
... 32 more
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
Re: [PR] HIVE-29022: Schematool fails while initializing hive schema. [hive]
Posted by "sonarqubecloud[bot] (via GitHub)" <gi...@apache.org>.
sonarqubecloud[bot] commented on PR #5876:
URL: https://github.com/apache/hive/pull/5876#issuecomment-2979063068
## [](https://sonarcloud.io/dashboard?id=apache_hive&pullRequest=5876) **Quality Gate passed**
Issues
 [0 New issues](https://sonarcloud.io/project/issues?id=apache_hive&pullRequest=5876&issueStatuses=OPEN,CONFIRMED&sinceLeakPeriod=true)
 [0 Accepted issues](https://sonarcloud.io/project/issues?id=apache_hive&pullRequest=5876&issueStatuses=ACCEPTED)
Measures
 [0 Security Hotspots](https://sonarcloud.io/project/security_hotspots?id=apache_hive&pullRequest=5876&issueStatuses=OPEN,CONFIRMED&sinceLeakPeriod=true)
 [0.0% Coverage on New Code](https://sonarcloud.io/component_measures?id=apache_hive&pullRequest=5876&metric=new_coverage&view=list)
 [0.0% Duplication on New Code](https://sonarcloud.io/component_measures?id=apache_hive&pullRequest=5876&metric=new_duplicated_lines_density&view=list)
[See analysis details on SonarQube Cloud](https://sonarcloud.io/dashboard?id=apache_hive&pullRequest=5876)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
Re: [PR] HIVE-29022: Schematool fails while initializing hive schema. [hive]
Posted by "sonarqubecloud[bot] (via GitHub)" <gi...@apache.org>.
sonarqubecloud[bot] commented on PR #5876:
URL: https://github.com/apache/hive/pull/5876#issuecomment-2978425195
## [](https://sonarcloud.io/dashboard?id=apache_hive&pullRequest=5876) **Quality Gate passed**
Issues
 [0 New issues](https://sonarcloud.io/project/issues?id=apache_hive&pullRequest=5876&issueStatuses=OPEN,CONFIRMED&sinceLeakPeriod=true)
 [0 Accepted issues](https://sonarcloud.io/project/issues?id=apache_hive&pullRequest=5876&issueStatuses=ACCEPTED)
Measures
 [0 Security Hotspots](https://sonarcloud.io/project/security_hotspots?id=apache_hive&pullRequest=5876&issueStatuses=OPEN,CONFIRMED&sinceLeakPeriod=true)
 [0.0% Coverage on New Code](https://sonarcloud.io/component_measures?id=apache_hive&pullRequest=5876&metric=new_coverage&view=list)
 [0.0% Duplication on New Code](https://sonarcloud.io/component_measures?id=apache_hive&pullRequest=5876&metric=new_duplicated_lines_density&view=list)
[See analysis details on SonarQube Cloud](https://sonarcloud.io/dashboard?id=apache_hive&pullRequest=5876)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
Re: [PR] HIVE-29022: Schematool fails while initializing hive schema. [hive]
Posted by "kokila-19 (via GitHub)" <gi...@apache.org>.
kokila-19 commented on PR #5876:
URL: https://github.com/apache/hive/pull/5876#issuecomment-2978923268
+1 LGTM
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org