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