title: why boolean field is not working in Hive?
body: <p>I have a column in my hive table which datatype is boolean. when I tried to import data from csv, it stored as NULL.</p>
  
  <p>This is my sample table :</p>
  
  <pre><code>CREATE tABLE if not exists Engineanalysis(
  
  EngineModel String,
  
  EnginePartNo String ,
  
  Location String,
  
  Position String,
  
  InspectionReq boolean)
  
  ROW FORMAT DELIMITED
  
  FIELDS TERMINATED BY ','
  
  LINES TERMINATED BY '\n';
  </code></pre>
  
  <p>My sample data :</p>
  
  <pre><code>AB01,AS01-IT01,AIRFRAME,,0
  
  AB02,AS01-IT02,AIRFRAME,,1
  
  AB03,AS01-IT03,AIRFRAME,,1
  
  AB04,AS01-IT04,AIRFRAME,,1
  
  AB05,AS01-IT05,HEAD,,1
  
  AB06,AS01-IT06,HEAD,,0
  
  AB07,AS01-IT07,HEAD,,0
  
  AB08,AS01-IT08,HEAD,,0
  
  AB09,AS01-IT09,NOSE,,1
  
  AB10,AS01-IT10,NOSE,,0
  </code></pre>
  
  <p>Result :</p>
  
  <pre><code>AB01 AS01-IT01 AIRFRAME NULL
  
  AB02 AS01-IT02 AIRFRAME NULL
  
  AB03 AS01-IT03 AIRFRAME NULL
  
  AB04 AS01-IT04 AIRFRAME NULL
  
  AB05 AS01-IT05 HEAD NULL
  
  AB06 AS01-IT06 HEAD NULL
  
  AB07 AS01-IT07 HEAD NULL
  
  AB08 AS01-IT08 HEAD NULL
  
  AB09 AS01-IT09 NOSE NULL
  
  AB10 AS01-IT10 NOSE NULL
  </code></pre>
  
  <p>when loading manually :</p>
  
  <pre><code>insert into Engineanalysis select 'AB11','AS01-IT11','AIRFRAME','',0;
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>AB11 AS01-IT11 AIRFRAME false
  </code></pre>
  
  <p>can someone explain why this dissimilarity?</p>