Re: count_distinct_if, count_if and sum_if

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. FILTER has been in Calcite for a while; I don't know whether it has made it into Kylin yet. Julian > On Aug 28, 2017, at 8:26 AM,

[jira] [Created] (KYLIN-2823) Trim TupleFilter after dictionary-based filter optimization

hongbin ma created KYLIN-2823: - Summary: Trim TupleFilter after dictionary-based filter optimization Key: KYLIN-2823 URL: https://issues.apache.org/jira/browse/KYLIN-2823 Project: Kylin Issue Ty

Re: Failed to find metadata store by url: kylin_metadata@hbase

Please check if your current account has privilege to create HTable on HBase, or if the RegionServer is on. 2017-08-28 15:45 GMT+08:00 1057718341 <1057718...@qq.com>: > 2017-08-28 15:37:33,799 INFO [localhost-startStop-1] > core.SpringSecurityCoreVersion:33 > : You are running with Spring Secur

when status of segment is 'NEW',the last_build_job_id is null

Hi,all ​When the job execution failed,or pending,then i get cube information: ​... {"uuid":"523623e7-6233-4a91-af15-b8f846ae6063","name":"2017061000_2017061100","storage_location_identifier":"KYLIN_P1MD9NPHP3","date_range_start":149705280,"date_range_end":149713920,"source_offset_s

Re: OutOfMemoryError happened when build cube

1. you can customize those mr parameters for hive running, like " mapreduce.map.memory.mb", "mapreduce.map.java.opts". For more tunning, you can check Hive's wiki. 2. Yes, check and update yarn configurations according to your cluster profile 3. Yes that will help the step 4. If it didn't change t

Re: when status of segment is 'NEW',the last_build_job_id is null

Hi, If resume a job, you need get the job uuid; The uuid was returned when you submit the job request. Another way is to do a search for the failed job list, and get the job uuid from the result. The segment's "last_build_job_id" will be updated when there is a successful build. In your case as

Re: Re: Subquery cann't work

Thanks for confirming kylin 2.1 does not have this problem. On Sun, Aug 20, 2017 at 9:12 PM, apache_...@163.com wrote: > Thinks . > > This issue not found in kylin v2.1. > > > > apache_...@163.com > > From: Li Yang > Date: 2017-08-20 14:31 > To: dev > Subject: Re: Subquery cann't work > Seems a

Re: Project Level ACL

I'm copying the suggestions to KYLIN-2760. Discussion can go on there. On Tue, Aug 22, 2017 at 4:04 AM, Alberto Ramón wrote: > About Kylin 2760 (https://issues.apache.org/jira/browse/KYLIN-2760) > > I propose small change: > >- Only system admin can create and see connection strings >- T

Re: how to get jobid

There is JIRA KYLIN-2795 on this. I'm seeing if any one can help. On Fri, Aug 18, 2017 at 5:50 PM, jandi...@aliyun.com wrote: > Hi, >i got a problem, when i programming to monitor the status of a cube > during the period of building, i don't know how to get the jobid? I have > checked the

Re: About kylin ACL

The ADMIN can grant permission to the MODELER at project level. After creating the new project. On Tue, Aug 22, 2017 at 4:26 PM, yu feng wrote: > In kylin, we have three role: ADMIN/ MODELER and ANALYST > > I find only ADMIN have Permission to create new project, But as a new > normal MODELER u

[jira] [Created] (KYLIN-2824) Parse Boolean type in JDBC driver

Tianhao Zhao created KYLIN-2824: --- Summary: Parse Boolean type in JDBC driver Key: KYLIN-2824 URL: https://issues.apache.org/jira/browse/KYLIN-2824 Project: Kylin Issue Type: Bug Compo

[jira] [Created] (KYLIN-2825) Make "ModelDataGenerator.java" serilizable

Shaofeng SHI created KYLIN-2825: --- Summary: Make "ModelDataGenerator.java" serilizable Key: KYLIN-2825 URL: https://issues.apache.org/jira/browse/KYLIN-2825 Project: Kylin Issue Type: Improvemen