search

feast-dev / feast

The Open Source Feature Store for Machine Learning
https://feast.dev
Apache License 2.0
5.48k stars 977 forks source link

Getting error: No schema has been selected to create in LINE 2: CREATE TABLE entities. #4470

Open prk2331 opened 3 weeks ago

prk2331 commented 3 weeks ago

Hi team I am getting error no schema is selected. as observed that while doing "feast apply" this will trying to create "entities" table in "feast_offline" and giving this error but the table is created inside "feast_offline"

File "/mnt/batch/tasks/shared/LS_root/mounts/clusters/mlopscp/code/Users/puneet.makhija/feast-env/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
  File "/mnt/batch/tasks/shared/LS_root/mounts/clusters/mlopscp/code/Users/puneet.makhija/feast-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
    self.dialect.do_execute(
  File "/mnt/batch/tasks/shared/LS_root/mounts/clusters/mlopscp/code/Users/puneet.makhija/feast-env/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InvalidSchemaName) no schema has been selected to create in
LINE 2: CREATE TABLE entities (
                     ^

[SQL: 
CREATE TABLE entities (
        entity_name VARCHAR(50) NOT NULL, 
        project_id VARCHAR(50) NOT NULL, 
        last_updated_timestamp BIGINT NOT NULL, 
        entity_proto BYTEA NOT NULL, 
        PRIMARY KEY (entity_name, project_id)
)

]
(Background on this error at: https://sqlalche.me/e/14/f405)
shuchu commented 1 day ago

what offline store are you using, and what's the Feast version?