AnsweredAssumed Answered

[DRILL 1.0.0] DRILL custom output format

Question asked by rvelfre on Sep 29, 2015
Latest reply on Sep 29, 2015 by leonclayton

I would like to extract data from Hive using Drill.

I want to get a file with ";" as the delimiter.

I tried this command :/opt/mapr/drill/drill-1.0.0/bin/sqlline -u jdbc:drill: --run=LOA.sql  --silent=true --outputformat=json > output.csv

But it generates a comma delimited file. How could I tune the output format ?

Is it possible ?

Thanks !