[
https://issues.apache.org/jira/browse/HIVE-29700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhihua Deng updated HIVE-29700:
-------------------------------
Description:
Query:
2026-07-06T14:31:48,365 INFO [14b9e60f-e8d2-41d3-a8a0-3a3d093db644 main]
handler.GetPartitionsHandler: Starting to get partitions of hive.default.tab1_n3
2026-07-06T14:31:48,402 WARN [14b9e60f-e8d2-41d3-a8a0-3a3d093db644 main]
directsql.MetastoreDirectSqlUtils: Failed to execute [select
"PARTITIONS"."PART_ID" from "PARTITIONS" inner join "TBLS" on
"PARTITIONS"."TBL_ID" = "TBLS"."TBL_ID" and "TBLS"."TBL_NAME" = ? inner
join "DBS" on "TBLS"."DB_ID" = "DBS"."DB_ID" and "DBS"."NAME" = ? inner
join "PARTITION_KEY_VALS" "FILTER1" on "FILTER1"."PART_ID" =
"PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 where "DBS"."CTLG_NAME"
= ? and (((case when "FILTER1"."PART_KEY_VAL" <> ? and "TBLS"."TBL_NAME" = ?
and "DBS"."NAME" = ? and "DBS"."CTLG_NAME" = ? and "FILTER1"."PART_ID" =
"PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 then
cast("FILTER1"."PART_KEY_VAL" as date) else null end) = ? and
"PARTITIONS"."PART_NAME" like ? )) order by "PART_NAME" asc] with parameters
[tab1_n3, default, hive, __HIVE_DEFAULT_PARTITION__, tab1_n3, default, hive,
2008-01-01, %/day=2008-01-01%]
javax.jdo.JDODataStoreException: Error executing SQL query "select
"PARTITIONS"."PART_ID" from "PARTITIONS" inner join "TBLS" on
"PARTITIONS"."TBL_ID" = "TBLS"."TBL_ID" and "TBLS"."TBL_NAME" = ? inner
join "DBS" on "TBLS"."DB_ID" = "DBS"."DB_ID" and "DBS"."NAME" = ? inner
join "PARTITION_KEY_VALS" "FILTER1" on "FILTER1"."PART_ID" =
"PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 where "DBS"."CTLG_NAME"
= ? and (((case when "FILTER1"."PART_KEY_VAL" <> ? and "TBLS"."TBL_NAME" = ?
and "DBS"."NAME" = ? and "DBS"."CTLG_NAME" = ? and "FILTER1"."PART_ID" =
"PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 then
cast("FILTER1"."PART_KEY_VAL" as date) else null end) = ? and
"PARTITIONS"."PART_NAME" like ? )) order by "PART_NAME" asc".
Exception:
Caused by: java.sql.SQLDataException: The syntax of the string representation
of a date/time value is incorrect.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:84)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:230)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:431)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:360)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2400)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:86)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1436)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1709)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(EmbedPreparedStatement.java:286)
at
org.apache.hive.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at
org.apache.hive.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at
org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:586)
at
org.datanucleus.store.rdbms.query.SQLQuery.performExecute(SQLQuery.java:669)
at org.datanucleus.store.query.Query.executeQuery(Query.java:2004)
at
org.datanucleus.store.rdbms.query.SQLQuery.executeWithArray(SQLQuery.java:826)
at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:433)
was:
Query:
2026-07-06T14:31:48,365 INFO [14b9e60f-e8d2-41d3-a8a0-3a3d093db644 main]
handler.GetPartitionsHandler: Starting to get partitions of hive.default.tab1_n3
2026-07-06T14:31:48,402 WARN [14b9e60f-e8d2-41d3-a8a0-3a3d093db644 main]
directsql.MetastoreDirectSqlUtils: Failed to execute [select
"PARTITIONS"."PART_ID" from "PARTITIONS" inner join "TBLS" on
"PARTITIONS"."TBL_ID" = "TBLS"."TBL_ID" and "TBLS"."TBL_NAME" = ? inner
join "DBS" on "TBLS"."DB_ID" = "DBS"."DB_ID" and "DBS"."NAME" = ? inner
join "PARTITION_KEY_VALS" "FILTER1" on "FILTER1"."PART_ID" =
"PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 where "DBS"."CTLG_NAME"
= ? and (((case when "FILTER1"."PART_KEY_VAL" <> ? and "TBLS"."TBL_NAME" = ?
and "DBS"."NAME" = ? and "DBS"."CTLG_NAME" = ? and "FILTER1"."PART_ID" =
"PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 then
cast("FILTER1"."PART_KEY_VAL" as date) else null end) = ? and
"PARTITIONS"."PART_NAME" like ? )) order by "PART_NAME" asc] with parameters
[tab1_n3, default, hive, __HIVE_DEFAULT_PARTITION__, tab1_n3, default, hive,
2008-01-01, %/day=2008-01-01%]
javax.jdo.JDODataStoreException: Error executing SQL query "select
"PARTITIONS"."PART_ID" from "PARTITIONS" inner join "TBLS" on
"PARTITIONS"."TBL_ID" = "TBLS"."TBL_ID" and "TBLS"."TBL_NAME" = ? inner
join "DBS" on "TBLS"."DB_ID" = "DBS"."DB_ID" and "DBS"."NAME" = ? inner
join "PARTITION_KEY_VALS" "FILTER1" on "FILTER1"."PART_ID" =
"PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 where "DBS"."CTLG_NAME"
= ? and (((case when "FILTER1"."PART_KEY_VAL" <> ? and "TBLS"."TBL_NAME" = ?
and "DBS"."NAME" = ? and "DBS"."CTLG_NAME" = ? and "FILTER1"."PART_ID" =
"PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 then
cast("FILTER1"."PART_KEY_VAL" as date) else null end) = ? and
"PARTITIONS"."PART_NAME" like ? )) order by "PART_NAME" asc".
Exception:
Caused by: java.sql.SQLDataException: The syntax of the string representation
of a date/time value is incorrect.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:84)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:230)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:431)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:360)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2400)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:86)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1436)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1709)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(EmbedPreparedStatement.java:286)
at
org.apache.hive.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at
org.apache.hive.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at
org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:586)
at
org.datanucleus.store.rdbms.query.SQLQuery.performExecute(SQLQuery.java:669)
at org.datanucleus.store.query.Query.executeQuery(Query.java:2004)
at
org.datanucleus.store.rdbms.query.SQLQuery.executeWithArray(SQLQuery.java:826)
at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:433)
> Fix flaky TestMiniLlapLocalCliDriver partition_type_check
> ---------------------------------------------------------
>
> Key: HIVE-29700
> URL: https://issues.apache.org/jira/browse/HIVE-29700
> Project: Hive
> Issue Type: Bug
> Reporter: Zhihua Deng
> Priority: Major
>
> Query:
> 2026-07-06T14:31:48,365 INFO [14b9e60f-e8d2-41d3-a8a0-3a3d093db644 main]
> handler.GetPartitionsHandler: Starting to get partitions of
> hive.default.tab1_n3
> 2026-07-06T14:31:48,402 WARN [14b9e60f-e8d2-41d3-a8a0-3a3d093db644 main]
> directsql.MetastoreDirectSqlUtils: Failed to execute [select
> "PARTITIONS"."PART_ID" from "PARTITIONS" inner join "TBLS" on
> "PARTITIONS"."TBL_ID" = "TBLS"."TBL_ID" and "TBLS"."TBL_NAME" = ? inner
> join "DBS" on "TBLS"."DB_ID" = "DBS"."DB_ID" and "DBS"."NAME" = ? inner
> join "PARTITION_KEY_VALS" "FILTER1" on "FILTER1"."PART_ID" =
> "PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 where
> "DBS"."CTLG_NAME" = ? and (((case when "FILTER1"."PART_KEY_VAL" <> ? and
> "TBLS"."TBL_NAME" = ? and "DBS"."NAME" = ? and "DBS"."CTLG_NAME" = ? and
> "FILTER1"."PART_ID" = "PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1
> then cast("FILTER1"."PART_KEY_VAL" as date) else null end) = ? and
> "PARTITIONS"."PART_NAME" like ? )) order by "PART_NAME" asc] with parameters
> [tab1_n3, default, hive, __HIVE_DEFAULT_PARTITION__, tab1_n3, default, hive,
> 2008-01-01, %/day=2008-01-01%]
> javax.jdo.JDODataStoreException: Error executing SQL query "select
> "PARTITIONS"."PART_ID" from "PARTITIONS" inner join "TBLS" on
> "PARTITIONS"."TBL_ID" = "TBLS"."TBL_ID" and "TBLS"."TBL_NAME" = ? inner
> join "DBS" on "TBLS"."DB_ID" = "DBS"."DB_ID" and "DBS"."NAME" = ? inner
> join "PARTITION_KEY_VALS" "FILTER1" on "FILTER1"."PART_ID" =
> "PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 where
> "DBS"."CTLG_NAME" = ? and (((case when "FILTER1"."PART_KEY_VAL" <> ? and
> "TBLS"."TBL_NAME" = ? and "DBS"."NAME" = ? and "DBS"."CTLG_NAME" = ? and
> "FILTER1"."PART_ID" = "PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1
> then cast("FILTER1"."PART_KEY_VAL" as date) else null end) = ? and
> "PARTITIONS"."PART_NAME" like ? )) order by "PART_NAME" asc".
> Exception:
> Caused by: java.sql.SQLDataException: The syntax of the string
> representation of a date/time value is incorrect.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:84)
> at
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:230)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:431)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:360)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2400)
> at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:86)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1436)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1709)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(EmbedPreparedStatement.java:286)
> at
> org.apache.hive.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
> at
> org.apache.hive.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
> at
> org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:586)
> at
> org.datanucleus.store.rdbms.query.SQLQuery.performExecute(SQLQuery.java:669)
> at org.datanucleus.store.query.Query.executeQuery(Query.java:2004)
> at
> org.datanucleus.store.rdbms.query.SQLQuery.executeWithArray(SQLQuery.java:826)
> at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:433)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
