Hello,
if you create a table
CREATE TABLE coltest
(
id
INT NULL,
description
VARCHAR(50) NULL
)
COLLATE='latin1_swedish_ci'
ENGINE=Columnstore
;
I got en error.
/ SQL Fehler (1178): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types. /
There is a workarround.
MCOL-337 (Error: Sorry, you cannot yet post http links. You need some more posts to do that. )
CREATE TABLE coltest
(
id
INT NULL,
description
VARCHAR(50) NULL
)
default CHARACTER SET latin1 engine=columnstore;
Regards,
Richard