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 >
