Re: Re: query Sql run Error

Is it a bug to be sure?Is there any way around this issue? this sql cann't work select F16,sum(F0) from ( select T8.PART_DT as F16,T8.I_eceb82a4498247aeb911ba59f82148f0 as F0 from ( select KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID, sum(KYLIN_SALES.PRICE)

Re: Multiple keys.

Hi! Thanks for the answer. The "AUTOR" is unique. I think so... I have the "AUTHOR" looking like that: "ID_Autor Name 1001Shery Denita Dietrich 1002Cruz Luettgen 1003Tonita Robertson 1004Donya Apryl Ryan 1005Wilhemina Kirstie Phillips 1006Elisa Lind 1007

Re: How to migrate cube from one Kylin to another (for example, Kylin QA to Kylin Production) within the different Hadoop Cluster

Kylin metadata migration is very simple, just follow the "backup/restore metadata" guide. But if you want to have the Cube data also be moved to new cluster, you need migrate: 1) Hive tables (metadata and files); 2) Files in Kylin HDFS working dir; 3) HBase tables (KYLIN_.*) There is no a tool

Re: sql语句中当in的列表超过一定数据量的时候性能突然变差，如何解决？

It might be related with storage layer cache. You can make more tests to see the differences. Besides, if you can provide more logs when executing these two queries, that would be good for analysis. 在 2017年8月3日 下午4:26，wangzy24 写道： > 如下两个sql，差别是第二个hotel_code

Re: Multiple keys.

Hi Bart, Kylin assumes the join columns are PK; Then it will take Hashmap snapshot with the PK as the Key. If the join column isn't unique, it will report such error. In your case, I think you're join the AUTHORSHIP table with "AUTHOR" as the condition. While "AUTHOR" isn't unique. Furthermore,

sql often running error

Maybe the picture cannot be displayed log : 2017-08-03 17:57:00,875 INFO [Query 440deaab-b8ee-4c0c-887e-2dd5982fcf8f-176] service.QueryService:286 : ==[QUERY]=== Query Id: 440deaab-b8ee-4c0c-887e-2dd5982fcf8f SQL: select count(1) from

sql often running error

Hi, Kylin2.0 on HDP2.5.3. sql does often running error,but after restart kylin server,SQL can execute properly How do I find out the reason? apache_...@163.com

ql often running error

Hi, sql does often running error,but after restart kylin server,SQL can execute properly How do I find out the reason? apache_...@163.com

sql语句中当in的列表超过一定数据量的时候性能突然变差，如何解决？

如下两个sql，差别是第二个hotel_code in的列表少一个元素（如红框标注），但性能差别很大:

[jira] [Created] (KYLIN-2777) Should throw error when sql contains non-equi left join

Roger Shi created KYLIN-2777: Summary: Should throw error when sql contains non-equi left join Key: KYLIN-2777 URL: https://issues.apache.org/jira/browse/KYLIN-2777 Project: Kylin Issue Type:

How to migrate cube from one Kylin to another (for example, Kylin QA to Kylin Production) within the different Hadoop Cluster

What would you do if you wanted to do metadata migration between completely independent environments within the different Hadoop Cluster? -- View this message in context:

[jira] [Created] (KYLIN-2776) new metric framework with kylin

yiming.xu created KYLIN-2776: Summary: new metric framework with kylin Key: KYLIN-2776 URL: https://issues.apache.org/jira/browse/KYLIN-2776 Project: Kylin Issue Type: New Feature Affects