The current implementation only route to hive, via Hive JDBC (add hive.url, hive.user, hive.password in kylin.properties); but it should be doable to extend; Please open a JIRA to track this requirement, thanks!
2016-08-28 15:40 GMT+08:00 Sarnath K <[email protected]>: > Yes, I am looking at routing cube-misses to impala. This can significantly > increase net performance. Impala can execute queries on Hive tables as > well. Impala provides a JDBC driver as well. > If this is possible, I just want to know what config variables I need to > set to make this happen. > Thanks for your time! > > Best, > Sarnath > On Aug 28, 2016 7:10 AM, "ShaoFeng Shi" <[email protected]> wrote: > > > I guess Sarnath's data source is still in hive, he wants to route some > > queries (cube didn't catch) to Impala, instead of hive. @Sarnath, can you > > confirm? Thanks. > > > > 2016-08-28 7:20 GMT+08:00 Li Yang <[email protected]>: > > > > > Use Impala as input source requires code change. It's not just some > > > configuration. Kylin is designed to support multiple data sources > however > > > implementation must be provided for each kind of data source. > > > > > > On Fri, Aug 26, 2016 at 8:35 PM, Sarnath K <[email protected]> wrote: > > > > > > > Thanks for your answer and time. I would be happy to give a try. But > > what > > > > config value I need to change (the above one is okay?) And from which > > > > version of Kylin is that config value supported? Sorry for being > > ignorant > > > > here. Any help is appreciated. i have the infra with me. Just tell me > > > what > > > > config value I should set in kylin.properties? > > > > On Aug 26, 2016 1:44 PM, "ShaoFeng Shi" <[email protected]> > > wrote: > > > > > > > > > Hi Sarnath, > > > > > > > > > > Routing to Impala looks better than routing to Hive; In theory it > is > > > > doable > > > > > as Kylin use standard JDBC API, but we haven't tried that; you can > > > have a > > > > > try and share your finding with the community, thanks! > > > > > > > > > > 2016-08-25 16:05 GMT+08:00 Sarnath K <[email protected]>: > > > > > > > > > > > Or in other words, > > > > > > Can I specify Impala JdBC server in kylin.Hive.jdbc.driver ??? > > > > > > There is a comment saying 'not in use' in the Github > > kylin.properties > > > > > file > > > > > > under examples.... > > > > > > > > > > > > Any inputs would be great! > > > > > > > > > > > > Best, > > > > > > Sarnath > > > > > > On Aug 25, 2016 11:30 AM, "Sarnath K" <[email protected]> > wrote: > > > > > > > > > > > > > Hi, > > > > > > > I tried searching for this a lot but could find a convincing > > > answer. > > > > > > > > > > > > > > Can Kylin use Impala JDBC driver underneath to run queries on > > Hive > > > > > table > > > > > > > instead of Hive server? > > > > > > > > > > > > > > If this is not possible, I would like to understand why this is > > not > > > > > > > possible and if there is a roadmap for this. > > > > > > > > > > > > > > Thanks, > > > > > > > Best, > > > > > > > Sarnath > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Best regards, > > > > > > > > > > Shaofeng Shi > > > > > > > > > > > > > > > > > > > > -- > > Best regards, > > > > Shaofeng Shi > > > -- Best regards, Shaofeng Shi
