Re: Some wrong with kylin2.5-hbase2.* for protobuf-java

2018-10-14 Thread liuzhixin
:00,Lijun Cao <641507...@qq.com> 写道: > > Hi liuzhixin: > > As I remember, the Hive version in HDP 3 is 3.1.0 . > > You can update Hive to 3.1.0 and then have another try. > > And according to my previous test, the binary package > apache-kylin-2.5.0-bin-hadoo

Re: Some wrong with kylin2.5-hbase2.* for protobuf-java-3.1.0

2018-10-15 Thread liuzhixin
if it works, then there should be something > wrong in Kylin. > > liuzhixin mailto:liuz...@163.com>> 于2018年10月15日周一 下午1:47写道: > >> Thank you for the answer! >> >> I can’t decide the hive version. >> >> And the hive version 2.3.3 can work well with HD

Re: Some wrong with kylin2.5-hbase2.* for protobuf-java

2018-10-14 Thread liuzhixin
r hive is properly installed; You can manually run that hive command : > > hive -e "use default; xxx" > > Lijun Cao <641507...@qq.com> 于2018年10月15日周一 上午11:01写道: > >> Hi liuzhixin: >> >> As I remember, the Hive version in HDP 3 is 3.

Re: Some wrong with kylin2.5-hbase2.* for protobuf-java

2018-10-14 Thread liuzhixin
; > I think the problem is how to run Hive 2 with HDP 3, no relation with Kylin. > > Usually, we don't encourage user to customize the component version in a > release, because that may bring dependency conflicts. > > I suggest you use the original Hive version in HDP 3. > >

Re: Some wrong with kylin2.5-hbase2.* for protobuf-java-3.1.0

2018-10-15 Thread liuzhixin
c.Launcher$AppClassLoader.loadClass(Launcher.java:335) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ... 51 more The command is: hive -e "USE default; > 在 2018年10月15日,下午2:35,liuzhixin 写道: > > Hi shaofeng: > > Yes, I can run the command well in hive shell.

Re: Some wrong with kylin2.5-hbase2.* for protobuf-java-3.1.0

2018-10-15 Thread liuzhixin
018年10月16日,上午9:56,ShaoFeng Shi 写道: > > Hi Zx, > > The source code of 1.13.0-kylin-r4. is in Kyligence's fork: > https://github.com/Kyligence/calcite <https://github.com/Kyligence/calcite> > Please provide the full kylin.log, maybe we can find new clue there. > >

Some wrong with kylin2.5-hbase2.* for protobuf-java

2018-10-12 Thread liuzhixin
Logging initialized using configuration in file:/data/hadoop-enviorment/apache-hive-2.3.3/conf/hive-log4j2.properties Async: true OK Time taken: 4.512 seconds OK Time taken: 1.511 seconds OK Time taken: 0.272 seconds OK Time taken: 0.185 seconds Exception in thread "main"

blocked because of many connection errors from mysql

2018-10-24 Thread liuzhixin
HI, kylin team: There is something wrong with the connection from mysql. # Kylin version: 2.5.0-hadoop3.1 for hbase 2.0 # NestedThrowables: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url =

Re: MapReduceException: Counter 0

2018-10-29 Thread liuzhixin
Hello kylin team: # Maybe kylin conf needs hpd.version for running! # Best wishes. > 在 2018年10月22日,下午6:44,liuzhixin 写道: > > Hello kylin team: what’s wrong with the Counter 0? Thank you. > > > # > Best wishes!

ArrayIndexOutOfBoundsException for NDCuboidBuilder

2018-10-29 Thread liuzhixin
Hello kylin team: # When I test the kylin2.5.0-hadoop3.1-hbase2 for hdp3.0, I select spark as the engine type, Sometimes there are some ArrayIndexOutOfBoundsExceptions, And the error info is blow: # # [2018-10-29 11:48:26][INFO][Driver][DAGScheduler:54] Job 1 failed: runJob at

Re: Kylin2.5不支持Hive2.x的SQL中的关键字识别

2018-10-31 Thread liuzhixin
in? > Thank you! > > liuzhixin 于2018年10月31日周三 下午6:48写道: > >> Hi kylin team: >> >> Hive2.3 版本严格限制了SQL中的关键字使用,必须添加上反引号, 例如`date`。 >> >> 但是Kylin在访问Hive的时候,生成的SQL语句没有添加反引号``来约束SQL关键字,这会带来很多问题。 >> >> >> Best wishes! > > > > -- > Best regards, > > Shaofeng Shi 史少锋

Re: Partition Column for Kylin

2018-10-31 Thread liuzhixin
king on it. > > Best regards, > > Chun’en Ni(George) > > - 原始邮件 - > 发件人: liuzhixin > 收件人: dev@kylin.apache.org > 抄送: 335960...@qq.com > 已发送邮件: Wed, 31 Oct 2018 20:11:34 +0800 (CST) > 主题: Partition Column for Kylin > > Hi kylin team: > > If m

Kylin2.5不支持Hive的SQL中的关键字识别

2018-10-31 Thread liuzhixin
Hi kylin team: Hive2.3 版本严格限制了SQL中的关键字使用,必须添加上反引号, 例如`date`。 但是Kylin在访问Hive的时候,生成的SQL语句没有添加反引号``来约束SQL关键字,这会带来很多问题。 Best wishes!

Re: Redistribute intermediate table default not by rand()

2018-11-02 Thread liuzhixin
distribution more even; > > Chao Long 于2018年11月2日周五 下午1:38写道: > >> Hi zhixin, >> Data may become not correct if use "distribute by rand()". >> https://issues.apache.org/jira/browse/KYLIN-3388 >> >> >> >> >> -

Re: Redistribute intermediate table default not by rand()

2018-11-02 Thread liuzhixin
018年11月2日,下午2:06,ShaoFeng Shi 写道: > > Hi ShaoFeng Shi, > > Kylin 2.5.1 will add some tips in the advanced step, hope that can help. > > liuzhixin 于2018年11月2日周五 下午2:05写道: > >> Hi Chao Long: >> >> Thank you for the answer. >> # >> Maybe kylin

Re: Redistribute intermediate table default not by rand()

2018-11-02 Thread liuzhixin
Chao Long 写道: > > Hi zhixin, > As I remember If you set "shard by" column in cube design page, Kylin will > use this column as the condition of "distribute by", rather than the first > three field of rowkey. > > > > > -- 原

Re: Redistribute intermediate table default not by rand()

2018-11-02 Thread liuzhixin
for shard. (has provided) Best Wishes. > 在 2018年11月2日,下午1:38,Chao Long 写道: > > Hi zhixin, > Data may become not correct if use "distribute by rand()". > https://issues.apache.org/jira/browse/KYLIN-3388 > > > > > ------ 原始邮件 --

Re: Redistribute intermediate table default not by rand()

2018-11-02 Thread liuzhixin
for shard. (has provided) Best Wishes. > 在 2018年11月2日,下午1:38,Chao Long 写道: > > Hi zhixin, > Data may become not correct if use "distribute by rand()". > https://issues.apache.org/jira/browse/KYLIN-3388 > > > > > ------ 原始邮件 --

Re: Redistribute intermediate table default not by rand()

2018-11-02 Thread liuzhixin
at will make the data distribution more even; > > Chao Long 于2018年11月2日周五 下午1:38写道: > >> Hi zhixin, >> Data may become not correct if use "distribute by rand()". >> https://issues.apache.org/jira/browse/KYLIN-3388 >> >> >> >> >>

Re: Redistribute intermediate table default not by rand()

2018-11-01 Thread liuzhixin
Hi kylin team: Step: Redistribute intermediate table # 默认选择了维度的前三个字段作为DISTRIBUTE BY的依据,没有采用DISTRIBUTE BY RAND() 如果没有合适的维度字段,这样的默认策略将会导致数据更加的数据不均衡。 Best Regards! > 在 2018年11月2日,下午12:03,liuzhixin 写道: > > Hi kylin team: > > Version: Kylin2.5-hadoop3.1 for hdp3.0 > # &g

Redistribute intermediate table default not by rand()

2018-11-01 Thread liuzhixin
Hi kylin team: Version: Kylin2.5-hadoop3.1 for hdp3.0 # Step: Redistribute intermediate table # DISTRIBUTE BY is that: INSERT OVERWRITE TABLE table_intermediate SELECT * FROM table_intermediate DISTRIBUTE BY Field1, Field2, Field3; # Not DISTRIBUTE BY RAND() # Is this default DISTRIBUTE BY

Re: Redistribute intermediate table default not by rand()

2018-11-02 Thread liuzhixin
rg/jira/browse/KYLIN-3388 > > > > > ------ 原始邮件 -- > 发件人: "liuzhixin"; > 发送时间: 2018年11月2日(星期五) 中午12:53 > 收件人: "dev"; > 抄送: "ShaoFeng Shi"; > 主题: Re: Redistribute intermediate table default not by rand() > > > > Hi

Re: Redistribute intermediate table default not by rand()

2018-11-02 Thread liuzhixin
018年11月2日,下午2:06,ShaoFeng Shi 写道: > > Hi ShaoFeng Shi, > > Kylin 2.5.1 will add some tips in the advanced step, hope that can help. > > liuzhixin 于2018年11月2日周五 下午2:05写道: > >> Hi Chao Long: >> >> Thank you for the answer. >> # >> Maybe kylin

Re: MapReduceException: Counter 0

2018-10-25 Thread liuzhixin
Hello,Na Zhai step: Kylin: Extract Fact TableDistinct Columns Kylin can’t submit the MR Task and throw the Counter: 0 # Best wishes! > 在 2018年10月24日,下午9:06,liuzhixin 写道: > > Hello Na Zhai: > # > The beeline connect hive successful, and There are no more messages! > # &

Compile in GitHub Error

2019-06-17 Thread liuzhixin
Hello kylin team: There is someting wrong for Compile in GitHub Error. Refer: https://travis-ci.org/apache/kylin/jobs/546641440 . Thanks very much for any help.

Re: Compile in GitHub Error

2019-06-17 Thread liuzhixin
Ok,Thank you very much! > 在 2019年6月17日,下午6:06,nichunen 写道: > > Hi, please rebase to the latest code of master branch. It should be fixed now. > > > > Best regards, > > > > Ni Chunen / George > > > > On 06/17/2019 18:03,liuzhixin wrot

[jira] [Created] (KYLIN-3627) calcite-core-1.13.0-kylin-r4

2018-10-11 Thread liuzhixin (JIRA)
liuzhixin created KYLIN-3627: Summary: calcite-core-1.13.0-kylin-r4 Key: KYLIN-3627 URL: https://issues.apache.org/jira/browse/KYLIN-3627 Project: Kylin Issue Type: Bug Reporter

[jira] [Created] (KYLIN-3658) The keywords of Hive are not supported By Kylin

2018-10-31 Thread liuzhixin (JIRA)
liuzhixin created KYLIN-3658: Summary: The keywords of Hive are not supported By Kylin Key: KYLIN-3658 URL: https://issues.apache.org/jira/browse/KYLIN-3658 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-4058) HBase tableName is case sensitie

2019-06-26 Thread liuzhixin (JIRA)
liuzhixin created KYLIN-4058: Summary: HBase tableName is case sensitie Key: KYLIN-4058 URL: https://issues.apache.org/jira/browse/KYLIN-4058 Project: Kylin Issue Type: Bug Components

[jira] [Created] (KYLIN-4156) Add JoinedFormatter for dynamic variables in where sentence

2019-09-03 Thread liuzhixin (Jira)
liuzhixin created KYLIN-4156: Summary: Add JoinedFormatter for dynamic variables in where sentence Key: KYLIN-4156 URL: https://issues.apache.org/jira/browse/KYLIN-4156 Project: Kylin Issue