| ==== |
| ---- 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 * 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 |
| ==== |