Yep, but some queries might not be recognized by SQL Server. For example, SQL Server does not support LIMIT.
Best regards, Kaige Liu(刘凯歌) Mail: kaige....@kyligence.io<mailto:kaige....@kyligence.io> Shanghai Kyligence Information Technology Co., Ltd 上海市浦东新区亮秀路112号Y1座405室 "Do small things with great love." From: Devhuti Kumari <devhuti.kum...@gmail.com> Reply-To: "user@kylin.apache.org" <user@kylin.apache.org> Date: Tuesday, April 17, 2018 at 5:16 PM To: "user@kylin.apache.org" <user@kylin.apache.org> Subject: Re: Need Information on source Type of Apache Kylin If there is no Pre built cube for any random query generated by BI tool then it uses SQL server query engine to fetch data from RDBMS? Thanks, Devhuti Kumari On Tue, Apr 17, 2018 at 8:00 AM, Kaige Liu <kaige....@kyligence.io<mailto:kaige....@kyligence.io>> wrote: Spark could be used as building engine for RDBMS data source as well. Best regards, Kaige Liu(刘凯歌) Mail: kaige....@kyligence.io<mailto:kaige....@kyligence.io> Shanghai Kyligence Information Technology Co., Ltd 上海市浦东新区亮秀路112号Y1座405室 "Do small things with great love." From: Devhuti Kumari <devhuti.kum...@gmail.com<mailto:devhuti.kum...@gmail.com>> Reply-To: "user@kylin.apache.org<mailto:user@kylin.apache.org>" <user@kylin.apache.org<mailto:user@kylin.apache.org>> Date: Tuesday, April 17, 2018 at 2:15 AM To: "user@kylin.apache.org<mailto:user@kylin.apache.org>" <user@kylin.apache.org<mailto:user@kylin.apache.org>> Subject: Re: Need Information on source Type of Apache Kylin Hi Kaige, If we are going to build cube on RDBMS data source then spark wont be used as computing engine for building fast cube right? Regards, Devhuti Kumari On 16-Apr-2018, at 9:00 PM, Kaige Liu <kaige....@kyligence.io<mailto:kaige....@kyligence.io>> wrote: Sure, I’d be glad to. Best regards, Kaige Liu(刘凯歌) Mail: kaige....@kyligence.io<mailto:kaige....@kyligence.io> Shanghai Kyligence Information Technology Co., Ltd 上海市浦东新区亮秀路112号Y1座405室 "Do small things with great love." From: ShaoFeng Shi <shaofeng...@apache.org<mailto:shaofeng...@apache.org>> Reply-To: "user@kylin.apache.org<mailto:user@kylin.apache.org>" <user@kylin.apache.org<mailto:user@kylin.apache.org>> Date: Monday, April 16, 2018 at 11:19 PM To: user <user@kylin.apache.org<mailto:user@kylin.apache.org>> Subject: Re: Need Information on source Type of Apache Kylin Hi Kaige, As more and more people try this function, can you compose a step by step tutorial, so we can put it to Kylin's online documentation? Thanks! 2018-04-16 22:54 GMT+08:00 Kaige Liu <kaige....@kyligence.io<mailto:kaige....@kyligence.io>>: “GUI is not ready to use” means RDBMS data source is not shown in the source list (check attachment) and reuse the “load hive table” button. When you configured your RDBMS data source correctly and click “Load hive table” button, it actually loads RDBMS tables. Then you could use these tables to design models and create cubes. This is an example for how to configure RDBMS data source. https://issues.apache.org/jira/browse/KYLIN-3044?focusedCommentId=16262000&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-16262000 Best regards, Kaige Liu(刘凯歌) Mail: kaige....@kyligence.io<mailto:kaige....@kyligence.io> Shanghai Kyligence Information Technology Co., Ltd 上海市浦东新区亮秀路112号Y1座405室 "Do small things with great love." On 4/16/18, 10:20 PM, "Devhuti Kumari" <devhuti.kum...@gmail.com<mailto:devhuti.kum...@gmail.com>> wrote: By GUI is not ready to use you mean though we can connect to these DB we cant create Cube yet on top of these, correct me if i misunderstood? On Mon, Apr 16, 2018 at 7:46 PM, Kaige Liu <kaige....@kyligence.io<mailto:kaige....@kyligence.io>> wrote: > Sql server, MySql and Vertica has already been supported as data source, and it’s easy to extend other RDBMS data source. But the GUI is not ready to use. > You are so welcome to contribute a patch for integrating Splice Machine ☺. > > Best regards, > > Kaige Liu(刘凯歌) > Mail: kaige....@kyligence.io<mailto:kaige....@kyligence.io> > Shanghai Kyligence Information Technology Co., Ltd > 上海市浦东新区亮秀路112号Y1座405室 > > "Do small things with great love." > > > > On 4/16/18, 7:51 PM, "Devhuti Kumari" <devhuti.kum...@gmail.com<mailto:devhuti.kum...@gmail.com>> wrote: > > Hi, > > Can we have any RDBMS as a data source for Apache Kylin instead of > Hadoop Hive tables? > > If Yes then can we integrate it to Splice Machine using Splice Machine > as data source. > > > > Thanks, > > Devhuti Kumari > > > -- Best regards, Shaofeng Shi 史少锋
