AnsweredAssumed Answered

Writing single line JSON in drill

Question asked by bwgriffith on Nov 11, 2015
Latest reply on Nov 22, 2015 by bwgriffith
Following the directions on this blog:  https://www.mapr.com/blog/how-convert-csv-file-apache-parquet-using-apache-drill I am trying write a large CSV file out to JSON.  However, it creates a multi-line json record for each source csv line.  For example

This Record:

foo,bar

Bob,Smith

Is converted to:

{

  "foo":  "Bob",

  "bar":  "Smith"

)

What I would like is:
{"foo":"Bob","bar":"Smith"}

Is there an easy way to accomplish this in drill?  An easy setting I may have overlooked hopefully?

Thanks!

Outcomes