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. --Andries > On Feb 3, 2016, at 1:53 PM, John Omernik <[email protected] > <mailto:[email protected]>> wrote: > > 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!
