[DRILL-2495] Query fails with more than one file, but works with one file.

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

Environment

MapR cluster

• Assignee: Ramana Inukonda Nagaraj
• Reporter: Sudhakar Thota
• Created: 18/Mar/15 19:38
• Updated: 20/Mar/15 20:57
• Resolved: 20/Mar/15 20:57

Description

My directory strucuture:
[sthota@se-node10 ~]$ hadoop fs -lsr /user/sthota/eward
lsr: DEPRECATED: Please use 'ls -R' instead.
drwxrwxr-x - sthota sthota 12 2015-03-18 19:04 /user/sthota/eward/2014
drwxrwxr-x - sthota sthota 1 2015-03-18 19:05 /user/sthota/eward/2014/01
rw-rr- 2 sthota sthota 20847681 2015-03-18 19:05 /user/sthota/eward/2014/01/mmlogsample
drwxrwxr-x - sthota sthota 1 2015-03-18 19:23 /user/sthota/eward/2014/02
rw-rr- 2 sthota sthota 20847681 2015-03-18 19:23 /user/sthota/eward/2014/02/mmlog2
drwxrwxr-x - sthota sthota 0 2015-03-18 19:04 /user/sthota/eward/2014/03

With One file, it returns with errror.
Copying the same file to one more directory /sthota/eward/2014/02/mmlog2 results in error like this:

Drill log file from se-node11.se.lab is attached.
Query failed: Query stopped., index: 8192, length: 4 (expected: range(0, 8192)) [ 555cdc46-c22b-4267-b1da-fbf61ff6f833 on se-node11.se.lab:31010 ]

java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
at sqlline.SqlLine.print(SqlLine.java:1809)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
at sqlline.SqlLine.dispatch(SqlLine.java:889)
at sqlline.SqlLine.begin(SqlLine.java:763)
at sqlline.SqlLine.start(SqlLine.java:498)
at sqlline.SqlLine.main(SqlLine.java:460)
0: jdbc:drill:zk=10.10.15.10:5181,10.10.15.11>