[jira] [Created] (KYLIN-2257) executed sql query cannot be reproduced

Luyuan Zhai created KYLIN-2257: -- Summary: executed sql query cannot be reproduced Key: KYLIN-2257 URL: https://issues.apache.org/jira/browse/KYLIN-2257 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-2256) No horizontal scroll bar in insight result window

Luyuan Zhai created KYLIN-2256: -- Summary: No horizontal scroll bar in insight result window Key: KYLIN-2256 URL: https://issues.apache.org/jira/browse/KYLIN-2256 Project: Kylin Issue Type:

kylin 1.6.0 cardinality can't greater than 5000000 ?

I improved the version from 1.5.4.1 to 1.6.0 and modified KYLIN_HOME, and modied "kylin.dictionary.max.cardinality=500" to "kylin.dictionary.max.cardinality=3000" in file kylin.properties, then start kylin 1.6-->create model-->create cube-->build cube I got the following error

Re: Issues in building cubes of Apache Kylin

Seems you were not using any Hadoop distribution, such HDP or CDH, but Apache Hadoop, Apache Hive and Apache HBase. Could you try export HIVE_CONF to your hive config path first? 2016-12-08 13:53 GMT+08:00 Samirul Haque : > Hi Billy, > > > > Thanks for your response. > > > >

回复：Re: 答复: 答复: 回复：答复: Kylin1.6.0流式Cube查询时间错误

对于SQL查询记录早了8小时的问题，我使用了JDBC和Kylin WEB两种方式进行测试，结果都是查询记录早了8小时。这说明Kylin服务端从HBase中扫描记录时，读取的记录就已经比实际时间早了8小时。所以，可能是Kylin服务端在处理kafka数据的时候，对于时间的处理有些问题。 在2016年12月8日 12:36， Jian Zhong写道： So, you can get right result you want for non-streaming cube? Did you query on Kylin UI or

回复：Re: 答复: 答复: 回复：答复: Kylin1.6.0流式Cube查询时间错误

我之前使用Kylin的时候从来没有出现过这种问题。在安装Kylin1.6.0之后，才出现这种问题的。 我在HBase里面查看流式cube对应的json数据时，每个segment的start time和end time对应的timestamp都是正确的，但是在Kylin WEB上显示的就早了8小时。用JDBC获取的timestamp肯定也是正确的，所以应该是Kylin WEB转换的问题。 在2016年12月8日 12:36， Jian Zhong写道： So, you can get right result you

Re: 答复: 答复: 回复：答复: Kylin1.6.0流式Cube查询时间错误

So, you can get right result you want for non-streaming cube? Did you query on Kylin UI or use jdbc driver? 2016-12-08 12:32 GMT+08:00 仇同心 : > streaming cube > > -邮件原件- > 发件人: Jian Zhong [mailto:zhongj...@apache.org] > 发送时间: 2016年12月8日 12:32 > 收件人:

答复: 答复: 回复：答复: Kylin1.6.0流式Cube查询时间错误

streaming cube -邮件原件- 发件人: Jian Zhong [mailto:zhongj...@apache.org] 发送时间: 2016年12月8日 12:32 收件人: dev@kylin.apache.org 主题: Re: 答复: 回复：答复: Kylin1.6.0流式Cube查询时间错误 this only happens in streaming cube or all cubes? 2016-12-08 11:28 GMT+08:00 Billy Liu : > here here some

Re: 答复: 回复：答复: Kylin1.6.0流式Cube查询时间错误

this only happens in streaming cube or all cubes? 2016-12-08 11:28 GMT+08:00 Billy Liu : > here here some threads about getting the right Date from Kylin > http://apache-kylin.74782.x6.nabble.com/JDBC-query-result- > Date-column-get-wrong-value-td5370.html > > 在 2016年12月8日

Re: 答复: 回复：答复: Kylin1.6.0流式Cube查询时间错误

here here some threads about getting the right Date from Kylin http://apache-kylin.74782.x6.nabble.com/JDBC-query-result-Date-column-get-wrong-value-td5370.html 在 2016年12月8日 上午11:09，仇同心 写道： > 是的，构建好的segment进行SQL查询的时候，发现这些查询记录的时间也都是早了8小时 > > > > -邮件原件- > 发件人: 汪胜

答复: 回复：答复: Kylin1.6.0流式Cube查询时间错误

是的，构建好的segment进行SQL查询的时候，发现这些查询记录的时间也都是早了8小时 -邮件原件- 发件人: 汪胜 [mailto:sky...@163.com] 发送时间: 2016年12月8日 11:06 收件人: dev 主题: 回复：答复: Kylin1.6.0流式Cube查询时间错误 我在查看前端页面代码的时候，发现传到前端的start time和end

回复：答复: Kylin1.6.0流式Cube查询时间错误

