You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Maciej Bryński (JIRA)" <ji...@apache.org> on 2016/09/27 21:54:20 UTC
[jira] [Created] (CALCITE-1392) Unable to specify time granularity
for Druid
Maciej Bryński created CALCITE-1392:
---------------------------------------
Summary: Unable to specify time granularity for Druid
Key: CALCITE-1392
URL: https://issues.apache.org/jira/browse/CALCITE-1392
Project: Calcite
Issue Type: Bug
Components: druid
Affects Versions: 1.9.0
Reporter: Maciej Bryński
Assignee: Julian Hyde
Druid 0.9.1.1
Calcite 1.9.0
I'm trying to calculate count per day.
What I'm doing wrong ?
{code}
!connect jdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid.DruidSchemaFactory admin admin
0: jdbc:calcite:schemaFactory=org.apache.calc> !describe "flink_imp"
+-----------+-------------+------------+-------------+-----------+-----------+-------------+---------------+----------------+----------------+----------+---------+------------+---------------+------------------+
| 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 | flink_imp | __time | -5 | BIGINT | -1 | | null | 10 | 1 | | | | |
|
| | adhoc | flink_imp | 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>)'
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)