Hi Olivier,
Here it is.
== Physical Plan ==
Aggregate false, [PartialGroup#155], [PartialGroup#155 AS
is_bad#108,Coalesce(SUM(PartialCount#152L),0) AS
count#109L,(CAST(SUM(PartialSum#153), DoubleType) /
CAST(SUM(PartialCount#154L), DoubleType)) AS avg#110]
Exchange (HashPartitioning [PartialGrou
can you post the explain too ?
Le mar. 12 mai 2015 à 12:11, Jianshi Huang a
écrit :
> Hi,
>
> I have a SQL query on tables containing big Map columns (thousands of
> keys). I found it to be very slow.
>
> select meta['is_bad'] as is_bad, count(*) as count, avg(nvar['var1']) as
> avg
> from test
