What's the difference between select distinct count, and select count distinct?

Viewed 6662

I am aware of select count(distinct a), but I recently came across select distinct count(a).

I'm not very sure if that is even valid.

If it is a valid use, could you give me a sample code with a sample data, that would explain me the difference.

Hive doesn't allow the latter.

Any leads would be appreciated!

2 Answers
Related