[jira] [Created] (DRILL-7500) CTAS to JSON omits the final newline

["Paul Rogers (Jira)" <ji...@apache.org>]

Paul Rogers created DRILL-7500:
----------------------------------

             Summary: CTAS to JSON omits the final newline
                 Key: DRILL-7500
                 URL: https://issues.apache.org/jira/browse/DRILL-7500
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Paul Rogers


Try the query from page 160 of _Learning Apache Drill_:

{code:sql}
ALTER SESSION SET `store.format` = 'json';
CREATE TABLE `out/json-null` AS SELECT * FROM `json/null2.json`;
{code}

Then, {{cat}} the resulting file:

{noformat}
cat out/json-null/0_0_0.json 
{
  "custId" : 123,
  "name" : "Fred",
  "balance" : 123.45
} {
  "custId" : 125,
  "name" : "Barney"
}(base) paul@paul-linux:~/eclipse-workspace/drillbook/data$
{noformat}

Notice that the file is missing a final newline, and so the shell prompt is appended to the last closing bracket.

Expected the line to be terminated with a newline.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)