Error in count function

[neerajthakur]

Hi, I am using below query and getting error of Invalid Expressions:

Load

count(distinct ID) as [Total ID],
count(if(sample_type='A','1')) as [Total A],
count(if(sample_type='B','1')) as [Total B],
count(if(sample_type='C','1')) as [Total C],

field1,

field2

Resident temp_table;