错误提示
问题描述：
doris2.1.8中两张表
CREATE TABLE orders ( order_id bigint NULL, user_id bigint NULL, product_id bigint NULL, order_time datetime NULL, ship_time datetime NULL, amount double NULL, quantity int NULL, discount float NULL, total decimal(10,2) NULL, order_status text NULL, payment_method text NULL, payment_time datetime NULL, shipping_address text NULL, shipping_zip text NULL, tracking_number text NULL, is_gift boolean NULL, gift_note text NULL, coupon_code text NULL, currency varchar(5) NULL, exchange_rate double NULL, device_id text NULL, app_channel text NULL, order_type tinyint NULL, invoice_required boolean NULL, invoice_title text NULL, loyalty_points int NULL, feedback text NULL, delivery_type text NULL, delivery_eta date NULL, metadata json NULL ) ENGINE=OLAP DUPLICATE KEY(order_id, user_id, product_id) PARTITION BY RANGE(order_time) (PARTITION p202405 VALUES [('0000-01-01 00:00:00'), ('2024-06-01 00:00:00')), PARTITION p202406 VALUES [('2024-06-01 00:00:00'), ('2024-07-01 00:00:00')), PARTITION pMAX VALUES [('2024-07-01 00:00:00'), ('9999-12-31 00:00:00'))) DISTRIBUTED BY HASH(order_id) BUCKETS 10 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "min_load_replica_num" = "-1", "is_being_synced" = "false", "storage_medium" = "hdd", "storage_format" = "V2", "inverted_index_storage_format" = "V1", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false", "group_commit_interval_ms" = "10000", "group_commit_data_bytes" = "134217728" );
CREATE TABLE orders_new ( order_id bigint NULL, user_id bigint NULL, product_id bigint NULL, order_time datetime NULL, ship_time datetime NULL, amount double NULL, quantity int NULL, discount float NULL, total decimal(10,2) NULL, order_status text NULL, payment_method text NULL, payment_time datetime NULL, shipping_address text NULL, shipping_zip text NULL, tracking_number text NULL, is_gift boolean NULL, gift_note text NULL, coupon_code text NULL, currency varchar(5) NULL, exchange_rate double NULL, device_id text NULL, app_channel text NULL, order_type tinyint NULL, invoice_required boolean NULL, invoice_title text NULL, loyalty_points int NULL, feedback text NULL, delivery_type text NULL, delivery_eta date NULL, metadata json NULL ) ENGINE=OLAP DUPLICATE KEY(order_id, user_id, product_id) PARTITION BY RANGE(order_time) (PARTITION p202405 VALUES [('0000-01-01 00:00:00'), ('2024-06-01 00:00:00')), PARTITION p202406 VALUES [('2024-06-01 00:00:00'), ('2024-07-01 00:00:00')), PARTITION pMAX VALUES [('2024-07-01 00:00:00'), ('9999-12-31 00:00:00'))) DISTRIBUTED BY HASH(order_id) BUCKETS 10 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "min_load_replica_num" = "-1", "is_being_synced" = "false", "storage_medium" = "hdd", "storage_format" = "V2", "inverted_index_storage_format" = "V1", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false", "group_commit_interval_ms" = "10000", "group_commit_data_bytes" = "134217728" );
sparksql (spark3.3.2, spark-doris-connector-25.1.0)
CREATE OR REPLACE TEMPORARY VIEW orders8 USING doris OPTIONS('table.identifier'='test1.orders','fenodes'='xx','user'='root','password'='xx','doris.batch.size'='1024');
CREATE OR REPLACE TEMPORARY VIEW orders8_new USING doris OPTIONS('table.identifier'='test1.orders_new','fenodes'='xx','user'='root','password'='xx','doris.batch.size'='1024');
insert into orders8_new select * from orders8 limit 1; 这条sql报错
insert into orders8_new select * from orders8; 这条不报错
doris218 be的错误日志如下：
