Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> distinct with union all


Copy link to this message
-
Re: distinct with union all

make sure you don't have any leading or trailing spaces (or special
characters) for the usernames being extracted.

also to debug, try to do a select username, count(1) then group by username

-- amr

Rakesh Setty wrote:
>
> Yes, I am getting duplicate usernames.
>
>  
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* Namit Jain [mailto:[EMAIL PROTECTED]]
> *Sent:* Thursday, July 02, 2009 1:25 PM
> *To:* [EMAIL PROTECTED]
> *Subject:* RE: distinct with union all
>
>  
>
> Are you getting duplicate usernames ?
>
>  
>
>  
>
> *From:* Rakesh Setty [mailto:[EMAIL PROTECTED]]
> *Sent:* Thursday, July 02, 2009 12:37 PM
> *To:* [EMAIL PROTECTED]
> *Subject:* distinct with union all
>
>  
>
> Hi,
>
>  
>
> I have a query like
>
>  
>
> select distinct username from (select user as username from page_views
> pv union all select name as username from users u) ur;
>
>  
>
> But I see that result is not actually distinct. Am I missing something
> here?
>
>  
>
> Thanks,
>
> Rakesh
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB