drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kunal Khatua" <ku...@apache.org>
Subject Re: SQLPad Support for Drill (JDBC)
Date Fri, 28 Dec 2018 18:26:54 GMT
Hi Charles

Can you provide steps of where the JDBC driver needs to be located ? I managed to start up
the server but I hit a signin message: 
Cannot GET /sqlpad/signin
I see the following in the server output:
[root@kk127 sqlpad]# npm start > sqlpad@2.8.0 start /root/drill/cgivre/sqlpad > concurrently
"npm run start-server-dev" "npm run start-client-dev" [0] [0] > sqlpad@2.8.0 start-server-dev
/root/drill/cgivre/sqlpad [0] > node-dev server/server.js --dir ./db --port 3010 --debug
--base-url '/sqlpad' [0] [1] [1] > sqlpad@2.8.0 start-client-dev /root/drill/cgivre/sqlpad
[1] > react-scripts start [1] [0] optional driver ../drivers/jdbc not available [0] optional
driver ../drivers/unixodbc not available [0] [0] NO FRONT END TEMPLATE DETECTED [0] If not
running in dev mode please report this issue. [0] [0] Loading users.. [0] Loading connections..
[0] Loading queries.. [0] Loading cache.. [0] Loading config.. [1] Starting the development
server... [1] [0] Schema is up to date (v3). [0] [0] Welcome to SQLPad!. Visit http://localhost:3010/sqlpad
to get started [0] GET /sqlpad/ 302 14.718 ms - 72 [0] GET /sqlpad/signin 404 4.511 ms - 152
[1] Compiled successfully! [1] [1] You can now view sqlpad in the browser. [1] [1] Local:
http://localhost:3000/ [1] On Your Network: http://10.10.100.127:3000/ [1] [1] Note that the
development build is not optimized. [1] To create a production build, use npm run build. [1]
[0] GET /sqlpad/ 302 2.275 ms - 72 [0] GET /sqlpad/signin 404 1.506 ms - 152 [0] GET /sqlpad/
302 1.155 ms - 72 [0] GET /sqlpad/signin 404 1.263 ms - 152

On 12/24/2018 9:09:11 AM, Charles Givre <cgivre@gmail.com> wrote:
Hello all,
After speaking with the developer of SQLPad and getting a little assistance, I managed to
get SQLPad to work using JDBC!

What works: You can establish a connection to Drill, execute queries, and visualize the results.
What’s not done: It doesn’t get the schema metadata, available tables etc. yet to populate
the drop downs. I’ll keep working on that.

Here is a link to my fork with the code:
https://github.com/cgivre/sqlpad/tree/jdbc

Also, here is a link to my branch with the Drill Embedded integration: (No JDBC)
https://github.com/cgivre/sqlpad/tree/drill

Thanks to Rick Bergfalk for his assistance with this. Please let me know what you think!
— C




Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message