feast icon indicating copy to clipboard operation
feast copied to clipboard

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

Open prk2331 opened this issue 6 months ago • 1 comments

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)

prk2331 avatar Aug 30 '24 14:08 prk2331