Hi Bhagwan,
Thanks for your response...
Is there any possible to use aggregated and non aggregated
columns in hive query to get data without using group by?
Regards,
Ravi
On Wed, Jun 3, 2015 at 10:24 AM, Bhagwan S. Soni <bhgwnsson...@gmail.com>
wrote:
> Ravishankar,
>
> below query will works fine without including group by
> SELECT
> COUNT(adventurepersoncontacts.contactid) as contact
> FROM
> default.adventurepersoncontacts
>
> But when you are planning to get aggregated column with non-aggregated
> column you have to specify the level of aggregation.
> Why don't you include selected column in group by, I don't think so it
> will affect your output.
>
> Thanks,
> Bhagwan
>
> On Wed, Jun 3, 2015 at 4:05 PM, Ravisankar Mani <rrav...@gmail.com> wrote:
>
>> 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
>>
>
>
