Re:Re: How to force sorted merge join to broadcast join

2019-07-29 Thread Rubén Berenguel
I think there is no way of doing that (at least don't remember one right now). The closer I remember now, is you can run the SQL "ANALYZE TABLE table_name COMPUTE STATISTIC" to compute them regardless of having a query (also hints the cost based optimiser if I remember correctly), but as far as dis

Re:Re: How to force sorted merge join to broadcast join

2019-07-29 Thread zhangliyun
thks! after using the syntax provided in the link, select /*+ BROADCAST (A) */ ... , i got what i want. but i want to ask beside using queryExecution.stringWithStats (dataframe api) to show the table statistics, is there any way to show the table statistics in explain xxx in spark sql command l