[GitHub] [incubator-doris] zhangy5 opened a new issue #2478: a problem when parse column data from hdfs path

[GitBox <gi...@apache.org>]

zhangy5 opened a new issue #2478: a problem when parse column data from hdfs path 
URL: https://github.com/apache/incubator-doris/issues/2478
 
 
   
   **To Reproduce**
   create table like:
   CREATE DATABASE test_sys_load_parse_from_path_test_parse_wrong_type_db;
   
   CREATE TABLE test_sys_load_parse_from_path_test_parse_wrong_type_db.test_sys_load_parse_from_path_test_parse_wrong_type_tb ( k1 TINYINT NULL, k2 SMALLINT NULL, k3 INT NULL, k4 BIGINT NULL, k5 DATETIME NULL, v1 DATE REPLACE NULL, v2 CHAR REPLACE NULL, v3 VARCHAR(4096) REPLACE NULL, v4 FLOAT SUM NULL, v5 DOUBLE SUM NULL, v6 DECIMAL(20,7) SUM NULL ) AGGREGATE KEY (k1, k2, k3, k4, k5) PARTITION BY RANGE(k1) ( PARTITION partition_a VALUES LESS THAN ("5"), PARTITION partition_b VALUES LESS THAN ("20"), PARTITION partition_c VALUES LESS THAN ("30"), PARTITION partition_d VALUES LESS THAN MAXVALUE ) DISTRIBUTED BY HASH(k2) BUCKETS 5;
   
   load sql is :
   LOAD LABEL test_sys_load_parse_from_path_test_parse_wrong_type_db.label_17_04_39_52_077258_128914487 (DATA INFILE("hdfs://hosti:ip/user/palo/test/data/sys/broker_load/k1=-1/k2=0/k5=100.12345/partition_type") INTO TABLE `test_sys_load_parse_from_path_test_parse_wrong_type_tb` (`k1`, `k2`, `k3`, `k4`, `tmp_k5`, `v1`, `v2`, `v3`, `v4`, `v5`, `v6`) COLUMNS FROM PATH AS (k5)) WITH BROKER "hdfs" ("username"="root", "password"="");
   
   ** Problem **
   k5 is datetime and the data parsed from hdfs path is 100.12345, this load job is expected to be cacenlled. But it is finished, and k5 is null. 
   Broker load without strict mode property, the default strict mode is true, but it doesn’t look like it.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org