Is there a way to load the data below with single record spanning multiple rows into a Hive table using Regex serde?
123,1,hello world,LINEEND 124,0,good luck,LINEEND with your new job,LINEEND 125,1,thanks,LINEEND
The last field of the second record spans 3 rows. I used the following serde but no luck:
According to http://myregexp.com/ this parses the second problem record correctly.