[jira] [Created] (KYLIN-2250) Make HiveMRInput support Hive View

2016-12-05 Thread Wang Cheng (JIRA)
Wang Cheng created KYLIN-2250:
-

 Summary: Make HiveMRInput support Hive View
 Key: KYLIN-2250
 URL: https://issues.apache.org/jira/browse/KYLIN-2250
 Project: Kylin
  Issue Type: Bug
Reporter: Wang Cheng
Priority: Minor


When hive table is a view, it can not be accessed by HCatalog. A compromised 
way is to materialize the view firstly.
In this purpose, make a little bit changes in HiveMRInput.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (KYLIN-2249) Build cube error when use "inmem" but ok with "layer"

2016-12-05 Thread hoangle (JIRA)
hoangle created KYLIN-2249:
--

 Summary: Build cube error when use "inmem" but ok with "layer"
 Key: KYLIN-2249
 URL: https://issues.apache.org/jira/browse/KYLIN-2249
 Project: Kylin
  Issue Type: Bug
Affects Versions: v1.6.0
Reporter: hoangle


2016-12-05 17:17:37,451 ERROR [Thread-13] org.apache.kylin.dict.TrieDictionary: 
Not a valid value: 122594010041
2016-12-05 17:17:38,452 ERROR [pool-8-thread-1] 
org.apache.kylin.cube.inmemcubing.DoggedCubeBuilder: Dogged Cube Build error
java.io.IOException: java.lang.IllegalArgumentException: Value not exists!
at 
org.apache.kylin.cube.inmemcubing.DoggedCubeBuilder$BuildOnce.abort(DoggedCubeBuilder.java:196)
at 
org.apache.kylin.cube.inmemcubing.DoggedCubeBuilder$BuildOnce.checkException(DoggedCubeBuilder.java:169)
at 
org.apache.kylin.cube.inmemcubing.DoggedCubeBuilder$BuildOnce.build(DoggedCubeBuilder.java:116)
at 
org.apache.kylin.cube.inmemcubing.DoggedCubeBuilder.build(DoggedCubeBuilder.java:75)
at 
org.apache.kylin.cube.inmemcubing.AbstractInMemCubeBuilder$1.run(AbstractInMemCubeBuilder.java:82)
at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalArgumentException: Value not exists!
at 
org.apache.kylin.common.util.Dictionary.getIdFromValueBytes(Dictionary.java:162)
at 
org.apache.kylin.dict.TrieDictionary.getIdFromValueImpl(TrieDictionary.java:167)
at 
org.apache.kylin.common.util.Dictionary.getIdFromValue(Dictionary.java:98)
at 
org.apache.kylin.dimension.DictionaryDimEnc$DictionarySerializer.serialize(DictionaryDimEnc.java:121)
at 
org.apache.kylin.cube.gridtable.CubeCodeSystem.encodeColumnValue(CubeCodeSystem.java:121)
at 
org.apache.kylin.cube.gridtable.CubeCodeSystem.encodeColumnValue(CubeCodeSystem.java:110)
at org.apache.kylin.gridtable.GTRecord.setValues(GTRecord.java:93)
at org.apache.kylin.gridtable.GTRecord.setValues(GTRecord.java:81)
at 
org.apache.kylin.cube.inmemcubing.InMemCubeBuilderInputConverter.convert(InMemCubeBuilderInputConverter.java:74)
at 
org.apache.kylin.cube.inmemcubing.InMemCubeBuilder$InputConverter$1.next(InMemCubeBuilder.java:544)
at 
org.apache.kylin.cube.inmemcubing.InMemCubeBuilder$InputConverter$1.next(InMemCubeBuilder.java:525)
at 
org.apache.kylin.gridtable.GTAggregateScanner.iterator(GTAggregateScanner.java:139)
at 
org.apache.kylin.cube.inmemcubing.InMemCubeBuilder.createBaseCuboid(InMemCubeBuilder.java:341)
at 
org.apache.kylin.cube.inmemcubing.InMemCubeBuilder.build(InMemCubeBuilder.java:168)
at 
org.apache.kylin.cube.inmemcubing.InMemCubeBuilder.build(InMemCubeBuilder.java:137)
at 
org.apache.kylin.cube.inmemcubing.DoggedCubeBuilder$SplitThread.run(DoggedCubeBuilder.java:284)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


Re: job build

2016-12-05 Thread Mario Copperfield
OK, thanks, i got it!

