Hi everyone,
I have selected specific column using aggregation . " FAILED:
SemanticException [Error 10002]: Line 2:26 Invalid column reference
'contactid " . Exception occur while executing following query. But it
working in sql server without using group by. Kindly refer the query.
SELECT
adventurepersoncontacts.contactid as contactid
,adventurepersoncontacts.fullname as fullname
,adventurepersoncontacts.age as age
,adventurepersoncontacts.emailaddress as emailaddress
,adventurepersoncontacts.phoneno as phoneno
,adventurepersoncontacts.modifieddate as modifieddate
, COUNT(adventurepersoncontacts.contactid) as contact
FROM
default.adventurepersoncontacts
Regards,
Ravisankar M R
