Cong Luo created PHOENIX-6606:
---------------------------------
Summary: Cannot use float array data type with PQS client
Key: PHOENIX-6606
URL: https://issues.apache.org/jira/browse/PHOENIX-6606
Project: Phoenix
Issue Type: Bug
Components: queryserver
Reporter: Cong Luo
IDE use the PQS client with the 6.0.0, then write and read the float data array
got :
case 1 (cannot be written) :
{code:java}
Array t_float = conn.createArrayOf("FLOAT", new Float[] { Float.MIN_VALUE,
Float.MAX_VALUE });
pstmt = conn.prepareStatement("upsert into s1.datatype(t_uuid, t_float)
values(?, ?)");
pstmt.setArray(2, t_float);{code}
{code:java}
Exception in thread "main" java.sql.SQLException: java.lang.Float cannot be
cast to java.lang.Double
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:557)
at
org.apache.calcite.avatica.AvaticaPreparedStatement.executeLargeUpdate(AvaticaPreparedStatement.java:152)
at
org.apache.calcite.avatica.AvaticaPreparedStatement.executeUpdate(AvaticaPreparedStatement.java:147)
{code}
case 2 (can be written and cannot be read) :
{code:java}
pstmt = conn.prepareStatement("upsert into s1.datatype(t_uuid, t_float)
values(?, ARRAY[1.0, 2.0])");{code}
{code:java}
Exception in thread "main" org.apache.calcite.avatica.AvaticaSqlException:
Error -1 (00000) : Remote driver error: ClassCastException: (null exception
message) at
org.apache.calcite.avatica.Helper.createException(Helper.java:54) at
org.apache.calcite.avatica.Helper.createException(Helper.java:41) at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:557)
at
org.apache.calcite.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:137)
{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