On 6 Dec 2016, 11:37 +0800, ShaoFeng Shi , wrote:
> Hi Copperfield,
>
> The "auto merge" is a "nice-to-have" feature for "partitioned" cube; For
> partitioned cube, the build is always incremental.
>
> 2016-12-06 11:08 GMT+08:00 Mario Copperfield :
>
> > Hi, all
> > I have a question about job build. Does kylin always use incremental build
> > strategy even we no set auto merge?
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋


Re: 回复: 使用全局字典报错AppendTrieDictionary can't retrive value from id

2016-12-05 Thread roger shi
Hi wangdan,

Would you please attach the cube desc json? The cube definition in previous 
email is cube instance json.

Thanks,
Roger

On 06/12/2016, 10:20 AM, "wang...@snqu.com"  wrote:


查看了kylin.properties文件中kylin.dictionary.max.cardinality=500修改为kylin.dictionary.max.cardinality=2000
 同时修改cube, 添加rowkey,重新编译成功
但是查询时以下的两个语句可以成功
select label, count(label) from USERCASE_20161204 group by label order by 
label desc
select name, count(name) from USERCASE_20161204 group by name order by name 
desc

以下的两个语句
select rowkey, count(rowkey) from USERCASE_20161204 group by rowkey order 
by rowkey desc
select job, count(job) from USERCASE_20161204 group by job order by job des
执行后报错:
Error while executing SQL "select rowkey, count(rowkey) from 
USERCASE_20161204 group by rowkey order by rowkey desc LIMIT 5": 
AppendTrieDictionary can't retrive value from id
Error while executing SQL "select job, count(job) from USERCASE_20161204 
group by job order by job desc LIMIT 5": AppendTrieDictionary can't retrive 
value from id

