Hi Kunal My branch of SQLpad does work right out of the box with Drill but it only works with the REST interface at the moment. I submitted a PR to SQLpad so we will see if they accept it.
Now that I’ve figured out their data model I could probably get it to work with JDBC as well. At this point it probably could be adapted to be Drills main UI but you would have to add the storage plugin config page and a few others and that is beyond what I have time for at the moment. I will work on getting SQLpad to use JDBC as well. Sent from my iPhone > On Nov 29, 2018, at 16:25, Kunal Khatua <ku...@apache.org> wrote: > > +1 if you can get it deployed and running smoothly out of the box. > We can then hack around Drill to host this as the Query interface on the > Drill server's webpage instead of using the current mashup of libraries, and > take away the inherent challenges of maintaining the web-based Query > interface within the Drill server. > > ~ KK > On 11/29/2018 10:59:49 AM, Parth Chandra <par...@apache.org> wrote: > Sure. Any improvements we can get in the UI would be cool. > >> On Thu, Nov 29, 2018 at 10:52 AM Charles Givre wrote: >> >> Hi Parth, >> SQLPad doesn’t currently support JDBC, but I think it could be extended to >> do so. I found some node modules for JDBC ( >> https://www.npmjs.com/package/nodejdbc >> https://www.npmjs.com/package/nodejdbc>), but I’m not the world’s best >> JavaScript programmer, so it took me a while to hack the current one >> together. I’ll have a go at it, now that I “know” what I’m doing. >> >> Regardless… I think it could be done with what’s out there. SQLPad does >> offer a huge improvement over what Drill’s current UI offers and I do think >> it would be really great to include or borrow code (with appropriate >> attribution) from it for the Drill UI. The current UI uses REST anyway, so >> it wouldn’t be any different. >> >> I always wonder why the developers of tools like this don’t include >> generic interfaces such as JDBC and ODBC rather than building tool-specific >> drivers, but that’s another discussion. >> >> >>> On Nov 29, 2018, at 13:40, Parth Chandra wrote: >>> >>> I once considered whether we could incorporate SQLPad as the query >>> execution interface in the web UI, but never got around to looking into >> it. >>> The problem with using the REST api is that it becomes unwieldy when the >>> number of records returned by the query becomes large. I haven't looked >> at >>> the code in SQLPad, but is there a way to use the JDBC/ODBC API's ? >>> >>>> On Thu, Nov 29, 2018 at 7:33 AM Charles Givre wrote: >>>> >>>> All, >>>> There is a really nice open source tool out there called SQLPad. In >>>> addition to executing basic SQL Queries, SQLPad enables to to export >>>> results and produce basic visualizations. Until recently, SQLPad did >> not >>>> support Drill however, I just wrote a first attempt at Drill support >> which >>>> you can download here: >>>> >>>> https://github.com/cgivre/sqlpad/tree/drill >>>> https://github.com/cgivre/sqlpad/tree/drill> >>>> >>>> Please check it out and let me know what you think. >>>> Best, >>>> — C >> >>
