-- Preparación común de cada script de P9 (la carga run.py antes del fichero; {F} = la construcción, por defecto 20261018) 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_{F}/**/*.parquet', hive_partitioning=true, union_by_name=true); CREATE OR REPLACE TEMP VIEW vf AS SELECT * FROM read_parquet('/d/unified_{F}.vinculos/filas.parquet'); CREATE OR REPLACE TEMP VIEW af AS SELECT * FROM read_parquet('/d/unified_{F}.identidad/adjudicatarios_filas.parquet'); CREATE OR REPLACE TEMP VIEW ofi AS SELECT * FROM read_parquet('/d/unified_{F}.identidad/organos_filas.parquet'); CREATE OR REPLACE TEMP VIEW org_id AS SELECT * FROM read_parquet('/d/unified_{F}.identidad/organos.parquet');