cube的定义如下:
{
  "uuid": "d4671695-96a1-4981-bb4c-2263de45f2ee",
  "last_modified": 1480939514479,
  "version": "1.6.0",
  "name": "dmp_cube_590w",
  "owner": "ADMIN",
  "descriptor": "dmp_cube_590w",
  "cost": 50,
  "status": "READY",
  "segments": [
{
  "uuid": "4237b09b-8d2e-4c5c-be19-afc67e6524f5",
  "name": "1970010100_2016120500",
  "storage_location_identifier": "KYLIN_IE2V4DQUY4",
  "date_range_start": 0,
  "date_range_end": 148089600,
  "source_offset_start": 0,
  "source_offset_end": 0,
  "status": "READY",
  "size_kb": 8180652,
  "input_records": 5978388,
  "input_records_size": 666419108,
  "last_build_time": 1480939514367,
  "last_build_job_id": "d563a6b8-c6cd-41c7-93c4-47bb319bf21b",
  "create_time_utc": 1480931400144,
  "cuboid_shard_nums": {
"1": 2,
"2": 2,
"3": 3,
"4": 2,
"5": 3,
"6": 3,
"7": 4,
"8": 2,
"9": 3,
"10": 3,
"11": 4,
"12": 3,
"13": 4,
"14": 4,
"15": 5,
"32": 2,
"33": 3,
"34": 3,
"35": 4,
"36": 3,
"37": 4,
"38": 4,
"39": 5,
"40": 3,
"41": 4,
"42": 4,
"43": 5,
"44": 4,
"45": 5,
"46": 5,
"47": 6,
"64": 6,
"65": 6,
"66": 6,
"67": 6,
"68": 6,
"69": 6,
"70": 6,
"71": 6,
"72": 6,
"73": 6,
"74": 6,
"75": 6,
"76": 6,
"77": 6,
"78": 6,
"79": 6,
"96": 6,
"97": 6,
"98": 6,
"99": 6,
"100": 6,
"101": 6,
"102": 6,
"103": 6,
"104": 6,
"105": 6,
"106": 6,
"107": 6,
"108": 6,
"109": 6,
"110": 6,
"111": 6,
"127": 6
  },
  "total_shards": 11,
  "blackout_cuboids": [],
  "binary_signature": null,
  "dictionaries": {
"DEFAULT.USERCASE_20161204/SEX": 
"/dict/DEFAULT.USERCASE_20161204/SEX/17d36c0b-e7a7-4bb4-941f-47bc78a24751.dict",
"DEFAULT.USERCASE_20161204/TIMESTAMP": 
"/dict/DEFAULT.USERCASE_20161204/TIMESTAMP/87ce791b-3de3-491f-901f-d28721a25e94.dict",
"DEFAULT.USERCASE_20161204/NAME": 
"/dict/DEFAULT.USERCASE_20161204/NAME/73a59cfb-eaa5-4531-ba7e-16ba2adeaea9.dict",
"DEFAULT.USERCASE_20161204/LABEL": 
"/dict/DEFAULT.USERCASE_20161204/LABEL/71c633ee-dffb-4d80-9844-768b6ee21782.dict",
"DEFAULT.USERCASE_20161204/LOCAL": 
"/dict/DEFAULT.USERCASE_20161204/LOCAL/31ed5b68-aae2-40b7-ba09-83abf1d64953.dict",
"DEFAULT.USERCASE_20161204/ROWKEY": 
"/dict/DEFAULT.USERCASE_20161204/ROWKEY/736822fd-5103-4814-bfcd-b6af80609970.dict",
"DEFAULT.USERCASE_20161204/JOB": 
"/dict/DEFAULT.USERCASE_20161204/JOB/a47cc0f8-80ab-46fa-953a-59a326412395.dict"
  },
  "snapshots": null,
  "index_path": 
"/kylin/kylin_metadata/kylin-d563a6b8-c6cd-41c7-93c4-47bb319bf21b/dmp_cube_590w/secondary_index/",
  "rowkey_stats": [
[
  "ROWKEY",
  5978389,
  4
],
[
  "NAME",
  1195682,
  3
],
[
  "TIMESTAMP",
  1,
  1
],
[
  "SEX",
  1195680,
  

回复: 使用全局字典报错AppendTrieDictionary can't retrive value from id

2016-12-05 Thread wang...@snqu.com
查看了kylin.properties文件中kylin.dictionary.max.cardinality=500修改为kylin.dictionary.max.cardinality=2000
 同时修改cube, 添加rowkey,重新编译成功
但是查询时以下的两个语句可以成功
select label, count(label) from USERCASE_20161204 group by label order by label 
desc
select name, count(name) from USERCASE_20161204 group by name order by name desc

以下的两个语句
select rowkey, count(rowkey) from USERCASE_20161204 group by rowkey order by 
rowkey desc
select job, count(job) from USERCASE_20161204 group by job order by job des
执行后报错:
Error while executing SQL "select rowkey, count(rowkey) from USERCASE_20161204 
group by rowkey order by rowkey desc LIMIT 5": AppendTrieDictionary can't 
retrive value from id
Error while executing SQL "select job, count(job) from USERCASE_20161204 group 
by job order by job desc LIMIT 5": AppendTrieDictionary can't retrive value 
from id

cube的定义如下:
{
  "uuid": "d4671695-96a1-4981-bb4c-2263de45f2ee",
  "last_modified": 1480939514479,
  "version": "1.6.0",
  "name": "dmp_cube_590w",
  "owner": "ADMIN",
  "descriptor": "dmp_cube_590w",
  "cost": 50,
  "status": "READY",
  "segments": [
{
  "uuid": "4237b09b-8d2e-4c5c-be19-afc67e6524f5",
  "name": "1970010100_2016120500",
  "storage_location_identifier": "KYLIN_IE2V4DQUY4",
  "date_range_start": 0,
  "date_range_end": 148089600,
  "source_offset_start": 0,
  "source_offset_end": 0,
  "status": "READY",
  "size_kb": 8180652,
  "input_records": 5978388,
  "input_records_size": 666419108,
  "last_build_time": 1480939514367,
  "last_build_job_id": "d563a6b8-c6cd-41c7-93c4-47bb319bf21b",
  "create_time_utc": 1480931400144,
  "cuboid_shard_nums": {
"1": 2,
"2": 2,
"3": 3,
"4": 2,
"5": 3,
"6": 3,
"7": 4,
"8": 2,
"9": 3,
"10": 3,
"11": 4,
"12": 3,
"13": 4,
"14": 4,
"15": 5,
"32": 2,
"33": 3,
"34": 3,
"35": 4,
"36": 3,
"37": 4,
"38": 4,
"39": 5,
"40": 3,
"41": 4,
"42": 4,
"43": 5,
"44": 4,
"45": 5,
"46": 5,
"47": 6,
"64": 6,
"65": 6,
"66": 6,
"67": 6,
"68": 6,
"69": 6,
"70": 6,
"71": 6,
"72": 6,
"73": 6,
"74": 6,
"75": 6,
"76": 6,
"77": 6,
"78": 6,
"79": 6,
"96": 6,
"97": 6,
"98": 6,
"99": 6,
"100": 6,
"101": 6,
"102": 6,
"103": 6,
"104": 6,
"105": 6,
"106": 6,
"107": 6,
"108": 6,
"109": 6,
"110": 6,
"111": 6,
"127": 6
  },
  "total_shards": 11,
  "blackout_cuboids": [],
  "binary_signature": null,
  "dictionaries": {
"DEFAULT.USERCASE_20161204/SEX": 
"/dict/DEFAULT.USERCASE_20161204/SEX/17d36c0b-e7a7-4bb4-941f-47bc78a24751.dict",
"DEFAULT.USERCASE_20161204/TIMESTAMP": 
"/dict/DEFAULT.USERCASE_20161204/TIMESTAMP/87ce791b-3de3-491f-901f-d28721a25e94.dict",
"DEFAULT.USERCASE_20161204/NAME": 
"/dict/DEFAULT.USERCASE_20161204/NAME/73a59cfb-eaa5-4531-ba7e-16ba2adeaea9.dict",
"DEFAULT.USERCASE_20161204/LABEL": 
"/dict/DEFAULT.USERCASE_20161204/LABEL/71c633ee-dffb-4d80-9844-768b6ee21782.dict",
"DEFAULT.USERCASE_20161204/LOCAL": 
"/dict/DEFAULT.USERCASE_20161204/LOCAL/31ed5b68-aae2-40b7-ba09-83abf1d64953.dict",
"DEFAULT.USERCASE_20161204/ROWKEY": 
"/dict/DEFAULT.USERCASE_20161204/ROWKEY/736822fd-5103-4814-bfcd-b6af80609970.dict",
"DEFAULT.USERCASE_20161204/JOB": 
"/dict/DEFAULT.USERCASE_20161204/JOB/a47cc0f8-80ab-46fa-953a-59a326412395.dict"
  },
  "snapshots": null,
  "index_path": 
"/kylin/kylin_metadata/kylin-d563a6b8-c6cd-41c7-93c4-47bb319bf21b/dmp_cube_590w/secondary_index/",
  "rowkey_stats": [
[
  "ROWKEY",
  5978389,
  4
],
[
  "NAME",
  1195682,
  3
],
[
  "TIMESTAMP",
  1,
  1
],
[
  "SEX",
  1195680,
  4
],
[
  "LOCAL",
  1195679,
  4
],
[
  "JOB",
  1195679,
  4
],
[
  "LABEL",
  1195676,
  3
]
  ]
}
  ],
  "create_time_utc": 1480907805715,
  "size_kb": 8180652,
  "input_records_count": 5978388,
  "input_records_size": 666419108
}
 
发件人: wang...@snqu.com
发送时间: 2016-12-05 15:11
收件人: dev
主题: 使用全局字典报错AppendTrieDictionary can't retrive value from id
hi, 
 每个维度的基数有590万,当在rowkey中选择dict时,编译产生错误:
“Too high cardinality is not suitable for dictionary -- cardinality: 5978388“

所以修改了model, 没有定义rowkey, 对所有维度定义了全局字典,build成功,查询时报错: 
“AppendTrieDictionary can't retrive value from id“




Re: A question about establishing Kylin

2016-12-05 Thread rockteen
Hi, thanks for replying.
According to the download page of the website, for Hbase 0.99 it seems that
the apache-kylin-1.6.0-bin.tar.gz  should be the appropriate binary package?
Actually I've try this one before but it didn't work. Thus I downloaded the
apache-kylin-1.5.4.1-bin.tar.gz and gave another try. 

Is their any other possible issue here or maybe I should reinstall the Hbase
to version 0.98? 



Regards.

--
View this message in context: 
http://apache-kylin.74782.x6.nabble.com/A-question-about-establishing-Kylin-tp6499p6502.html
Sent from the Apache Kylin mailing list archive at Nabble.com.


Re: Streaming cube build failed

2016-12-05 Thread Billy Liu
Thanks for the update. Any feedback is welcomed.

2016-12-05 14:42 GMT+08:00 汪胜 :

> I'm sorry to trouble you. I had found the reason about why the build job
> failed. I wrote the wrong kafka host when I create streaming table. When I
> added a broker, I wrote the host as "localhost".
>
>
>
> On 12/5/2016 11:00, 汪胜wrote:
>
> Hello, I installed kylin1.6.0 and kafka0.10.1, and I followed the blog
> "Scalable Cubing from Kafka (beta)" step by step, but the build job failed
> at the first step "Save data from Kafka". ​The hadoop yarn log show the
> below content:
>
>
> "WARN [main] org.apache.hadoop.mapred.YarnChild: Exception running child
> : java.io.IOException: Unexpected ending of stream, expected ending offset
> 5689, but end at 0
> at org.apache.kylin.source.kafka.hadoop.KafkaInputRecordReader.
> nextKeyValue(KafkaInputRecordReader.java:121)
> at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.
> nextKeyValue(MapTask.java:533)
> at org.apache.hadoop.mapreduce.task.MapContextImpl.
> nextKeyValue(MapContextImpl.java:80)
> at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.
> nextKeyValue(WrappedMapper.java:91)
> at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
> at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:764)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:340)
> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:415)
> at org.apache.hadoop.security.UserGroupInformation.doAs(
> UserGroupInformation.java:1614)
> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163)
> "
>
>
> It's there something wrong with my kafka settings or kylin env? (The kafka
> producer can send messages, and consumer can receive messages.)
>


