embucket-labs icon indicating copy to clipboard operation
embucket-labs copied to clipboard

Unclear error on unsupported datatype in create table sql

Open YaroslavLitvinov opened this issue 5 months ago • 0 comments

Getting non-clear error: 000200: 200: SQL compilation error: unsupported feature: Unsupported SQL type Character(Some(IntegerLength { length: 10, unit: None }))

Expected error, as in Snowflake: 001003 (42000): 01bdbb3d-0003-340a-0004-d66e02cf2262: SQL compilation error: syntax error line 46 at position 42 unexpected '('.

error stack trace:

0: DataFusion error: This feature is not implemented: Unsupported SQL type Character(Some(IntegerLength { length: 10, unit: None })), at crates/core-executor/src/query.rs:1638:14
1: NotImplemented("Unsupported SQL type Character(Some(IntegerLength { length: 10, unit: None }))")

When running statement like:

CREATE TABLE __DATABASE__.__SCHEMA__.all_snowflake_types (
        -- Numeric Types
        col_number NUMBER,
        col_decimal DECIMAL(10,2),
        col_numeric NUMERIC(10,2),
        col_int INT,
        col_integer INTEGER,
        col_bigint BIGINT,
        col_smallint SMALLINT,
        col_float FLOAT,
        col_float4 FLOAT4,
        col_float8 FLOAT8,
        col_double DOUBLE,
        col_double_precision DOUBLE PRECISION,
        col_real REAL,

        -- String Types
        col_char CHAR(10),
        col_character CHARACTER(10),
        col_varchar VARCHAR(255),
        col_string STRING,
        col_text TEXT,

        -- Boolean
        col_boolean BOOLEAN,

        -- Date & Time Types
        col_date DATE,
        col_time TIME,
        col_timestamp TIMESTAMP,
        col_timestamp_ltz TIMESTAMP_LTZ,
        col_timestamp_ntz TIMESTAMP_NTZ,
        col_timestamp_tz TIMESTAMP_TZ,
        col_datetime DATETIME,

        -- Semi-structured
        col_variant VARIANT,
        col_object OBJECT,
        col_array ARRAY,

        -- Binary
        col_binary BINARY,
        col_varbinary VARBINARY,

        -- Geography (optional feature)
        col_geography GEOGRAPHY
    )

YaroslavLitvinov avatar Jul 16 '25 16:07 YaroslavLitvinov