Re: Re: Re: build cube and hbase coprocessor not avaliable

2017-02-05 Thread ShaoFeng Shi 
Obviously the coprocessor wasn't deployed; a correctly created table looks
like:

hbase(main):002:0> describe 'KYLIN_SNHN6PVOWS'
Table KYLIN_SNHN6PVOWS is ENABLED
KYLIN_SNHN6PVOWS, {TABLE_ATTRIBUTES => {coprocessor$1 => 'hdfs://
sandbox.hortonworks.com:8020/kylin/kylin_default_instance/coprocessor/kylin-storage-hbase-2
.0.0-SNAPSHOT-coprocessor-2.jar|org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.CubeVisitService|1001|',
METADATA => {'CREATION_TIME' => '148517
3320247', 'KYLIN_HOST' => 'kylin_default_instance', 'OWNER' => '
ky...@kylin.apache.org', 'SEGMENT' =>
'ci_inner_join_cube[1970010100_2022070100]', '
SPLIT_POLICY' =>
'org.apache.hadoop.hbase.regionserver.DisabledRegionSplitPolicy'}}
COLUMN FAMILIES DESCRIPTION

If the coprocessor failed to deployed, Kylin will catch that error and then
move on; In kylin.log there should be error like "Error deploying
coprocessor"; Please check what's the detail error message. If possible,
also check HBase server side.

2017-02-05 10:57 GMT+08:00 叶 <yecon...@163.com>:

> @shaofeng，any idea?
>
>
>
>
> 在 2017-02-03 16:35:58，yecongyc <yecon...@163.com> 写道：
>
>
> Hi,ShaoFeng:
>
> 1，hadoop2.6.4,hbase1.1.5,kylin1.6.0
>
> 2,  the log is result code:0
>
> 3,hbase(main):009:0> describe 'KYLIN_IJP9PE0X9U'
>
> Table KYLIN_IJP9PE0X9U is ENABLED
>
> KYLIN_IJP9PE0X9U, {TABLE_ATTRIBUTES => {METADATA => {'CREATION_TIME' =>
> '1486109612484', 'GIT_COMMIT' => '0fca0717
>
> 8088320fda44513c63a1134b7d39427c;', 'KYLIN_HOST' => 'kylin_metadata',
> 'OWNER' => 'who...@kylin.apache.org', 'SEGME
>
> NT' => 'ff1[2017010100_2017020800]', 'SPLIT_POLICY' =>
> 'org.apache.hadoop.hbase.regionserver.DisabledRegio
>
> nSplitPolicy', 'USER' => 'ADMIN'}}
>
> COLUMN FAMILIES DESCRIPTION
>
> {NAME => 'F1', DATA_BLOCK_ENCODING => 'FAST_DIFF', BLOOMFILTER => 'NONE',
> REPLICATION_SCOPE => '0', VERSIONS => '1
>
> ', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER',
> KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '6553
>
> 6', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
>
> 1 row(s) in 0.1060 seconds
>
> 4,kylin-coprocessor-1.6.0.jar, kylin-jdbc-1.6.0.jar, kylin-job-1.6.0.jar
>
>
>
>  原始邮件
> 发件人: ShaoFeng Shi<shaofeng...@apache.org>
> 收件人: dev<dev@kylin.apache.org>
> 发送时间: 2017年2月3日(周五) 09:40
> 主题: Re: Re: build cube and hbase coprocessor not avaliable
>
>
> Hi Ye,
>
> Could you please provide the following information for check?:
> 1) your Kylin and Hadoop/HBase version
> 2) log output when Kylin executes the "Create HTable" step;
> 3) the description of such a table in hbase shell : "describe KYLIN_A";
> 4) the file lists in $KYLIN_HOME/lib
>
>
> 2017-02-01 22:27 GMT+08:00 叶 <yecon...@163.com>:
>
> > yes ,this method can resolve this problem。but After each build cube will
> > appear this problem. I want to one-time solve this problem. I don't know
> > what should I do。。。
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > At 2017-02-01 20:37:11,nichunen <nichu...@mininglamp.com> wrote:
> > >Maybe you need to update the hbase coprocessor, try the tutorial as the
> > link below:
> > >http://kylin.apache.org/docs15/howto/howto_update_coprocessor.html
> > >
> > >
> > >
> > >
> > >
> > >  George/倪春恩
> > >
> > >Mobile:+86-13501723787| WeChat:nceecn
> > >
> > >北京明略软件系统有限公司（MiningLamp.COM
> > >）
> > >
> > >
> > >
> > >
> > >
> > >上海市浦东新区晨晖路258号G座iDream张江科创中心C125
> > >
> > >
> > >
> > >
> > >Room C125#,Intelligent Industrial Park Building G,258#Chenhui Road,
> > Pudong District,Shanghai,201203
> > >
> > >
> > >
> > >
> > >> On Feb 1, 2017, at 7:26 PM, 叶 <yecon...@163.com> wrote:
> > >>
> > >>
> > >> Dear Developers:
> > >>
> > >>
> > >> today I add kylin.coprocessor.local.jar arguments in kylin.property
> > file and when build cube done . I execute query "select * from xxx" hits
> > error below:
> > >>
> > >>
> > >> org.apache.hadoop.hbase.exceptions.UnknownProtocolException: No
> > registered coprocessor service found for name CubeVisitService in region
> > KYLIN_GA464RXYQX,,1484635706236.9aac092cc3bd8855999c7a8734f09842.
> > >>
> > >>
> > >> how can I resolve this problem?
> > >>
> > >>
> > >> thanks
> > >>
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>


-- 
Best regards,

Shaofeng Shi 史少锋

Re:Re: Re: build cube and hbase coprocessor not avaliable

2017-02-04 Thread 叶 
@shaofeng，any idea?




在 2017-02-03 16:35:58，yecongyc <yecon...@163.com> 写道：


Hi,ShaoFeng:

1，hadoop2.6.4,hbase1.1.5,kylin1.6.0

2,  the log is result code:0

3,hbase(main):009:0> describe 'KYLIN_IJP9PE0X9U'

Table KYLIN_IJP9PE0X9U is ENABLED

KYLIN_IJP9PE0X9U, {TABLE_ATTRIBUTES => {METADATA => {'CREATION_TIME' => 
'1486109612484', 'GIT_COMMIT' => '0fca0717

8088320fda44513c63a1134b7d39427c;', 'KYLIN_HOST' => 'kylin_metadata', 'OWNER' 
=> 'who...@kylin.apache.org', 'SEGME

NT' => 'ff1[2017010100_2017020800]', 'SPLIT_POLICY' => 
'org.apache.hadoop.hbase.regionserver.DisabledRegio

nSplitPolicy', 'USER' => 'ADMIN'}}

COLUMN FAMILIES DESCRIPTION

{NAME => 'F1', DATA_BLOCK_ENCODING => 'FAST_DIFF', BLOOMFILTER => 'NONE', 
REPLICATION_SCOPE => '0', VERSIONS => '1

', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', 
KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '6553

6', IN_MEMORY => 'false', BLOCKCACHE => 'true'}

1 row(s) in 0.1060 seconds

4,kylin-coprocessor-1.6.0.jar, kylin-jdbc-1.6.0.jar, kylin-job-1.6.0.jar



 原始邮件 
发件人: ShaoFeng Shi<shaofeng...@apache.org>
收件人: dev<dev@kylin.apache.org>
发送时间: 2017年2月3日(周五) 09:40
主题: Re: Re: build cube and hbase coprocessor not avaliable


Hi Ye,

Could you please provide the following information for check?:
1) your Kylin and Hadoop/HBase version
2) log output when Kylin executes the "Create HTable" step;
3) the description of such a table in hbase shell : "describe KYLIN_A";
4) the file lists in $KYLIN_HOME/lib


2017-02-01 22:27 GMT+08:00 叶 <yecon...@163.com>:

> yes ,this method can resolve this problem。but After each build cube will
> appear this problem. I want to one-time solve this problem. I don't know
> what should I do。。。
>
>
>
>
>
>
>
>
>
> At 2017-02-01 20:37:11,nichunen <nichu...@mininglamp.com> wrote:
> >Maybe you need to update the hbase coprocessor, try the tutorial as the
> link below:
> >http://kylin.apache.org/docs15/howto/howto_update_coprocessor.html
> >
> >
> >
> >
> >
> >  George/倪春恩
> >
> >Mobile:+86-13501723787| WeChat:nceecn
> >
> >北京明略软件系统有限公司（MiningLamp.COM
> >）
> >
> >
> >
> >
> >
> >上海市浦东新区晨晖路258号G座iDream张江科创中心C125
> >
> >
> >
> >
> >Room C125#,Intelligent Industrial Park Building G,258#Chenhui Road,
> Pudong District,Shanghai,201203
> >
> >
> >
> >
> >> On Feb 1, 2017, at 7:26 PM, 叶 <yecon...@163.com> wrote:
> >>
> >>
> >> Dear Developers:
> >>
> >>
> >> today I add kylin.coprocessor.local.jar arguments in kylin.property
> file and when build cube done . I execute query "select * from xxx" hits
> error below:
> >>
> >>
> >> org.apache.hadoop.hbase.exceptions.UnknownProtocolException: No
> registered coprocessor service found for name CubeVisitService in region
> KYLIN_GA464RXYQX,,1484635706236.9aac092cc3bd8855999c7a8734f09842.
> >>
> >>
> >> how can I resolve this problem?
> >>
> >>
> >> thanks
> >>
>



-- 
Best regards,

Shaofeng Shi 史少锋

Re: Re: build cube and hbase coprocessor not avaliable

2017-02-02 Thread ShaoFeng Shi 
Hi Ye,

Could you please provide the following information for check?:
1) your Kylin and Hadoop/HBase version
2) log output when Kylin executes the "Create HTable" step;
3) the description of such a table in hbase shell : "describe KYLIN_A";
4) the file lists in $KYLIN_HOME/lib


