[jira] [Created] (DRILL-597) shouldn't we have a interval data type in Drill?

["Chun Chang (JIRA)" <ji...@apache.org>]

Chun Chang created DRILL-597:
--------------------------------

             Summary: shouldn't we have a interval data type in Drill?
                 Key: DRILL-597
                 URL: https://issues.apache.org/jira/browse/DRILL-597
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Chun Chang


In postgres, interval itself is a valid data type. It seems in drill, it's not the case, only interval year/day... are valid.

0: jdbc:drill:schema=dfs> select cast(c_interval as interval) from data;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "689c6a7b-cc66-47b2-8205-d79128060541"
endpoint {
  address: "qa-node119.qa.lab"
  user_port: 31010
  control_port: 31011
  data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < SqlParseException:[ Encountered \"interval )\" at line 1, column 27.\nWas expecting one of:\n    \"CHARACTER\" ...\n    \"CHAR\" ...\n    \"VARCHAR\" ...\n    \"DATE\" ...\n    \"TIME\" ...\n    \"TIMESTAMP\" ...\n    \"DECIMAL\" ...\n    \"DEC\" ...\n    \"NUMERIC\" ...\n    \"BOOLEAN\" ...\n    \"INTEGER\" ...\n    \"INT\" ...\n    \"BINARY\" ...\n    \"VARBINARY\" ...\n    \"TINYINT\" ...\n    \"SMALLINT\" ...\n    \"BIGINT\" ...\n    \"REAL\" ...\n    \"DOUBLE\" ...\n    \"FLOAT\" ...\n    \"ANY\" ...\n    \"MULTISET\" ...\n    <IDENTIFIER> ...\n    <QUOTED_IDENTIFIER> ...\n    <BACK_QUOTED_IDENTIFIER> ...\n    <BRACKET_QUOTED_IDENTIFIER> ...\n    <UNICODE_QUOTED_IDENTIFIER> ...\n    \"INTERVAL\" \"YEAR\" ...\n    \"INTERVAL\" \"MONTH\" ...\n    \"INTERVAL\" \"DAY\" ...\n    \"INTERVAL\" \"HOUR\" ...\n    \"INTERVAL\" \"MINUTE\" ...\n    \"INTERVAL\" \"SECOND\" ...\n     ] < ParseException:[ Encountered \"interval )\" at line 1, column 27.\nWas expecting one of:\n    \"CHARACTER\" ...\n    \"CHAR\" ...\n    \"VARCHAR\" ...\n    \"DATE\" ...\n    \"TIME\" ...\n    \"TIMESTAMP\" ...\n    \"DECIMAL\" ...\n    \"DEC\" ...\n    \"NUMERIC\" ...\n    \"BOOLEAN\" ...\n    \"INTEGER\" ...\n    \"INT\" ...\n    \"BINARY\" ...\n    \"VARBINARY\" ...\n    \"TINYINT\" ...\n    \"SMALLINT\" ...\n    \"BIGINT\" ...\n    \"REAL\" ...\n    \"DOUBLE\" ...\n    \"FLOAT\" ...\n    \"ANY\" ...\n    \"MULTISET\" ...\n    <IDENTIFIER> ...\n    <QUOTED_IDENTIFIER> ...\n    <BACK_QUOTED_IDENTIFIER> ...\n    <BRACKET_QUOTED_IDENTIFIER> ...\n    <UNICODE_QUOTED_IDENTIFIER> ...\n    \"INTERVAL\" \"YEAR\" ...\n    \"INTERVAL\" \"MONTH\" ...\n    \"INTERVAL\" \"DAY\" ...\n    \"INTERVAL\" \"HOUR\" ...\n    \"INTERVAL\" \"MINUTE\" ...\n    \"INTERVAL\" \"SECOND\" ...\n     ]"
]
Error: exception while executing query (state=,code=0)



--
This message was sent by Atlassian JIRA
(v6.2#6252)