[ https://issues.apache.org/jira/browse/DRILL-2495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-2495. ----------------------------------- Resolution: Fixed > Query fails with more than one file, but works with one file. > ------------------------------------------------------------- > > Key: DRILL-2495 > URL: https://issues.apache.org/jira/browse/DRILL-2495 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Text & CSV > Affects Versions: 0.7.0 > Environment: MapR cluster > Reporter: Sudhakar Thota > Assignee: Ramana Inukonda Nagaraj > Attachments: drillbit.log > > > 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-r--r-- 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-r--r-- 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> -- This message was sent by Atlassian JIRA (v6.3.4#6332)