You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Mars J <xu...@gmail.com> on 2016/05/17 08:54:17 UTC
How to use the measure 'raw' ?
Hello All,
I try to build a cube with raw and give it a column, but I don't know
what the measure 'raw ' mean and how to use it.
Re: How to use the measure 'raw' ?
Posted by Xiaoyu Wang <wa...@jd.com>.
Yes, I will write a document on this!
\u5728 2016\u5e7405\u670819\u65e5 17:14, Li Yang \u5199\u9053:
> Xiaoyu, do you mind to write a document on this? I see many requests.
>
> On Tue, May 17, 2016 at 5:07 PM, Xiaoyu Wang <wangxiaoyu1@jd.com
> <ma...@jd.com>> wrote:
>
> Hi Mars!
> Sorry for the lack of documentation!
> RAW measure is a custom measure function for the detail row data
> query on the fact table.
> if you have the same scenario. you can define the RAW measure
> function on the column which you want to select the detail row data.
> if you want to the SQL "select column1,column2,column3 from
> fact_table" return the correct result. you must define RAW measure
> function on "column1","column2","column3",
> and choose some column which well-distributed to dimensions.
> after the cube build, you can use the SQL "select
> column1,column2,column3 from fact_table" to query the detail row
> data on the fact table!
>
>
>
> \u5728 2016\u5e7405\u670817\u65e5 16:54, Mars J \u5199\u9053:
>> Hello All,
>> I try to build a cube with raw and give it a column, but I
>> don't know what the measure 'raw ' mean and how to use it.
>
>
Re: How to use the measure 'raw' ?
Posted by Li Yang <li...@apache.org>.
Xiaoyu, do you mind to write a document on this? I see many requests.
On Tue, May 17, 2016 at 5:07 PM, Xiaoyu Wang <wa...@jd.com> wrote:
> Hi Mars!
> Sorry for the lack of documentation!
> RAW measure is a custom measure function for the detail row data query on
> the fact table.
> if you have the same scenario. you can define the RAW measure function on
> the column which you want to select the detail row data.
> if you want to the SQL "select column1,column2,column3 from fact_table"
> return the correct result. you must define RAW measure function on
> "column1","column2","column3",
> and choose some column which well-distributed to dimensions.
> after the cube build, you can use the SQL "select column1,column2,column3
> from fact_table" to query the detail row data on the fact table!
>
>
>
> 在 2016年05月17日 16:54, Mars J 写道:
>
> Hello All,
>
> I try to build a cube with raw and give it a column, but I don't
> know what the measure 'raw ' mean and how to use it.
>
>
>
Re: How to use the measure 'raw' ?
Posted by Xiaoyu Wang <wa...@jd.com>.
Hi Mars!
Sorry for the lack of documentation!
RAW measure is a custom measure function for the detail row data query
on the fact table.
if you have the same scenario. you can define the RAW measure function
on the column which you want to select the detail row data.
if you want to the SQL "select column1,column2,column3 from fact_table"
return the correct result. you must define RAW measure function on
"column1","column2","column3",
and choose some column which well-distributed to dimensions.
after the cube build, you can use the SQL "select
column1,column2,column3 from fact_table" to query the detail row data on
the fact table!
\u5728 2016\u5e7405\u670817\u65e5 16:54, Mars J \u5199\u9053:
> Hello All,
> I try to build a cube with raw and give it a column, but I don't
> know what the measure 'raw ' mean and how to use it.