RANK/DENSE_RANK on KYLIN

Does Kylin support these analytic functions? I'm hitting into an issue while running this. Works ok on hive. SELECT CST_KEY, AMT, RANK() OVER( ORDER BY AMT DESC) FROM FCT Message: Error while executing SQL "SELECT CST_KEY, AMT, RANK() OVER( ORDER BY AMT DESC) FROM TXN_FCT_ORC LIMIT 5":

VER1.5 -- Cannot find rowkey column DT_KEY in cube CubeDesc [name=TEST_CUBE]

I have designed model/cubes in the past on version 1.2 and 1.3 no issue. I'm hitting this issue with 1.5. Please check the model and cube JSON and let me know if there is anything that stands out to cause this. *Error Message Cannot find rowkey column DT_KEY in cube CubeDesc [name=TEST_CUBE]*

java.lang.IllegalStateException: No resource found at

Hi, I have run too many jobs successfully but never hit any issues before on the 2nd step. Not sure how this came exception about. Any idea? [pool-7-thread-10]:[2016-03-05 21:57:08,353][ERROR][org.apache.kylin.job.hadoop.cube.FactDistinctColumnsJob.run(FactDistinctColumnsJob.java:86)] - error

Re: [jira] [Created] (KYLIN-1089) Kylin failed to run on CDH with HBase 1.0

Team -- More than happy to. Can some one guide me on how to get the patch out? Thanks, Regards, -- View this message in context: http://apache-kylin.74782.x6.nabble.com/jira-Created-KYLIN-1089-Kylin-failed-to-run-on-CDH-with-HBase-1-0-tp2027p3784.html Sent from the Apache Kylin mailing list

Re: [jira] [Created] (KYLIN-1089) Kylin failed to run on CDH with HBase 1.0

I have some good news. I have rebuilt the current Kylin Master1.2 against CDH5.5.3. I had to bring some of 1.1.3 branch changes dealing with Cloudera API around additional methods for RegionScanner interface. Also, I had exclude some HBase (server) dependencies in the pom and upgrade curator

Re: [jira] [Created] (KYLIN-1089) Kylin failed to run on CDH with HBase 1.0

Team -- Any successful builds against CDH5.5.x? I have just attempted it with changes in job/storage package to fix the HBase interface changes borrowed from 1.1.4 branch. 1.0.0-cdh5.5.x version of HBase from Cloudera is not aligning with 1.0.0 from Apache. However, I have got a clean build and

Re: TopN Results Differ in Hive and Kylin

I was looking at the commits. 10 days back, 2 files (QueryReqeust and SQLRequest.java) were touched that have fixed the issue for clients using REST API, changing the default acceptPartial to false. I tried with Zeppelin and it works and results from Hive and Zeppelin (via REST API) work.

Re: TopN Results Differ in Hive and Kylin

>From FAQs Getting wrong result for the query with order by By default if you're making queries on the web client, a mode called "AcceptPartialResults" is enabled​, this is a protection mechanism that will only return part of the results to reduce server overhead. Honestly it might hurt the

TopN Results Differ in Hive and Kylin

I'm hitting an issue and am not able to understand clearly what the root cause is. I have customer,time dimension and a transaction fact table. Customer table has 1MM rows and transaction fact 154MM. I have to find topN customers by transaction volume for a year. I ran the following query in

Kylin and Tableau -- Top N query

Results from Kylin and Tableau on a live connection don't match. Any reason? I'm creating a custom data source (Custom SQL Query) in Tableau and adding a parameter control using a query similar to below: SELECT t2.c1 ,sum(t1.c2) AS c3 FROM t1 Inner join t2 on t1.k1 = t2.k1 group by t2.c1 order

Error when scan from lower key

Hi Kylin Team -- I'm hitting the below error when executing query with the time dimension in the where clause against a 35GB cube (No issues running otherwise). Same exact query works fine against Hive with the WHERE clause. Any ideas? Thanks, Regards, Error when scan from lower key � ;8