[
https://issues.apache.org/jira/browse/KYLIN-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15853972#comment-15853972
]
hongbin ma commented on KYLIN-2015:
-----------------------------------
The performance issue of H2 is solved in KYLIN-2424 without replacing H2
> replace h2 with alternatives like sqllite or mysql
> --------------------------------------------------
>
> Key: KYLIN-2015
> URL: https://issues.apache.org/jira/browse/KYLIN-2015
> Project: Kylin
> Issue Type: Improvement
> Reporter: hongbin ma
> Assignee: hongbin ma
>
> in IT we compare kylin's result with H2's results to ensure query correctness.
> however h2 only supports part of the SQL syntax. For example, it cannot
> support functions like timestampadd, or (DATE'2013-01-02' + interval '3'
> day). What's more, subqueries are observed to be very slow on H2.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
