I don't fully understand. But - The dimension name is up to you, don't have to be same as column name. - Table name and Column name must match what's in hive table. - Any column could be a dimension, not necessarily primary key of table. - Dictionary helps to compress the column in storage, and nothing more. It has nothing to do with uniqueness for example.
Hope this helps. On Tue, Apr 7, 2015 at 7:26 PM, Abhishek Sinha <[email protected]> wrote: > Hi, > > While designing cube: > Edit Dimension asks for name, table name and column name. > Does the column name necessarily be the primary key of the table? If it is, > then primary keys are generally IDs and generating dictionary for them does > not make much sense. > Since whatever column name we provide appears in the rowkey of the Advanced > Settings page with dictionary set to true. > Correct me if I am wrong. > > > Thanks > > -- > Abhishek Sinha > Mobile: +919035191078 > infoworks.io >
