awesome, it's always important to give us your feedbacks:) On Fri, Apr 22, 2016 at 4:58 PM, 耳东 <[email protected]> wrote:
> 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";<[email protected]>; > 发送时间: 2016年4月22日(星期五) 下午4:28 > 收件人: "dev"<[email protected]>; > > 主题: 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, [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 > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
