As Hongbin mentioned in the JIRA, H2 is used in Integration Test: verifying for the same data and query, kylin's output is the same as H2. Kylin's runtime doesn't need it.
2016-09-14 20:27 GMT+08:00 Alberto Ramón <[email protected]>: > 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) > > > -- Best regards, Shaofeng Shi
