[GitHub] [druid] mmcentre opened a new issue #11441: SQL query ("queryType":"timeseries") returns Infinity, causing ClassCastException with Avatica Calcite JDBC driver

[GitBox <gi...@apache.org>]

mmcentre opened a new issue #11441:
URL: https://github.com/apache/druid/issues/11441


   An SQL query (generated by Tableau), translated into timeseries native query, returns an invalid value for a column. When used with Avatica Calcite JDBC driver, causes (java.lang.ClassCastException) getting value for: 1/1 (java.lang.Double: X): java.lang.ClassCastException
   
   ### Affected Version
   
   0.20.2, 0.21.1
   
   ### Description
   
   We use a single VM deployment with a custom configuration, however we have reproduced the issue in multiple versions and configurations, including nano. We believe the problem is independent of the cluster size.
   
   The following SQL query, simplified from a query generated by Tableau, returns an invalid value for the column:
   
   ```
   SELECT
       AVG (CASE
           WHEN 60000 = 0
               THEN NULL
           ELSE 
                CAST (__time AS FLOAT)/60000
           END) AS X
   FROM 
       any_table
   ```
   
   returns invalid value (Infinity) for the column. Any attempt to further simplify the query eliminates the error.
   
   Modifying the query as:
   
   ```
   SELECT
       AVG (CASE 
           WHEN 60000 = 0 
           THEN 0
           ELSE CAST (__time AS FLOAT) / 60000
       END) AS X
   FROM
       any_table
   
   ``` 
   returns valid value, though changing NULL to 0 should not affect the result (because 60000 never equals to 0).
   
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org