Venugopal Reddy K created HIVE-29481:
----------------------------------------
Summary: Select queries fail with java.lang.NumberFormatException,
when table is created with properties '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
*[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)
