A problem when I build a cube

2017-11-14 Thread 李巍
Hi all. Sometimes, I met a problem when I build a cube in both step 3 and step 7, the logs were same 'no counters for job'. I found that both these cubes had nearly 20 mersures(dimensions were only 2 or 3). So, kylin doesn't support too many columns either in dimensions or measures, right?

Question about using dedicated EC2 server with EMR cluster

2017-11-14 Thread jxs
When using dedicated client node on EC2, should I configure kylin with the same: kylin.env.hdfs-working-dir = s3://our-emr/kylin/ kylin.storage.hbase.cluster-fs = s3://our-emr Should the kylin.server.mode be "query" ? Thanks.

Re: how to change the order of rowkey_columns

2017-11-14 Thread ShaoFeng Shi
I had thought everyone knows that; If not, that means the GUI there is not enough clear. 2017-11-15 9:40 GMT+08:00 杨浩 : > Thanks for that > > 2017-11-14 22:50 GMT+08:00 Billy Liu : > >> You could change the rowkey order by drag-and-drop from GUI

Re: how to change the order of rowkey_columns

2017-11-14 Thread 杨浩
Thanks for that 2017-11-14 22:50 GMT+08:00 Billy Liu : > You could change the rowkey order by drag-and-drop from GUI directly. > > 2017-11-14 10:52 GMT+08:00 杨浩 : > >>To speed up the query, we should position the frequent column before >> others,

Re: Apache Kylin - Driver/Connector for Cognos BI Tool

2017-11-14 Thread ShaoFeng Shi
Hi Manoj, The open source Kylin ODBC driver is built on MS .NET framework, so it only supports Windows. The commercial ODBC driver for Kylin is another story. Let's talk offline. 2017-11-14 21:56 GMT+08:00 Kumar, Manoj H : > Thanks for this.. Can you pls. tell how

Re: how to change the order of rowkey_columns

2017-11-14 Thread Billy Liu
You could change the rowkey order by drag-and-drop from GUI directly. 2017-11-14 10:52 GMT+08:00 杨浩 : >To speed up the query, we should position the frequent column before > others, such as partition column date should be at the first for every > query would contain it.

RE: Apache Kylin - Driver/Connector for Cognos BI Tool

2017-11-14 Thread Kumar, Manoj H
Thanks for this.. Can you pls. tell how to installed Kylin ODBC driver on Cognos Server as it would be Linux machine? Regards, Manoj From: ShaoFeng Shi [mailto:shaofeng...@apache.org] Sent: Tuesday, November 14, 2017 6:53 PM To: user Subject: Re: Apache Kylin - Driver/Connector for Cognos BI

Re: Apache Kylin - Driver/Connector for Cognos BI Tool

2017-11-14 Thread ShaoFeng Shi
Hi Kumar, What's your Cognos version and platform? Here is a reference on how to connect with Kylin from Cognos: http://docs.kyligence.io/v2.5/en/integration/cognos.en.html 2017-11-14 19:35 GMT+08:00 Kumar, Manoj H : > Can someone share the details for how to get

Apache Kylin - Driver/Connector for Cognos BI Tool

2017-11-14 Thread Kumar, Manoj H
Can someone share the details for how to get connected with Congnos BI tool? I didn’t find any details about this. Thanks. Regards, Manoj This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and

How to estimate resource cost according to data scale?

2017-11-14 Thread Chase Zhang
Hi all, This is Chase from Strikingly. Recently we're confronted with one problem upon the usage of Apache Kylin. Here is the description. Hoping anyone here could give some suggestions :) The problem is about the estimation of resource and time cost for one build of cube in proportion to

Re: Apache Kylin - Does it take input data from Parquet file format

2017-11-14 Thread ShaoFeng Shi
Exactly, using the external table. After creating the table, let your upstreaming app output files to the location. And then you can query the data from Hive; If the table is available in Hive, that means Kylin can fetch the data. 2017-11-14 16:13 GMT+08:00 Kumar, Manoj H

RE: Apache Kylin - Does it take input data from Parquet file format

2017-11-14 Thread Kumar, Manoj H
Do you mean that using external table it can be possible ? Just sample – Table name would be same as File name & upstream will be loading the file in that Directory? create external table parquet_table_name (x INT, y STRING) ROW FORMAT SERDE 'parquet.hive.serde.ParquetHiveSerDe' STORED AS