Hello, I am Alex and I recentrly started to use apache drill. One of connected to apache drill databases is postgresql. I dumped 65gb of csv files there and tryed to select something from there via apache drill like "select imei from billing limit 10". It starts perform this query for a while and then i get an error: "Error: CONNECTION ERROR: Connection /172.17.0.16:53996 <--> 986910249f08/ 172.17.0.16:31010 (user client) closed unexpectedly. Drillbit down? [Error Id: 552dedfa-7ebb-42d7-bedd-57a599f78bbc ] (state=,code=0)"
And when I add some where clause like ... from billing WHERE imei = '123456789', drill responses me after 80 seconds and gives me expected result. The same queries in PrestoDB work fine and much more fast. What do I do wrong? Thank you, Trishin Alex.
