-- E-M1 · Preparación común (run.py la antepone a cada fichero). Datos en solo lectura (/d :ro). SET memory_limit='7GB'; SET threads=6; SET temp_directory='/w/tmp/duckdb_tmp'; SET preserve_insertion_order=false; CREATE OR REPLACE TEMP VIEW u AS SELECT * FROM read_parquet('/d/unified_20261018/**/*.parquet', hive_partitioning=true, union_by_name=true); CREATE OR REPLACE TEMP VIEW vf AS SELECT * FROM read_parquet('/d/unified_20261018.vinculos/filas.parquet'); CREATE OR REPLACE TEMP VIEW af AS SELECT * FROM read_parquet('/d/unified_20261018.identidad/adjudicatarios_filas.parquet'); CREATE OR REPLACE TEMP VIEW ofi AS SELECT * FROM read_parquet('/d/unified_20261018.identidad/organos_filas.parquet'); CREATE OR REPLACE TEMP VIEW org_id AS SELECT * FROM read_parquet('/d/unified_20261018.identidad/organos.parquet'); CREATE OR REPLACE TEMP VIEW org_tipo AS SELECT * FROM read_parquet('/d/unified_20261018.identidad/organos_tipo.parquet');