You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jim Scott (JIRA)" <ji...@apache.org> on 2015/06/26 17:52:04 UTC
[jira] [Created] (DRILL-3395) wide tables data overlap previously
written row data in the CLI
Jim Scott created DRILL-3395:
--------------------------------
Summary: 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)