I use docker image postgres:latest (postgres version is 16.0) to run ./tpch_pgsql.py load command, and I get the result unable to run load tables. relation "LINEITEM" does not exist. This error is due to table name uppercase and lowercase mismatch. Specifically, the variable TABLES defined in ./tpch_pgsql.py is uppercase, but the table name loaded in the database is lowercase.
I use docker image
postgres:latest(postgres version is 16.0) to run./tpch_pgsql.py loadcommand, and I get the resultunable to run load tables. relation "LINEITEM" does not exist. This error is due to table name uppercase and lowercase mismatch. Specifically, the variableTABLESdefined in ./tpch_pgsql.py is uppercase, but the table name loaded in the database is lowercase.