Cannot create model

[radiantone]

Does this SDK work at all? Seems like its broken

Tried to create a model using a simple SQL query "select * from prices" and looks like its introducing parens or something.

• Python version: 3.10.12

• Operating system: Pop!_OS(Ubuntu) 22.04

• Mindsdb Python SDK version:
  mindsdb-sdk==1.0.4
  mindsdb-sql==0.6.7

• Additional info if applicable:

Please describe your issue and how we can replicate it

File "/home/darren/PycharmProjects/pyfi/pyfi/server/api.py", line 1747, in create_model
project.create_model(name=model, predict=data["column"], query=data['query'])
File "/home/darren/PycharmProjects/pyfi/venv/lib/python3.10/site-packages/mindsdb_sdk/project.py", line 410, in create_model
df = self.query(ast_query.to_string()).fetch()
File "/home/darren/PycharmProjects/pyfi/venv/lib/python3.10/site-packages/mindsdb_sdk/query.py", line 29, in fetch
return self.api.sql_query(self.sql, self.database)
File "/home/darren/PycharmProjects/pyfi/venv/lib/python3.10/site-packages/mindsdb_sdk/connectors/rest_api.py", line 11, in wrapper
return fnc(self, *args, **kwargs)
File "/home/darren/PycharmProjects/pyfi/venv/lib/python3.10/site-packages/mindsdb_sdk/connectors/rest_api.py", line 82, in sql_query
raise RuntimeError(data['error_message'])
RuntimeError: SQL statement cannot be parsed by mindsdb_sql - CREATE PREDICTOR modeltest (select * from prices) PREDICT prices: Syntax error at token LPAREN: "("

[ZoranPandovski]

Can you share the code example please?

[ea-rus]

@radiantone, here is data['query'] a string?
project.create_model(name=model, predict=data["column"], query=data['query'])

If yes, you need to add 'database' param. If query have to be executed in context of mindsdb, please add database='mindsdb'. It should help

[ea-rus]

Let's close it and open again when we have more information

[kiuyaku]

Let's close it and open again when we have more information
@ea-rus

Hi sir, I can't create a model either, I get an error after using models.create.

• Python version: 3.11
• SDK version: 2.4.4
• mindsdb container: mindsdb/mindsdb:cloud

ERROR:
“”“

CREATE PREDICTOR my_project.my_model (SELECT * FROM my_db.my_article) PREDICT id
----------------------------------------^
Expected symbol: "PREDICT"
”“”

I've looked for a lot of examples and issues that can't solve my problem.

Here's my code:
I want to use the default engine and insert my data to create a model.
Is the following usage correct? Or are there other steps?
Can you please help me see where the error is? Thank you sosososososososo much.

CODE
"""
project = server.get_project('my_project')
table = mysql_db.tables.get('my_article')
model = project.models.create(
'my_model',
predict='id',
query=table,
)
"""

[ea-rus]

@kiuyaku, please try to update mindsdb_sql to the latest version

[ea-rus]

This could be the cause: #129

[kiuyaku]

@kiuyaku, please try to update mindsdb_sql to the latest version

OK! thank you very much!