Some of the columns in the hive has multiple lines of values which comes as newline
|2015||6||3|| || || || |
But when I query the table with year it gives the correct answer
select year from tbl_name where year='2015'
what could be the reason for these multiline values and how to align these values in a proper column?