[DRILL-2739] Drill stops reading columns > 4095

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.9.0
• Component/s: Storage - Text & CSV

Environment

CentOS 6.4
sqlline 1.1.6
Drill 0.7

• Assignee: Chris Westin
• Reporter: Nick Amato
• Created: 09/Apr/15 20:40
• Updated: 24/Apr/15 22:56
• Resolved: 22/Apr/15 17:23

Description

Querying a CSV file with 10000 columns, it looks like I can't query past column 4095.
0: jdbc:drill:localhost:5181> SELECT columns[4094] FROM `dfs`.`tmp`.`manycols.csv` limit 1;
------------

EXPR$0

------------

833

------------
1 row selected (0.269 seconds)
0: jdbc:drill:localhost:5181> SELECT columns[4095] FROM `dfs`.`tmp`.`manycols.csv` limit 1;
--

--
--
No rows selected (0.198 seconds)
0: jdbc:drill:localhost:5181>

[mapr@drilltwitter tmp]$ awk -F, '

{ print $4095,$4096,$4097 }

' manycols.csv | head -1
833 2552 2222
[mapr@drilltwitter tmp]$

Issue Links

• relates to: DRILL-1960 Automatically realloc buffers when vector runs out of space