hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sreebalineni ." <sreebalin...@gmail.com>
Subject Re: Issue with Star schema
Date Tue, 15 Mar 2016 16:32:32 GMT
You can think of map joins.If cluster is configured by default it must be
happening already check query profile

On Tue, 15 Mar 2016 21:12 Himabindu sanka, <himabindu.sanka@gmail.com>
wrote:

> Hi Team,
>
>
>
> I have a query where I am joining with 10 other entities
>
>
>
> Like
>
>
>
> Select  a.col1,b1.col1,b2.col1 from
>
>
>
> A a
>
> Left outer join b1 on
>
> Left outer join b2 on
>
> Left outer join b3….
>
>
>
>
>
> A is my driver entity which a 20 million data. Most of the other entities
> are small just 10 to 20 rows of data.
>
>
> In that scenario, my hive query is taking hours of time to join and fetch
> it.  Please suggest me optimization technique.
>
> This is chocking the query performance.
>
>
>
>
>
> *Regards,*
>
> *Himabindu Sanka*
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message