impala select count distinct code example

Example 1: select count of distinct values sql

SELECT COUNT (DISTINCT column-name)  FROM table-name

Example 2: select count distinct multiple columns sql server

SELECT COUNT(DISTINCT (CHECKSUM(DocumentId,DocumentSessionId)) + CHECKSUM(REVERSE(DocumentId),REVERSE(DocumentSessionId)) )
FROM DocumentOutPutItems