2017-02-01 22:27 GMT+08:00 叶 :

> yes ,this method can resolve this problem。but After each build cube will
> appear this problem. I want to one-time solve this problem. I don't know
> what should I do。。。
>
>
>
>
>
>
>
>
>
> At 2017-02-01 20:37:11,nichunen  wrote:
> >Maybe you need to update the hbase coprocessor, try the tutorial as the
> link below:
> >http://kylin.apache.org/docs15/howto/howto_update_coprocessor.html
> >
> >
> >
> >
> >
> >  George/倪春恩
> >
> >Mobile:+86-13501723787| WeChat:nceecn
> >
> >北京明略软件系统有限公司（MiningLamp.COM
> >）
> >
> >
> >
> >
> >
> >上海市浦东新区晨晖路258号G座iDream张江科创中心C125
> >
> >
> >
> >
> >Room C125#,Intelligent Industrial Park Building G,258#Chenhui Road,
> Pudong District,Shanghai,201203
> >
> >
> >
> >
> >> On Feb 1, 2017, at 7:26 PM, 叶  wrote:
> >>
> >>
> >> Dear Developers:
> >>
> >>
> >> today I add kylin.coprocessor.local.jar arguments in kylin.property
> file and when build cube done . I execute query "select * from xxx" hits
> error below:
> >>
> >>
> >> org.apache.hadoop.hbase.exceptions.UnknownProtocolException: No
> registered coprocessor service found for name CubeVisitService in region
> KYLIN_GA464RXYQX,,1484635706236.9aac092cc3bd8855999c7a8734f09842.
> >>
> >>
> >> how can I resolve this problem?
> >>
> >>
> >> thanks
> >>
>



-- 
Best regards,

Shaofeng Shi 史少锋

Re: build cube and hbase coprocessor not avaliable

2017-02-01 Thread nichunen 
Maybe you need to update the hbase coprocessor, try the tutorial as the link 
below:
http://kylin.apache.org/docs15/howto/howto_update_coprocessor.html
 




  George/倪春恩

Mobile:+86-13501723787| WeChat:nceecn

北京明略软件系统有限公司（MiningLamp.COM
）





上海市浦东新区晨晖路258号G座iDream张江科创中心C125




Room C125#,Intelligent Industrial Park Building G,258#Chenhui Road, Pudong 
District,Shanghai,201203




> On Feb 1, 2017, at 7:26 PM, 叶  wrote:
> 
> 
> Dear Developers:
> 
> 
> today I add kylin.coprocessor.local.jar arguments in kylin.property file and 
> when build cube done . I execute query "select * from xxx" hits error below:
> 
> 
> org.apache.hadoop.hbase.exceptions.UnknownProtocolException: No registered 
> coprocessor service found for name CubeVisitService in region 
> KYLIN_GA464RXYQX,,1484635706236.9aac092cc3bd8855999c7a8734f09842.
> 
> 
> how can I resolve this problem?
> 
> 
> thanks
>