drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andries Engelbrecht <aengelbre...@maprtech.com>
Subject Re: Sqlline Tricks
Date Wed, 03 Feb 2016 22:00:32 GMT
Try using an alias in .bash_profile or similar.

Modify as needed, but this may help you.

alias sqlline="/usr/bin/sqlline -u jdbc:drill:zk=drilldemo:5181"

You can play with the user and password options, but they should work.


> On Feb 3, 2016, at 1:53 PM, John Omernik <john@omernik.com <mailto:john@omernik.com>>
> Hey all, I am trying to "Ease" my users into using drill.
> One thing that I'd like to automate for them is the initial connection,
> basically, my zk string
> jdbc:drill:zk:zknode1:5181,zknode2:5181,zknode3:5181
> Is a bit of pain, in addition, my users have to find sqlline, so what if I
> change versions etc... my idea was to put an executable script in /usr/sbin
> named zetadrill (zeta is a nod To Mr. Scott!)
> Basically, that has the path and I hoped the connect string so users would
> not have to find my sqlline, nor would they have to know/remember zookeeper
> information. Ideal world: They'd type zetadrill and it would say "Please
> enter Username" "Please enter password" and they'd be good to go.
> So I tried using -u flag.
> When I do that (without a username and password) it fails out on me,
> basically telling me that auth failed (invalid user credentials).
> I obviously can't put a username and password in the script, running the
> connect with -u and -n (no password) results in the same failure.
> I guess I am asking: Is there any way to provide a connection string, and
> then have sqlline prompt for credentials? This would make the user exp so
> much better.
> Thanks in advanced!

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