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
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 im
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
are there 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