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.


SELECT DISTINCT property1 FROM object
Note: 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.