[Bug] VARIANT doesn't exist in 2.1.1 version

[emahdij]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Version

operator image: selectdb/doris.k8s-operator:1.4.1 Doris images: selectdb/doris.fe-ubuntu:2.1.1 selectdb/doris.be-ubuntu:2.1.1

What's Wrong?

Hi folks I’ve installed Apache Doris in k8s by selectdb operator. When I want to create a table with a VARIANT variable I will get this error:

CREATE TABLE IF NOT EXISTS ${table_name} (
    k BIGINT,
    v VARIANT
)
table_properties;
no viable alternative at input 'VARIANT'(line 1, pos 53)

This is the version that MySQL command tells me:

Server version: 5.7.99 Doris version doris-2.1.1-rc05-9f2520537f

What You Expected?

I expect to create table with VARIANT variable.

How to Reproduce?

This is the

Anything Else?

No response

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[eldenmoon]

your sql is syntacticly wrong，you should use full sql like :

CREATE DATABASE test_variant;
USE test_variant;
CREATE TABLE IF NOT EXISTS github_events (
    id BIGINT NOT NULL,
    type VARCHAR(30) NULL,
    actor VARIANT NULL,
    repo VARIANT NULL,
    payload VARIANT NULL,
    public BOOLEAN NULL,
    created_at DATETIME NULL,
    INDEX idx_payload (`payload`) USING INVERTED PROPERTIES("parser" = "english") COMMENT 'inverted index for payload'
)
DUPLICATE KEY(`id`)
DISTRIBUTED BY HASH(id) BUCKETS 10
properties("replication_num" = "1");

referer to https://doris.apache.org/docs/sql-manual/sql-reference/Data-Types/VARIANT