[
https://issues.apache.org/jira/browse/HIVE-29223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18033293#comment-18033293
]
Denys Kuzmenko edited comment on HIVE-29223 at 10/27/25 5:23 PM:
-----------------------------------------------------------------
{code:java}
2025-10-27 20:06:53,824 ERROR [Metastore-Handler-Pool: Thread-59]
metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(144)) -
MetaException(message:java.lang.NumberFormatException: For input string: "60s")
at
org.apache.hadoop.hive.metastore.ExceptionHandler.newMetaException(ExceptionHandler.java:152)
at
org.apache.hadoop.hive.metastore.ExceptionHandler.defaultMetaException(ExceptionHandler.java:168)
at
org.apache.hadoop.hive.metastore.HMSHandler.create_database_req(HMSHandler.java:1429)
at
org.apache.hadoop.hive.metastore.HMSHandler.create_database(HMSHandler.java:1368)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:91)
at
org.apache.hadoop.hive.metastore.AbstractHMSHandlerProxy.invoke(AbstractHMSHandlerProxy.java:82)
at jdk.proxy2/jdk.proxy2.$Proxy26.create_database(Unknown Source)
at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_database.getResult(ThriftHiveMetastore.java:19312)
at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_database.getResult(ThriftHiveMetastore.java:19291)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
at
org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:104)
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:250)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NumberFormatException: For input string: "60s"
at java.base/java.lang.NumberFormatException.forInputString(Unknown
Source)
at java.base/java.lang.Long.parseLong(Unknown Source)
at java.base/java.lang.Long.parseLong(Unknown Source)
at org.apache.hadoop.conf.Configuration.getLong(Configuration.java:1607)
at org.apache.hadoop.fs.s3a.S3AUtils.longOption(S3AUtils.java:985)
at
org.apache.hadoop.fs.s3a.S3AFileSystem.initThreadPools(S3AFileSystem.java:785)
at
org.apache.hadoop.fs.s3a.S3AFileSystem.initialize(S3AFileSystem.java:555)
at
org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:3615)
at org.apache.hadoop.fs.FileSystem.access$300(FileSystem.java:172)
at
org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:3716)
at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:3667)
at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:557)
at org.apache.hadoop.fs.Path.getFileSystem(Path.java:366)
at
org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider.checkPermissions(StorageBasedAuthorizationProvider.java:409)
at
org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider.authorize(StorageBasedAuthorizationProvider.java:381)
at
org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider.authorize(StorageBasedAuthorizationProvider.java:176)
at
org.apache.hadoop.hive.ql.security.authorization.AuthorizationPreEventListener.authorizeCreateDatabase(AuthorizationPreEventListener.java:238)
at
org.apache.hadoop.hive.ql.security.authorization.AuthorizationPreEventListener.onEvent(AuthorizationPreEventListener.java:165)
at
org.apache.hadoop.hive.metastore.HMSHandler.firePreEvent(HMSHandler.java:4130)
at
org.apache.hadoop.hive.metastore.HMSHandler.create_database_core(HMSHandler.java:1217)
at
org.apache.hadoop.hive.metastore.HMSHandler.create_database_req(HMSHandler.java:1421){code}
Has nothing todo with HMS. make sure to use proper version of Hadoop (3.4.1) as
specified in RN:
https://hive.apache.org/general/downloads/#31-july-2025--release-410-available
wget -P ./jars
[https://repo1.maven.org/maven2/org/apache/hadoop/hadoop-aws/3.4.1/hadoop-aws-3.4.1.jar]
was (Author: dkuzmenko):
{code:java}
2025-10-27 20:06:53,824 ERROR [Metastore-Handler-Pool: Thread-59]
metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(144)) -
MetaException(message:java.lang.NumberFormatException: For input string: "60s")
at
org.apache.hadoop.hive.metastore.ExceptionHandler.newMetaException(ExceptionHandler.java:152)
at
org.apache.hadoop.hive.metastore.ExceptionHandler.defaultMetaException(ExceptionHandler.java:168)
at
org.apache.hadoop.hive.metastore.HMSHandler.create_database_req(HMSHandler.java:1429)
at
org.apache.hadoop.hive.metastore.HMSHandler.create_database(HMSHandler.java:1368)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:91)
at
org.apache.hadoop.hive.metastore.AbstractHMSHandlerProxy.invoke(AbstractHMSHandlerProxy.java:82)
at jdk.proxy2/jdk.proxy2.$Proxy26.create_database(Unknown Source)
at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_database.getResult(ThriftHiveMetastore.java:19312)
at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_database.getResult(ThriftHiveMetastore.java:19291)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
at
org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:104)
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:250)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NumberFormatException: For input string: "60s"
at java.base/java.lang.NumberFormatException.forInputString(Unknown
Source)
at java.base/java.lang.Long.parseLong(Unknown Source)
at java.base/java.lang.Long.parseLong(Unknown Source)
at org.apache.hadoop.conf.Configuration.getLong(Configuration.java:1607)
at org.apache.hadoop.fs.s3a.S3AUtils.longOption(S3AUtils.java:985)
at
org.apache.hadoop.fs.s3a.S3AFileSystem.initThreadPools(S3AFileSystem.java:785)
at
org.apache.hadoop.fs.s3a.S3AFileSystem.initialize(S3AFileSystem.java:555)
at
org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:3615)
at org.apache.hadoop.fs.FileSystem.access$300(FileSystem.java:172)
at
org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:3716)
at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:3667)
at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:557)
at org.apache.hadoop.fs.Path.getFileSystem(Path.java:366)
at
org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider.checkPermissions(StorageBasedAuthorizationProvider.java:409)
at
org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider.authorize(StorageBasedAuthorizationProvider.java:381)
at
org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider.authorize(StorageBasedAuthorizationProvider.java:176)
at
org.apache.hadoop.hive.ql.security.authorization.AuthorizationPreEventListener.authorizeCreateDatabase(AuthorizationPreEventListener.java:238)
at
org.apache.hadoop.hive.ql.security.authorization.AuthorizationPreEventListener.onEvent(AuthorizationPreEventListener.java:165)
at
org.apache.hadoop.hive.metastore.HMSHandler.firePreEvent(HMSHandler.java:4130)
at
org.apache.hadoop.hive.metastore.HMSHandler.create_database_core(HMSHandler.java:1217)
at
org.apache.hadoop.hive.metastore.HMSHandler.create_database_req(HMSHandler.java:1421){code}
Has nothing todo with HMS. make sure to use proper version of Hadoop (3.4.1)
wget -P ./jars
[https://repo1.maven.org/maven2/org/apache/hadoop/hadoop-aws/3.4.1/hadoop-aws-3.4.1.jar]
> The BUG is found in apache/hive:4.1.0
> --------------------------------------
>
> Key: HIVE-29223
> URL: https://issues.apache.org/jira/browse/HIVE-29223
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 4.1.0, 4.0.1
> Environment: with image: apache/hive:4.0.1
> * trino> CREATE SCHEMA minio_catalog.mini WITH (location = 's3a://tiny/');
> * CREATE SCHEMA
> with image: apache/hive:4.1.0
> trino> CREATE SCHEMA minio_catalog.mini WITH (location = 's3a://tiny/');
> Query 20250923_071049_00000_ht8pd failed: java.lang.NumberFormatException:
> For input string: "60s"
> Reporter: Naeel
> Assignee: Denys Kuzmenko
> Priority: Major
> Fix For: 4.1.0
>
>
> *The BUG is found in apache/hive:4.1.0*
> _Query 20250923_071049_00000_ht8pd failed: java.lang.NumberFormatException:
> For input string: "60s"_
> _project with docker containers explains_
>
> *_https://github.com/Repinoid/hive410bug_*
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
