Hello, I've just changed my materialized view to have one partition key. The view gets generated now.
After some refactoring I found that I didn't need a composite primary key at all. However if I later need one then I'll use a UDT. If it works... On Wed, 10 Feb 2016 at 13:04 DuyHai Doan <doanduy...@gmail.com> wrote: > 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 >> > > -- Regards Abdul Jabbar Azam twitter: @ajazam
