framework/resources/Functional/case_expr/castToBooln_12.q - drill-test-framework - Git at Google

 CREATE TABLE TBL_ON_BLN_12 (c1, c2, c3, c4) AS SELECT cast(columns[0] as int), cast(columns[1] as boolean), cast(columns[2] as char(2)), cast(columns[3] as varchar(64)) FROM `bools.csv`;
 select c2 from TBL_ON_BLN_12 WHERE c2 = false;
 DROP TABLE TBL_ON_BLN_12;
	CREATE TABLE TBL_ON_BLN_12 (c1, c2, c3, c4) AS SELECT cast(columns[0] as int), cast(columns[1] as boolean), cast(columns[2] as char(2)), cast(columns[3] as varchar(64)) FROM `bools.csv`;
	select c2 from TBL_ON_BLN_12 WHERE c2 = false;
	DROP TABLE TBL_ON_BLN_12;