"*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 <x...@apache.org> 于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" <phi...@optonline.net> 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 > >= 40000 > > > >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 > > >org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:62) > > > > at > > >org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetry > >ingCaller.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(RpcRetrying > >Caller.java:126) > > > > ... 4 more > > > >2020-04-14 13:58:24,142 INFO [close-hbase-conn] > hbase.HBaseConnection:137 : > >Closing HBase connections... > > > >2020-04-14 13:58:24,143 INFO [close-hbase-conn] > >client.ConnectionManager$HConnectionImplementation:1676 : Closing > zookeeper > >sessionid=0x17178f6fbd6000a > > > >2020-04-14 13:58:24,150 INFO [close-hbase-conn] zookeeper.ZooKeeper:684 : > >Session: 0x17178f6fbd6000a closed > > > >2020-04-14 13:58:24,150 INFO [main-EventThread] zookeeper.ClientCnxn:512 > : > >EventThread shut down > > > >ERROR: Unknown error. Please check full log > > > > > > > >I'm not sure, but my feeling is that there is an error with the HBase or > >Kafka or Zookeper default configuration that needs some changes from my > end, > >but not sure what. > > > > > > > >Appreciate your help on this, > > > > > > > >Thanks. > > > >David Rubio > >_______________________________________ > > > >GFT IT Consulting, S.L.U. > >Avinguda Oest 48 > >46001 VALENCIA > > > >T +34963012486 > >david.ru...@gft.com <mailto:david.ru...@gft.com> > > <https://www.gft.com/es> www.gft.com/es > >https://blog.gft.com/es > > <https://www.twitter.com/gft_es> www.twitter.com/gft_es > >_______________________________________ > > >