Does the cloudera impala jdbc driver support 'distinct' in the query?
The driver should support DISTINCT. Did you encounter any errors? If so, can you please paste those error, together with the query and driver version?
Its working now, thanks.