My project has three segment: 2016060100_2016060200,
2016060200_2016060300, 2016060300_2016060400
When I used filter condition like this : day>='2016-06-01' and day<'2016-06-02'
Kylin would generated three CubeSegmentScanner, and each CubeSegmentScanner's
GTScanRequest
Hello，
I execute a sql below:
select PRODUCT_LOOKUP.PRODUCT_NAME,SUM(SALES_FACT.STORE_SALES) from SALES_FACT
inner join PRODUCT_LOOKUP on PRODUCT_LOOKUP.PRODUCT_ID=SALES_FACT.PRODUCT_ID
where PRODUCT_LOOKUP.PRODUCT_NAME like '%' || 'Label' || '%'
group by PRODUCT_LOOKUP.PRODUCT_NAME
And this
Thanks for your suggestion! I'll try this way.
在2016年12月13日 21:26， Billy Liu<billy...@apache.org>写道：
Maybe you could edit the cube json directly, but be careful always.
2016-12-13 15:30 GMT+08:00 汪胜 <sky...@163.com>:
> Hello all,
> I have many measures(about fifty), an
Hello all,
I have many measures(about fifty), and I have to create SUM, MIN and MAX
for every measure. Is there any good ways to create them at a time instead of
create one by one?
est Regards!
> -
>
> Luke Han
>
> 2016-12-08 13:57 GMT+08:00 汪胜 <sky...@163.com>:
>
> > 对于SQL查询记录早了8小时的问题，我使用了JDBC和Kylin WEB两种方式进行测试，结果都是查询记录早了8小时。
> > 这说明Kylin服务端从HBase中扫描记录时，读取的记录就已经比实际时间早了8小时。所以，可能是Kylin服务端在处理kafka数据的时候，
> > 对于时间的处理有些问题。
. Could you provide more information? including
Kylin server timezone, kylin.web.timezone.
2016-12-09 9:46 GMT+08:00 汪胜 <sky...@163.com>:
> Sorry for that. I used JDBC and Kylin Web to test the sql query for
> streaming cube, but the records came from JDBC and Kylin Web are incorrect.
&
Sorry for that. I used JDBC and Kylin Web to test the sql query for streaming
cube, but the records came from JDBC and Kylin Web are incorrect. All of theses
records' date are earlier than my PC date(8 hours).
I found that records came from Kylin server are incorrected when I did query by
value-td5370.html
> >
> > 在 2016年12月8日 上午11:09，仇同心 <qiutong...@jd.com>写道：
> >
> > > 是的，构建好的segment进行SQL查询的时候，发现这些查询记录的时间也都是早了8小时
> > >
> > >
> > >
> > > -邮件原件-
> > > 发件人: 汪胜 [mailto:sky...@163.com]
> > > 发送
bble.com/JDBC-query-result-
> > Date-column-get-wrong-value-td5370.html
> >
> > 在 2016年12月8日 上午11:09，仇同心 <qiutong...@jd.com>写道：
> >
> > > 是的，构建好的segment进行SQL查询的时候，发现这些查询记录的时间也都是早了8小时
> > >
> > >
> > >
> > > -邮件原件-
> &
d 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 如果kylin.properties改的是页面上显示
的来自Kylin服务器的数据，是Kylin通过查询HBase之后返回的。每一列数据的时间都比电脑上的实际时间晚了8小时。
在2016年12月6日 20:30， Mario Copperfield<xwhfcen...@gmail.com>写道：
> kylin.properties改的应该是页面上显示的时间，流式Cube用脚本启动了话和页面上的时间是不一致的，应该手动加上8小时
On 6 Dec 2016, 19:40 +0800, 汪胜 <sky...@163.com>, wrote:
> 你好，
> 我在安装了Kylin1.6
I'm sorry to trouble you. I had found the reason about why the build job
failed. I wrote the wrong kafka host when I create streaming table. When I
added a broker, I wrote the host as "localhost".
On 12/5/2016 11:00， 汪胜<sky...@163.com>wrote：
Hello, I installed kylin1.6.0
Hello, I installed kylin1.6.0 and kafka0.10.1, and I followed the blog
"Scalable Cubing from Kafka (beta)" step by step, but the build job failed at
the first step "Save data from Kafka". The hadoop yarn log show the below
content:
"WARN [main] org.apache.hadoop.mapred.YarnChild: Exception
Hello, I download kylin 1.6.0, and installed successful. Streaming cubing build
need script "streaming_build.sh" in ${KYLIN_HOME}/bin, but I didn't found this
file in kylin 1.6.0 source code. Besides, in kylin 1.6.0 source code, script
"kylin.sh" didn't handle the situation of "./kylin.sh
14 matches
Mail list logo
