Pasted

CREATE TABLE [dbo].[BusinessHierarchies](
	[BookId] [nvarchar](250)	,
	[Division] [nvarchar](100)	,
	[Cluster] [nvarchar](100)	,
	[Desk] [nvarchar](100)		,
	[Book] [nvarchar](100)		,
	[Volcker] [nvarchar](100)	,
	[Region] [nvarchar](100)	
)
WITH
(
	CLUSTERED COLUMSTORE INDEX
,	DISTRIBUTION = HASH([Volcker])
)
;