Question: The limit on the kylin web UI, what does it limit?

Hi all, I was running a group by query with subquery. Something like the follows: SELECT SUM(col3) AS col4, SUM(col5) AS total_col5, col1 FROM ( SELECT col1, col2, MAX(col3) AS col3, COUNT(*) AS col5 FROM db.table WHERE col6 = 'somestring' GROUP BY col1, col2 )

Question: The limit on the kylin web UI, what does it limit?

Hi all, The previous email seems to be blocked. So I'm re-send this email. I was running a group by query with subquery. Something like the follows: SELECT SUM(col3) AS col4, SUM(col5) AS total_col5, col1 FROM ( SELECT col1, col2, MAX(col3) AS col3, COUNT(*) AS col5

Re: Can't edit cube

You'd better provide Kylin version, and how it be deployed (single or clustered). 2017-09-03 19:26 GMT+08:00 Li Yang : > As a workaround, you can reload metadata (under System tab) and edit again. > > On Thu, Aug 31, 2017 at 3:22 PM, Cheng Wang >

Re: Unknown exception. Jdbc operation attempted: MIX_JdbcCatalog_execTables

The direct cause is Kylin JDBC ResultSet does not support the previous() operation. Is there any way to workaround in MSTR avoiding calling previous()? Or maybe try connect via ODBC. On Tue, Aug 22, 2017 at 5:53 PM, alantt wrote: > Hello! > > Kylin 2.0 > JDBC 2.0 >

Re: HDP-2.6.1 virtualbox sandbox DebugTomcat error

Haven't tried hdp-2.6. Most Kylin developers are on hdp-2.4 as far as I know. On Thu, Aug 24, 2017 at 9:56 AM, jun <1063489...@qq.com> wrote: > hi, all > I use hdp-2.6.1 sandbox to run IDEA DebugTomcat.java, and when I build > cube, it get errors: > > 2017-08-23 08:50:01,016 WARN

Re: How to get a job status?

Guosheng is working on https://issues.apache.org/jira/browse/KYLIN-2795 The document will be updated soon. On Mon, Aug 28, 2017 at 12:02 PM, apache_...@163.com wrote: > Hi, > >I run a cube by api(/kylin/api/cubes/{cubeName}/build), It's daily > task。 > >How do I

Re: Document for Kylin with MicroStrategy

Cool~~~ On Fri, Sep 1, 2017 at 1:27 PM, ShaoFeng Shi wrote: > Hi, > > Joanna He (jingke...@kyligence.io) contributed a doc on how to integrate > Kylin with MicroStrategy. The doc has been published on Kylin website[1] > today. Thanks Joanna's contribution. > >

Re: SQL execute failed when use CASE in where clause

This looks like a bug. Please log a JIRA. Thanks for reporting! On Thu, Aug 24, 2017 at 8:44 PM, skyyws wrote: > Sorry for my mistake. It should be "use CAST in where clause" not "CASE" > > 2017-08-24 > > skyyws > > > > 发件人："skyyws" > 发送时间：2017-08-24 20:41 >

Re: perdue cube

We do not recommend creating mode/cube using API as they are not public according to Kylin document. To fix your inconsistent metadata, try export all, manual edit the JSON files, and import back. http://kylin.apache.org/docs21/howto/howto_backup_metadata.html On Tue, Aug 29, 2017 at 8:38 PM,

Re: count_distinct_if, count_if and sum_if

@Alex, support of the FILTER clause or the count_distinct_if() will be more complicated than you think. It is not just about measure type. You can open a JIRA and collaborate there. On Sun, Sep 3, 2017 at 7:12 PM, Li Yang wrote: > Kylin does not support FILTER clause as of

Re: Can't edit cube

As a workaround, you can reload metadata (under System tab) and edit again. On Thu, Aug 31, 2017 at 3:22 PM, Cheng Wang wrote: > Sometimes it happens because one Kylin instance is used by multi-users. > Please make sure there are no others using the Kylin at the same

Re: how to filter long tail data

Please ask Kylin related question here. On Fri, Sep 1, 2017 at 2:47 PM, 杨浩 wrote: > If a index is less than 2, we don't want to store it in hbase . How to > filter the long tail data ? >

[jira] [Created] (KYLIN-2839) UI Bug: Rowkey setting is inconsistent with dimensions

Mu Kong created KYLIN-2839: -- Summary: UI Bug: Rowkey setting is inconsistent with dimensions Key: KYLIN-2839 URL: https://issues.apache.org/jira/browse/KYLIN-2839 Project: Kylin Issue Type: Bug

Re: How to set timezone in JDBC parameter?

This is a common problem when converting Java dates to/from SQL dates. It can be resolved by correctly setting the time zone at JDBC API calls. Following is the answer from Julian from the Apache Calcite community: "Calcite is implementing the SQL standard, which says that date-time values have

[jira] [Created] (KYLIN-2838) Should get storageType in changeHtableHost of CubeMigrationCLI

kangkaisen created KYLIN-2838: - Summary: Should get storageType in changeHtableHost of CubeMigrationCLI Key: KYLIN-2838 URL: https://issues.apache.org/jira/browse/KYLIN-2838 Project: Kylin

Re: count_distinct_if, count_if and sum_if

Kylin does not support FILTER clause as of 2.1 On Wed, Aug 30, 2017 at 3:06 PM, Julian Hyde wrote: > Are you aware of the FILTER clause? I believe that COUNT_DISTINCT_IF(x, b) > is equivalent to COUNT(DISTINCT x) FILTER(WHERE b). And similarly COUNT_IF > and SUM_IF. > >

Re: how to filter long tail data

Okay, our team want to use Kylin as an ETL tool， but there are many long tail data after building. Can these data be filtered directly by kylin, or do we have to make some change to the code ? 2017-09-03 19:42 GMT+08:00 Li Yang : > Please ask Kylin related question here. > >

Re: how to filter long tail data

Top-N measure is amied to filter the long tail data. Besides, in Data model, there is a "filter condition", where you can add a filtering condition to exclude those tail data. 2017-09-04 10:54 GMT+08:00 杨浩 : > Okay, our team want to use Kylin as an ETL tool， but there are

[jira] [Created] (KYLIN-2840) unseen cube

cnwangdp created KYLIN-2840: --- Summary: unseen cube Key: KYLIN-2840 URL: https://issues.apache.org/jira/browse/KYLIN-2840 Project: Kylin Issue Type: Bug Components: Environment