Questions tagged [kylin]

An open source distributed Analytical Engine from eBay to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop to support TB to PB size analysis.

An open source distributed Analytical Engine from eBay to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop to support TB to PB size analysis.

Learning more

158 questions
0
votes
1 answer

Apache Kylin - how to solve cube build error problem

When i built kylin_sales_cube in Apache Kylin,i get the error: ERROR [main] org.apache.kylin.engine.mr.KylinReducer:java.lang.NoSuchMethodError: org.apache.hadoop.fs.FileSystem.setStoragePolicy(Lorg/apache/hadoop/fs/Path;Ljava/lang/String;)V when i…
zgg
  • 1
  • 1
0
votes
1 answer

Turn subquery result to array in Kylin

How can I turn the result from subquery into an array in Kylin? In PostgresSQL, I can do it like the query below, but in Kylin it is an error. SELECT ARRAY( SELECT A.ID FROM A WHERE A.num = 123 )
0
votes
1 answer

Kylin Additional Data Sources like SQL Server

I have a Kubernetes cluster with Kylin for Back-End and Superset as Front-End. Everything works great for the example "Default" database within the Kylin application. Now I am trying to add SQL Server database where I have added the following code…
Stavros Koureas
  • 1,126
  • 12
  • 34
0
votes
1 answer

Could not load database driver: KylinEngineSpec

Just install Apache Superset within Kubernetes. Already have a working Apache Kylin Cluster in the same Kubernetes Cluster. While trying to connect Kylin within Superset i get the following error message: ERROR: Could not load database driver:…
Stavros Koureas
  • 1,126
  • 12
  • 34
0
votes
1 answer

Apache Kylin stuck on 'Convert Cuboid Data to HFile'

I installed the following stack on my lab setup: Hadoop 2.7.1 Hive 1.2.2 HBase 1.7.1 Kylin 3.1.2 I now try to build a cube from the sample dataset provided by Kylin itself, and the process gets stuck at 78.26% "Convert Cuboid Data to HFile". The…
Herry
  • 365
  • 1
  • 14
0
votes
2 answers

problemin connecting apache superset running inside docker container to Kylin

I have a running apache-superset inside a docker container that i want to connect to a running apache-kylin (Not inside docker ). I am recieving the following error whenever i test connection with this alchemy URI :…
0
votes
1 answer

Apache Kylin and Sqoop - Is there a way to edit the Sqoop generated SQL statement?

I am working with Apache Kylin and using Sqoop to connect to my PostgreSQL database. I have a cube created based on a fact table that references the same dimensional table twice. So the problem arises when I try to build the cube, I get the…
PaulaR13
  • 33
  • 5
0
votes
1 answer

Apache Kylin - Can't select partition date from date dimension

I am doing a project in Apache Kylin and I would like to use a date column from my date dimension as a partition column as I don't have any date columns in my fact table. However, as you can see in the image, it only allows me to select my fact…
PaulaR13
  • 33
  • 5
0
votes
1 answer

Unable to access localhost:7070 due to error in Apache Kylin

Good afternoon, I am having problems when trying to access http://:7070. I installed the following programs: apache-hive-3.1.2-bin , kylin-3.1.1-bin-hadoop3 , kafka_2.12-2.5.0 , hadoop-3.3.0 , and hbase-2.3.4 I tend to think it has to do with some…
0
votes
2 answers

sed command to find and replace string with special characters to a string in command line

I am trying to use sed to find/replace a string with special characters in a .property file. This is my original line in the file: kylin.source.hive.beeline-params=-n root --hiveconf…
Sai
  • 25
  • 4
0
votes
1 answer

Kylin Cardinality Calculation

I have a Kylin Cube built on some data that is partitioned on date. Whenever a new date's data is added into hive, Kylin is not able to detect it. Is this normal behaviour? Currently I am manually reloading the table in data-sources tab. This calls…
Mr. Butter
  • 13
  • 3
0
votes
1 answer

Kylin installation on CentOS Error /var/lib/docker/overlay2/

I am having some trouble installing Apache Kylin on centOS server. I already had install Kylin on this server. But I had to erase all the images from docker with sudo docker system prune -a, and then when I run the command below to pull the Kylin…
0
votes
1 answer

Unable to run Apache Kylin inside Docker on Centos 7

I'm using the official repository of Kylin. And run it, as all tutorials suggest doing: docker run -d \ -m 8G \ -p 7070:7070 \ -p 8088:8088 \ -p 50070:50070 \ -p 8032:8032 \ -p 8042:8042 \ -p 60010:60010 \ apache-kylin-standalone All ports, listed…
Jacobian
  • 10,122
  • 29
  • 128
  • 221
0
votes
1 answer

IBM Cloud: How to open Analytics Engine port 7070?

I want to use big data services on the IBM Cloud, so I found Analytics Engine(AE) and BigInsight, but unfortunately, BigInsight is going to stop, so I can only choose AE. However, IBM AE is different AWS and GCP big data services, AE prohibits users…
Hades Su
  • 25
  • 4
0
votes
0 answers

java.lang.IllegalArgumentException: Wrong FS: hdfs://nameservice1/kylin_metadata/kylin-..., excepted: hdfs://node111a11:8020

when I start use kylin to Scheduling cube,I meet the following error: The job log of Cube as follows: java.lang.IllegalArgumentException: Wrong FS: hdfs://nameservice1/kylin_metadata/kylin-..., excepted: hdfs://node111a11:8020 at org. apache…