The statement failed because a nonclustered index and the underlying clustered columnstore index must be partition-aligned. ...

The statement failed because a nonclustered index and the underlying clustered columnstore index must be partition-aligned. Consider creating the nonclustered index using the same partition function and same (or equivalent) partition scheme as the clustered columnstore index.