Build a view with new column combining Year,Month and Day
在 2016年8月5日 上午10:19,热爱大发挥 <385639...@qq.com>写道:
> 我的日期分区有多个该怎么办呢
> 分区字段如下
> year
> month
> day
> 三个字段, 而在创建model只能选择一个
>
--
With Warm regards
Yiming Liu (刘一鸣)
Sql: "select ADX,GEOID,SUM(IMPS) as imps,SUM(CLKS) as clks,SUM(CONS) as
cons,SUM(IMP_CLOSINGPRICE)+SUM(CLK_CLOSINGPRICE) as cost,COUNT(DISTINCT
IMP_DEVICEID) as imp_uv,COUNT(DISTINCT CLK_DEVICEID) as clk_uv from
EXT_MID_EVENT_JOIN where "DATE">=DATE'2016-01-01' and
"DATE"=DATE'2016-01-01' and
"DATE
There's no such route in current release.
You could build your app on top of Kylin and route to Hive or any other SQL
on Hadoop from there.
Thanks.
Best Regards!
-
Luke Han
On Wed, Aug 10, 2016 at 12:52 AM, Ahmed Mahran
wrote:
> Hi,
>
> I'm confused about how to enable ro
Hi,
I'm confused about how to enable routing unsupported to hive. Getting both
exceptions: no realization found and table not found.
Kylin: 1.5.3-cdh5.7
Hadoop: 2.6.0-cdh5.7.1
HBase: 1.2.0-cdh5.7.1
Hive: 1.1.0-cdh5.7.1
Spark: 1.6.0-cdh5.7.1
Regards,
Ahmed
In fact, getValuefromId mainly used for dimension encoding and querying, it’s
not necessary for measure.
In the other hand, dimension is not necessary for encoding at cube level,
encoding at segment level is good enough.
GlobalDictionary is just one implementation of DictBuilder, you can imple
Ok, i will try it.
ShaoFeng Shi 于2016年8月9日周二 下午6:36写道:
> The "date" encoding is better than "dic" encoding as it doesn't need
> storage cost.
>
> Did you try this (explicitly let SQL parser know it is a Date value): where
> "DATE">=DATE'2016-01-01'
>
> 2016-08-09 17:38 GMT+08:00 张天生 :
>
>> I foun
Define a SUM measure in the cube, then use the SUM value (for all items)
minus the total value of Top 10 items, will get the total of others;
2016-08-09 15:22 GMT+08:00 Alberto Ramón :
> Hi,
>
> Top-N is usefull for one 'Top 10', but can be useful know the Sum of 'the
> Others' (= sum (top > 10))
The "date" encoding is better than "dic" encoding as it doesn't need
storage cost.
Did you try this (explicitly let SQL parser know it is a Date value): where
"DATE">=DATE'2016-01-01'
2016-08-09 17:38 GMT+08:00 张天生 :
> I found the answer, it because DATE dimension rowkey encode is date. When
> e
I found the answer, it because DATE dimension rowkey encode is date. When
executes "select APPID, SUM(IMPS) as imps from EXT_MID_EVENT_JOIN where
"DATE">=146206080 and "DATE"<146214720 group by APPID order by imps
desc limit 100", it returned right results. Btw, whether the date rowkey
enco
I built a cube, it has 2 dimesions : CAMPAIGNID, DATE, and has 2 measures:
count(1), topN(100). TOP-N is grouped by APPID and order by/sum
by IMPS measure. When i queried: select APPID, SUM(IMPS) as imps from
EXT_MID_EVENT_JOIN where "DATE">='2016-01-01' and "DATE"<'2016-01-08' group
by APPID order
Hi,
Top-N is usefull for one 'Top 10', but can be useful know the Sum of 'the
Others' (= sum (top > 10))
Example:
In a Shop Top 10 Sellers, sold 1.2M $
How much sold 'the others'? 1.2M $ its a lot respect the others?
I know that this is not easy to implement, but if someboy have any idea .
11 matches
Mail list logo