2026-04-11 10:42:47 - __main__ - INFO - ============================================================
2026-04-11 10:42:47 - __main__ - INFO - ImdbUpdate v2 - Avvio (DuckDB pipeline)
2026-04-11 10:42:47 - __main__ - INFO - ============================================================
2026-04-11 10:42:47 - __main__ - INFO - Base directory: C:\PYTHON\ImdbUpdate
2026-04-11 10:42:47 - __main__ - INFO - Temp directory: C:\PYTHON\ImdbUpdate\Temp
2026-04-11 10:42:47 - __main__ - INFO - Parquet output: C:\PYTHON\ImdbUpdate\parquet\imdb.parquet
2026-04-11 10:42:47 - __main__ - WARNING - Download saltato - uso file esistenti in Temp/
2026-04-11 10:42:47 - __main__ - INFO - ============================================================
2026-04-11 10:42:47 - __main__ - INFO - FASE 3: Transform DuckDB → imdb.parquet
2026-04-11 10:42:47 - __main__ - INFO - ============================================================
2026-04-11 10:42:47 - src.transformer - INFO - Caricamento title_basics: title_basics.txt
2026-04-11 10:42:49 - src.transformer - INFO -   title_basics: 1,264,057 righe (filtrate per titleType)
2026-04-11 10:42:49 - src.transformer - INFO - Caricamento title_akas: title_akas.txt
2026-04-11 10:42:56 - src.transformer - INFO -   title_akas: 5,321,724 righe (solo region=IT)
2026-04-11 10:42:56 - src.transformer - INFO - Caricamento title_ratings: title_ratings.txt
2026-04-11 10:42:56 - src.transformer - INFO -   title_ratings: 1,658,155 righe
2026-04-11 10:42:56 - src.transformer - INFO - Caricamento title_principals: title_principals.txt
2026-04-11 10:43:08 - src.transformer - INFO -   title_principals: 31,768,337 righe (director+actor)
2026-04-11 10:43:08 - src.transformer - INFO - Caricamento name_basics: name_basics.txt
2026-04-11 10:43:10 - src.transformer - INFO -   name_basics: 15,225,343 righe
2026-04-11 10:43:10 - src.transformer - INFO - Caricamento OTT da: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\db_split_OTT.accdb
2026-04-11 10:43:45 - src.transformer - INFO -   OTT caricata: 326,017 righe
2026-04-11 10:43:45 - src.transformer - INFO - Costruzione new_imdb (step separati)...
2026-04-11 10:43:45 - src.transformer - INFO -   Step 1/5: titoli italiani
2026-04-11 10:43:45 - src.transformer - INFO -   Step 2/5: registi
2026-04-11 10:44:19 - src.transformer - INFO -   Step 3/5: attori
2026-04-11 10:44:36 - __main__ - ERROR - Errore fatale: Out of Memory Error: failed to allocate data of size 16.0 MiB (3.7 GiB/3.7 GiB used)

Possible solutions:
* Reducing the number of threads (SET threads=X)
* Disabling insertion-order preservation (SET preserve_insertion_order=false)
* Increasing the memory limit (SET memory_limit='...GB')

See also https://duckdb.org/docs/stable/guides/performance/how_to_tune_workloads
Traceback (most recent call last):
  File "C:\PYTHON\ImdbUpdate\main.py", line 255, in main
    if not transform_and_export_parquet(files):
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\PYTHON\ImdbUpdate\main.py", line 86, in transform_and_export_parquet
    row_count = transformer.transform(files)
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\PYTHON\ImdbUpdate\src\transformer.py", line 60, in transform
    self._build_new_imdb()
  File "C:\PYTHON\ImdbUpdate\src\transformer.py", line 228, in _build_new_imdb
    self._con.execute(f"""
_duckdb.OutOfMemoryException: Out of Memory Error: failed to allocate data of size 16.0 MiB (3.7 GiB/3.7 GiB used)

Possible solutions:
* Reducing the number of threads (SET threads=X)
* Disabling insertion-order preservation (SET preserve_insertion_order=false)
* Increasing the memory limit (SET memory_limit='...GB')

See also https://duckdb.org/docs/stable/guides/performance/how_to_tune_workloads