tpch-pgsql icon indicating copy to clipboard operation
tpch-pgsql copied to clipboard
verified publisher icon Data-Science-Platform

unable to run load tables. relation "LINEITEM" does not exist

Open hijackthe2 opened this issue 2 years ago • 1 comments

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.

hijackthe2 avatar Nov 14 '23 04:11 hijackthe2

Ah, I see someone found this error before #23 , however that pr is blocked for sometime😅.

hijackthe2 avatar Nov 14 '23 04:11 hijackthe2