title: Hive new line character issue when creating table over text file format
body: <p>I have text file in hdfs location and I want to create hive table on top of that. The file contains new line character in between the end of line (EOL). But when i am creating hive table delimited by \n the new line character present in between the EOL is considered as new row and the resulting hive table is containing more number of rows than required. How I can i tell hive to ignore the new line character present before the EOL. 
  Note : In my case i can't edit the hdfs file.</p>