Multiple arguments in count function.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Multiple arguments in count function.

prabhatkashyap
I am able to use multiple column name and even asterisk with columns in count function. Even though it is giving me correct output but I think it should not be allowed.

select count(id,id) from emp4;
select count(id,id,name,*,*) from emp4;

As the same queries give error when executed in HIVE.

Please confirm.