title: Select statement in hive return some columns with null value
body: <p>I have seen this type of questions were asked many times, but those solutions not worked for me. I created a external hive table, since i had the data is from map-only job output. Then, by load command i given the path for the specific file. It showed ok. But when i give <code>select * from table</code> command it returns some column with null values. Each command i have executed is in the error pic.</p>
  
  <p>My delimiter in file is <code>||</code>, so i mentioned the same in create table command too.</p>
  
  <p>Here is my input file pic <a href="https://i.stack.imgur.com/O3WQ5.png" rel="nofollow noreferrer">file pic</a>.  And here is the <a href="https://i.stack.imgur.com/OdfDY.png" rel="nofollow noreferrer">error pic</a>
  . I have also tried a normal table instead of external table. That too showed the same error. I also tried by mentioning delimiter as <code>//||</code> and also <code>\|\|</code>. But none worked. </p>