Hi, I am trying to create table for a text file who has a row delimiter other than new line character. I know hive create table does not support anything other than new line. I have columns where in data contains new line so i specified a new line character in my sqoop. What are the best options as far as i googled or looked at the manual a transformation is required but my table is real huge.
Thanks, G
