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

 CREATE TABLE TBL_ON_BLN_10 (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_10 WHERE c2 = true;
 DROP TABLE TBL_ON_BLN_10;
	CREATE TABLE TBL_ON_BLN_10 (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_10 WHERE c2 = true;
	DROP TABLE TBL_ON_BLN_10;