Re: Drill support for SQLPad
ttribution) 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 >>>>> >>>>> >>> >> >> >> -- >> Regards, >> Salim >
Re: Drill support for SQLPad
arth 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 >>>> >>>> >> > > > -- > Regards, > Salim
Re: Drill support for SQLPad
One benefit of the REST based UI is that it does handle change-of-schema events per dataset (addition / removal of columns) whereas SQLline doesn't. I was wondering if SQLPad can be made to consume Drill's dynamic datasets. On Thu, Nov 29, 2018 at 2:56 PM Kunal Khatua wrote: > I think getting the interface to work with JDBC would be a killer feature > as it will eliminate the out of heap space issue we encounter with the REST > API approach. > > I did come across a couple of projects that exposed JDBC access via a web > interface, but nothing that seemed straightforward and opensource. I'll > need to dig up my graveyard of experiments to see which one of these came > closest to that. > > In the meanwhile, if you are able to figure out the basic functionality > with JDBC, I can work with you to make it a full-fledged query component > for Drill. > On 11/29/2018 2:06:01 PM, Charles Givre wrote: > 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 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 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 > >> > >> > -- Regards, Salim
Re: Drill support for SQLPad
I think getting the interface to work with JDBC would be a killer feature as it will eliminate the out of heap space issue we encounter with the REST API approach. I did come across a couple of projects that exposed JDBC access via a web interface, but nothing that seemed straightforward and opensource. I'll need to dig up my graveyard of experiments to see which one of these came closest to that. In the meanwhile, if you are able to figure out the basic functionality with JDBC, I can work with you to make it a full-fledged query component for Drill. On 11/29/2018 2:06:01 PM, Charles Givre wrote: 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 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 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 >> >>
Re: Drill support for SQLPad
Just got it to run on my Mac; looks nice (though the results are flushed to the left, like 55_ instead of _55 ) Thanks Charles for making SQLPad work with Drill ! And for anyone else wanting to try (on a Mac), here are the steps used: $ git clone https://github.com/cgivre/sqlpad.git $ cd sqlpad/ $ git checkout drill $ curl -o- https://raw.githubusercontent.com/creationix/nvm/v0.33.11/install.sh | bash $ source ~/.bashrc ### to get the nvm in the path << install "node" from https://nodejs.org/en/download/ >> $ sudo npm i npm -g ### need sudo for write access to /usr/local/lib/node_modules $ npm install ### had some errors, so ran the following $ npm audit fix ### still has some errors downloading fsevents-binaries $ npm start At this point, it opens your browser and connects to localhost:3000 . Start Drill in embedded mode, and in the browser configure a Drill connection ( to 127.0.0.1:8048 , don't care about user/password). Run queries .. Thanks, Boaz On 11/29/18 7:26 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://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_cgivre_sqlpad_tree_drill=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=PqKay2uOMZUqopDRKNfBtZSlsp2meGOxWNAVHxHnXCk=SDFB6Jw9G8FdLYUKjQoQK8aUTMY05hzjbfcCgSQIvxI=zTMNxDd3-5PocjYj_K7wajK_3dCsEUVJmnEW5UszMiQ= <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_cgivre_sqlpad_tree_drill=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=PqKay2uOMZUqopDRKNfBtZSlsp2meGOxWNAVHxHnXCk=SDFB6Jw9G8FdLYUKjQoQK8aUTMY05hzjbfcCgSQIvxI=zTMNxDd3-5PocjYj_K7wajK_3dCsEUVJmnEW5UszMiQ=> Please check it out and let me know what you think. Best, — C
Re: Drill support for SQLPad
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 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 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 >> >>
Re: Drill support for SQLPad
+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 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 > >
Re: Drill support for SQLPad
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 > >
Re: Drill support for SQLPad
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
Re: Drill support for SQLPad
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
Drill support for SQLPad
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