SELECT DISTINCT
Use DISTINCT to remove duplicate values from the result set. Use a property value to specify the property in the data object on which duplicate values are based.
Syntax
SELECT DISTINCT property1 FROM objectNote: The values in Data Lake are case-sensitive. The same values
can be displayed in the results, even though the only difference is the capitalization.
For example, values ‘ABC’ and ‘abc’ are different and both values are returned in a
select distinct query. To perform a select distinct on case-insensitive values, use
upper or lower functions to convert values to upper- or lower-case characters.