blob: 83a15407f2263c6d2796837620867595afcae3f8 [file] [log] [blame]
====
---- QUERY
select c1 from illtypes
---- CATCH
Type mismatch: table column BOOLEAN is map to column int in ORC file
====
---- QUERY
select c2 from illtypes
---- CATCH
Type mismatch: table column FLOAT is map to column boolean in ORC file
====
---- QUERY
select c3 from illtypes
---- CATCH
Type mismatch: table column BOOLEAN is map to column tinyint in ORC file
====
---- QUERY
select c4 from illtypes
---- CATCH
Type mismatch: table column TINYINT is map to column smallint in ORC file
====
---- QUERY
select c5 from illtypes
---- CATCH
Type mismatch: table column SMALLINT is map to column int in ORC file
====
---- QUERY
select c6 from illtypes
---- CATCH
Type mismatch: table column INT is map to column bigint in ORC file
====
---- QUERY
select c7 from illtypes
---- CATCH
Type mismatch: table column BOOLEAN is map to column float in ORC file
====
---- QUERY
select c8 from illtypes
---- CATCH
Type mismatch: table column STRING is map to column double in ORC file
====
---- QUERY
select c9 from illtypes
---- CATCH
Type mismatch: table column INT is map to column string in ORC file
====
---- QUERY
select c10 from illtypes
---- CATCH
Type mismatch: table column FLOAT is map to column string in ORC file
====
---- QUERY
select c11 from illtypes
---- CATCH
Type mismatch: table column BIGINT is map to column timestamp in ORC file
====
---- QUERY
select c11 from illtypes_ts_to_date
---- CATCH
Type mismatch: table column DATE is map to column timestamp in ORC file
====
---- QUERY
select c2 from illtypes_date_tbl
---- CATCH
Type mismatch: table column TIMESTAMP is map to column date in ORC file
====
---- QUERY
select * from safetypes order by c1
---- TYPES
bigint,boolean,smallint,int,bigint,bigint,double,double,char,string,timestamp,int,int
---- RESULTS
0,true,0,0,0,0,0,0,'01/','0',2009-01-01 00:00:00,2009,1
1,false,1,1,1,10,1.100000023841858,10.1,'01/','1',2009-01-01 00:01:00,2009,1
2,true,0,0,0,0,0,0,'02/','0',2009-02-01 00:00:00,2009,2
3,false,1,1,1,10,1.100000023841858,10.1,'02/','1',2009-02-01 00:01:00,2009,2
4,true,0,0,0,0,0,0,'03/','0',2009-03-01 00:00:00,2009,3
5,false,1,1,1,10,1.100000023841858,10.1,'03/','1',2009-03-01 00:01:00,2009,3
6,true,0,0,0,0,0,0,'04/','0',2009-04-01 00:00:00,2009,4
7,false,1,1,1,10,1.100000023841858,10.1,'04/','1',2009-04-01 00:01:00,2009,4
====
---- QUERY
select d1 from mismatch_decimals
---- TYPES
decimal
---- RESULTS
1234
2345
12345
12345
132842
====
---- QUERY
select d2 from mismatch_decimals where d6 = 1
---- TYPES
decimal
---- RESULTS
---- CATCH
Column decimal(10,0) in ORC file '$NAMENODE/test-warehouse/decimal_tbl_orc_def/d6=1/000000_0' can't be truncated to table column DECIMAL(8,0)
====
---- QUERY
select d3 from mismatch_decimals
---- TYPES
decimal
---- RESULTS
1.2345678900
12.3456789000
123.4567890000
1234.5678900000
12345.6789000000
====
---- QUERY
select d4 from mismatch_decimals
---- TYPES
decimal
---- RESULTS
---- CATCH
Type mismatch: table column DECIMAL(20,20) is map to column decimal(38,38) in ORC file
====
---- QUERY
select d5 from mismatch_decimals
---- TYPES
decimal
---- RESULTS
---- CATCH
Type mismatch: table column DECIMAL(2,0) is map to column decimal(10,5) in ORC file
====
---- QUERY
select d6 from mismatch_decimals
---- TYPES
decimal
---- RESULTS
1
1
1
1
1
====