Apache Kylin: Intermediate table not found

I’m a newbie for kylin. After installing, I run sample.sh, and then build the cube, but get the wrong message: java.io.IOException:...

Apache Kylin Unable to find HBase common lib

I have installed Hadoop version 2.6.0, HBase version 0.99.0 , Hive version 1.2, Kylin version 1.5.0. I have setup all of the above in Standalone mode while in running Kylin it checks in early...

In oozie workflow (HUE), how to pass parameter from shell action to HDFS fs action

In My workflow, I have one shell action and an HDFS fs action Shell action echos date. (date=2016-10-06) I want to set the above date parameter in HDFS fs action mkdir path. Following is the...

is Apache Kylin good alternative for SSRS(SQL Server Reporting Services)?

We have framework for analysis data with the help of cube design for OLAP and warehouse that has ETL connections, all of them are in sqlServer structure and SSRS(SQL Server Reporting...

How to create table in partition data in hive?

drwxr-xr-x - mgupta supergroup 0 2018-03-26 22:16 /kylin/retailer/qi_basket_brand_bucket_fact/_impala_insert_staging drwxr-xr-x - mgupta supergroup 0 2018-03-26 22:18...

Unable to read HiveServer2 configs from ZooKeeper

I use HDP3.1. And I Ambari to deploy hadoop cluster and hive. After deployed, I can run hive in shell successfully. And then I deploy Apache Kylin2.6, it can sync hive table. But when I build the...

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

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

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

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

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

sql order by does not work when spark connect to kylin via jdbc

We use apache spark to query data from apache kylin via jdbc,we write a sql with a order by clause,but sometimes it does not work. Briefly,there is a table called shop_dim in kylin,a field SHOP_ID...

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

How to know Cube build have finished

I am using Kylin REST API to submit Cube build request, Kylin will build the cube asynchronously, I would ask how to know that the Cube build request has been finished?

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

I'm having a error while building a Cube in Apache Kylin

See the Logs in the Step one: java.io.IOException: OS command error exit with return code: 127, error message: Logging initialized using configuration in...

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

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

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

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-...,...

Apache Kylin without Hadoop/Hive

I'm using Snowflake as my DWH and Spark for my ETL and I don't have Hive tables. Is there an option to use Apache Kylin without the Hadoop ecosystem?

java.lang.NoSuchMethodError: org.apache.hive.common.util.ShutdownHookManager.addShutdownHook

I'm trying to build a cube on Kylin with Spark as engine type. The cluster contains the following tools: OS image: 1.0-debian9 Apache Spark 2.4.4 (changed from 1.6.2) Apache Hadoop 2.7.4 Apache...

Kylin start fail java.lang.IllegalArgumentException: Failed to find metadata store by url: [email protected]

I install kylin by https://github.com/cas-packone/ambari-kylin-service/ 2020-01-13 01:52:16,673 INFO [main] utils.Compatibility:41 : Running in ZooKeeper 3.4.x compatibility mode 2020-01-13...

Kylin Web UI and HBase Web UI on Docker does not work properly (Ubuntu 18)

I installed kylin on docker with this command docker pull apachekylin/apache-kylin-standalone:3.0.0-alpha2 and it was fine. And then I ran docker run -d \ -m 8G \ -p 7070:7070 \ -p 8088:8088 \ ...

Filter charts with different datasources in a superset dashboard?

I'm creating a dashboard with different charts that are the result of SQL queries to different tables in kylin. I cant see how to make a filter (of dates for example) that impact in more than one...

Copy particular XML document element to Another XML document using shell commands

I am working on installing Kylin on AWS EMR via shell script . I have an xml file with below content from which I need to copy particular document element to another xml file . This is the manual...

Apache Zeppelin will not start

Newbie here, please be gentle. The computer in question uses Windows 10 and Apache Zeppelin(zeppelin-0.9.0-bin-all.tgz) refuses to start. I've tried removing .template from the config files and...

Apache Kylin docker image fails to start

I have downloaded the Apache Kylin docker image from their site, I use the following command to run the image and it exits with code 139: docker run -d -m 8G -p 7070:7070 -p 8088:8088 -p...

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

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