[HIVE-26561] Fix test TestMiniLlapLocalCliDriver#stats_part2

• Type: Test
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Tests
• Assignee: Unassigned Assign to me
• Reporter: Zhihua Deng
• Created: 26/Sep/22 08:06
• Updated: 26/Sep/22 21:09

Description

The test is flaky, sometimes failed by: 

Caused by: org.apache.derby.iapi.error.StandardException: Invalid character string format for type DECIMAL.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.iapi.types.DataType.invalidFormat(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.iapi.types.DataType.setValue(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.exe.ac29cfd09cx0183x5e87xdb0ax00002168460057f.e4(Unknown Source) ~[?:?]
        at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) ~[derby-10.14.2.0.jar:?]
        at org.apache.hive.com.zaxxer.hikari.pool.HikariProxyResultSet.next(HikariProxyResultSet.java) ~[hive-exec-4.0.0-alpha-2-SNAPSHOT.jar:4.0.0-alpha-2-SNAPSHOT]
        at org.datanucleus.store.rdbms.query.ForwardQueryResult.initialise(ForwardQueryResult.java:93) ~[datanucleus-rdbms-5.2.10.jar:?]
        at org.datanucleus.store.rdbms.query.SQLQuery.performExecute(SQLQuery.java:687) ~[datanucleus-rdbms-5.2.10.jar:?]
        at org.datanucleus.store.query.Query.executeQuery(Query.java:1975) ~[datanucleus-core-5.2.10.jar:?]
        at org.datanucleus.store.rdbms.query.SQLQuery.executeWithArray(SQLQuery.java:818) ~[datanucleus-rdbms-5.2.10.jar:?]
        at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:433) ~[datanucleus-api-jdo-5.2.8.jar:?]

Issue Links

• is caused by: HIVE-25965 SQLDataException when obtaining partitions from HMS via direct SQL over Derby