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)