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 <[email protected]> wrote: > What is the difference between dimension and measure column > > Is this related to the nested data like JSON? > -- Thanks & Regards, Ravi
