In addition to what Sudheesh mentioned to post the query profile. You also mention you are using Drill in embedded mode, is Drill on the same system as the Hive Warehouse or is Hive on a remote system/cluster?
A bit more information about your setup will be helpful. --Andries > On Apr 7, 2016, at 2:42 PM, Sudheesh Katkam <[email protected]> wrote: > > Can you gather the query profile from the web UI [1]? > > This mailing list does not accept attachments; please put the profile in a > shareable location (Dropbox?), and post a link. > > Thank you, > Sudheesh > > [1] https://drill.apache.org/docs/query-profiles/ > <https://drill.apache.org/docs/query-profiles/> > >> On Apr 7, 2016, at 2:16 PM, Tomek W <[email protected]> wrote: >> >> Hello, >> I configured hive datasource. It is simple file system. These data are >> saved by spark application (/user/hive/warehaouse). >> >> I am able from command line of drill query data. However, for 1200 rows >> table it consumes 20s. >> >> Be honestly, I am launching embeded instance of your drill, but 20s. seems >> to be very much. Given that this table is very small. >> >> How to improve this result? >> First of all, is it possible to keep table in memory (RAM) >> >> Thanks in advance, >> >> Tom >
