Re: Kylin 3.0 - Need some help - Can't open the Kylin UI
"*Caused by: java.net.ConnectException: Connection refused"* *This error indicates the HBase service is unavailable. As you know, Kylin stores Cube and its metadata in HBase, so making HBase service running is a prerequisite of starting Kylin.* Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: user-subscr...@kylin.apache.org Join Kylin dev mail group: dev-subscr...@kylin.apache.org Xiaoxiang Yu 于2020年4月16日周四 下午2:35写道： > Hi friend, > I can felt your pain, but please be patient. > In my opinion, to make good use of Apache Kylin, or any other complex > system, some prerequisites should be met. Firstly, I think understanding > Kylin's overall architecture, some knowledge of analysing > logs(kylin.log/kylin.out) of Kylin are very important, only in this way you > can narrow down the problem you faced. After problem was identified, if > you have some knowledge of how to manipulate Hadoop components: such as > Apache HBase, Apache HDFS and Apache Hive, I think you can fix problem > yourself or ask for assistance from community. Hortonworks have provided > some documentation which looks good to me( > https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.0/starting-hive/content/hive_start_a_command_line_query_locally.html), > maybe you can have a try. > > > Besides, did you ever try to use docker image to start kylin in one > command? It will give you a learning env without any Hadoop cluster. I > think it works well in my laptop(Macbook Pro,15 inch with the latest Docker > Desktop installed), here is the link, > https://hub.docker.com/r/apachekylin/apache-kylin-standalone > > > > > > > > > > > > > > -- > > Best wishes to you ! > From ：Xiaoxiang Yu > > > > > > At 2020-04-15 21:46:49, "Phillip Poirier" wrote: > >Not that misery always loves company, but I had the previous Kylin version > >and was trying to use it with the Hortonworks 2.0 distro, and even though > I > >could eventually get the service to start, the UI would never launch. The > >few people that responded to me told me to try things I already tried > (like > >try a different URL or try using different browsers) and it never worked. > >As someone who's spent decades working in BI and OLAP (especially in SSAS, > >Essbase and TM1) I too was very interested in trying Kylin as a big data > >OLAP option and even took the Udemy course on it. Unfortunately, I just > had > >to sit and watch as the course instructor performed cube-building tasks > as I > >was never able to get the UI to launch. > > > > > > > >If you get a real answer to this issue, I'd like to try again. I have the > >Hortonworks 3.0 distro now, and would like to try the new version of > Kylin, > >if possible. If not, I'll take a look at Druid. > > > > > > > >Good luck. > > > > > > > >-Phil > > > > > > > >From: Rubio Piqueras, David [mailto:david.ru...@gft.com] > >Sent: Tuesday, April 14, 2020 11:58 AM > >To: dev@kylin.apache.org > >Subject: Kylin 3.0 - Need some help - Can't open the Kylin UI > > > > > > > >Hi guys, > > > > > > > >Just starting using Kylin too which looks so interesting. > > > >We downloaded your Kylin 3.0 image version: > > > > > > > > > > > >However, I can't open the Kylin UI anytime I try to open it. Checking the > >logs, this is what we are seeing: > > > > > > > >2020-04-14 13:58:23,853 INFO [main-SendThread(localhost:2181)] > >zookeeper.ClientCnxn:1235 : Session establishment complete on server > >localhost/127.0.0.1:2181, sessionid = 0x17178f6fbd6000a, negotiated > timeout > >= 4 > > > >Exception in thread "main" java.lang.IllegalArgumentException: Failed to > >find metadata store by url: kylin_metadata@hbase > > > >at > > >org.apache.kylin.common.persistence.ResourceStore.createResourceStore(Resour > >ceStore.java:101) > > > >at > > >org.apache.kylin.common.persistence.ResourceStore.getStore(ResourceStore.jav > >a:113) > > > >at > > >org.apache.kylin.rest.service.AclTableMigrationTool.checkIfNeedMigrate(AclTa > >bleMigrationTool.java:99) > > > >at > > >org.apache.kylin.tool.AclTableMigrationCLI.main(AclTableMigrationCLI.java:43 > >) > > > >Caused by: java.lang.reflect.InvocationTargetException > > > >at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > >Method) > > > >at > > >sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces > >sorImpl.java:62) > > > >at > > >sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc > >torAccessorImpl.java:45) > > > >at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > > > >at > > >org.apache.kylin.common.persistence.ResourceStore.createResourceStore(Resour > >ceStore.java:94) > > > >... 3 more > > > >Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: > Failed > >after attempts=1, exceptions: > > > >Tue Apr
RE: Kylin 3.0 - Need some help - Can't open the Kylin UI
Hi friend,
I can felt your pain, but please be patient.
In my opinion, to make good use of Apache Kylin, or any other complex
system, some prerequisites should be met. Firstly, I think understanding
Kylin's overall architecture, some knowledge of analysing
logs(kylin.log/kylin.out) of Kylin are very important, only in this way you can
narrow down the problem you faced. After problem was identified, if you have
some knowledge of how to manipulate Hadoop components: such as Apache HBase,
Apache HDFS and Apache Hive, I think you can fix problem yourself or ask for
assistance from community. Hortonworks have provided some documentation which
looks good to
me(https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.0/starting-hive/content/hive_start_a_command_line_query_locally.html),
maybe you can have a try.
Besides, did you ever try to use docker image to start kylin in one
command? It will give you a learning env without any Hadoop cluster. I think
it works well in my laptop(Macbook Pro,15 inch with the latest Docker Desktop
installed), here is the link,
https://hub.docker.com/r/apachekylin/apache-kylin-standalone
--
Best wishes to you !
From ：Xiaoxiang Yu
At 2020-04-15 21:46:49, "Phillip Poirier" wrote:
>Not that misery always loves company, but I had the previous Kylin version
>and was trying to use it with the Hortonworks 2.0 distro, and even though I
>could eventually get the service to start, the UI would never launch. The
>few people that responded to me told me to try things I already tried (like
>try a different URL or try using different browsers) and it never worked.
>As someone who's spent decades working in BI and OLAP (especially in SSAS,
>Essbase and TM1) I too was very interested in trying Kylin as a big data
>OLAP option and even took the Udemy course on it. Unfortunately, I just had
>to sit and watch as the course instructor performed cube-building tasks as I
>was never able to get the UI to launch.
>
>
>
>If you get a real answer to this issue, I'd like to try again. I have the
>Hortonworks 3.0 distro now, and would like to try the new version of Kylin,
>if possible. If not, I'll take a look at Druid.
>
>
>
>Good luck.
>
>
>
>-Phil
>
>
>
>From: Rubio Piqueras, David [mailto:david.ru...@gft.com]
>Sent: Tuesday, April 14, 2020 11:58 AM
>To: dev@kylin.apache.org
>Subject: Kylin 3.0 - Need some help - Can't open the Kylin UI
>
>
>
>Hi guys,
>
>
>
>Just starting using Kylin too which looks so interesting.
>
>We downloaded your Kylin 3.0 image version:
>
>
>
>
>
>However, I can't open the Kylin UI anytime I try to open it. Checking the
>logs, this is what we are seeing:
>
>
>
>2020-04-14 13:58:23,853 INFO [main-SendThread(localhost:2181)]
>zookeeper.ClientCnxn:1235 : Session establishment complete on server
>localhost/127.0.0.1:2181, sessionid = 0x17178f6fbd6000a, negotiated timeout
>= 4
>
>Exception in thread "main" java.lang.IllegalArgumentException: Failed to
>find metadata store by url: kylin_metadata@hbase
>
>at
>org.apache.kylin.common.persistence.ResourceStore.createResourceStore(Resour
>ceStore.java:101)
>
>at
>org.apache.kylin.common.persistence.ResourceStore.getStore(ResourceStore.jav
>a:113)
>
>at
>org.apache.kylin.rest.service.AclTableMigrationTool.checkIfNeedMigrate(AclTa
>bleMigrationTool.java:99)
>
>at
>org.apache.kylin.tool.AclTableMigrationCLI.main(AclTableMigrationCLI.java:43
>)
>
>Caused by: java.lang.reflect.InvocationTargetException
>
>at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>Method)
>
>at
>sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
>sorImpl.java:62)
>
>at
>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
>torAccessorImpl.java:45)
>
>at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>
>at
>org.apache.kylin.common.persistence.ResourceStore.createResourceStore(Resour
>ceStore.java:94)
>
>... 3 more
>
>Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed
>after attempts=1, exceptions:
>
>Tue Apr 14 13:58:24 UTC 2020,
>RpcRetryingCaller{globalStartTime=1586872703980, pause=100, retries=1},
>java.net.ConnectException: Connection refused
>
>
>
>at
>org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetrying
>Caller.java:147)
>
>at
>org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture
>.run(ResultBoundedCompletionService.java:64)
>
>at
>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:11
>49)
>
>at
>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:6
>24)
>
>at java.lang.Thread.run(Thread.java:748)
>
>Caused by: java.net.ConnectException: Connection refused
>
>at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
>
>at
RE: Kylin 3.0 - Need some help - Can't open the Kylin UI
Not that misery always loves company, but I had the previous Kylin version
and was trying to use it with the Hortonworks 2.0 distro, and even though I
could eventually get the service to start, the UI would never launch. The
few people that responded to me told me to try things I already tried (like
try a different URL or try using different browsers) and it never worked.
As someone who's spent decades working in BI and OLAP (especially in SSAS,
Essbase and TM1) I too was very interested in trying Kylin as a big data
OLAP option and even took the Udemy course on it. Unfortunately, I just had
to sit and watch as the course instructor performed cube-building tasks as I
was never able to get the UI to launch.
If you get a real answer to this issue, I'd like to try again. I have the
Hortonworks 3.0 distro now, and would like to try the new version of Kylin,
if possible. If not, I'll take a look at Druid.
Good luck.
-Phil
From: Rubio Piqueras, David [mailto:david.ru...@gft.com]
Sent: Tuesday, April 14, 2020 11:58 AM
To: dev@kylin.apache.org
Subject: Kylin 3.0 - Need some help - Can't open the Kylin UI
Hi guys,
Just starting using Kylin too which looks so interesting.
We downloaded your Kylin 3.0 image version:
However, I can't open the Kylin UI anytime I try to open it. Checking the
logs, this is what we are seeing:
2020-04-14 13:58:23,853 INFO [main-SendThread(localhost:2181)]
zookeeper.ClientCnxn:1235 : Session establishment complete on server
localhost/127.0.0.1:2181, sessionid = 0x17178f6fbd6000a, negotiated timeout
= 4
Exception in thread "main" java.lang.IllegalArgumentException: Failed to
find metadata store by url: kylin_metadata@hbase
at
org.apache.kylin.common.persistence.ResourceStore.createResourceStore(Resour
ceStore.java:101)
at
org.apache.kylin.common.persistence.ResourceStore.getStore(ResourceStore.jav
a:113)
at
org.apache.kylin.rest.service.AclTableMigrationTool.checkIfNeedMigrate(AclTa
bleMigrationTool.java:99)
at
org.apache.kylin.tool.AclTableMigrationCLI.main(AclTableMigrationCLI.java:43
)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at
org.apache.kylin.common.persistence.ResourceStore.createResourceStore(Resour
ceStore.java:94)
... 3 more
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed
after attempts=1, exceptions:
Tue Apr 14 13:58:24 UTC 2020,
RpcRetryingCaller{globalStartTime=1586872703980, pause=100, retries=1},
java.net.ConnectException: Connection refused
at
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetrying
Caller.java:147)
at
org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture
.run(ResultBoundedCompletionService.java:64)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:11
49)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:6
24)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at
sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:717)
at
org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.java:2
06)
at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:529)
at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:493)
at
org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupConnection(RpcClie
ntImpl.java:424)
at
org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupIOstreams(RpcClien
tImpl.java:748)
at
org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.writeRequest(RpcClientI
mpl.java:920)
at
org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.tracedWriteRequest(RpcC
lientImpl.java:889)
at
org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1222)
at
org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpc
Client.java:213)
at
org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementati
on.callBlockingMethod(AbstractRpcClient.java:287)
at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$Blocki
ngStub.scan(ClientProtos.java:32651)
at
org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.j
ava:372)
at
org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:199
)
at
Re: Kylin 3.0 - Need some help - Can't open the Kylin UI
Hi David：
The image doesn't seem to load successfully, so I can't see its contents.
Is the kylin you downloaded a docker image or a binary package？
If kylin's binary package is installed in your own Hadoop environment, this
error may indicate that there are some problems in your HBase environment. You
can execute commands in the HBase shell to check the HBase status.
> 在 2020年4月14日，23:57，Rubio Piqueras, David 写道：
>
> Hi guys,
>
> Just starting using Kylin too which looks so interesting.
> We downloaded your Kylin 3.0 image version:
>
>
> However, I can’t open the Kylin UI anytime I try to open it. Checking the
> logs, this is what we are seeing:
>
> 2020-04-14 13:58:23,853 INFO [main-SendThread(localhost:2181)]
> zookeeper.ClientCnxn:1235 : Session establishment complete on server
> localhost/127.0.0.1:2181, sessionid = 0x17178f6fbd6000a, negotiated timeout =
> 4
> Exception in thread "main" java.lang.IllegalArgumentException: Failed to find
> metadata store by url: kylin_metadata@hbase
> at
> org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:101)
> at
> org.apache.kylin.common.persistence.ResourceStore.getStore(ResourceStore.java:113)
> at
> org.apache.kylin.rest.service.AclTableMigrationTool.checkIfNeedMigrate(AclTableMigrationTool.java:99)
> at
> org.apache.kylin.tool.AclTableMigrationCLI.main(AclTableMigrationCLI.java:43)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at
> org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:94)
> ... 3 more
> Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed
> after attempts=1, exceptions:
> Tue Apr 14 13:58:24 UTC 2020,
> RpcRetryingCaller{globalStartTime=1586872703980, pause=100, retries=1},
> java.net.ConnectException: Connection refused
>
> at
> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:147)
> at
> org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: java.net.ConnectException: Connection refused
> at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
> at
> sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:717)
> at
> org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.java:206)
> at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:529)
> at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:493)
> at
> org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupConnection(RpcClientImpl.java:424)
> at
> org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupIOstreams(RpcClientImpl.java:748)
> at
> org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.writeRequest(RpcClientImpl.java:920)
> at
> org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.tracedWriteRequest(RpcClientImpl.java:889)
> at
> org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1222)
> at
> org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:213)
> at
> org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:287)
> at
> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:32651)
> at
> org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:372)
> at
> org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:199)
> at
> org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:62)
> at
> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200)
> at
> org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:346)
> at
> org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:320)
> at
> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
> ... 4 more
> 2020-04-14 13:58:24,142 INFO [close-hbase-conn]
