Managed models

Instance version requirements

Managed models require a supported Hologres instance version.

Upgrade your instance from the Hologres console if needed.

Supported regions

Available regions:

• China (Beijing)

• China (Shanghai)

• China (Hangzhou)

• China (Shenzhen)

• Singapore

Purchase model resources

Purchase Hologres AI model resources from the AI model resource purchase page before using managed models.

When purchasing resources, note:

• Pay-as-you-go: Billed based on actual usage with no upfront fees.

• Region selection: Select the same region as your Hologres instance to avoid cross-region charges.

• Billing dimensions: Billing units vary by model: token count, image count, video duration, or audio duration.

Pricing details

For per-model pricing, see Managed models billing.

Model catalog

Hologres managed models support text generation, translation, embedding, image generation/editing, speech-to-text, and video generation.

Deploy a model

After purchasing model resources, deploy managed models from the Hologres console:

1. Log on to the Hologres console and go to the details page of the target instance.

2. In the left-side navigation pane, choose AI Model to open the model management page.

3. Click Deploy Model.

4. Set the model provider to Hologres-managed model.

5. Select the model categories you need. You can deploy multiple models at once.

6. Configure parameters for each model (defaults usually work) and set the retry mechanism.

7. Click Confirm to complete the deployment.

8. After deployment, view deployed models and their status on the model list page.

Use managed models

After deployment, call models through SQL AI Functions. Hologres provides AI Functions for text generation, embedding, translation, image understanding, speech-to-text, and video generation. For the full list and usage details, see AI functions.

The system assigns a default model to each AI Function. To view the current mapping:

SELECT * FROM list_ai_function_infos();

Sample output:

    function_name     |    model_name
----------------------+------------------
 ai_embed             | my_gte_embedding
 ai_classify          | my_qwen32b
 ai_extract           | my_qwen32b

To change the default model for an AI Function:

SELECT set_ai_function_info('<FUNCTION_NAME>', '<MODEL_NAME>');

Example:

SELECT set_ai_function_info('ai_embed', 'my_gte_embedding');

1. Purchase model resources

Purchase Hologres AI model resources from the AI model resource purchase page. Billing is pay-as-you-go based on actual usage.

2. Deploy the models

After purchasing resources, open the instance details page in the Hologres console, go to the AI Model tab, select Hologres-managed model as the provider, and deploy the models you need.

This example deploys the following models for the AI Function calls in step 3:

• qwen3.7-plus: Text generation model for inference tasks.

• text-embedding-v4: Embedding model for vector representations.

3. Call AI Functions

After deployment, call models through SQL AI Functions. For the full list and usage details, see AI functions.

Example 1: Text inference (with qwen3.7-plus)

-- Use a managed model for text generation
SELECT ai_gen('qwen3.7-plus', 'Generate an engaging description for the following product: wireless noise-cancelling headphones');

Example 2: Embedding (with text-embedding-v4)

-- Use a managed model to generate embeddings
SELECT ai_embed('text-embedding-v4', 'Hologres is a real-time data warehouse product');