Re: A question about establishing Kylin

2016-12-05 Thread Dong Li
Hello,

Seems the root cause is:

java.lang.NoSuchMethodError:
org.apache.hadoop.hbase.client.HBaseAdmin.(Lorg/apache/hadoop/hbase/client/HConnection;)V


Since HBase APIs differ in different versions, Kylin provides 3 binary
packages for different hbase versions. Please check your version.

If you're using HBase 0.99, please use the binary package for HBase 0.98.

http://kylin.apache.org/download/

Thanks,
Dong Li

2016-12-05 21:21 GMT+08:00 rockteen :

> Hi,
>
> I was trying to setup Kylin on a Hadoop Cluster which is managed by Ambari.
> The version of hadoop is 2.6.0, the version of Hive is 0.14.0, the version
> of HBase is 0.99.2 and the version of kylin is
> apache-kylin-1.5.4.1-bin.tar.gz.
>
> I could see the "A new Kylin instance is started by root" but then I was
> failed to access the web UI, also running sample.sh returned several error
> messages.Hive and Hbase shell runs totally well on the server, there are
> "kylin_metadata","kylin_metadata_acl","kylin_metadata_user" in the list of
> Hbase catagory. I also tested the connection between Hbase and Hive by
> creating a mutual table. A lot of solution on Baidu and Google were tested
> but the issue remains. Much appreciated if someone can help me on this.
>
>
> 2016-12-05 20:03:05,953 WARN  [localhost-startStop-1]
> util.HeapMemorySizeUtil:55 : hbase.regionserver.global.memstore.upperLimit
> is deprecated by hbase.regionserver.global.memstore.size
> 2016-12-05 20:03:06,816 WARN  [localhost-startStop-1]
> support.XmlWebApplicationContext:487 : Exception encountered during
> context
> initialization - cancelling refresh attempt:
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name 'mvcContentNegotiationManager': BeanPostProcessor before
> instantiation of bean failed; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name 'org.springframework.cache.config.internalCacheAdvisor': Cannot
> resolve reference to bean
> 'org.springframework.cache.annotation.AnnotationCacheOperationSource#0'
> while setting bean property 'cacheOperationSource'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name
> 'org.springframework.cache.annotation.AnnotationCacheOperationSource#0':
> BeanPostProcessor before instantiation of bean failed; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name
> 'org.springframework.security.methodSecurityMetadataSourceAdvisor': Cannot
> resolve reference to bean
> 'org.springframework.security.access.method.DelegatingMethodSecurityMetada
> taSource#0'
> while setting constructor argument; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name
> 'org.springframework.security.access.method.DelegatingMethodSecurityMetada
> taSource#0':
> Cannot create inner bean '(inner bean)#7284f1a1' of type
> [org.springframework.security.access.prepost.
> PrePostAnnotationSecurityMetadataSource]
> while setting constructor argument with key [0]; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name '(inner bean)#7284f1a1': Cannot create inner bean '(inner
> bean)#98c3bc5' of type
> [org.springframework.security.access.expression.method.
> ExpressionBasedAnnotationAttributeFactory]
> while setting constructor argument; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name '(inner bean)#98c3bc5': Cannot resolve reference to bean
> 'expressionHandler' while setting constructor argument; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name 'expressionHandler' defined in class path resource
> [kylinSecurity.xml]: Cannot resolve reference to bean 'permissionEvaluator'
> while setting bean property 'permissionEvaluator'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name 'permissionEvaluator' defined in class path resource
> [kylinSecurity.xml]: Cannot resolve reference to bean 'aclService' while
> setting constructor argument; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name 'aclService': Invocation of init method failed; nested exception
> is java.lang.NoSuchMethodError:
> org.apache.hadoop.hbase.client.HBaseAdmin.(Lorg/
> apache/hadoop/hbase/client/HConnection;)V
> Related cause:
> org.springframework.beans.factory.BeanCurrentlyInCreationException: Error
> creating bean with name 'mvcContentNegotiationManager': Requested bean is
> currently in creation: Is there an unresolvable circular reference?
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/A-question-about-establishing-Kylin-tp6499.html
> Sent from the Apache Kylin mailing 

A question about establishing Kylin

2016-12-05 Thread rockteen
Hi,

I was trying to setup Kylin on a Hadoop Cluster which is managed by Ambari.
The version of hadoop is 2.6.0, the version of Hive is 0.14.0, the version
of HBase is 0.99.2 and the version of kylin is
apache-kylin-1.5.4.1-bin.tar.gz.

I could see the "A new Kylin instance is started by root" but then I was
failed to access the web UI, also running sample.sh returned several error
messages.Hive and Hbase shell runs totally well on the server, there are
"kylin_metadata","kylin_metadata_acl","kylin_metadata_user" in the list of
Hbase catagory. I also tested the connection between Hbase and Hive by
creating a mutual table. A lot of solution on Baidu and Google were tested
but the issue remains. Much appreciated if someone can help me on this.


2016-12-05 20:03:05,953 WARN  [localhost-startStop-1]
util.HeapMemorySizeUtil:55 : hbase.regionserver.global.memstore.upperLimit
is deprecated by hbase.regionserver.global.memstore.size
2016-12-05 20:03:06,816 WARN  [localhost-startStop-1]
support.XmlWebApplicationContext:487 : Exception encountered during context
initialization - cancelling refresh attempt:
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'mvcContentNegotiationManager': BeanPostProcessor before
instantiation of bean failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'org.springframework.cache.config.internalCacheAdvisor': Cannot
resolve reference to bean
'org.springframework.cache.annotation.AnnotationCacheOperationSource#0'
while setting bean property 'cacheOperationSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name
'org.springframework.cache.annotation.AnnotationCacheOperationSource#0':
BeanPostProcessor before instantiation of bean failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name
'org.springframework.security.methodSecurityMetadataSourceAdvisor': Cannot
resolve reference to bean
'org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource#0'
while setting constructor argument; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name
'org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource#0':
Cannot create inner bean '(inner bean)#7284f1a1' of type
[org.springframework.security.access.prepost.PrePostAnnotationSecurityMetadataSource]
while setting constructor argument with key [0]; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name '(inner bean)#7284f1a1': Cannot create inner bean '(inner
bean)#98c3bc5' of type
[org.springframework.security.access.expression.method.ExpressionBasedAnnotationAttributeFactory]
while setting constructor argument; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name '(inner bean)#98c3bc5': Cannot resolve reference to bean
'expressionHandler' while setting constructor argument; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'expressionHandler' defined in class path resource
[kylinSecurity.xml]: Cannot resolve reference to bean 'permissionEvaluator'
while setting bean property 'permissionEvaluator'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'permissionEvaluator' defined in class path resource
[kylinSecurity.xml]: Cannot resolve reference to bean 'aclService' while
setting constructor argument; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'aclService': Invocation of init method failed; nested exception
is java.lang.NoSuchMethodError:
org.apache.hadoop.hbase.client.HBaseAdmin.(Lorg/apache/hadoop/hbase/client/HConnection;)V
Related cause:
org.springframework.beans.factory.BeanCurrentlyInCreationException: Error
creating bean with name 'mvcContentNegotiationManager': Requested bean is
currently in creation: Is there an unresolvable circular reference?

--
View this message in context: 
http://apache-kylin.74782.x6.nabble.com/A-question-about-establishing-Kylin-tp6499.html
Sent from the Apache Kylin mailing list archive at Nabble.com.