using huggingface met predict error AttributeError: 'IntegrationDataNode' object has no attribute 'predict'

[chencjiajy]

1. Mindsdb version is 23.8.3.0, installed it locally by pip.
2. when run the totorial: Predicting Text Sentiment with Hugging Face

3. The create model is successful

4. but when I try to test the model:

SELECT *
FROM example_db.sentiment_classifier
WHERE comment = 'I like you. I love you.';

I got error:
'IntegrationDataNode' object has no attribute 'predict'
and the error traceback is

2023-09-04 09:30:36,947 - INFO - Traceback (most recent call last):
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/api/http/namespaces/sql.py", line 40, in post
    result = mysql_proxy.process_query(query)
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/utilities/profiler/profiler.py", line 138, in wrapper
    result = function(*args, **kwargs)
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/api/mysql/mysql_proxy/mysql_proxy.py", line 495, in process_query
    executor.query_execute(sql)
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/utilities/profiler/profiler.py", line 138, in wrapper
    result = function(*args, **kwargs)
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/api/mysql/mysql_proxy/executor/executor.py", line 116, in query_execute
    self.do_execute()
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/utilities/profiler/profiler.py", line 138, in wrapper
    result = function(*args, **kwargs)
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/api/mysql/mysql_proxy/executor/executor.py", line 213, in do_execute
    ret = self.command_executor.execute_command(self.query)
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/utilities/profiler/profiler.py", line 138, in wrapper
    result = function(*args, **kwargs)
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/api/mysql/mysql_proxy/executor/executor_commands.py", line 593, in execute_command
    query = SQLQuery(statement, session=self.session)
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/api/mysql/mysql_proxy/classes/sql_query.py", line 463, in __init__
    self.execute_query()
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/api/mysql/mysql_proxy/classes/sql_query.py", line 685, in execute_query
    raise e
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/api/mysql/mysql_proxy/classes/sql_query.py", line 679, in execute_query
    data = self.execute_step(step, steps_data)
  File "/root/anaconda3/lib/python3.8/site-packages/mindsdb/api/mysql/mysql_proxy/classes/sql_query.py", line 868, in execute_step
    predictions = project_datanode.predict(
AttributeError: 'IntegrationDataNode' object has no attribute 'predict'

[martyna-mindsdb]

Hi @chencjiajy
I tried to reproduce this error using MindsDB 23.8.3.0 installed locally. But I could execute all commands, including querying for predictions, with no errors.

Please note that the model should be stored in one of the projects (not in example_db).

Here is a sample code from this tutorial that you can try executing:

CREATE DATABASE example_db
WITH ENGINE = "postgres",
PARAMETERS = {
    "user": "demo_user",
    "password": "demo_password",
    "host": "3.220.66.106",
    "port": "5432",
    "database": "demo"
    };

SELECT *
FROM example_db.demo_data.user_comments;

-- model is created in the default project called mindsdb
CREATE MODEL sentiment_classifier
PREDICT sentiment
USING engine='huggingface',
  model_name= 'cardiffnlp/twitter-roberta-base-sentiment',
  input_column = 'comment',
  labels=['negative','neutral','positive'];

DESCRIBE sentiment_classifier;

SELECT * FROM sentiment_classifier
WHERE comment='It is really easy to do NLP with MindsDB';

SELECT input.comment, model.sentiment
FROM example_db.demo_data.user_comments AS input
JOIN sentiment_classifier AS model;

Here is the output of DESCRIBE:

[chencjiajy]

Many thanks for your reply! @martyna-mindsdb

After create model in project mindsdb, the error indeed diappear, I can predict successfully. I wonder why must create model in project mindsdb to make model predict successfully.

when I created the model, I met error Project 'example_db' does not exist., so I created a project example_db use create project example_db; , After that , I created a model in project example_db, Then I met the AttributeError: 'IntegrationDataNode' object has no attribute 'predict'

I'm also kind of confused with the relation between project and database。 In document https://docs.mindsdb.com/sql/project ， create a project example is CREATE DATABASE project_alpha;

[chencjiajy]

One can create a model in another project other than the mindsdb, I created a project named 'project_alpha' and could predict successfully.
I guess I met the error because I created a project with the same name as a database, and the structure looks different

[martyna-mindsdb]

@chencjiajy
Thanks for pointing attention to this doc page - it is going to be updated.

Meanwhile, please have a look here: https://docs.mindsdb.com/sql/create/project
There is the CREATE PROJECT statement to create a project. Projects store models and views created in MindsDB.
And the CREATE DATABASE statement is used to connect a data source to MindsDB: https://docs.mindsdb.com/sql/create/database