@krishna raj Have you tried setting this property to true? "hive.lazysimple.extended_boolean_literal": Default Value: false Added in: Hive 0.14 with HIVE-3635 LazySimpleSerDe uses this property to determine if it treats 'T', 't', 'F', 'f', '1', and '0' as extended, legal boolean literals, in addition to 'TRUE' and 'FALSE'. The default is false , which means only 'TRUE' and 'FALSE' are treated as legal boolean literals. See: https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties . Also please refer to the following link to know how to set "hive.lazysimple.extended_boolean_literal" to "true" while creating the Hive Tables. Like: CREATE TABLE ........ [TBLPROPERTIES ("hive.lazysimple.extended_boolean_literal"="true")]; https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL . ... View more