Re:Query over Rest API results in bad query
Hello, What kind of exception/error did you met ? Could you please share with us some more log? Actually, "org.apache.kylin.rest.service.BadQueryDetector - Detect bad query." did not provided enough information for cause analysis. -- Best wishes to you ! From :Xiaoxiang Yu At 2020-10-17 22:45:34, "Aditya Rohilla" wrote: >Hey, > > > >I am trying to send this query : > > > >{ "sql": "select process, avg(w) as `avg_w`, sum(vol) as `sum_vol` from >WHY_XYZ where id in ('BLA') and balance_date between '2020-03-06' and >'2020-09-06' group by process order by process asc, "offset": 0, "limit": >1000, "acceptPartial": false, "project": null } > > > >And it results in bad query as shown in the logs: > > > >2020-10-15T22:29:37,092 INFO [BadQueryDetector] >org.apache.kylin.rest.service.BadQueryDetector - Detect bad query. > > >Any idea how I should send the sql query? > >I am using mysql as sqldialect. > > > >Thanks and Regards, > >Aditya Rohilla
[RESULT][VOTE] Release apache-kylin-3.1.1 (RC1)
Thanks to everyone who has tested the release candidate and given their comments and votes. The tally is as follows. 3 binding +1s: Chunen Ni Shaofeng Shi Xiaoxiang Yu 6 non-binding +1s: Yaqian Zhang Rupeng Wang Chuxiao Zhichao Zhang Chao Long Johnson No 0s or -1s. Therefore I am delighted to announce that the proposal to release Apache-Kylin-3.1.1 has passed. -- Best wishes to you ! From :Xiaoxiang Yu
[Announce] Apache Kylin 3.1.1 released
The Apache Kylin team is pleased to announce the immediate availability of the 3.1.1 release. This is a bugfix release after 3.1.0, with 21 bug fixes and 37 enhancements. All of the changes in this release can be found in: https://kylin.apache.org/docs/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 Analytical Data Warehouse for Big Data; it was designed to provide OLAP (Online Analytical Processing) capability in the big data era. By renovating the multi-dimensional cube and precalculation technology on Hadoop and Spark, Kylin is able to achieve near-constant query speed regardless of the ever-growing data volume. Reducing query latency from minutes to sub-second, Kylin brings online analytics back to big data. Apache Kylin lets you query billions of rows at sub-second latency in 3 steps: 1. Identify a Star/Snowflake Schema on Hadoop. 2. Build Cube from the identified tables. 3. Query using ANSI-SQL and get results in sub-second, via ODBC, JDBC or RESTful API. Thanks to everyone who has contributed to this 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/ -- Best wishes to you ! From :Xiaoxiang Yu
Re: [Announce] Apache Kylin 3.1.1 released
This is great! Thank you Xiaoxiang! Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: user-subscr...@kylin.apache.org Join Kylin dev mail group: dev-subscr...@kylin.apache.org Xiaoxiang Yu 于2020年10月18日周日 下午9:18写道: > The Apache Kylin team is pleased to announce the immediate availability of > > the 3.1.1 release. > > > This is a bugfix release after 3.1.0, with 21 bug fixes and 37 > enhancements. > > All of the changes in this release can be found in: > > https://kylin.apache.org/docs/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 Analytical Data Warehouse for > > Big Data; it was designed to provide OLAP (Online Analytical Processing) > > capability in the big data era. By renovating the multi-dimensional cube > > and precalculation technology on Hadoop and Spark, Kylin is able to achieve > > near-constant query speed regardless of the ever-growing data volume. > > Reducing query latency from minutes to sub-second, Kylin brings online > > analytics back to big data. > > > Apache Kylin lets you query billions of rows at sub-second latency in 3 > > steps: > > 1. Identify a Star/Snowflake Schema on Hadoop. > > 2. Build Cube from the identified tables. > > 3. Query using ANSI-SQL and get results in sub-second, via ODBC, JDBC or > > RESTful API. > > > Thanks to everyone who has contributed to this 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/ > > -- > *Best wishes to you ! * > *From :**Xiaoxiang Yu* >