Can not show all model and remove model

[BsoBird]

duckdb:1.3.2

create model {
'Test01Model12',
'xxx',
'xxx',
{"tuple_format": "json", "batch_size": "32", "model_parameters": {"temperature": "1.0"}}
}; -- okay, can success

GET MODELS;
--Invalid Error: Expected non-empty string literal for model name.

GET MODEL 'Test01Model12';
--Invalid Error: Unexpected characters after the model name. Only a semicolon is allowed.

GET MODEL Test01Model12
--Invalid Error: Expected non-empty string literal for model name.

DELETE MODEL "Test01Model12"
--Invalid Error: Expected non-empty string literal for model name.

DELETE MODEL Test01Model12
--Invalid Error: Expected non-empty string literal for model name.

DELETE MODEL 'Test01Model12'
--Invalid Error: Unexpected characters after the closing parenthesis. Only a semicolon is allowed.

SELECT llm_complete(
{'model_name': 'Test01Model12'},
{'prompt': 'Talk like a duck 🦆 and explain what a database is 📚'}
);
--Invalid Error: [json.exception.type_error.302] type must be string, but is null

[anasdorbani]

Thank you @BsoBird for reporting that. We’ve been working on fixing the issue; it was a bug from our end, and we’ve now deployed the latest release of FlockMTL, which is v0.3.1.

You can reinstall and verify the setup using the following query:

FORCE INSTALL flockmtl FROM community;
LOAD flockmtl;
SELECT
  CASE
    WHEN extension_version = 'e26d2ed' THEN 'FlockMTL v0.3.1 is installed and up to date.'
    ELSE 'FlockMTL v0.3.1 is not yet deployed to your region. Please wait for availability.'
  END AS status_message
FROM duckdb_extensions() 
WHERE extension_name = 'flockmtl';

Please check the function again and let us know if you encounter any further bugs or issues. We appreciate your feedback and hope you enjoy using FlockMTL!

[BsoBird]

extension_version = '303249f'
i have executed FORCE INSTALL flockmtl FROM community;
@anasdorbani

[anasdorbani]

@BsoBird Thanks for your interest! DuckDB deploys extensions based on region and platform, so it typically takes a few hours for the update to become available in your area. Sorry about that :')

[BsoBird]

@anasdorbani
Hello. Since DUCKDB v1.3.0+ has ceased support for GCC 4 systems, the version of DuckDB used by many of our users remains stuck at 1.2.2.0. Could the flockmtl library provide support for version 1.2.2.0 for a certain period? We hope to use the fully functional flockmtl library on version 1.2.2.0.

[anasdorbani]

@BsoBird This is an important issue, and we are actively working on a solution by providing manual binaries that users can install themselves. Currently, since the deployment of extensions is managed by the DuckDB team, new versions of FlockMTL are only automatically available for the most recent DuckDB releases. This means updates and new features for FlockMTL will generally be limited to the DuckDB versions that the team officially supports.

To help us better track and prioritize this request, could you please open a GitHub issue? This will enable us to explore making FlockMTL available for multiple DuckDB versions, including 1.2.2.0, and keep you updated on any progress.

[BsoBird]

@anasdorbani
Hello, I found that my flockmtl version has been updated to e26d2ed, but the issue still persists.
If possible, could you tell me which version of duckdb can work properly with flockmtl?

[anasdorbani]

Hi @BsoBird, sorry for the confusion earlier. I reviewed your queries and found a few minor issues, mainly some missing ";" or "(" symbols. I’ve gone ahead and revised the queries, and the updated version should now work correctly. And to answer your question, I'm using DuckDB v1.3.2

Could you please try it out and let me know if it works for you? Also, could you let me know which platform you're working on (e.g., Python, Linux CLI, macOS CLI, or Windows CLI)?

I hope this resolves your issue!

-- Install and load the `flockmtl` extension from the community repo
FORCE INSTALL flockmtl FROM community;
LOAD flockmtl;

-- confirm that you have the latest `flockmtl` version
SELECT
  CASE
    WHEN extension_version = 'e26d2ed' THEN 
      'FlockMTL v0.3.1 is installed and up to date.'
    ELSE 
      'FlockMTL v0.3.1 is not yet deployed to your region. Please wait for availability.'
  END AS status_message
FROM duckdb_extensions()
WHERE extension_name = 'flockmtl';

-- Create the OpenAI secret
CREATE SECRET (
  type OPENAI,
  API_KEY 'your-api-key'
);

-- Create the model
CREATE MODEL (
  'Test01Model12',
  'gpt-4o',
  'openai',
  {"tuple_format": "JSON", "batch_size": 32, "model_parameters": {"temperature": 1.0}}
);

-- Get details about the specific model
GET MODEL 'Test01Model12';

-- Run inference using the model
SELECT llm_complete(
  {'model_name': 'Test01Model12'},
  {'prompt': 'Talk like a duck 🦆 and explain what a database is 📚'}
);

-- List all models
GET MODELS;

-- Delete the model
DELETE MODEL 'Test01Model12';

-- Confirm deletion by listing models again
GET MODELS;

[BsoBird]

@anasdorbani I am using dbeaver with duckdb_java+duckdb_jdbc to operate duckdb. My operating system is windows. Currently, I am clearing all the data and reloading.

[anasdorbani]

@BsoBird Thanks for the information. I tried to reproduce the error, but I wasn't able to because DuckDB hasn’t implemented the GetAlterInfo method for Java on osx_arm64. So I can’t confirm whether your issue is caused by a bug in the flockmtl extension or in DuckDB itself.

What I suggest is trying to run the same setup using the DuckDB CLI on Windows, or using a Python script with the DuckDB Python package. Let me know if you need help setting that up. In the meantime, I’ll continue investigating the issue on my end.

[BsoBird]

I found that it seems duckdb_java cannot use flockmtl? I can use it normally with windows cli.
In dbeaver, initially I couldn't execute commands like GET MODELS. After testing windows_cli and restarting dbeaver, now dbeaver can't load flockmtl.
@anasdorbani

[anasdorbani]

@BsoBird Thanks for pointing that out. Yes, we're currently investigating the issue with duckdb_java and its compatibility with flockmtl. I'll keep you updated and let you know as soon as we have a solution.

[anasdorbani]

@BsoBird, Just wanted to let you know that your issue has been resolved. You can verify the setup using the following queries:

FORCE INSTALL flockmtl FROM community;

LOAD flockmtl;

SELECT
  CASE
    WHEN extension_version = 'be6192f' THEN 'FlockMTL v0.3.1 is installed and up to date.'
    ELSE 'FlockMTL v0.3.1 is not yet deployed to your region. Please wait for availability.'
  END AS status_message
FROM duckdb_extensions() 
WHERE extension_name = 'flockmtl';

GET PROMPTS;

Results

I tested everything on my end, and it's working fine now. The issue was caused by a parsing inconsistency between different DuckDB platforms, which wasn't previously handled in FlockMTL. That's now been addressed.

Let me know if you run into any other issues or have suggestions for improvement. I'm happy to hear your feedback!

[BsoBird]

@anasdorbani Tks. I tested it, and it's indeed working normally now.