set hive.mapred.mode=nonstrict;
SET hive.vectorized.execution.enabled = false;
SET hive.int.timestamp.conversion.in.seconds=false;
set hive.fetch.task.conversion=none;

create table t_n17 (s string) stored as orc;

insert into t_n17 values ('false');
insert into t_n17 values ('FALSE');
insert into t_n17 values ('FaLsE');
insert into t_n17 values ('true');
insert into t_n17 values ('TRUE');
insert into t_n17 values ('TrUe');
insert into t_n17 values ('');
insert into t_n17 values ('Other');
insert into t_n17 values ('Off');
insert into t_n17 values ('No');
insert into t_n17 values ('0');
insert into t_n17 values ('1');

explain select s,cast(s as boolean) from t_n17 order by s;

select s,cast(s as boolean) from t_n17 order by s;