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
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