github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/table/external_table.result (about) 1 drop table if exists ex_table_1; 2 drop table if exists ex_table_2_1; 3 drop table if exists ex_table_2_2; 4 drop table if exists ex_table_2_3; 5 drop table if exists ex_table_2_4; 6 drop table if exists ex_table_2_5; 7 drop table if exists ex_table_2_6; 8 drop table if exists ex_table_2_7; 9 drop table if exists ex_table_2_8; 10 drop table if exists ex_table_2_9; 11 drop table if exists ex_table_2_10; 12 drop table if exists ex_table_2_11; 13 drop table if exists ex_table_2_12; 14 drop table if exists ex_table_2_13; 15 drop table if exists ex_table_2_14; 16 drop table if exists ex_table_2_15; 17 drop table if exists ex_table_2_16; 18 drop table if exists ex_table_2_17; 19 drop table if exists ex_table_2_18; 20 drop table if exists ex_table_2_19; 21 drop table if exists ex_table_3; 22 drop table if exists ex_table_3_1; 23 drop table if exists ex_table_3_2; 24 drop table if exists ex_table_3_3; 25 drop table if exists ex_table_3_4; 26 drop table if exists ex_table_3_5; 27 drop table if exists ex_table_31; 28 drop table if exists ex_table_4; 29 drop table if exists ex_table_5; 30 drop table if exists ex_table_6; 31 drop table if exists ex_table_6a; 32 drop table if exists ex_table_7; 33 drop table if exists ex_table_8; 34 drop table if exists ex_table_9; 35 drop table if exists ex_table_10; 36 drop table if exists ex_table_10a; 37 drop table if exists ex_table_11; 38 drop table if exists ex_table_12; 39 drop table if exists ex_table_13; 40 drop table if exists ex_table_14; 41 drop table if exists ex_table_text; 42 drop table if exists ex_table_log; 43 drop table if exists ex_table_gzip; 44 drop table if exists ex_table_bzip2; 45 drop table if exists ex_table_lz4; 46 drop table if exists ex_table_auto; 47 drop table if exists ex_table_none; 48 drop table if exists ex_table_nocomp; 49 drop table if exists ex_table_cp1; 50 drop table if exists ex_table_cp2; 51 drop table if exists ex_table_15; 52 drop table if exists ex_table_drop; 53 drop table if exists table_15; 54 drop table if exists table_16; 55 drop table if exists ex_table_yccs; 56 drop table if exists ex_table_null; 57 create external table ex_table_1(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double,num_col11 decimal(38,19)) infile{"filepath"='$resources/external_table_file/ex_table_number.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 58 select * from ex_table_1; 59 num_col1 num_col2 num_col3 num_col4 num_col5 num_col6 num_col7 num_col8 num_col9 num_col10 num_col11 60 60 -1000 8403 -10934535423423 200 1 673892 8374 73.98 9.0002 8345398234.9838234985858298432 61 -128 -32768 -2147483648 -9223372036854775808 0 0 0 0 null -1.7976931348623157E308 9345.4535000000000000000 62 127 32767 2147483647 9223372036854775807 255 65535 4294967295 18446744073709551615 null 1.7976931348623157E308 883453.0999320000000000000 63 null null null null null null null null null null null 64 create external table ex_table_2_1(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_1.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 65 select * from ex_table_2_1; 66 internal error: the input value 'abc' is not int8 type for column 0 67 create external table ex_table_2_2(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_2.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 68 select * from ex_table_2_2; 69 internal error: the input value 'cd' is not int16 type for column 1 70 create external table ex_table_2_3(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_3.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 71 select * from ex_table_2_3; 72 internal error: the input value 'e' is not int32 type for column 2 73 create external table ex_table_2_4(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_4.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 74 select * from ex_table_2_4; 75 internal error: the input value 'i' is not int64 type for column 3 76 create external table ex_table_2_5(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_5.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 77 select * from ex_table_2_5; 78 internal error: the input value 'u' is not uint8 type for column 4 79 create external table ex_table_2_6(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_6.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 80 select * from ex_table_2_6; 81 internal error: the input value '中文' is not uint16 type for column 5 82 create external table ex_table_2_7(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_7.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 83 select * from ex_table_2_7; 84 internal error: the input value '%*' is not uint32 type for column 6 85 create external table ex_table_2_8(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_8.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 86 select * from ex_table_2_8; 87 internal error: the input value '0op' is not uint64 type for column 7 88 create external table ex_table_2_9(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_9.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 89 select * from ex_table_2_9; 90 internal error: the input value 'er众' is not float32 type for column 8 91 create external table ex_table_2_10(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_10.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 92 select * from ex_table_2_10; 93 internal error: the input value 'abc' is not float64 type for column 9 94 create external table ex_table_2_11(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_11.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 95 select * from ex_table_2_11; 96 internal error: the input value '纸123' is invalid Decimal128 type for column 10 97 create external table ex_table_2_12(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_12.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 98 select * from ex_table_2_12; 99 internal error: the input value '128' is not int8 type for column 0 100 create external table ex_table_2_13(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_13.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 101 select * from ex_table_2_13; 102 internal error: the input value '-32769' is not int16 type for column 1 103 create external table ex_table_2_14(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_14.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 104 select * from ex_table_2_14; 105 internal error: the input value '2147483648' is not int32 type for column 2 106 create external table ex_table_2_15(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_15.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 107 select * from ex_table_2_15; 108 internal error: the input value '9223372036854775808' is not int64 type for column 3 109 create external table ex_table_2_16(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_16.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 110 select * from ex_table_2_16; 111 internal error: the input value '-1' is not uint8 type for column 4 112 create external table ex_table_2_17(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_17.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 113 select * from ex_table_2_17; 114 internal error: the input value '65536' is not uint16 type for column 5 115 create external table ex_table_2_18(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_18.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 116 select * from ex_table_2_18; 117 internal error: the input value '4294967296' is not uint32 type for column 6 118 create external table ex_table_2_19(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19))infile{"filepath"='$resources/external_table_file/ex_table_2_19.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 119 select * from ex_table_2_19; 120 internal error: the input value '-2.7976931348623157E+308' is not float64 type for column 9 121 create external table ex_table_3(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_char.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 122 select char_1,char_2,date_1,date_2 from ex_table_3; 123 char_1 char_2 date_1 date_2 124 cat yellow 芝士 2020-10-09 0001-01-01 00:00:00 125 123木头人 zt@126.com 1000-01-01 9999-12-31 00:00:00 126 abc$%*()#$ ttttt 9999-12-31 2019-10-23 23:00:09 127 set time_zone='SYSTEM'; 128 create external table ex_table_3_1(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_3_1.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 129 select * from ex_table_3_1; 130 char_1 char_2 date_1 date_2 date_3 131 cat yellow 芝士 2020-10-09 0001-01-01 00:00:00 1970-01-01 00:00:01 132 create external table ex_table_3_2(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_3_2.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 133 select * from ex_table_3_2; 134 internal error: the input value '0001' is not Date type for column 2 135 create external table ex_table_3_3(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_3_3.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 136 select * from ex_table_3_3; 137 internal error: the input value '0000-12-31 23:59:59.000000' is not Datetime type for column 3 138 create external table ex_table_3_4(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_3_4.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 139 select * from ex_table_3_4; 140 internal error: the input value '0000-0-20 03:14:07.999999' is not Timestamp type for column 4 141 create external table ex_table_3_5(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_3_5.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 142 select * from ex_table_3_5; 143 char_1 char_2 date_1 date_2 date_3 144 78 yellow 芝士 2020-10-09 0001-01-01 00:00:00 2011-01-20 03:14:08 145 create external table ex_table_31(clo1 tinyint default 8,clo2 smallint null,clo3 int not null,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255),primary key(clo1))infile{"filepath"='$resources/external_table_file/ex_table_3_6.csv'}; 146 select clo1,clo2,clo3,clo4,clo5,clo6,clo7,clo8,col9,col10,col11,col12,col13,col15,col16,col17,col18,col19,col20 from ex_table_31; 147 clo1 clo2 clo3 clo4 clo5 clo6 clo7 clo8 col9 col10 col11 col12 col13 col15 col16 col17 col18 col19 col20 148 1 11 1 2 15 600 700 56 3.4365 5.559 math 2020-04-30 1998-08-07 00:00:00 true 602.53 abcdefg message s@126.com comment balabalabalabalabala 149 2 20 3 4 21 220 1 3 7.2914 6.5836 art 2020-02-22 1998-06-04 00:00:00 false 878.09 abcdefg message r@sina.com aaaabbbbbbccccc 150 3 9 null 20 1 500 2 4 1.1559 6.5635 english 2020-02-16 1998-01-21 23:59:59 true 439.95 EF,GHI,G;KL/MN?OPQR.STU-_+=VWXYZabcdefgh OPQR.STU-_+=VWXYZa U-_+=VWXYZabcdefghigklmno .STU-_+=VWXYZab 151 3 20 null 7 1 700 600 20 7.2914 1.1732 science 2020-05-08 1998-12-30 00:00:00 false 428.14 U-_+=VWXYZabcdefghigklmnopqrstuvwxy L/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz012 r@sina.com bbbbbbccccc 152 create external table ex_table_4(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 153 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_1.csv'} fields terminated by '|' enclosed by '\"' lines terminated by '\n'; 154 select clo1,clo5,clo7,col12,col13,col16,col17,col18 from ex_table_4; 155 clo1 clo5 clo7 col12 col13 col16 col17 col18 156 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 I|G;KL/MN?OPQR.STU-_+=VWXYZabcdefghi HI|G;KL/MN?OPQR.STU-_+=VWXYZa 157 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 HI|G;KL/MN?OPQR.STU-_+=VWXYZabcd QR.STU-_+=VWXYZabcdefghigklmnopqrstu 158 33 104 3258037690 6316-02-16 3647-01-21 23:59:59 439.95 EF|GHI|G;KL/MN?OPQR.STU-_+=VWXYZabcdefgh OPQR.STU-_+=VWXYZa 159 121 141 849972079 9948-05-08 6216-12-30 00:00:00 428.14 U-_+=VWXYZabcdefghigklmnopqrstuvwxy L/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz012 160 create external table ex_table_5(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_2.csv'} fields terminated by '|' lines terminated by '\n'; 161 select clo1,clo5,clo7,col12,col13,col16,col17,col18 from ex_table_5; 162 clo1 clo5 clo7 col12 col13 col16 col17 col18 163 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 I G;KL/MN?OPQR.STU-_+=VWXYZabcdefghi 164 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 HI G;KL/MN?OPQR.STU-_+=VWXYZabcd 165 33 104 3258037690 6316-02-16 3647-01-21 23:59:59 439.95 EF GHI 166 create external table ex_table_6(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 167 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_3.csv'} fields terminated by '*' enclosed by '\"' lines terminated by '\n'; 168 select clo1,clo5,clo7,col12,col13,col16,col17,col18 from ex_table_6; 169 clo1 clo5 clo7 col12 col13 col16 col17 col18 170 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 I*G;KL/MN?OPQR.STU-_+=VWXYZabcdefghi HI*G;KL/MN?OPQR.STU-_+=VWXYZa 171 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 HI*G;KL/MN?OPQR.STU-_+=VWXYZabcd QR.STU-_+=VWXYZabcdefghigklmnopqrstu 172 33 104 3258037690 6316-02-16 3647-01-21 23:59:59 439.95 EF*GHI*G;KL/MN?OPQR.STU-_+=VWXYZabcdefgh OPQR.STU-_+=VWXYZa 173 create external table ex_table_6a(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 174 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_11.csv'} fields terminated by '\t' enclosed by '\"' lines terminated by '\n'; 175 select clo1,clo5,clo7,col12,col13,col16 from ex_table_6a; 176 clo1 clo5 clo7 col12 col13 col16 177 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 178 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 179 33 104 3258037690 6316-02-16 3647-01-21 23:59:59 439.95 180 121 141 849972079 9948-05-08 6216-12-30 00:00:00 428.14 181 create external table ex_table_7(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 182 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_4.csv'} fields terminated by '#' enclosed by '\"' lines terminated by '\n'; 183 select * from ex_table_7; 184 csv: invalid field or comment delimiter 185 create external table ex_table_8(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 186 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_5.csv'} fields terminated by '\n' enclosed by '\"' lines terminated by '\n'; 187 select * from ex_table_8; 188 csv: invalid field or comment delimiter 189 create external table ex_table_9(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 190 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_6.csv'} fields terminated by '\r' enclosed by '\"' lines terminated by '\n'; 191 select * from ex_table_9; 192 csv: invalid field or comment delimiter 193 create external table ex_table_10(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 194 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_7.csv'} fields terminated by '' lines terminated by '\n'; 195 select * from ex_table_10; 196 internal error: the table column is larger than input data column 197 create external table ex_table_10a(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 198 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_1.csv'} fields terminated by ',' enclosed by '@' lines terminated by '\n'; 199 select * from ex_table_10a; 200 internal error: the table column is larger than input data column 201 create external table ex_table_11(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 202 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_8.csv'} fields terminated by '|' lines terminated by '\n'; 203 select * from ex_table_11; 204 internal error: the table column is larger than input data column 205 create external table ex_table_12(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 206 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_9.csv'} fields terminated by ',' enclosed by '\"' ; 207 select clo1,clo5,clo7,col12,col13,col16,col17,col18 from ex_table_12; 208 clo1 clo5 clo7 col12 col13 col16 col17 col18 209 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 I,G;KL/MN?OPQR.STU-_+=VWXYZabcdefghi HI,G;KL/MN?OPQR.STU-_+=VWXYZa 210 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 HI,G;KL/MN?OPQR.STU-_+=VWXYZabcd QR.STU-_+=VWXYZabcdefghigklmnopqrstu 211 create external table ex_table_13(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 212 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_10.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\r\n'; 213 select clo1,clo5,clo7,col12,col13,col16,col17,col18 from ex_table_13; 214 clo1 clo5 clo7 col12 col13 col16 col17 col18 215 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 I,G;KL/MN?OPQR.STU-_+=VWXYZabcdefghi HI,G;KL/MN?OPQR.STU-_+=VWXYZa 216 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 HI,G;KL/MN?OPQR.STU-_+=VWXYZabcd QR.STU-_+=VWXYZabcdefghigklmnopqrstu 217 create external table ex_table_14(clo1 tinyint primary key,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_10.csv'}; 218 select clo1,clo5,clo7,col12,col13,col16,col17,col18 from ex_table_14; 219 clo1 clo5 clo7 col12 col13 col16 col17 col18 220 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 I,G;KL/MN?OPQR.STU-_+=VWXYZabcdefghi HI,G;KL/MN?OPQR.STU-_+=VWXYZa 221 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 HI,G;KL/MN?OPQR.STU-_+=VWXYZabcd QR.STU-_+=VWXYZabcdefghigklmnopqrstu 222 create external table ex_table_text(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_char.text'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 223 select char_1,char_2,date_1,date_2 from ex_table_text; 224 char_1 char_2 date_1 date_2 225 cat yellow 芝士 2020-10-09 0001-01-01 00:00:00 226 123木头人 zt@126.com 1000-01-01 9999-12-31 00:00:00 227 abc$%*()#$ ttttt 9999-12-31 2019-10-23 23:00:09 228 create external table ex_table_log(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_char.log'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 229 select char_1,char_2,date_1,date_2 from ex_table_log; 230 char_1 char_2 date_1 date_2 231 cat yellow 芝士 2020-10-09 0001-01-01 00:00:00 232 123木头人 zt@126.com 1000-01-01 9999-12-31 00:00:00 233 abc$%*()#$ ttttt 9999-12-31 2019-10-23 23:00:09 234 create external table ex_table_gzip(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double,num_col11 decimal(38,19)) infile{"filepath"='$resources/external_table_file/ex_table_gzip.gz',"compression"='gzip'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 235 select * from ex_table_gzip; 236 num_col1 num_col2 num_col3 num_col4 num_col5 num_col6 num_col7 num_col8 num_col9 num_col10 num_col11 237 60 -1000 8403 -10934535423423 200 1 673892 8374 73.98 9.0002 8345398234.9838234985858298432 238 -128 -32768 -2147483648 -9223372036854775808 0 0 0 0 null -1.7976931348623157E308 9345.4535000000000000000 239 127 32767 2147483647 9223372036854775807 255 65535 4294967295 18446744073709551615 null 1.7976931348623157E308 883453.0999320000000000000 240 null null null null null null null null null null null 241 create external table ex_table_bzip2(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_bzip.bz2',"compression"='bz2'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 242 select char_1,char_2,date_1,date_2 from ex_table_bzip2; 243 char_1 char_2 date_1 date_2 244 cat yellow 芝士 2020-10-09 0001-01-01 00:00:00 245 123木头人 zt@126.com 1000-01-01 9999-12-31 00:00:00 246 abc$%*()#$ ttttt 9999-12-31 2019-10-23 23:00:09 247 create external table ex_table_lz4(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double,num_col11 decimal(38,19)) infile{"filepath"='$resources/external_table_file/ex_table_lz4.lz4',"compression"='lz4'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 248 select * from ex_table_lz4; 249 num_col1 num_col2 num_col3 num_col4 num_col5 num_col6 num_col7 num_col8 num_col9 num_col10 num_col11 250 60 -1000 8403 -10934535423423 200 1 673892 8374 73.98 9.0002 8345398234.9838234985858298432 251 -128 -32768 -2147483648 -9223372036854775808 0 0 0 0 null -1.7976931348623157E308 9345.4535000000000000000 252 127 32767 2147483647 9223372036854775807 255 65535 4294967295 18446744073709551615 null 1.7976931348623157E308 883453.0999320000000000000 253 null null null null null null null null null null null 254 create external table ex_table_auto(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double,num_col11 decimal(38,19)) infile{"filepath"='$resources/external_table_file/ex_table_lz4.lz4',"compression"='auto'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 255 select * from ex_table_auto; 256 num_col1 num_col2 num_col3 num_col4 num_col5 num_col6 num_col7 num_col8 num_col9 num_col10 num_col11 257 60 -1000 8403 -10934535423423 200 1 673892 8374 73.98 9.0002 8345398234.9838234985858298432 258 -128 -32768 -2147483648 -9223372036854775808 0 0 0 0 null -1.7976931348623157E308 9345.4535000000000000000 259 127 32767 2147483647 9223372036854775807 255 65535 4294967295 18446744073709551615 null 1.7976931348623157E308 883453.0999320000000000000 260 null null null null null null null null null null null 261 create external table ex_table_none(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date, 262 col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255)) infile{"filepath"='$resources/external_table_file/ex_table_sep_8.csv',"compression"='none'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 263 select clo1,clo5,clo7,col12,col13,col16,col17,col18 from ex_table_none; 264 clo1 clo5 clo7 col12 col13 col16 col17 col18 265 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 IG;KL/MN?OPQR.STU-_+=VWXYZabcdefghi HI,G;KL/MN?OPQR.STU-_+=VWXYZa 266 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 HI,G;KL/MN?OPQR.STU-_+=VWXYZabcd QR.STU-_+=VWXYZabcdefghigklmnopqrstu 267 create external table ex_table_nocomp(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_bzip.bz2'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 268 select char_1,char_2,date_1,date_2 from ex_table_nocomp; 269 char_1 char_2 date_1 date_2 270 cat yellow 芝士 2020-10-09 0001-01-01 00:00:00 271 123木头人 zt@126.com 1000-01-01 9999-12-31 00:00:00 272 abc$%*()#$ ttttt 9999-12-31 2019-10-23 23:00:09 273 create external table ex_table_cp1(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19)) infile{"filepath"='$resources/external_table_file/ex_table_gzip.gz',"compression"='lz4'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 274 select * from ex_table_cp1; 275 lz4: bad magic number 276 create external table ex_table_cp2(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19)) infile{"filepath"='$resources/external_table_file/ex_table_number.csv',"compression"='lz4'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 277 select * from ex_table_cp2; 278 lz4: bad magic number 279 create external table ex_table_15(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_1.csv'} fields terminated by '|' enclosed by '' lines terminated by '\n'; 280 create table table_15(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255)); 281 insert into table_15 select * from ex_table_15; 282 select clo1,clo5,clo7,col12,col13,col16,col17,col18 from table_15; 283 clo1 clo5 clo7 col12 col13 col16 col17 col18 284 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 I|G;KL/MN?OPQR.STU-_+=VWXYZabcdefghi HI|G;KL/MN?OPQR.STU-_+=VWXYZa 285 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 HI|G;KL/MN?OPQR.STU-_+=VWXYZabcd QR.STU-_+=VWXYZabcdefghigklmnopqrstu 286 33 104 3258037690 6316-02-16 3647-01-21 23:59:59 439.95 EF|GHI|G;KL/MN?OPQR.STU-_+=VWXYZabcdefgh OPQR.STU-_+=VWXYZa 287 121 141 849972079 9948-05-08 6216-12-30 00:00:00 428.14 U-_+=VWXYZabcdefghigklmnopqrstuvwxy L/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz012 288 create external table ex_table_drop(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_1.csv'} fields terminated by '|' enclosed by '' lines terminated by '\n'; 289 drop table ex_table_drop; 290 create external table ex_table_drop(clo1 tinyint,clo2 smallint,clo3 int,clo4 bigint,clo5 tinyint unsigned,clo6 smallint unsigned,clo7 int unsigned,clo8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 varchar(255))infile{"filepath"='$resources/external_table_file/ex_table_sep_1.csv'} fields terminated by '|' enclosed by '' lines terminated by '\n'; 291 select clo1,clo5,clo7,col12,col13,col16,col17,col18 from ex_table_drop; 292 clo1 clo5 clo7 col12 col13 col16 col17 col18 293 -62 154 2658450361 4149-04-30 5732-08-07 00:00:00 602.53 I|G;KL/MN?OPQR.STU-_+=VWXYZabcdefghi HI|G;KL/MN?OPQR.STU-_+=VWXYZa 294 91 122 625429347 2865-02-22 9976-06-04 00:00:00 878.09 HI|G;KL/MN?OPQR.STU-_+=VWXYZabcd QR.STU-_+=VWXYZabcdefghigklmnopqrstu 295 33 104 3258037690 6316-02-16 3647-01-21 23:59:59 439.95 EF|GHI|G;KL/MN?OPQR.STU-_+=VWXYZabcdefgh OPQR.STU-_+=VWXYZa 296 121 141 849972079 9948-05-08 6216-12-30 00:00:00 428.14 U-_+=VWXYZabcdefghigklmnopqrstuvwxy L/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz012 297 select count(*) from ex_table_15,table_15 where ex_table_15.clo1=table_15.clo1; 298 count(*) 299 4 300 create external table ex_table_yccs(char_1 char(20),char_2 varchar(10),date_1 date,date_2 datetime,date_3 timestamp)infile{"filepath"='$resources/external_table_file/ex_table_char.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 301 insert into ex_table_yccs select 'yellow','apple','2020-09-30','2020-09-30 10:20:08','2020-09-30 10:20:08.09834'; 302 invalid input: cannot insert/update/delete from external table 303 update ex_table_yccs set char_1="cat123"; 304 invalid input: cannot insert/update/delete from external table 305 delete from ex_table_yccs; 306 invalid input: cannot insert/update/delete from external table 307 308 create table table_16(a int); 309 insert into table_16 values(99); 310 select * from table_16, ex_table_gzip; 311 a num_col1 num_col2 num_col3 num_col4 num_col5 num_col6 num_col7 num_col8 num_col9 num_col10 num_col11 312 99 60 -1000 8403 -10934535423423 200 1 673892 8374 73.98 9.0002 8345398234.9838234985858298432 313 99 -128 -32768 -2147483648 -9223372036854775808 0 0 0 0 null -1.7976931348623157E308 9345.4535000000000000000 314 99 127 32767 2147483647 9223372036854775807 255 65535 4294967295 18446744073709551615 null 1.7976931348623157E308 883453.0999320000000000000 315 99 null null null null null null null null null null null 316 create external table ex_table_space(a varchar(200), b varchar(200), c varchar(200)) infile{"filepath"='$resources/external_table_file/ex_table_space.csv'} fields terminated by '|' enclosed by '\"' lines terminated by '\n'; 317 select length(a), length(b), length(c) from ex_table_space; 318 length(a) length(b) length(c) 319 4 6 8 320 2 2 2 321 create table t1(a varchar(100), b varchar(100), c varchar(100)); 322 load data infile '$resources/external_table_file/ex_table_space.csv' into table t1 fields terminated by '|' enclosed by '\"' lines terminated by '\n'; 323 select length(a), length(b), length(c) from t1; 324 length(a) length(b) length(c) 325 4 6 8 326 2 2 2 327 create external table ex_table_null( col1 int, col2 float, col3 varchar, col4 blob, col6 date, col7 bool )infile{"filepath"='$resources/external_table_file/ex_table_null.csv'} fields terminated by ',' enclosed by '"' lines terminated by '\n' set col3=nullif(col3,'null'); 328 select max(col3), min(col3) from ex_table_null; 329 max(col3) min(col3) 330 你好 你 331 drop table if exists ex_table_1; 332 drop table if exists ex_table_2_1; 333 drop table if exists ex_table_2_2; 334 drop table if exists ex_table_2_3; 335 drop table if exists ex_table_2_4; 336 drop table if exists ex_table_2_5; 337 drop table if exists ex_table_2_6; 338 drop table if exists ex_table_2_7; 339 drop table if exists ex_table_2_8; 340 drop table if exists ex_table_2_9; 341 drop table if exists ex_table_2_10; 342 drop table if exists ex_table_2_11; 343 drop table if exists ex_table_2_12; 344 drop table if exists ex_table_2_13; 345 drop table if exists ex_table_2_14; 346 drop table if exists ex_table_2_15; 347 drop table if exists ex_table_2_16; 348 drop table if exists ex_table_2_17; 349 drop table if exists ex_table_2_18; 350 drop table if exists ex_table_2_19; 351 drop table if exists ex_table_3; 352 drop table if exists ex_table_3_1; 353 drop table if exists ex_table_3_2; 354 drop table if exists ex_table_3_3; 355 drop table if exists ex_table_3_4; 356 drop table if exists ex_table_3_5; 357 drop table if exists ex_table_31; 358 drop table if exists ex_table_4; 359 drop table if exists ex_table_5; 360 drop table if exists ex_table_6; 361 drop table if exists ex_table_6a; 362 drop table if exists ex_table_7; 363 drop table if exists ex_table_8; 364 drop table if exists ex_table_9; 365 drop table if exists ex_table_10; 366 drop table if exists ex_table_10a; 367 drop table if exists ex_table_11; 368 drop table if exists ex_table_12; 369 drop table if exists ex_table_13; 370 drop table if exists ex_table_14; 371 drop table if exists ex_table_text; 372 drop table if exists ex_table_log; 373 drop table if exists ex_table_gzip; 374 drop table if exists ex_table_bzip2; 375 drop table if exists ex_table_lz4; 376 drop table if exists ex_table_auto; 377 drop table if exists ex_table_none; 378 drop table if exists ex_table_nocomp; 379 drop table if exists ex_table_cp1; 380 drop table if exists ex_table_cp2; 381 drop table if exists ex_table_15; 382 drop table if exists ex_table_drop; 383 drop table if exists table_15; 384 drop table if exists ex_table_yccs; 385 drop table if exists ex_table_space; 386 drop table if exists t1; 387 drop table if exists ex_table_null;