Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Cannot use query with LAST when fine-tuning a model #9051

Open
martyna-mindsdb opened this issue Apr 10, 2024 · 0 comments · May be fixed by #9135
Open

[Bug]: Cannot use query with LAST when fine-tuning a model #9051

martyna-mindsdb opened this issue Apr 10, 2024 · 0 comments · May be fixed by #9135
Assignees
Labels
bug Something isn't working

Comments

@martyna-mindsdb
Copy link
Collaborator

Short description of current behavior

Problem
When fine-tuning a model and passing a query with LAST, it results in an error:

FINETUNE regression_model
FROM local_postgres
    (SELECT *
    FROM demo.home_rentals
    WHERE created_at > LAST);

Error:

Exception: Error in local_postgres: column "last" does not exist

Workaround
A workaround is to create a view and use it in FINETUNE:

CREATE VIEW last_rentals (
SELECT *
    FROM local_postgres.demo.home_rentals
    WHERE created_at > LAST
);

FINETUNE regression_model
FROM mindsdb
    (SELECT *  FROM last_rentals);

Possible solution
Allow FINETUNE to work like this:

FINETUNE regression_model
FROM (SELECT *
      FROM local_postgres.demo.home_rentals
      WHERE created_at > LAST);

Video or screenshots

No response

Expected behavior

No response

How to reproduce the error

No response

Anything else?

No response

@martyna-mindsdb martyna-mindsdb added the bug Something isn't working label Apr 10, 2024
@ea-rus ea-rus linked a pull request Apr 25, 2024 that will close this issue
11 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants