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

 CREATE TABLE TBL_ON_BLN_11 (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 * from TBL_ON_BLN_11 WHERE c2 = false;
 DROP TABLE TBL_ON_BLN_11;
	CREATE TABLE TBL_ON_BLN_11 (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 * from TBL_ON_BLN_11 WHERE c2 = false;
	DROP TABLE TBL_ON_BLN_11;