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
0 answers

Does kylin update aggregates on joined tables

We have 3 tables which are updated daily. In one of the query these 3 tables are joined and the final joined table has timestamp column. Final joined table is used to compute various aggregates. This query runs everyday and hence everyday join is…
sunillp
  • 983
  • 3
  • 13
  • 31
0
votes
2 answers

Install Apache Kylin in custom environment

I'm trying to install Apache Kylin in Ubuntu 16.04. I installed: hadoop 3.1.2 in pseudo distributed mode (fs.default.name: hdfs://localhost:9000) apache hive 3.1.2 and db derby 10.14.2.0 (config hive use db derby) hbase 1.4.10 in pseudo distributed…
n2tisme
  • 3
  • 3
0
votes
1 answer

Kylin Build Cube failed somtimes at" #19 Step Name: Hive Cleanup" java.lang.RuntimeException: Failed to read kylin_hive_conf.xml

The error occurs sometimes ,and after reboot kylin(kylin.sh stop and then kylin.sh start), it will find the conf dir location and pass this step. I am using Kylin version "2.6.2", and KYLIN_CONF="/opt/kylin/conf" is already set correctly. The errors…
0
votes
0 answers

connect to kylin from R

I´m trying to access to Kylin cubes from my R code. My machine is Ubuntu server. But I've been searching for packages or code to try it for long time to no avail. What i've done so far after copied jar files to /usr/lib: > drv <-…
Forge
  • 1,587
  • 1
  • 15
  • 36
0
votes
1 answer

Cannot build cube with apache kylin

I have installed Apache Kylin in Hortonworks's HDP Sandbox image. Following this I have connected Apache Kylin to our Microsoft SQL Data Warehouse and when I try to build a cube the process is failing. 19/06/25 15:35:54 INFO sqoop.Sqoop: Running…
0
votes
1 answer

How does hierarchy dimension reduction work in Kylin

Following picture is illustrating the effect of hierarchy dimension reduction. It reduces the number of cuboid from 2^N to N+1 With this dimension reduction, I wonder how following queries could give correct answer? select B, count(1) from X…
Tom
  • 5,848
  • 12
  • 44
  • 104
0
votes
1 answer

Does Apache Kylin support querying struct type?

I finished the sample cube http://kylin.apache.org/docs/tutorial/kylin_sample.html. But this data structure is very basic. I'm wondering can query work for a struct type field by using .? for example, car (struct) has name, so can I run the…
Holm
  • 2,987
  • 3
  • 27
  • 48
0
votes
2 answers

Unable to start Apache Kylin in HDP 3.0.1

I'm trying to run Apache Kylin on a cluster with HDP 3.0.1. When I run ./kylin.sh start I get the following output: (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it…
Shadowtrooper
  • 1,372
  • 15
  • 28
0
votes
1 answer

Kylin odbc driver C++ solution fails to build

I am unable to build Kylin ODBC C++ solution. I followed the instructions found here, unfortunately, I get an error when I try to build the solution. I am getting the below error message: Error LNK1181 cannot open input file 'zlibstat.lib' …
0
votes
0 answers

Mondrian Kylin Connection

does somebody has a valid and working example of a Mondrian to Kylin connection? I found that the unique version on Mondrian made to run standalone far away from other things from Pentaho / Saiku is available from this report on github. So I…
ozw1z5rd
  • 3,034
  • 3
  • 32
  • 49
0
votes
1 answer

Saiku/Hitachi-Pentaho Schema Workbench

I'm using the Schema Workbench that I compiled from the source available on github using: mvn -Pworkbench package It starts with no problem and there is a folder called drivers which suggests to copy there all the additional JDBC drivers. I did…
ozw1z5rd
  • 3,034
  • 3
  • 32
  • 49
0
votes
1 answer

Why does the log always say "No Data Available" when the cube is built?

In the sample case on the Kylin official website, when I was building cube, in the first step of the Create Intermediate Flat Hive Table, the log is always No Data Available, the status is always running. The cube build has been executed for more…
sharon
  • 1
  • 1
0
votes
1 answer

Does Apache Kylin can still work with Mondrian 4.4 and Saiku CE?

I am using : Apache Hadoop 2.7.3 Apache HBase 1.2.4 Apache Hive 2.1.1 Apache Kylin 2.6.1 Saiku Mondrian 4.4 Dialect Kylin I've managed to create a schema and i saw it on my cube list from saiku but i couldnt get any data from it! checked my saiku…
Khalil Mejdi
  • 132
  • 1
  • 8
0
votes
1 answer

When superset connect to kylin,table not found error occured

I followed the steps from the http://kylin.apache.org/blog/2018/01/01/kylin-and-superset/ to connect Apache Superset with Kylin. When I click the "Test Connection" button, I get the popup that says: "Seems OK!" But when I am trying to add a table…
hzl
  • 1
0
votes
1 answer

Where can download apache kylin odbc driver?

I tried to integrate Tableau BI with Apache Kylin through ODBC way. Then visited the official website to get the ODBC driver, but found that it was doesn't provide installation file download. Only tell us to compile it from the source code by…
elkan1788
  • 97
  • 1
  • 2
  • 11