sorry by Q Is H2 used in Kylin? for what?
2016-09-14 11:39 GMT+02:00 hongbin ma (JIRA) <[email protected]>: > hongbin ma created KYLIN-2015: > --------------------------------- > > Summary: 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.4#6332) >
