search

mindsdb / mindsdb_sql

SQL parser and planner used by MindsDB
https://mindsdb.com
GNU General Public License v3.0
55 stars 21 forks source link

Condition to model in join: exclude predict target #347

Closed ea-rus closed 8 months ago

ea-rus commented 8 months ago

Update of: https://github.com/mindsdb/mindsdb_sql/pull/327 (https://github.com/mindsdb/mindsdb/issues/5379)

If column is a model output (like in example below), don't use it as input to model. Keep it as filter

   SELECT *  FROM yt.comments c
    JOIN yt_sentiment_classifier AS m
    WHERE m.sentiment = 'positive';
chandrevdw31 commented 8 months ago

works

Image