我在查看前端页面代码的时候，发现传到前端的start time和end time都是timestamp的形式，我自己对这些timestamp进行转换的时候，发现时间是正确。因此我觉得有可能是前端在转换这些timestamp的时候，没有考虑到配置文件的时区问题，但是我还没有进行验证。 除此之外，我在对构建好的segment进行SQL查询的时候，发现这些查询记录的时间也都是早了8小时，不知道你有没有碰到这个问题？ 在2016年12月8日 10:57， 仇同心写道： 我也遇到了一样的问题，cube的Last Build Time

Re: Re: 使用全局字典报错AppendTrieDictionary can't retrive value from id

Thank you for your answer, I will try my best to use English to ask question. 发件人： Billy Liu 发送时间： 2016-12-08 09:15 收件人： dev 主题： Re: Re: 使用全局字典报错AppendTrieDictionary can't retrive value from id To use GlobalDictionaryBuilder, there are some benefits, but also some limitation. It's very useful

答复: Kylin1.6.0流式Cube查询时间错误

我也遇到了一样的问题，cube的Last Build Time 是正确的：2016-12-08 10:48:37 GMT+8 但是segment的时间早8个小时： Start Time: 2016-12-08 02:44:00 End Time: 2016-12-08 02:45:00 请问这个问题是kylin哪里造成的？ 发件人: 汪胜 [mailto:sky...@163.com] 发送时间: 2016年12月6日 21:17 收件人: dev 主题: Re: Kylin1.6.0流式Cube查询时间错误 你好， 非常感谢您的回答，但是我仍然有两个地方不太理解，望指教： 1

sql query(min/max over) seems to be replicated

Hi Kylin Dev team, I used a dataset called learn_kylin, the sample data of table kylin_sales looks like: A problem came when I inputed sql query as: " select LSTG_FORMAT_NAME, avg(price) over(partition by LSTG_FORMAT_NAME) as price_level, max(price) over(partition by LSTG_FORMAT_NAME) as

[jira] [Created] (KYLIN-2255) Drop v1 CubeStorageQuery

liyang created KYLIN-2255: - Summary: Drop v1 CubeStorageQuery Key: KYLIN-2255 URL: https://issues.apache.org/jira/browse/KYLIN-2255 Project: Kylin Issue Type: Improvement Reporter:

Re: select * clause still case all regionserver crash

about v1.5.4,"select * from table limit N" clause seems not to crash regionserver,but meantime no result return for the clause -- View this message in context: http://apache-kylin.74782.x6.nabble.com/select-clause-still-cause-all-regionserver-crash-tp6474p6535.html Sent from the Apache Kylin

Re: kylin1.6版本增量build的BUG

Thanks for the reporting, but the images could not display. 在 2016年12月8日 上午8:55，gaolv123...@163.com 写道： > kylin1.6版本增量build的BUG > > 如下两张图片所示，条件只能是日期嘛？ > 并且手动输入的无效，必须通过控件输入 > > > -- > gaolv123...@163.com >

kylin1.6版本增量build的BUG

kylin1.6版本增量build的BUG 如下两张图片所示，条件只能是日期嘛？ 并且手动输入的无效，必须通过控件输入 gaolv123...@163.com

Re: Issues in building cubes of Apache Kylin

Hi Tarun, what's the output of bin/find-hive-dependency.sh? It seems something wrong in the environment variables. Which Hadoop distribution were you using? 2016-12-07 23:04 GMT+08:00 Tarun Vashisth : > Hi, > > > > We are trying to build cubes for data and while doing so, we

Issues in building cubes of Apache Kylin

Hi, We are trying to build cubes for data and while doing so, we are getting the following error during the step 3 of cube creating File does not exist: hdfs://localhost:54310/app/hadoop/tmp/mapred/staging/hduser341814501/.staging/job_local341814501_0007/libjars/hive-exec-2.1.0.jar

Re: Cube Configuration Overwrites doesn't work

Hi Peter, Which version were you using? This override feature is introduced by KYLIN-2095, which is released in Kylin 1.6.0. 2016-12-07 19:47 GMT+08:00 Jian Zhong : > Forward to dev list. > > -- Forwarded message -- > From: peter zhang

Fwd: Cube Configuration Overwrites doesn't work

Forward to dev list. -- Forwarded message -- From: peter zhang Date: Wed, Dec 7, 2016 at 9:03 AM Subject: Re: Cube Configuration Overwrites doesn't work To: u...@kylin.apache.org In case of inline snapshots break, add attchment 2016-12-07 9:00

[jira] [Created] (KYLIN-2254) A kind of sub-query does not work

liyang created KYLIN-2254: - Summary: A kind of sub-query does not work Key: KYLIN-2254 URL: https://issues.apache.org/jira/browse/KYLIN-2254 Project: Kylin Issue Type: Bug Reporter:

[jira] [Created] (KYLIN-2253) sql union did not remove replicated records (distinct)

zhou degao created KYLIN-2253: - Summary: sql union did not remove replicated records (distinct) Key: KYLIN-2253 URL: https://issues.apache.org/jira/browse/KYLIN-2253 Project: Kylin Issue Type: