Re: New committer: Xiaoxiang Yu

2019-12-29 Thread
Congratulations! Best regards, Youcheng Congratulations! You deserve it. [cid:7D3EAE76-AF2E-4EFA-97B5-6220180DA6F6@hz.ali.com] 在 2019年12月29日,19:49,zhan shaoxiong mailto:shaoxiong0...@gmail.com>> 写道: Congratulations! Best regards, Shaoxiong Zhan 在 2019/12/29

Re: Build cube by JDBC

2019-06-14 Thread
Hello, Actually the package kap-datasource-adaptor-oracle-11g-1.0.0-SNAPSHOT.jar you download from Kyligence is adapt to Enterprise version, not adapt to Kylin now. Return to your first question: ORA-00911 may caused by the backtick ` You may try your sql without backtick. Thanks,

Re: Tableau Server 连接 Kylin 疑问

2019-02-28 Thread
Hi Luster, For ODBC: As I know, Kylin ODBC only supports windows. For JDBC: Actually I can’t see your images. Maybe you can attached in the enclosure? Best Regards 发件人: Luster Leung 答复: "dev@kylin.apache.org" 日期: 2019年3月1日 星期五 上午11:54 收件人: "dev@kylin.apache.org" 抄送:

Re: 回复: kylin连接sqlserver数据库: kylin生成的sql语句有反单引号 `, 查询sqlserver报错了

2019-02-28 Thread
Hi, You should create a configuration file maybe name mssql.xml to define configuration to adapt Microsoft Sqlserver. As you mentioned I guess you define DIALECT="mysql", actually mysql use ` as quote. You should define DIALECT="mssql" in mssql.xml. And if you don't want to enable quote,

答复: Partition Date Issue

2018-05-21 Thread
Hi Shaofeng, I'm not sure but if create a view with adding a new column which combined with the three column can simplify the problem? Thank you 发件人: ShaoFeng Shi 发送时间: 2018年5月16日 20:00 收件人: dev 抄送: user 主题: Re: Partition Date Issue Hi

答复: 答复: Timezone offset with java.sql.Date with kylin jdbc

2018-02-04 Thread
Finally after watch document of calcite, I changed connect url from "jdbc:kylin//" --> "jdbc:kylin:timeZone=UTC//" maybe not a good solution, welcome suggestions. Thanks best regards ________ 发件人: 张 佑铖 <edouard...@hotmail.com> 发

答复: 答复: Timezone offset with java.sql.Date with kylin jdbc

2018-02-04 Thread
or PR is welcomed. 2018-02-04 21:42 GMT+08:00 张 佑铖 <edouard...@hotmail.com>: > Hi Shaofeng, > > Thank you for reply, but a little strange is that when I use in previous > version 2.1.0 and not encounter this problem. > I will check it later. > > Thanks again > > &

答复: Timezone offset with java.sql.Date with kylin jdbc

2018-02-04 Thread
mezone offset with java.sql.Date with kylin jdbc Check whether this can help: http://apache-kylin.74782.x6.nabble.com/JDBC-query-result-Date-column-get-wrong-value-td5370.html 2018-02-04 19:29 GMT+08:00 张 佑铖 <edouard...@hotmail.com>: > Hi kylin team, > > Single problem, column

答复: 答复: 答复: Can't delete segment

2018-02-04 Thread
nerate the patch by following the guide here: https://kylin.apache.org/development/howto_contribute.html 2018-02-04 19:01 GMT+08:00 张 佑铖 <edouard...@hotmail.com>: > > You mean a patch for github ? > I am very pleased to do it. > I haven't done it before, but I will try it thes

Timezone offset with java.sql.Date with kylin jdbc

2018-02-04 Thread
Hi kylin team, Single problem, column with type Date values '2018-02-02' in hive. Query in kylin sight is okay return value with '2018-02-02'. But when I used jdbc it returns '2018-02-01'. Apparently it is a problem with timezone. 1. Check the configuration first kylin.web.timezone=GMT+8

答复: 答复: Can't delete segment

2018-02-04 Thread
01 收件人: dev 主题: Re: 答复: Can't delete segment Thank you You Cheng; And if you want to contribute a patch, that is welcomed! 2018-02-02 21:29 GMT+08:00 张 佑铖 <edouard...@hotmail.com>: > 1. KYLIN-3228<https://issues.apache.org/jira/browse/KYLIN-3228> has

答复: Can't delete segment

2018-02-02 Thread
b, it should remove the related segment. Could you please report a JIRA? Next time, you don't need to purge the cube; you can backup the metadata to disk, edit the cube json manually, and then restore it. 2018-02-02 18:29 GMT+08:00 张 佑铖 <edouard...@hotmail.com>: > Hi kylin team, > >

Can't delete segment

2018-02-02 Thread
Hi kylin team, After a job been error, I click drop instead of discard by mistake, I can't find the job anywhere, but it still remain an empty segment in cube. When I call restful request /{cubeName}/segs/{segmentName} it returns Cannot delete segment '' as its status is not READY. Discard

答复: Calculate count distinct with 2 segments not correct

2018-01-11 Thread
column that doing distinct count? 2018-01-11 15:57 GMT+08:00 张 佑铖 <edouard...@hotmail.com>: > Hi Kylin team, > > > > In my cube, partition by date, auto merge by 7 days. > > And I use bitmap for count distinct. > > The case is I have 2 segments which is 20171229-20

Calculate count distinct with 2 segments not correct

2018-01-10 Thread
Hi Kylin team, In my cube, partition by date, auto merge by 7 days. And I use bitmap for count distinct. The case is I have 2 segments which is 20171229-20180105 and 20180105-20180112, I found that if the time of query in both 2 segments, the result of count distinct is not correct, after

Kylin standalone deploy

2017-12-21 Thread
Hi kylin team: I want to deploy kylin in a standalone node apart from the hadoop cluster. Can you give me some hints or successful cases? As I know, when run kylin.sh start, the script will call 'hbase classpath' and `hive -e set | grep 'env:CLASSPATH'`, how can I find a workaround ? Is