Hi all :
This problem has been solved.
In my cluster, there are two hive server, therefor there are two hive_conf
and hive metadata. I changed the hive_conf_path in find-hive-dependency.sh and
export the hive_conf_dir to get the metadata I want kylin to access and let
kylin to start up hive with the metadata I prefered.
-- 原始邮件 --
发件人: "mahongbin";;
发送时间: 2016年4月22日(星期五) 下午4:28
收件人: "dev";
主题: Re: Re: hive table change
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, wangxianbin1...@gmail.com <
wangxianbin1...@gmail.com> 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!
>
>
>
> wangxianbin1...@gmail.com
>
> 发件人: 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, wangxianbin1...@gmail.com <
> wangxianbin1...@gmail.com> 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!
> >
> >
> >
> > wangxianbin1...@gmail.com
> >
> > 发件人: 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:耳东775620...@qq.com
> > Recipient:dev...@kylin.apache.org
> > 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";
> > mahong...@apache.org; 发送时间: 2016年4月21日(星期四) 晚上6:31 收件人: "dev"
> > dev@kylin.apache.org; 主题: 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, wangxianbin1...@gmail.com wangxianbin1...@gmail.com wrote:
> > hi! for clarifying, hive can deploy in remote mode, kylin access it by
> > "SSHClient" best regards!wangxianbin1...@gmail.com 发件人: 耳东
> 发送时间:
> > 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. -- 原始邮件 -- 发件人: "
> > wangxianbin1...@gmail.com";wangxianbin1...@gmail.com; 发送时间:
> > 2016年4月21日(星期四) 中午1:19 收件人: "dev"dev@kylin.apache.o