Hey Akif, There is a known issue that looks similar to the error you reported:
DRILL-2851 <https://issues.apache.org/jira/browse/DRILL-2851> There is already a patch for review to fix for this and it may fix your issue or at the very least give you a more meaningful error message. You could either wait until the patch is merged in master or try it by yourself and see if the issue has been fixed. Thanks! On Thu, Jun 18, 2015 at 5:35 AM, Akif Khan <[email protected]> wrote: > Hi > > I am re posting my query as there weren't any responses earlier. please > tell why this error happens and can it avoided ? Or is it due to bad data ? > > I wrote a query mentioned below and got this error, I have an amazon aws > with four nodes having 32 GB RAM and 8 cores on ubuntu with Hadoop FS and > zookeeper installed : > > *Query *: select flatten(campaign['funders'])['user_id'] from > `new_crowdfunding`; > > > the s*tructure of new_crowdfunding table* is as follows: > https://gist.github.com/akifkhan/d864ad9dcf5be712ff24 > > *Error after running for 40 seconds and printing various user_ids* > > java.lang.RuntimeException: java.sql.SQLException: SYSTEM ERROR: > java.lang.IllegalArgumentException: initialCapacity: -2147483648 (expectd: > 0+) > > Fragment 0:0 > > [Error Id: 4fa13e31-ad84-42c6-aa50-c80c92ab026d on hadoop-slave1:31010] > at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73) > at > > sqlline.TableOutputFormat$ResizingRowsProvider.next(TableOutputFormat.java:85) > at sqlline.TableOutputFormat.print(TableOutputFormat.java:116) > at sqlline.SqlLine.print(SqlLine.java:1583) > at sqlline.Commands.execute(Commands.java:852) > at sqlline.Commands.sql(Commands.java:751) > at sqlline.SqlLine.dispatch(SqlLine.java:738) > at sqlline.SqlLine.begin(SqlLine.java:612) > at sqlline.SqlLine.start(SqlLine.java:366) > -- Abdelhakim Deneche Software Engineer <http://www.mapr.com/> Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
