Hi, Some of the columns in the hive has multiple lines of values which comes as newline for example   Empid Empname Dept company year month day 1234 ASD Finance qqq null null null 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?   ... View more