You can't have more than 1 non-pk column from the base table as primary key column of the view. All is explained here: http://www.doanduyhai.com/blog/?p=1930
On Wed, Feb 10, 2016 at 10:43 AM, Abdul Jabbar Azam <aja...@gmail.com> wrote: > Hello, > > I tried creating a material view using a composite partition key but I got > an error. I can't remember the error but it was complaining about the > presence of the second field in the partition key. > > Has anybody experienced this or have a workaround. I haven't tried UDT's > yet. > > > -- > Regards > > Abdul Jabbar Azam > twitter: @ajazam >
