drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jim Scott (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3395) wide tables data overlap previously written row data in the CLI
Date Fri, 26 Jun 2015 15:52:04 GMT
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)

Mime
View raw message