Dimension vs. Measure Column

[Ahmed Abdelhamid <sa...@purdue.edu>]

What is the difference between dimension and measure column

Is this related to the nested data like JSON?

Re: Dimension vs. Measure Column

[Ravindra Pesala <ra...@gmail.com>]

Hi Ahmed,

Dimensions are usually the fields that cannot be aggregated and the fields
you want to track like Country, Product etc. Where as measures, as its name
suggests, are those fields that can be measured, aggregated, or used for
mathematical operations like Quantity, Price etc.
By default all columns having Numeric datatype like Integer,Double, Long
etc are treated as measures and remaining columns are treated as
dimensions.But this behavior can be overridden by using TBLPROPERTIES while
creating the table. So when it comes to MDK(Multi dimensional key) concept
of Carbon , only dimensions are part of it.
From the outside to users all fields are treated as normal columns like any
other database.


Thanks & Regards,
Ravindra.

On 14 July 2016 at 03:33, Ahmed Abdelhamid <sa...@purdue.edu> wrote:

> What is the difference between dimension and measure column
>
> Is this related to the nested data like JSON?
>



-- 
Thanks & Regards,
Ravi