java - Handling newline character in Greenplum external table -

i creating greenplum external table , populating data map reduce output files present in hdfs. able connect external table hdfs , access files present in directories. files have values in comma separated format.

for example have 2 files employee , student having comma delimiter as:

employee:

id, name, company, status 1, xyz, greenplumb, online 2, abc, big data, available 

student:

name, courses, description abc, hadoop, course hadoop. (newline character) .               understand hadoop , how play big data using hadoop. 

so when create external table employee file works properly. every row in employee file row in external table gets created. (delimiter comma).

but when try create external table student file gives error. because description column has value having newline character feeds in it. whenever external table encountering new line feed considering end of record , starts treating value after each newline feed new record.

things tried:

1. making above description value double quotes treating complete string. did not worked out.
2. removing new line character feed data in map reduce making data unreadable. not option.

can suggest how can handle problem. in advance.