When reading a csv file which contains newlines within quoted strings, e.g. via
select * from dfs.`/tmp/q.csv`;
Drill 1.0 says:
Error: SYSTEM ERROR: com.univocity.parsers.common.TextParsingException: Error processing input: Cannot use newline character within quoted string
But many tools produce csv files with newlines in quoted strings. Drill should be able to handle them.
Workaround: the csvquote program (https://github.com/dbro/csvquote) can encode embedded commas and newlines, and even decode them later if desired.