Stack Overflow
Stack Overflow

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

Kylin - Group by Rollup and Cube

I am trying to use the ROLLUP and CUBE operators to summarise data using the sample cube. If I execute the query the following error message is returned: Internal error: Error while applying rule OLAPAggregateRule, args…
rivethead_
  • 131
  • 1
  • 6
0
votes
3 answers

SQL query for ids, who never show a special combination

I have 2 tables like id_a | id_b ----------- 01 | 011 01 | 012 02 | 021 02 | 022 and id_b | cl | ds ------------------ 011 | F9.00 | G 012 | F3.00 | G 021 | F9.00 | P 022 | G7.50 | G the tables are joined on id_b. Now I want to know…
Søren
  • 31
  • 3
0
votes
1 answer

Apache Kylin: cube settings

I created a cube in Apache Kylin (1.5.3) with 2 tables who look like this: Facttable || Dimensiontable id_a | id_b || id | pos ------------------------------ 01 | 011 || 011 | 1 01 | 011 || 012 | 1 01 | 011 || 013 | 0 01 | 012 ||…
Søren
  • 31
  • 3
0
votes
1 answer

Apache Kylin: query does not return full result

I created an cube in Apache kylin where 'ft' is my facttable and 'ls' is one of the dimensiontables. Both are joint on the column 'lid'. My query select ft.sid, ls.lid, ls.pos from( select sid, lid from ft where lid = '1500221' group…
Søren
  • 31
  • 3
0
votes
0 answers

Apache Kylin: How to use '!=' in queries?

I got a short question on Apache kylin (version 1.5.3). I have built a cube successfully. Now I want to use the 'insight' tab of kylin to submit some queries. I have a table with two columns (id[varchar], abc[int]). Queries like select id, abc from…
Søren
  • 31
  • 3
0
votes
0 answers

Kylin: Datasource tab is disabled

Going thru this tutorial: http://kylin.apache.org/docs15/tutorial/create_cube.html But the 'Data Source' tab under 'Model' is disabled. I am logged in as ADMIN. What am I doing wrong? Did I miss a step? I do have the following tables in Hive: hive>…
DilTeam
  • 2,551
  • 9
  • 42
  • 69
0
votes
1 answer

Unable to start Kylin in HDP 2.4

Tried to install Kylin using the documentation . I was able to start kylin and execute sample.sh. But I was not able to use web UI. Please find below the error message. I am using Kylin apache-kylin-1.5.2.1-HBase1.x-bin.tar.gz and hbase…
Nithin
  • 9,661
  • 14
  • 44
  • 67
0
votes
1 answer

No seller_id in dimensions but can create a count distinct measure on it in kylin sample cube

CDH: 5.7 Kylin: 1.5.2_CDH_5.7 In kylin sample cube kylin_sales_cube, there is a measure named SELLER_CNT_HLL which is COUNT_DISTINCT and uses the column seller_ID but when I edit it I can't select the seller_id because there is no column named…
conia
  • 13
  • 3
0
votes
1 answer

How to filter by price range in sample cube of kylin

Sorry, I just start to lean kylin When I execute the sql select * from kylin_sales where price > 2 in default sample cube of kylin, it failed with the message ERROR while executing SQL "select * from kylin_sales where price > 2 LIMIT 50000": Can't…
conia
  • 13
  • 3
0
votes
1 answer

Apache Kylin - "Timeout visiting cube" and other weirdness

I've installed Kylin with MapR distribution, and things seem to work fine up to a point. I ran the sample.sh script and I now have the "learning_kylin" project, and I can run "build" on the cube and the job reports success at 100% complete. But..…
mindcrime
  • 657
  • 8
  • 23
0
votes
1 answer

What version of Kylin should I use with HDP 2.4?

So I have installed HDP 2.4 and I know want to install Kylin. On the website there are binaries for hbase 1.1.3+ or 0.99 but I have hbase 1.1.2 (installed by Ambari 2.2.1). I have tried several ones and the best case I have is no errors when…
Bob Dudan
  • 97
  • 3
  • 9
0
votes
1 answer

Kylin - Query OLAP cube which is on Hbase?

I have installed apache kylin on virtual machine and created a cube with sample data. Kylin stores the created cube on Hbase. Now I want to query the created olap cube(Perform: drill down, roll up, slice and dice) which is present on Hbase. Is…
adp
  • 1
  • 1
0
votes
1 answer

hive hadoop permissions not correct

I installed apache kylin which requires Hadoop, hove, hbase and java to work. All things are installed correctly. Now when I try to run this example. I get error after the first command ie ${KYLIN_HOME}/bin/sample.sh and below is the error I am…
Legendary_Hunter
  • 1,040
  • 2
  • 10
  • 29
0
votes
1 answer

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:…
jyzheng
  • 13
  • 5
0
votes
2 answers

Hadoop Map Reduce job: Class org.apache.hive.hcatalog.mapreduce.HCatInputFormat not found

I'm using kylin. It is a data warehouse tool and it uses hadoop, hive and hbase. It is shipped with sample data so that we can test the system. I was building this sample. It is a multi-step process many of the steps are map-reduce jobs. Second step…
Aryaveer
  • 943
  • 1
  • 12
  • 27
1 2 3
…
10
11