[
https://issues.apache.org/jira/browse/DRILL-3395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14606603#comment-14606603
]
Jim Scott commented on DRILL-3395:
----------------------------------
This issue actually appears to exist for outputformat=table,csv,tsv
outputformat=vertical works just fine.
> wide tables data overlap previously written row data in the CLI
> ---------------------------------------------------------------
>
> Key: DRILL-3395
> URL: https://issues.apache.org/jira/browse/DRILL-3395
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - CLI
> Affects Versions: 1.0.0
> Environment: Linux
> Reporter: Jim Scott
> Assignee: Daniel Barclay (Drill)
>
> when querying a parquet or csv file with 18 columns the columns from the end
> of the row overwrite the data at the beginning of the row. You can use the
> below data and query it and notice that the 01001 will not show up in the
> output results.
> repeat with storage format:
> "nndb": {
> "type": "text",
> "extensions": [ "txt" ],
> "quote": "~",
> "escape": "~",
> "delimiter": "^"
> },
> Data records in file NUT_DATA.txt:
> ~01001~^~203~^0.85^16^0.074^~1~^~~^~~^~~^^^^^^^~~^11/1976^
> ~01001~^~204~^81.11^580^0.065^~1~^~~^~~^~~^^^^^^^~~^11/1976^
> ~01001~^~205~^0.06^0^^~4~^~NC~^~~^~~^^^^^^^~~^11/1976^
> ~01001~^~207~^2.11^35^0.054^~1~^~~^~~^~~^^^^^^^~~^11/1976^
> ~01001~^~208~^717^0^^~4~^~NC~^~~^~~^^^^^^^~~^08/2010^
> ~01001~^~221~^0.0^0^^~7~^~~^~~^~~^^^^^^^~~^04/1985^
> ~01001~^~255~^15.87^522^0.061^~1~^~~^~~^~~^^^^^^^~~^11/1976^
> ~01001~^~262~^0^0^^~7~^~Z~^~~^~~^^^^^^^~~^02/2001^
> ~01001~^~263~^0^0^^~7~^~Z~^~~^~~^^^^^^^~~^02/2001^
> ~01001~^~268~^3000^0^^~4~^~~^~~^~~^^^^^^^~~^06/2013^
> select columns[0], columns[1], columns[2], columns[3], columns[4],
> columns[5], columns[6], columns[7], columns[8], columns[9], columns[10],
> columns[11], columns[12], columns[13], columns[14], columns[15], columns[16],
> columns[17] from dfs.tmp.`sr27asc/NUT_DATA.txt`
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
