My explanation about hive CLI might not be accurate. take the comment in code as reference:
# If true, job engine will not assume that hadoop CLI reside on the same server as it self # you will have to specify kylin.job.remote.cli.hostname, kylin.job.remote.cli.username and kylin.job.remote.cli.password # It should not be set to "true" unless you're NOT running Kylin.sh on a hadoop client machine # (Thus kylin instance has to ssh to another real hadoop client machine to execute hbase,hive,hadoop commands) kylin.job.run.as.remote.cmd=false # Only necessary when kylin.job.run.as.remote.cmd=true kylin.job.remote.cli.hostname= # Only necessary when kylin.job.run.as.remote.cmd=true kylin.job.remote.cli.username= # Only necessary when kylin.job.run.as.remote.cmd=true kylin.job.remote.cli.password= On Fri, Apr 22, 2016 at 3:23 PM, [email protected] < [email protected]> wrote: > hi hongbin! > > can you give a more clear description, I can not understand "you'll find > it helpful", did you miss something? > > best regards! > > > > [email protected] > > 发件人： hongbin ma > 发送时间： 2016-04-22 13:51 > 收件人： dev > 主题： Re: 回复： hive table change > yes, theoretically if you hive CLI does not co-exist on the server you > deployed Kylin (which must be a hbase CLI), you'll find it helpful. > > However in most cases hbase CLI is also a hive CLI, then you don't have the > problem > > On Fri, Apr 22, 2016 at 1:20 PM, [email protected] < > [email protected]> wrote: > > > hi all! > > > > thanks hongbin & dong help to clarify this. > > > > just one more thing need to be confirmed, kylin.job.remote.cli.hostname > > CLI(which can be remote) seem like will be used for create intermediate > > flat table, not just for dev use, right? > > > > best regards! > > > > > > > > [email protected] > > > > 发件人： Dong Li > > 发送时间： 2016-04-22 10:35 > > 收件人： dev > > 主题： 回复： 回复： hive table change > > Hello, > > > > > > Try to set env var HIVE_CONF_DIR and HIVE_CONF before start kylin > service: > > > > > > bin/kylin.sh stop > > export HIVE_CONF_DIR=The real conf path kylin want to access > > export HIVE_CONF=The real conf path kylin want to access > > bin/kylin.sh start > > > > > > Thanks, > > Dong Li > > > > > > Original Message > > Sender:耳东[email protected] > > Recipient:[email protected] > > Date:Thursday, Apr 21, 2016 19:04 > > Subject:回复： 回复： hive table change > > > > > > yes,as you said Kylin see the same tables as the hive shell in the > server. > > however in my cluster there is another app which invoke hive and create > > some hive tables, of which the metadata and store location is different > > from the hive shell. how can i make the kylin to access these tables? > > ------------------ 原始邮件 ------------------ 发件人: "hongbin ma"; > > [email protected]; 发送时间: 2016年4月21日(星期四) 晚上6:31 收件人: "dev" > > [email protected]; 主题: Re: 回复： hive table change I want to clarify > > that kylin.job.remote.cli.hostname is usually used for developing > purpose, > > it's not related to hive table syncing. The way how Kylin gets aware of > > hive table is through HCatlog. When kylin starts, it will look for hive > > settings where Kylin resides to initialize HCatlog. So basically kylin > will > > see same tables as the hive shell in the that server. On Thu, Apr 21, > 2016 > > at 3:20 PM, [email protected] [email protected] wrote: > > hi! for clarifying, hive can deploy in remote mode, kylin access it by > > "SSHClient" best regards! [email protected] 发件人： 耳东 > 发送时间： > > 2016-04-21 14:57 收件人： dev 主题： 回复： hive table change How does kylin > > access the hive table , where can I configure to change the hive > metadata > > kylin access. ------------------ 原始邮件 ------------------ 发件人: " > > [email protected]";[email protected]; 发送时间: > > 2016年4月21日(星期四) 中午1:19 收件人: "dev"[email protected]; 主题: 回复: hive > > table change hi! what do you mean by "original hive table > position"? > > do you mean hive "external table" or hive table that specific new hdfs > > location by hive 'location' keywords? if it is so, you don't have to do > > extro config if you mean hive that not deploy with kylin, it seem like > > that it is not supported by kylin(need comfirm by others) best > regards! > > [email protected] 发件人： 耳东 发送时间： 2016-04-21 11:34 收件人： dev > > 主题： hive table change hi all： In my cluster there is another > application > > which create some hive tables not in the original hive table position. > > where should I configure to access these hive tables？ -- Regards, *Bin > > Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: > > https://github.com/binmahone > > > > > > -- > Regards, > > *Bin Mahone | 马洪宾* > Apache Kylin: http://kylin.io > Github: https://github.com/binmahone > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
