add distinct command + test
DO NOT merge back, yaml for sonar branch only