drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Omernik <j...@omernik.com>
Subject Re: Sqlline Tricks
Date Wed, 03 Feb 2016 22:14:17 GMT
Ya, Andries, that's effectively what I did with my script, I passed the url
with -u, but without the username and password provided on the command
line, I get an auth error.  If there truly is no way to ask for
username/password when providing auth string, I may open a JIRA on that, I
think it would be a helpful feature. Right now my work around is to use the
bash script to echo out what they need to type to get into drill :)



On Wed, Feb 3, 2016 at 4:03 PM, Christopher Matta <cmatta@mapr.com> wrote:

> The only way I know of getting sqlline to ask for a password is to run the
> !connect command after starting the shell:
>
> $ /opt/mapr/drill/drill-1.4.0/bin/sqlline
> apache drill 1.4.0
> "a drill in the hand is better than two in the bush"
> sqlline> !connect jdbc:drill:
> scan complete in 427ms
> Enter username for jdbc:drill:: cmatta
> Enter password for jdbc:drill:: **************
>
> I’m not sure how to send that string to the sqlline shell once it’s opened
> though..
> ​
>
> Chris Matta
> cmatta@mapr.com
> 215-701-3146
>
> On Wed, Feb 3, 2016 at 4:53 PM, John Omernik <john@omernik.com> 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!
> >
>

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