Re: Do not order columns for Auto Generate Dimensions in Cube Design

[hongbin ma]

The order by original table is already lost when we define dimensions in
model. So the problem becomes how to order the dimension when creating
model?

To illustrate the problem let's assume we have fact table and a lookup
table. Assume the columns on fact is "dim1, FK, dim2, metrics1, metrics2",
and the lookup table looks like "PK, dim3, dim4", what kind of ordering is
reasonable? 1234 ro 1342?

On Sat, Sep 3, 2016 at 6:01 PM, Yiming Liu  wrote:

> I would like suggest keeping original order still. Just like we execute
> "desc table", no reorder happens, and the original order normal has some
> kinds of relationship.
>
> 2016-09-03 16:13 GMT+08:00 hongbin ma :
>
> > ​+1
> >
> > ​alphabetical order obviously makes no sense. can we sort them by
> > cardinality?
> >
> >
> >
> > --
> > Regards,
> >
> > *Bin Mahone | 马洪宾*
> >
>
>
>
> --
> With Warm regards
>
> Yiming Liu (刘一鸣)
>



-- 
Regards,

*Bin Mahone | 马洪宾*

Re: Do not order columns for Auto Generate Dimensions in Cube Design

[Luke Han]

+1 should keep orginal order




Best Regards!
-

Luke Han

On Sat, Sep 3, 2016 at 6:01 PM, Yiming Liu  wrote:

> I would like suggest keeping original order still. Just like we execute
> "desc table", no reorder happens, and the original order normal has some
> kinds of relationship.
>
> 2016-09-03 16:13 GMT+08:00 hongbin ma :
>
> > ​+1
> >
> > ​alphabetical order obviously makes no sense. can we sort them by
> > cardinality?
> >
> >
> >
> > --
> > Regards,
> >
> > *Bin Mahone | 马洪宾*
> >
>
>
>
> --
> With Warm regards
>
> Yiming Liu (刘一鸣)
>

Re: Do not order columns for Auto Generate Dimensions in Cube Design

[Yiming Liu]

I would like suggest keeping original order still. Just like we execute
"desc table", no reorder happens, and the original order normal has some
kinds of relationship.

2016-09-03 16:13 GMT+08:00 hongbin ma :

> ​+1
>
> ​alphabetical order obviously makes no sense. can we sort them by
> cardinality?
>
>
>
> --
> Regards,
>
> *Bin Mahone | 马洪宾*
>



-- 
With Warm regards

Yiming Liu (刘一鸣)

Re: Do not order columns for Auto Generate Dimensions in Cube Design

[hongbin ma]

​+1

​alphabetical order obviously makes no sense. can we sort them by
cardinality?



-- 
Regards,

*Bin Mahone | 马洪宾*

Do not order columns for Auto Generate Dimensions in Cube Design

[Yiming Liu]

Hi Kylin devs,


Currently, the Auto Generate Dimensions in Cube Design(Step 2), will reorder 
all columns alphabetically. But the column names do not have any order 
relationship. Could Kylin just leave the same column order with the hive table?