[
https://issues.apache.org/jira/browse/HIVE-29481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venugopal Reddy K updated HIVE-29481:
-------------------------------------
Description:
*[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}
was:
*[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}
> 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
> 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)
