We are forced change the datatype from BIGINT to VARCHAR to handle case statement.
select distinct QUESTION_CODE, CASE
QUESTION_CODE WHEN '20061'
THEN 'UNKNOWN'
ELSE QUESTION_CODE
END AS HRA_STANDARD_ANSWER
from XXXXXX.HRA_QUESTION_ANSWER
Steps to reproduce:
Table Definition :
CREATE TABLE [XXXXX].[HRA_QUESTION_ANSWER]
(
[QUESTION_CODE] [bigint] NULL
)
WITH
(
DISTRIBUTION = HASH ( [QUESTION_CODE] ),
CLUSTERED COLUMNSTORE INDEX
)
Load sample data into table and run above failed query.

