embucket-labs
embucket-labs copied to clipboard
Unclear error on unsupported datatype in create table sql
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
)