You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "hongbin ma (JIRA)" <ji...@apache.org> on 2016/09/14 09:39:20 UTC
[jira] [Created] (KYLIN-2015) replace h2 with alternatives like
sqllite or mysql
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)
Re: [jira] [Created] (KYLIN-2015) replace h2 with alternatives like
sqllite or mysql
Posted by ShaoFeng Shi <sh...@apache.org>.
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 <a....@gmail.com>:
> sorry by Q
>
> Is H2 used in Kylin? for what?
>
> 2016-09-14 11:39 GMT+02:00 hongbin ma (JIRA) <ji...@apache.org>:
>
> > 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
Re: [jira] [Created] (KYLIN-2015) replace h2 with alternatives like
sqllite or mysql
Posted by Alberto Ramón <a....@gmail.com>.
sorry by Q
Is H2 used in Kylin? for what?
2016-09-14 11:39 GMT+02:00 hongbin ma (JIRA) <ji...@apache.org>:
> 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)
>