[
https://issues.apache.org/jira/browse/HIVE-29481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venugopal Reddy K updated HIVE-29481:
-------------------------------------
Summary: Select queries fail with java.lang.NumberFormatException, when
table is created with 'transactional'='false' and
'transactional_properties'='insert_only' (was: Select queries fail with
java.lang.NumberFormatException, when table is created with properties
'transactional'='false' and 'transactional_properties'='insert_only' )
> Select queries fail with java.lang.NumberFormatException, when table is
> created with 'transactional'='false' and
> 'transactional_properties'='insert_only'
> ----------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-29481
> URL: https://issues.apache.org/jira/browse/HIVE-29481
> Project: Hive
> Issue Type: Bug
> Environment: {code:java}
> {code}
> Reporter: Venugopal Reddy K
> Priority: Minor
>
> *[Description]*
> Select queries fail with ("Error: Error while compiling statement:
> java.io.IOException: java.lang.NumberFormatException: For input string:
> "0000_copy_1") when table is created with properties 'transactional'='false'
> and 'transactional_properties'='insert_only'.
> *[Steps to reproduce]*
> # Create a table with tblproperties 'transactional'='false' and
> 'transactional_properties'='insert_only'.
> # Insert some data into it.
> # Run a select query on it. Fails with java.lang.NumberFormatException: For
> input string: "0000_copy_1" exception.
> {code:java}
> 0: jdbc:hive2://localhost:10000> create table t1 (i int)
> tblproperties('transactional'='false','transactional_properties'='insert_only');
> 0: jdbc:hive2://localhost:10000>
> 0: jdbc:hive2://localhost:10000> desc formatted t1;
> +-------------------------------+---------------------------------------------------+----------------------------------------------------+
> | col_name | data_type
> | comment |
> +-------------------------------+---------------------------------------------------+----------------------------------------------------+
> | i | int
> | |
> | | NULL
> | NULL |
> | # Detailed Table Information | NULL
> | NULL |
> | Database: | default
> | NULL |
> | OwnerType: | USER
> | NULL |
> | Owner: | hive
> | NULL |
> | CreateTime: | Tue Mar 03 23:16:42 IST 2026
> | NULL |
> | LastAccessTime: | UNKNOWN
> | NULL |
> | Retention: | 0
> | NULL |
> | Location: | file:/tmp/warehouse/managed/t1
> | NULL |
> | Table Type: | MANAGED_TABLE
> | NULL |
> | Table Parameters: | NULL
> | NULL |
> | | COLUMN_STATS_ACCURATE
> | {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"i\":\"true\"}} |
> | | bucketing_version
> | 2 |
> | | numFiles
> | 0 |
> | | numRows
> | 0 |
> | | rawDataSize
> | 0 |
> | | totalSize
> | 0 |
> | | transactional_properties
> | insert_only |
> | | transient_lastDdlTime
> | 1772560002 |
> | | NULL
> | NULL |
> | # Storage Information | NULL
> | NULL |
> | SerDe Library: | org.apache.hadoop.hive.ql.io.orc.OrcSerde
> | NULL |
> | InputFormat: |
> org.apache.hadoop.hive.ql.io.orc.OrcInputFormat | NULL
> |
> | OutputFormat: |
> org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat | NULL
> |
> | Compressed: | No
> | NULL |
> | Num Buckets: | -1
> | NULL |
> | Bucket Columns: | []
> | NULL |
> | Sort Columns: | []
> | NULL |
> | Storage Desc Params: | NULL
> | NULL |
> | | serialization.format
> | 1 |
> +-------------------------------+---------------------------------------------------+----------------------------------------------------+
> 31 rows selected (0.264 seconds)
> 0: jdbc:hive2://localhost:10000> insert into t1 values (1),(2),(3);
> 0: jdbc:hive2://localhost:10000> select * from t1;
> INFO : Compiling
> command(queryId=kvenureddy_20260303232617_1c894296-edfa-4c81-b45e-255d6e874ade):
> select * from t1
> INFO : Semantic Analysis Completed (retrial = false)
> INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:t1.i,
> type:int, comment:null)], properties:null)
> INFO : Completed compiling
> command(queryId=kvenureddy_20260303232617_1c894296-edfa-4c81-b45e-255d6e874ade);
> Time taken: 0.163 seconds
> INFO : Executing
> command(queryId=kvenureddy_20260303232617_1c894296-edfa-4c81-b45e-255d6e874ade):
> select * from t1
> INFO : Completed executing
> command(queryId=kvenureddy_20260303232617_1c894296-edfa-4c81-b45e-255d6e874ade);
> Time taken: 0.0 seconds
> ERROR : Failed with exception
> java.io.IOException:java.lang.NumberFormatException: For input string:
> "0000_copy_1"
> java.io.IOException: java.lang.NumberFormatException: For input string:
> "0000_copy_1"
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:628)
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:535)
> at org.apache.hadoop.hive.ql.exec.FetchTask.executeInner(FetchTask.java:194)
> at org.apache.hadoop.hive.ql.exec.FetchTask.execute(FetchTask.java:95)
> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:196)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:142)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:137)
> at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:190)
> at
> org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:234)
> at
> org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:334)
> at
> java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
> at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1899)
> at
> org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:354)
> at
> java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
> at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
> at java.base/java.lang.Thread.run(Thread.java:1583)
> Caused by: java.lang.NumberFormatException: For input string: "0000_copy_1"
> at
> java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67)
> at java.base/java.lang.Integer.parseInt(Integer.java:662)
> at java.base/java.lang.Integer.parseInt(Integer.java:778)
> at
> org.apache.hadoop.hive.ql.io.AcidUtils$ParsedDeltaLight.parse(AcidUtils.java:1082)
> at org.apache.hadoop.hive.ql.io.AcidUtils.parsedDelta(AcidUtils.java:1262)
> at
> org.apache.hadoop.hive.ql.io.AcidUtils.processDeltaDir(AcidUtils.java:1911)
> at org.apache.hadoop.hive.ql.io.AcidUtils.getChildState(AcidUtils.java:1858)
> at org.apache.hadoop.hive.ql.io.AcidUtils.getAcidState(AcidUtils.java:1355)
> at org.apache.hadoop.hive.ql.io.AcidUtils.getAcidState(AcidUtils.java:1321)
> at
> org.apache.hadoop.hive.ql.io.HiveInputFormat.processForWriteIdsForMmRead(HiveInputFormat.java:734)
> at
> org.apache.hadoop.hive.ql.io.HiveInputFormat.processPathsForMmRead(HiveInputFormat.java:683)
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.processCurrPathForMmWriteIds(FetchOperator.java:470)
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextSplits(FetchOperator.java:385)
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.getRecordReader(FetchOperator.java:310)
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:566)
> ... 18 more
>
> Error: Error while compiling statement: java.io.IOException:
> java.lang.NumberFormatException: For input string: "0000_copy_1"; Query ID:
> kvenureddy_20260303232617_1c894296-edfa-4c81-b45e-255d6e874ade (state=,code=1)
> 0: jdbc:hive2://localhost:10000>
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
