Re:Query over Rest API results in bad query

2020-10-18 Thread Xiaoxiang Yu 
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)

2020-10-18 Thread Xiaoxiang Yu 
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

2020-10-18 Thread Xiaoxiang Yu 
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

2020-10-18 Thread ShaoFeng Shi 
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*
>