That's totally possible. The ErrorIds are stored on the drillbit machines right? Our logging is configured incorrectly at the moment so I can't find the error. Will fix that and report back.
If I limit to 100,000 rows the query consistently works. If I limit to 1M rows then the query consistently disconnects. If I CTAS on 1M rows then it works, so it does appear to be an issue only when returning results to the client. I don't know if there is some value between 100k and 1M for which it sometimes works and sometimes doesn't. Is that useful to know? I can do a little binary searching on values if that would help. Wes On Mon, Mar 27, 2017 at 4:13 PM, rahul challapalli < challapallira...@gmail.com> wrote: > Do you think that the error you are seeing is related to DRILL-4708 > <https://issues.apache.org/jira/browse/DRILL-4708> ? If not kindly provide > more information about the error (message, stack trace etc). And also does > the connection error happen consistently after returning X number of > records or is it random? > > - Rahul > > On Mon, Mar 27, 2017 at 1:07 PM, Wesley Chow <w...@chartbeat.com> wrote: > > > hi all, > > > > I've been noticing that queries that return large numbers of rows (1M+, > > each row maybe around 500 bytes) via the JDBC connector (and thus > sqlline) > > from our office to drillbits in EC2 consistently disconnect with a > > connection error while streaming the results back. The same query > initiated > > from an EC2 machine works fine. Any thoughts on what I should be looking > > at? When the disconnection occurs, none of my other network connections > > such as ssh are affected, just the Drill JDBC connector. > > > > Thanks, > > Wes > > >