Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1392

Druid default time column not properly recognized

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.0
    • Fix Version/s: 1.10.0
    • Component/s: druid
    • Labels:
      None

      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>)'
      

        Attachments

          Activity

            People

            • Assignee:
              jcamachorodriguez Jesus Camacho Rodriguez
              Reporter:
              maver1ck Maciej Bryński
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: