Drill Explorer and Squirrel are handy tools to explore the data and create Views, etc on DFS or complex data sources. A text editor with Drill Explorer or SQLline can be handy, but you may want to look at how to configure JDBC on your system to use Squirrel. https://drill.apache.org/docs/using-the-jdbc-driver/ <https://drill.apache.org/docs/using-the-jdbc-driver/>
Most BI/Analytical tools and Visualization tools like MicroStrategy, Tableau, QlikSense/View, Spotfire, etc may need a little help with DFS or complex data sources (unless you are familiar with the data and can create the SQL in the tool itself). They tend to work very well with Hive and Drill Views that are already created though. —Andries > On Oct 7, 2015, at 4:42 AM, Geercken, Uwe <[email protected]> wrote: > > I use the drill web interface and also have requested an enhancement through > jira. > > From what I understood with version 1.2 there will be quite some enhancements > in the area of user handling/login and also query handling. > > Taking that the drill 1.2 release should be soon - I heard next week - it > will soon be on our tables... > > Uwe > > > -----Original Message----- > From: Fabian Wilckens [mailto:[email protected]] > Sent: Mittwoch, 7. Oktober 2015 13:40 > To: [email protected]; Boris Chmiel > Subject: Re: Query Builder & Productivity tools > > I personally had good results so far with visualization tools ... in the > Drill UI you can see the queries that have been executed. > > > > On Wed, Oct 7, 2015 at 12:33 PM, Boris Chmiel < > [email protected]> wrote: > >> Hello users, >> I wonder which productivity tools are you using to build your queries >> with Drill. I found myself using text editor for building queries, >> sqlline to run files and console to remove CTAS results when needed. I >> am ok with thoses tools but from an end user prespective - let's say a >> data analyst building Tableau reports - creating views with this not >> so user friendly toolset seems a bit tricky. The drill explorer is not >> bad but somewhat limited. I failed to deploy full functionnalities of >> SQuirreL due to the JDBC driver (or due to my lack of knowledge). Any >> alternative in mind ? >> Regs.Boris
