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)
