You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Billy Liu <bi...@apache.org> on 2018/03/04 06:44:27 UTC
[Announce] Apache Kylin 2.3.0 released
Hello Kylin & Apache community,
The Apache Kylin team is pleased to announce the immediate
availability of the 2.3.0 release.
This is a major release after 2.2.0, with more than 250 bug fixes and
enhancements; All of the changes in this release can be found in:
https://kylin.apache.org/docs23/release_notes.html
You can download the source release and binary packages from Apache
Kylin's download page: https://kylin.apache.org/download/
Apache Kylin is an open source Distributed Analytics Engine designed
to provide SQL interface and multi-dimensional analysis (OLAP) on
Apache Hadoop, supporting extremely large datasets.
Apache Kylin lets you query massive data set at sub-second latency in 3 steps:
1. Identify a star schema or snowflake schema data set on Hadoop.
2. Build Cube on Hadoop/Spark.
3. Query data with ANSI-SQL and get results in sub-second, via ODBC,
JDBC or RESTful API.
Thanks everyone who have contributed to the 2.3.0 release.
We welcome your help and feedback. For more information on how to
report problems, and to get involved, visit the project website at
https://kylin.apache.org/
With Warm regards
Billy Liu
Re: [Announce] Apache Kylin 2.3.0 released
Posted by Billy Liu <bi...@apache.org>.
To learn how to use SQLServer as Data Source, please check the
comments in JIRA: https://issues.apache.org/jira/browse/KYLIN-3044
The RDBMS as datasource issue is still open. Hope someone help on
this: https://issues.apache.org/jira/browse/KYLIN-2873
For the dashboard, please check
http://kylin.apache.org/docs23/howto/howto_use_dashboard.html
With Warm regards
Billy Liu
2018-03-04 23:58 GMT-08:00 Kumar, Manoj H <ma...@jpmorgan.com>:
> Thanks for sharing this.. I have changed conf. folder from 2.1 to 2.3
> (kylin.properties). but didn’t see the dashboard menu on Kylin UI. What do
> you mean for “Support SQL Server as data source”. Do you have any document
> or help?
>
>
>
>
>
>
>
> [KYLIN-2727] - Introduce cube planner able to select cost-effective
> cuboids to be built by cost-based algorithms
> [KYLIN-2726] - Introduce a dashboard for showing kylin service related
> metrics, like query count, query latency, job count, etc
>
> [KYLIN-3125] - Support SparkSql in Cube building step “Create Intermediate
> Flat Hive Table”
> [KYLIN-3052] - Support Redshift as data source
> [KYLIN-3044] - Support SQL Server as data source
>
>
>
> Regards,
>
> Manoj
>
>
>
> From: Billy Liu [mailtobillyliu@apache.org]
> Sent: Sunday, March 04, 2018 12:14 PM
> To: dev <de...@kylin.apache.org>; user <us...@kylin.apache.org>;
> announce@apache.org
> Subject: [Announce] Apache Kylin 2.3.0 released
>
>
>
> Hello Kylin & Apache community,
>
> The Apache Kylin team is pleased to announce the immediate
> availability of the 2.3.0 release.
>
> This is a major release after 2.2.0, with more than 250 bug fixes and
> enhancements; All of the changes in this release can be found in:
> https://kylin.apache.org/docs23/release_notes.html
>
> You can download the source release and binary packages from Apache
> Kylin's download page: https://kylin.apache.org/download/
>
> Apache Kylin is an open source Distributed Analytics Engine designed
> to provide SQL interface and multi-dimensional analysis (OLAP) on
> Apache Hadoop, supporting extremely large datasets.
>
> Apache Kylin lets you query massive data set at sub-second latency in 3
> steps:
> 1. Identify a star schema or snowflake schema data set on Hadoop.
> 2. Build Cube on Hadoop/Spark.
> 3. Query data with ANSI-SQL and get results in sub-second, via ODBC,
> JDBC or RESTful API.
>
> Thanks everyone who have contributed to the 2.3.0 release.
>
> We welcome your help and feedback. For more information on how to
> report problems, and to get involved, visit the project website at
> https://kylin.apache.org/
>
>
> With Warm regards
>
> Billy Liu
>
> This message is confidential and subject to terms at:
> http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal
> privilege, viruses and monitoring of electronic messages. If you are not the
> intended recipient, please delete this message and notify the sender
> immediately. Any unauthorized use is strictly prohibited.
Re: [Announce] Apache Kylin 2.3.0 released
Posted by Billy Liu <bi...@apache.org>.
To learn how to use SQLServer as Data Source, please check the
comments in JIRA: https://issues.apache.org/jira/browse/KYLIN-3044
The RDBMS as datasource issue is still open. Hope someone help on
this: https://issues.apache.org/jira/browse/KYLIN-2873
For the dashboard, please check
http://kylin.apache.org/docs23/howto/howto_use_dashboard.html
With Warm regards
Billy Liu
2018-03-04 23:58 GMT-08:00 Kumar, Manoj H <ma...@jpmorgan.com>:
> Thanks for sharing this.. I have changed conf. folder from 2.1 to 2.3
> (kylin.properties). but didn’t see the dashboard menu on Kylin UI. What do
> you mean for “Support SQL Server as data source”. Do you have any document
> or help?
>
>
>
>
>
>
>
> [KYLIN-2727] - Introduce cube planner able to select cost-effective
> cuboids to be built by cost-based algorithms
> [KYLIN-2726] - Introduce a dashboard for showing kylin service related
> metrics, like query count, query latency, job count, etc
>
> [KYLIN-3125] - Support SparkSql in Cube building step “Create Intermediate
> Flat Hive Table”
> [KYLIN-3052] - Support Redshift as data source
> [KYLIN-3044] - Support SQL Server as data source
>
>
>
> Regards,
>
> Manoj
>
>
>
> From: Billy Liu [mailtobillyliu@apache.org]
> Sent: Sunday, March 04, 2018 12:14 PM
> To: dev <de...@kylin.apache.org>; user <us...@kylin.apache.org>;
> announce@apache.org
> Subject: [Announce] Apache Kylin 2.3.0 released
>
>
>
> Hello Kylin & Apache community,
>
> The Apache Kylin team is pleased to announce the immediate
> availability of the 2.3.0 release.
>
> This is a major release after 2.2.0, with more than 250 bug fixes and
> enhancements; All of the changes in this release can be found in:
> https://kylin.apache.org/docs23/release_notes.html
>
> You can download the source release and binary packages from Apache
> Kylin's download page: https://kylin.apache.org/download/
>
> Apache Kylin is an open source Distributed Analytics Engine designed
> to provide SQL interface and multi-dimensional analysis (OLAP) on
> Apache Hadoop, supporting extremely large datasets.
>
> Apache Kylin lets you query massive data set at sub-second latency in 3
> steps:
> 1. Identify a star schema or snowflake schema data set on Hadoop.
> 2. Build Cube on Hadoop/Spark.
> 3. Query data with ANSI-SQL and get results in sub-second, via ODBC,
> JDBC or RESTful API.
>
> Thanks everyone who have contributed to the 2.3.0 release.
>
> We welcome your help and feedback. For more information on how to
> report problems, and to get involved, visit the project website at
> https://kylin.apache.org/
>
>
> With Warm regards
>
> Billy Liu
>
> This message is confidential and subject to terms at:
> http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal
> privilege, viruses and monitoring of electronic messages. If you are not the
> intended recipient, please delete this message and notify the sender
> immediately. Any unauthorized use is strictly prohibited.
RE: [Announce] Apache Kylin 2.3.0 released
Posted by "Kumar, Manoj H" <ma...@jpmorgan.com.INVALID>.
Thanks for sharing this.. I have changed conf. folder from 2.1 to 2.3 (kylin.properties). but didn’t see the dashboard menu on Kylin UI. What do you mean for “Support SQL Server as data source”. Do you have any document or help?
[KYLIN-2727] - Introduce cube planner able to select cost-effective cuboids to be built by cost-based algorithms
[KYLIN-2726] - Introduce a dashboard for showing kylin service related metrics, like query count, query latency, job count, etc
[KYLIN-3125] - Support SparkSql in Cube building step “Create Intermediate Flat Hive Table”
[KYLIN-3052] - Support Redshift as data source
[KYLIN-3044] - Support SQL Server as data source
Regards,
Manoj
From: Billy Liu [mailto:billyliu@apache.org]
Sent: Sunday, March 04, 2018 12:14 PM
To: dev <de...@kylin.apache.org>; user <us...@kylin.apache.org>; announce@apache.org
Subject: [Announce] Apache Kylin 2.3.0 released
Hello Kylin & Apache community,
The Apache Kylin team is pleased to announce the immediate
availability of the 2.3.0 release.
This is a major release after 2.2.0, with more than 250 bug fixes and
enhancements; All of the changes in this release can be found in:
https://kylin.apache.org/docs23/release_notes.html<https://secureweb.jpmchase.net/readonly/https:/kylin.apache.org/docs23/release_notes.html>
You can download the source release and binary packages from Apache
Kylin's download page: https://kylin.apache.org/download/<https://secureweb.jpmchase.net/readonly/https:/kylin.apache.org/download/>
Apache Kylin is an open source Distributed Analytics Engine designed
to provide SQL interface and multi-dimensional analysis (OLAP) on
Apache Hadoop, supporting extremely large datasets.
Apache Kylin lets you query massive data set at sub-second latency in 3 steps:
1. Identify a star schema or snowflake schema data set on Hadoop.
2. Build Cube on Hadoop/Spark.
3. Query data with ANSI-SQL and get results in sub-second, via ODBC,
JDBC or RESTful API.
Thanks everyone who have contributed to the 2.3.0 release.
We welcome your help and feedback. For more information on how to
report problems, and to get involved, visit the project website at
https://kylin.apache.org/<https://secureweb.jpmchase.net/readonly/https:/kylin.apache.org/>
With Warm regards
Billy Liu
This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.
Re: [Announce] Apache Kylin 2.3.0 released
Posted by deva namaste <oh...@gmail.com>.
I able to correct the issue by deleting intermediate files.
http://kylin.apache.org/docs23/howto/howto_cleanup_storage.html
On Tue, Mar 6, 2018 at 11:18 AM, deva namaste <oh...@gmail.com> wrote:
> Thanks Billy.
>
> After I upgrade to 2.3 I am getting following error (
> org.apache.kylin.rest.exception.InternalErrorException: Storage Engine
> (id=0) ) during query.
>
> 2018-03-06 09:43:04,607 ERROR [http-bio-7070-exec-9]
> controller.BasicController:61 :
> org.apache.kylin.rest.exception.InternalErrorException: Storage Engine
> (id=0) is not supported any more
> while executing SQL: "select * from FACT_TABLE LIMIT 50000"
>
> Any help is appreciated.
>
>
> On Sun, Mar 4, 2018 at 1:44 AM, Billy Liu <bi...@apache.org> wrote:
>
>> Hello Kylin & Apache community,
>>
>> The Apache Kylin team is pleased to announce the immediate
>> availability of the 2.3.0 release.
>>
>> This is a major release after 2.2.0, with more than 250 bug fixes and
>> enhancements; All of the changes in this release can be found in:
>> https://kylin.apache.org/docs23/release_notes.html
>>
>> You can download the source release and binary packages from Apache
>> Kylin's download page: https://kylin.apache.org/download/
>>
>> Apache Kylin is an open source Distributed Analytics Engine designed
>> to provide SQL interface and multi-dimensional analysis (OLAP) on
>> Apache Hadoop, supporting extremely large datasets.
>>
>> Apache Kylin lets you query massive data set at sub-second latency in 3
>> steps:
>> 1. Identify a star schema or snowflake schema data set on Hadoop.
>> 2. Build Cube on Hadoop/Spark.
>> 3. Query data with ANSI-SQL and get results in sub-second, via ODBC,
>> JDBC or RESTful API.
>>
>> Thanks everyone who have contributed to the 2.3.0 release.
>>
>> We welcome your help and feedback. For more information on how to
>> report problems, and to get involved, visit the project website at
>> https://kylin.apache.org/
>>
>>
>> With Warm regards
>>
>> Billy Liu
>>
>
>
Re: [Announce] Apache Kylin 2.3.0 released
Posted by deva namaste <oh...@gmail.com>.
Thanks Billy.
After I upgrade to 2.3 I am getting following error ( org.apache.kylin.rest.
exception.InternalErrorException: Storage Engine (id=0) ) during query.
2018-03-06 09:43:04,607 ERROR [http-bio-7070-exec-9]
controller.BasicController:61 :
org.apache.kylin.rest.exception.InternalErrorException: Storage Engine
(id=0) is not supported any more
while executing SQL: "select * from FACT_TABLE LIMIT 50000"
Any help is appreciated.
On Sun, Mar 4, 2018 at 1:44 AM, Billy Liu <bi...@apache.org> wrote:
> Hello Kylin & Apache community,
>
> The Apache Kylin team is pleased to announce the immediate
> availability of the 2.3.0 release.
>
> This is a major release after 2.2.0, with more than 250 bug fixes and
> enhancements; All of the changes in this release can be found in:
> https://kylin.apache.org/docs23/release_notes.html
>
> You can download the source release and binary packages from Apache
> Kylin's download page: https://kylin.apache.org/download/
>
> Apache Kylin is an open source Distributed Analytics Engine designed
> to provide SQL interface and multi-dimensional analysis (OLAP) on
> Apache Hadoop, supporting extremely large datasets.
>
> Apache Kylin lets you query massive data set at sub-second latency in 3
> steps:
> 1. Identify a star schema or snowflake schema data set on Hadoop.
> 2. Build Cube on Hadoop/Spark.
> 3. Query data with ANSI-SQL and get results in sub-second, via ODBC,
> JDBC or RESTful API.
>
> Thanks everyone who have contributed to the 2.3.0 release.
>
> We welcome your help and feedback. For more information on how to
> report problems, and to get involved, visit the project website at
> https://kylin.apache.org/
>
>
> With Warm regards
>
> Billy Liu
>
RE: [Announce] Apache Kylin 2.3.0 released
Posted by "Kumar, Manoj H" <ma...@jpmorgan.com>.
Thanks for sharing this.. I have changed conf. folder from 2.1 to 2.3 (kylin.properties). but didn’t see the dashboard menu on Kylin UI. What do you mean for “Support SQL Server as data source”. Do you have any document or help?
[KYLIN-2727] - Introduce cube planner able to select cost-effective cuboids to be built by cost-based algorithms
[KYLIN-2726] - Introduce a dashboard for showing kylin service related metrics, like query count, query latency, job count, etc
[KYLIN-3125] - Support SparkSql in Cube building step “Create Intermediate Flat Hive Table”
[KYLIN-3052] - Support Redshift as data source
[KYLIN-3044] - Support SQL Server as data source
Regards,
Manoj
From: Billy Liu [mailto:billyliu@apache.org]
Sent: Sunday, March 04, 2018 12:14 PM
To: dev <de...@kylin.apache.org>; user <us...@kylin.apache.org>; announce@apache.org
Subject: [Announce] Apache Kylin 2.3.0 released
Hello Kylin & Apache community,
The Apache Kylin team is pleased to announce the immediate
availability of the 2.3.0 release.
This is a major release after 2.2.0, with more than 250 bug fixes and
enhancements; All of the changes in this release can be found in:
https://kylin.apache.org/docs23/release_notes.html<https://secureweb.jpmchase.net/readonly/https:/kylin.apache.org/docs23/release_notes.html>
You can download the source release and binary packages from Apache
Kylin's download page: https://kylin.apache.org/download/<https://secureweb.jpmchase.net/readonly/https:/kylin.apache.org/download/>
Apache Kylin is an open source Distributed Analytics Engine designed
to provide SQL interface and multi-dimensional analysis (OLAP) on
Apache Hadoop, supporting extremely large datasets.
Apache Kylin lets you query massive data set at sub-second latency in 3 steps:
1. Identify a star schema or snowflake schema data set on Hadoop.
2. Build Cube on Hadoop/Spark.
3. Query data with ANSI-SQL and get results in sub-second, via ODBC,
JDBC or RESTful API.
Thanks everyone who have contributed to the 2.3.0 release.
We welcome your help and feedback. For more information on how to
report problems, and to get involved, visit the project website at
https://kylin.apache.org/<https://secureweb.jpmchase.net/readonly/https:/kylin.apache.org/>
With Warm regards
Billy Liu
This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.
Re: [Announce] Apache Kylin 2.3.0 released
Posted by deva namaste <oh...@gmail.com>.
Thanks Billy.
After I upgrade to 2.3 I am getting following error ( org.apache.kylin.rest.
exception.InternalErrorException: Storage Engine (id=0) ) during query.
2018-03-06 09:43:04,607 ERROR [http-bio-7070-exec-9]
controller.BasicController:61 :
org.apache.kylin.rest.exception.InternalErrorException: Storage Engine
(id=0) is not supported any more
while executing SQL: "select * from FACT_TABLE LIMIT 50000"
Any help is appreciated.
On Sun, Mar 4, 2018 at 1:44 AM, Billy Liu <bi...@apache.org> wrote:
> Hello Kylin & Apache community,
>
> The Apache Kylin team is pleased to announce the immediate
> availability of the 2.3.0 release.
>
> This is a major release after 2.2.0, with more than 250 bug fixes and
> enhancements; All of the changes in this release can be found in:
> https://kylin.apache.org/docs23/release_notes.html
>
> You can download the source release and binary packages from Apache
> Kylin's download page: https://kylin.apache.org/download/
>
> Apache Kylin is an open source Distributed Analytics Engine designed
> to provide SQL interface and multi-dimensional analysis (OLAP) on
> Apache Hadoop, supporting extremely large datasets.
>
> Apache Kylin lets you query massive data set at sub-second latency in 3
> steps:
> 1. Identify a star schema or snowflake schema data set on Hadoop.
> 2. Build Cube on Hadoop/Spark.
> 3. Query data with ANSI-SQL and get results in sub-second, via ODBC,
> JDBC or RESTful API.
>
> Thanks everyone who have contributed to the 2.3.0 release.
>
> We welcome your help and feedback. For more information on how to
> report problems, and to get involved, visit the project website at
> https://kylin.apache.org/
>
>
> With Warm regards
>
> Billy Liu
>