[CALCITE-1392] Druid default time column not properly recognized

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.10.0
• Component/s: druid-adapter
• Assignee: Jesús Camacho Rodríguez
• Reporter: Maciej Bryński
• Created: 27/Sep/16 21:53
• Updated: 27/Feb/24 22:24
• Resolved: 06/Oct/16 19:33

Description

Druid 0.9.1.1
Calcite 1.9.0

I'm trying to calculate count per day.
What I'm doing wrong ?

!connect jdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid.DruidSchemaFactory admin admin
0: jdbc:calcite:schemaFactory=org.apache.calc> !describe "table"
+-----------+-------------+------------+-------------+-----------+-----------+-------------+---------------+----------------+----------------+----------+---------+------------+---------------+------------------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | DATA_TYPE | TYPE_NAME | COLUMN_SIZE | BUFFER_LENGTH | DECIMAL_DIGITS | NUM_PREC_RADIX | NULLABLE | REMARKS | COLUMN_DEF | SQL_DATA_TYPE | SQL_DATETIME_SUB |
+-----------+-------------+------------+-------------+-----------+-----------+-------------+---------------+----------------+----------------+----------+---------+------------+---------------+------------------+
|           | adhoc       | table  | __time      | -5        | BIGINT    | -1          |               | null           | 10             | 1        |         |            |               |                  |
|
|           | adhoc       | table    | count       | -5        | BIGINT    | -1          |               | null           | 10             | 1        |         |            |               |                  

0: jdbc:calcite:schemaFactory=org.apache.calc> select sum("count") from "table" group by floor("__time" to DAY);
2016-09-27 21:50:26,770 [main] ERROR - org.apache.calcite.sql.validate.SqlValidatorException: Cannot apply 'FLOOR' to arguments of type 'FLOOR(<BIGINT>, <INTERVAL DAY>)'. Supported form(s): 'FLOOR(<NUMERIC>)'
'FLOOR(<DATETIME_INTERVAL>)'
'FLOOR(<DATE> TO <TIME_UNIT>)'
'FLOOR(<TIME> TO <TIME_UNIT>)'
'FLOOR(<TIMESTAMP> TO <TIME_UNIT>)'