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
>_______________________________________
>
