-- @comparación unidad a unidad: SQL (unc, U1) frente a pandas (impl2, población uf) WITH a AS (SELECT unit, est365 est, aviso365 aviso FROM unc WHERE u1), b AS (SELECT unit, est, aviso FROM read_parquet('/c/interno/impl2_unidades_uf.parquet')) SELECT coalesce(a.est,'-') sql_est, coalesce(b.est,'-') pandas_est, count(*) n, sum((a.aviso IS DISTINCT FROM b.aviso)::INT) aviso_distinto FROM a FULL JOIN b USING (unit) GROUP BY 1,2 ORDER BY 3 DESC