TblColRef redesign and snowflake schema support

Hi Kylin developers Want to get your attention of the recent redesign of TblColRef on master branch. As a prerequisite of snowflake support, I'm working on KYLIN-1971 recently. The goal is to support a table appearing more than once in a model, e.g. the COUNTRY lookup table may join the SALES fac

[jira] [Created] (KYLIN-2136) Enhance cubing algorithm selection

liyang created KYLIN-2136: - Summary: Enhance cubing algorithm selection Key: KYLIN-2136 URL: https://issues.apache.org/jira/browse/KYLIN-2136 Project: Kylin Issue Type: Improvement Report

回复： Exceed scan threshold at 10000001

Query1:select count(1),sum(LO_REVENUE) from lineorder group by LO_CUSTKEY,LO_PARTKEY LIMIT 1 I find it scan 1 rows from HBase Query2: select count(1),sum(LO_REVENUE) from lineorder group by LO_CUSTKEY,LO_PARTKEY LIMIT 10001 I find it scan 1001 rows from Hbase I do not know why

Re: failed to take action

it is a bug, next release will include the fix. 2016-10-28 11:29 GMT+08:00 胡志华(万里通科技及数据中心商务智能团队数据分析组) < huzhihua...@pingan.com.cn>: > Hi all, >After updating kylin1.5.4.1, when I click the detail of cube, press > “SQL” button, it return “Failed to take action”, the situation will never >

failed to take action

Hi all, After updating kylin1.5.4.1, when I click the detail of cube, press “SQL” button, it return “Failed to take action”, the situation will never happen in kylin 1.5.3 So ,may be this a bug. **

Re: Exceed scan threshold at 10000001

Alberto, thanks for your explaination, you got the points and is already an Kylin expert I believe. In order to protect HBase and Kylin from crashing by bad queries (which scan too many rows), Kylin add this mechnisam to interrupt when reach some threshold. Usually in an OLAP scenario, the result

Re: version compability

Thanks for the feedback. 2016-10-28 8:50 GMT+08:00 Billy(Yiming) Liu : > Glad to hear that. > > 2016-10-28 6:43 GMT+08:00 mnagy : > > > Problem fixed at version 1.6. > > I have just checked it ;) > > > > -- > > View this message in context: http://apache-kylin.74782.x6. > > nabble.com/version-com

Re: java.lang.NoClassDefFoundError: org/apache/hive/hcatalog/mapreduce/HCatInputFormat

Today I start a Kylin 1.5.4.1-hbase1.x package on a EMR cluster (separately request a client node), got this NoClassDefFoundError, finally solved by changing the /usr/lib/hbase/conf/hbase-env.sh; I recorded it in the FAQ page, just for your reference: https://kylin.apache.org/docs15/gettingstarted

Re: version compability

Glad to hear that. 2016-10-28 6:43 GMT+08:00 mnagy : > Problem fixed at version 1.6. > I have just checked it ;) > > -- > View this message in context: http://apache-kylin.74782.x6. > nabble.com/version-compability-tp5636p6106.html > Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: version compability

Problem fixed at version 1.6. I have just checked it ;) -- View this message in context: http://apache-kylin.74782.x6.nabble.com/version-compability-tp5636p6106.html Sent from the Apache Kylin mailing list archive at Nabble.com.

[jira] [Created] (KYLIN-2135) Enlarge FactDistinctColumns reducer number

kangkaisen created KYLIN-2135: - Summary: Enlarge FactDistinctColumns reducer number Key: KYLIN-2135 URL: https://issues.apache.org/jira/browse/KYLIN-2135 Project: Kylin Issue Type: Improvement

Re: Exceed scan threshold at 10000001

NOTE: I'm not a expert on Kylin ;) Where is mandatory? No Where is recommended? yes Where bypass the threshold? No, I think this limit is hardcoded ¿? The real question must be: why this limit exists ?: (opinion) - The target of Kylin is Real / Near RT, limit rows --> limit response time - If Yo

?????? Exceed scan threshold at 10000001

Do you mean when i query, i should add where clause, but in some case, the number of records > threshold, how can i do? For example, order by all groups, the number of the all groups > threshold -- -- ??: "Alberto Ram??n";; : 2016??10??27?

Re: Exceed scan threshold at 10000001

ERROR: Scan row count exceeded threshold MailList Kilin 1787 v1.5.3 *Scan row count exceeded threshol

Exceed scan threshold at 10000001

Hi When i query a sql, I do not know why should scan hbase? How can i do? Thanks! Table: lineorder 12,000,000 row records Dimensions: LO_CUSTKEY,LO_PARTKEY Measures: count(1), sum(LO_REVENUE) Query SQL: select count(1),sum(LO_REVENUE) from lineorder group by LO_CUSTKEY,LO_PARTKEY order by

[jira] [Created] (KYLIN-2134) Kylin will treat empty string as NULL by mistake

hongbin ma created KYLIN-2134: - Summary: Kylin will treat empty string as NULL by mistake Key: KYLIN-2134 URL: https://issues.apache.org/jira/browse/KYLIN-2134 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-2133) Check web server port availability when startup

Billy(Yiming) Liu created KYLIN-2133: Summary: Check web server port availability when startup Key: KYLIN-2133 URL: https://issues.apache.org/jira/browse/KYLIN-2133 Project: Kylin Issue