in
smaller table.
select * from large_table a where a.dt in (select dt from small_table2)
limit 5;
Could you please confirm if this is the expected behavior or any way we can
tune this query to fetch results faster?
Regards
Prabhakar Reddy
Thank you Gopal for this Information.Currently I am using EMR to run this
query.As this operation is CPU intensive could you please let me know if
increasing the RAM/cores can speed up this process?
On Tue, Aug 28, 2018 at 8:56 PM Gopal Vijayaraghavan
wrote:
>
> > Will it be referring to orc met
scan all the files every time.
On Sun, Aug 26, 2018, 4:24 PM Jörn Franke wrote:
> You can partition it and only compute statistics for new partitions...
>
> On 26. Aug 2018, at 12:43, Prabhakar Reddy wrote:
>
> Hello,
>
> Are there any properties that I can set to
same command with few columns then the query runs 60%
faster.Is there any property that I can modify to reduce the time taken for
this read?
Regards
Prabhakar Reddy
