The SQL syntax and functions Kylin supports: https://calcite.incubator.apache.org/docs/reference.html
Also make sure your query always carry a "group by" clause, because Kylin only contains aggregated result. On Fri, Jul 10, 2015 at 11:37 PM, Luke Han <[email protected]> wrote: > Hi Xiaowei, > Thanks to start evaluate Kylin. > Please refer to below comments for your question. > Any issue, please feel free to let's know. > > Thanks. > > > Best Regards! > --------------------- > > Luke Han > > On Thu, Jul 9, 2015 at 6:14 PM, [email protected] <[email protected]> > wrote: > > > > > Dear Mr./Ms, > > We plan to use Kylin, but some problems in use process. > > 1, the date function support is not very good.For example: the > > date conversion function to_date (), date comparison function datediff () > > > * Please try latest 0.7-staging code with Calcite 1.3 > supported * > > > 2, when I create a cube, the query page after executing the query > > returns only a single data > > > * Kylin's query page is for experimentation and verify, it > will be better if you could open JIRA and screenshot for this issue if > still there * > > > 3, in the "count" method cannot be used "distinct" > > > * Please try select count(distinct column).* > > > 4, a lot of hive function is not supported > > > * Kylin is not RMDB system, will not support all Hive > functions, but will try to support more and more ANSI SQL.* > > > > Really looking forward to your reply, thank you > > Yours faithfully, > > > > > > > > 姚啸威 > > 研发中心 > > 欢网科技有限责任公司 > > 北京市劲松三区甲302号华腾大厦13层 100021 > > 手机：15811317156 > > >
