You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Renato Marroquín Mogrovejo <re...@gmail.com> on 2014/06/04 17:38:23 UTC
Passing commands to sqline
Hi all,
I am trying to read some parquet files using local mode, but I can not tell
the sqlline class to use both options. Any idea what I am doing wrong?
This works:
./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
This also works:
./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
This doesn't work:
./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin -p admin
Thanks!
Renato M.
Re: Passing commands to sqline
Posted by Yash Sharma <ya...@gmail.com>.
Unfortunately I don not have edit permissions myself. I guess Jacques might
be able to help with this.
Peace,
Yash
On Wed, Jun 4, 2014 at 9:24 PM, Renato Marroquín Mogrovejo <
renatoj.marroquin@gmail.com> wrote:
> Hey man,
>
> Just another quick question. I am trying to update [1] to actually work
> locally but I don't have access to edit the wiki no more, would you be able
> to change the line:
>
> ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p
> admin
>
> for
>
> ./bin/sqlline -u jdbc:drill:zk=local
> jdbc:drill:schema=parquet-local
> -n admin -p admin
>
> Or if someone can re-give me my editing powers, I can do it myself :)
>
>
> Renato M.
>
> [1]
>
> https://cwiki.apache.org/confluence/display/DRILL/Compiling+Drill+from+source
>
>
> 2014-06-04 17:50 GMT+02:00 Yash Sharma <ya...@gmail.com>:
>
> > Awesome !!
> >
> >
> > On Wed, Jun 4, 2014 at 9:19 PM, Renato Marroquín Mogrovejo <
> > renatoj.marroquin@gmail.com> wrote:
> >
> > > Thanks Yash! that worked.
> > >
> > >
> > > Renato M.
> > >
> > >
> > > 2014-06-04 17:44 GMT+02:00 Yash Sharma <ya...@gmail.com>:
> > >
> > > > Please try:
> > > >
> > > > ./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local
> -n
> > > > admin -p admin
> > > >
> > > >
> > > > Peace,
> > > > Yash
> > > >
> > > >
> > > > On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
> > > > renatoj.marroquin@gmail.com> wrote:
> > > >
> > > > > Hi all,
> > > > >
> > > > > I am trying to read some parquet files using local mode, but I can
> > not
> > > > tell
> > > > > the sqlline class to use both options. Any idea what I am doing
> > wrong?
> > > > >
> > > > > This works:
> > > > > ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
> > > > >
> > > > > This also works:
> > > > > ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
> > > > >
> > > > > This doesn't work:
> > > > > ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin
> -p
> > > > admin
> > > > >
> > > > > Thanks!
> > > > >
> > > > >
> > > > > Renato M.
> > > > >
> > > >
> > >
> >
>
Re: Passing commands to sqline
Posted by Renato Marroquín Mogrovejo <re...@gmail.com>.
Hey man,
Just another quick question. I am trying to update [1] to actually work
locally but I don't have access to edit the wiki no more, would you be able
to change the line:
./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
for
./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local
-n admin -p admin
Or if someone can re-give me my editing powers, I can do it myself :)
Renato M.
[1]
https://cwiki.apache.org/confluence/display/DRILL/Compiling+Drill+from+source
2014-06-04 17:50 GMT+02:00 Yash Sharma <ya...@gmail.com>:
> Awesome !!
>
>
> On Wed, Jun 4, 2014 at 9:19 PM, Renato Marroquín Mogrovejo <
> renatoj.marroquin@gmail.com> wrote:
>
> > Thanks Yash! that worked.
> >
> >
> > Renato M.
> >
> >
> > 2014-06-04 17:44 GMT+02:00 Yash Sharma <ya...@gmail.com>:
> >
> > > Please try:
> > >
> > > ./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local -n
> > > admin -p admin
> > >
> > >
> > > Peace,
> > > Yash
> > >
> > >
> > > On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
> > > renatoj.marroquin@gmail.com> wrote:
> > >
> > > > Hi all,
> > > >
> > > > I am trying to read some parquet files using local mode, but I can
> not
> > > tell
> > > > the sqlline class to use both options. Any idea what I am doing
> wrong?
> > > >
> > > > This works:
> > > > ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
> > > >
> > > > This also works:
> > > > ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
> > > >
> > > > This doesn't work:
> > > > ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin -p
> > > admin
> > > >
> > > > Thanks!
> > > >
> > > >
> > > > Renato M.
> > > >
> > >
> >
>
Re: Passing commands to sqline
Posted by Yash Sharma <ya...@gmail.com>.
Awesome !!
On Wed, Jun 4, 2014 at 9:19 PM, Renato Marroquín Mogrovejo <
renatoj.marroquin@gmail.com> wrote:
> Thanks Yash! that worked.
>
>
> Renato M.
>
>
> 2014-06-04 17:44 GMT+02:00 Yash Sharma <ya...@gmail.com>:
>
> > Please try:
> >
> > ./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local -n
> > admin -p admin
> >
> >
> > Peace,
> > Yash
> >
> >
> > On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
> > renatoj.marroquin@gmail.com> wrote:
> >
> > > Hi all,
> > >
> > > I am trying to read some parquet files using local mode, but I can not
> > tell
> > > the sqlline class to use both options. Any idea what I am doing wrong?
> > >
> > > This works:
> > > ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
> > >
> > > This also works:
> > > ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
> > >
> > > This doesn't work:
> > > ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin -p
> > admin
> > >
> > > Thanks!
> > >
> > >
> > > Renato M.
> > >
> >
>
Re: Passing commands to sqline
Posted by Renato Marroquín Mogrovejo <re...@gmail.com>.
Thanks Yash! that worked.
Renato M.
2014-06-04 17:44 GMT+02:00 Yash Sharma <ya...@gmail.com>:
> Please try:
>
> ./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local -n
> admin -p admin
>
>
> Peace,
> Yash
>
>
> On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
> renatoj.marroquin@gmail.com> wrote:
>
> > Hi all,
> >
> > I am trying to read some parquet files using local mode, but I can not
> tell
> > the sqlline class to use both options. Any idea what I am doing wrong?
> >
> > This works:
> > ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
> >
> > This also works:
> > ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
> >
> > This doesn't work:
> > ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin -p
> admin
> >
> > Thanks!
> >
> >
> > Renato M.
> >
>
Re: Passing commands to sqline
Posted by Jacques Nadeau <ja...@apache.org>.
My bad, the correct syntax has a semi colon between the properties (but not
the scheme). Can you try the following?
./bin/sqlline -u "jdbc:drill:zk=local;schema=parquet-local"
As far as the data goes, our current default tpch data doesn't include
Parquet embedded schema. As such, we return varbinary. If you want to
look at the data, you have to cast to varchar(255) or similar. We plan on
replacing the default tpchd data so that is encoded that way.
On Thu, Jun 5, 2014 at 2:06 AM, Renato Marroquín Mogrovejo <
renatoj.marroquin@gmail.com> wrote:
> And when I do:
>
> 0: jdbc:drill:zk=local> SELECT * FROM
> dfs.`/tmp/sample-data/region.parquet`;
>
> +-------------+------------+------------+
> | R_REGIONKEY | R_NAME | R_COMMENT |
> +-------------+------------+------------+
> | 0 | [B@bdf37d1 | [B@6bc9806d |
> | 1 | [B@7a0eab63 | [B@59162f2f |
> | 2 | [B@96b0c3f | [B@33992303 |
> | 3 | [B@6e76966a | [B@46db51b8 |
> | 4 | [B@5c4e5eb8 | [B@1d2cb160 |
> +-------------+------------+------------+
>
> I guess this is also not expected. Could you please point me where I could
> start looking for trying to learn more about Drill internals? Thanks!
>
>
> Renato M.
>
>
>
> 2014-06-05 10:47 GMT+02:00 Renato Marroquín Mogrovejo <
> renatoj.marroquin@gmail.com>:
>
> > Hi Jacques,
> >
> > Yes I realized that after trying 10 times with my gmail account, sorry
> > about that.
> > Now the command you suggested me doesn't work either:
> >
> > ./bin/sqlline -u "jdbc:drill:zk=local:schema=parquet-local" -n admin -p
> > admin
> >
> > 10:32:16.334 [main] ERROR c.n.c.f.imps.CuratorFrameworkImpl - Background
> > exception was not retry-able or retry gave up
> > java.lang.NumberFormatException: For input string: "schema=parquet-local"
> > at
> >
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> > ~[na:1.7.0_51]
> > at java.lang.Integer.parseInt(Integer.java:492) ~[na:1.7.0_51]
> > at java.lang.Integer.parseInt(Integer.java:527) ~[na:1.7.0_51]
> > at
> >
> org.apache.zookeeper.client.ConnectStringParser.<init>(ConnectStringParser.java:72)
> > ~[zookeeper-3.4.3.jar:3.4.3-1240972]
> > at org.apache.zookeeper.ZooKeeper.<init>(ZooKeeper.java:438)
> > ~[zookeeper-3.4.3.jar:3.4.3-1240972]
> > at org.apache.zookeeper.ZooKeeper.<init>(ZooKeeper.java:375)
> > ~[zookeeper-3.4.3.jar:3.4.3-1240972]
> > ...
> >
> > I guess this is a problem in parsing the parameters inside sqlline and
> > then passing them correctly to DrillFactory. Could you explain to me a
> > little bit about how sqlline works with Drill? Because I haven't been
> able
> > to find any "obvious" code relating both of them. I will update the wiki
> > with the working command, and then when this gets fixed, I have no
> problem
> > updating it again ;)
> >
> >
> > Renato M.
> >
> >
> > 2014-06-04 18:53 GMT+02:00 Jacques Nadeau <ja...@apache.org>:
> >
> > I just added Yash. It looks like Renato, you already have edit access
> via
> >> your apache login.
> >>
> >>
> >> On Wed, Jun 4, 2014 at 9:19 AM, Jacques Nadeau <ja...@apache.org>
> >> wrote:
> >>
> >> > Woh, i don't think that is the problem. I'm not even sure why that
> >> > command line would work.
> >> >
> >> > I think you need to quote.
> >> >
> >> > Can you try ./bin/sqlline -u
> "jdbc:drill:zk=local:schema=parquet-local"
> >> >
> >> > What are your guys Confluence ids? I'll get you edit rights.
> >> >
> >> >
> >> > On Wed, Jun 4, 2014 at 8:44 AM, Yash Sharma <ya...@gmail.com>
> wrote:
> >> >
> >> >> Please try:
> >> >>
> >> >> ./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local
> -n
> >> >> admin -p admin
> >> >>
> >> >>
> >> >> Peace,
> >> >> Yash
> >> >>
> >> >>
> >> >> On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
> >> >> renatoj.marroquin@gmail.com> wrote:
> >> >>
> >> >> > Hi all,
> >> >> >
> >> >> > I am trying to read some parquet files using local mode, but I can
> >> not
> >> >> tell
> >> >> > the sqlline class to use both options. Any idea what I am doing
> >> wrong?
> >> >> >
> >> >> > This works:
> >> >> > ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
> >> >> >
> >> >> > This also works:
> >> >> > ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
> >> >> >
> >> >> > This doesn't work:
> >> >> > ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin
> -p
> >> >> admin
> >> >> >
> >> >> > Thanks!
> >> >> >
> >> >> >
> >> >> > Renato M.
> >> >> >
> >> >>
> >> >
> >> >
> >>
> >
> >
>
Re: Passing commands to sqline
Posted by Renato Marroquín Mogrovejo <re...@gmail.com>.
And when I do:
0: jdbc:drill:zk=local> SELECT * FROM
dfs.`/tmp/sample-data/region.parquet`;
+-------------+------------+------------+
| R_REGIONKEY | R_NAME | R_COMMENT |
+-------------+------------+------------+
| 0 | [B@bdf37d1 | [B@6bc9806d |
| 1 | [B@7a0eab63 | [B@59162f2f |
| 2 | [B@96b0c3f | [B@33992303 |
| 3 | [B@6e76966a | [B@46db51b8 |
| 4 | [B@5c4e5eb8 | [B@1d2cb160 |
+-------------+------------+------------+
I guess this is also not expected. Could you please point me where I could
start looking for trying to learn more about Drill internals? Thanks!
Renato M.
2014-06-05 10:47 GMT+02:00 Renato Marroquín Mogrovejo <
renatoj.marroquin@gmail.com>:
> Hi Jacques,
>
> Yes I realized that after trying 10 times with my gmail account, sorry
> about that.
> Now the command you suggested me doesn't work either:
>
> ./bin/sqlline -u "jdbc:drill:zk=local:schema=parquet-local" -n admin -p
> admin
>
> 10:32:16.334 [main] ERROR c.n.c.f.imps.CuratorFrameworkImpl - Background
> exception was not retry-able or retry gave up
> java.lang.NumberFormatException: For input string: "schema=parquet-local"
> at
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> ~[na:1.7.0_51]
> at java.lang.Integer.parseInt(Integer.java:492) ~[na:1.7.0_51]
> at java.lang.Integer.parseInt(Integer.java:527) ~[na:1.7.0_51]
> at
> org.apache.zookeeper.client.ConnectStringParser.<init>(ConnectStringParser.java:72)
> ~[zookeeper-3.4.3.jar:3.4.3-1240972]
> at org.apache.zookeeper.ZooKeeper.<init>(ZooKeeper.java:438)
> ~[zookeeper-3.4.3.jar:3.4.3-1240972]
> at org.apache.zookeeper.ZooKeeper.<init>(ZooKeeper.java:375)
> ~[zookeeper-3.4.3.jar:3.4.3-1240972]
> ...
>
> I guess this is a problem in parsing the parameters inside sqlline and
> then passing them correctly to DrillFactory. Could you explain to me a
> little bit about how sqlline works with Drill? Because I haven't been able
> to find any "obvious" code relating both of them. I will update the wiki
> with the working command, and then when this gets fixed, I have no problem
> updating it again ;)
>
>
> Renato M.
>
>
> 2014-06-04 18:53 GMT+02:00 Jacques Nadeau <ja...@apache.org>:
>
> I just added Yash. It looks like Renato, you already have edit access via
>> your apache login.
>>
>>
>> On Wed, Jun 4, 2014 at 9:19 AM, Jacques Nadeau <ja...@apache.org>
>> wrote:
>>
>> > Woh, i don't think that is the problem. I'm not even sure why that
>> > command line would work.
>> >
>> > I think you need to quote.
>> >
>> > Can you try ./bin/sqlline -u "jdbc:drill:zk=local:schema=parquet-local"
>> >
>> > What are your guys Confluence ids? I'll get you edit rights.
>> >
>> >
>> > On Wed, Jun 4, 2014 at 8:44 AM, Yash Sharma <ya...@gmail.com> wrote:
>> >
>> >> Please try:
>> >>
>> >> ./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local -n
>> >> admin -p admin
>> >>
>> >>
>> >> Peace,
>> >> Yash
>> >>
>> >>
>> >> On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
>> >> renatoj.marroquin@gmail.com> wrote:
>> >>
>> >> > Hi all,
>> >> >
>> >> > I am trying to read some parquet files using local mode, but I can
>> not
>> >> tell
>> >> > the sqlline class to use both options. Any idea what I am doing
>> wrong?
>> >> >
>> >> > This works:
>> >> > ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
>> >> >
>> >> > This also works:
>> >> > ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
>> >> >
>> >> > This doesn't work:
>> >> > ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin -p
>> >> admin
>> >> >
>> >> > Thanks!
>> >> >
>> >> >
>> >> > Renato M.
>> >> >
>> >>
>> >
>> >
>>
>
>
Re: Passing commands to sqline
Posted by Renato Marroquín Mogrovejo <re...@gmail.com>.
Hi Jacques,
Yes I realized that after trying 10 times with my gmail account, sorry
about that.
Now the command you suggested me doesn't work either:
./bin/sqlline -u "jdbc:drill:zk=local:schema=parquet-local" -n admin -p
admin
10:32:16.334 [main] ERROR c.n.c.f.imps.CuratorFrameworkImpl - Background
exception was not retry-able or retry gave up
java.lang.NumberFormatException: For input string: "schema=parquet-local"
at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
~[na:1.7.0_51]
at java.lang.Integer.parseInt(Integer.java:492) ~[na:1.7.0_51]
at java.lang.Integer.parseInt(Integer.java:527) ~[na:1.7.0_51]
at
org.apache.zookeeper.client.ConnectStringParser.<init>(ConnectStringParser.java:72)
~[zookeeper-3.4.3.jar:3.4.3-1240972]
at org.apache.zookeeper.ZooKeeper.<init>(ZooKeeper.java:438)
~[zookeeper-3.4.3.jar:3.4.3-1240972]
at org.apache.zookeeper.ZooKeeper.<init>(ZooKeeper.java:375)
~[zookeeper-3.4.3.jar:3.4.3-1240972]
...
I guess this is a problem in parsing the parameters inside sqlline and then
passing them correctly to DrillFactory. Could you explain to me a little
bit about how sqlline works with Drill? Because I haven't been able to find
any "obvious" code relating both of them. I will update the wiki with the
working command, and then when this gets fixed, I have no problem updating
it again ;)
Renato M.
2014-06-04 18:53 GMT+02:00 Jacques Nadeau <ja...@apache.org>:
> I just added Yash. It looks like Renato, you already have edit access via
> your apache login.
>
>
> On Wed, Jun 4, 2014 at 9:19 AM, Jacques Nadeau <ja...@apache.org> wrote:
>
> > Woh, i don't think that is the problem. I'm not even sure why that
> > command line would work.
> >
> > I think you need to quote.
> >
> > Can you try ./bin/sqlline -u "jdbc:drill:zk=local:schema=parquet-local"
> >
> > What are your guys Confluence ids? I'll get you edit rights.
> >
> >
> > On Wed, Jun 4, 2014 at 8:44 AM, Yash Sharma <ya...@gmail.com> wrote:
> >
> >> Please try:
> >>
> >> ./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local -n
> >> admin -p admin
> >>
> >>
> >> Peace,
> >> Yash
> >>
> >>
> >> On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
> >> renatoj.marroquin@gmail.com> wrote:
> >>
> >> > Hi all,
> >> >
> >> > I am trying to read some parquet files using local mode, but I can not
> >> tell
> >> > the sqlline class to use both options. Any idea what I am doing wrong?
> >> >
> >> > This works:
> >> > ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
> >> >
> >> > This also works:
> >> > ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
> >> >
> >> > This doesn't work:
> >> > ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin -p
> >> admin
> >> >
> >> > Thanks!
> >> >
> >> >
> >> > Renato M.
> >> >
> >>
> >
> >
>
Re: Passing commands to sqline
Posted by Jacques Nadeau <ja...@apache.org>.
I just added Yash. It looks like Renato, you already have edit access via
your apache login.
On Wed, Jun 4, 2014 at 9:19 AM, Jacques Nadeau <ja...@apache.org> wrote:
> Woh, i don't think that is the problem. I'm not even sure why that
> command line would work.
>
> I think you need to quote.
>
> Can you try ./bin/sqlline -u "jdbc:drill:zk=local:schema=parquet-local"
>
> What are your guys Confluence ids? I'll get you edit rights.
>
>
> On Wed, Jun 4, 2014 at 8:44 AM, Yash Sharma <ya...@gmail.com> wrote:
>
>> Please try:
>>
>> ./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local -n
>> admin -p admin
>>
>>
>> Peace,
>> Yash
>>
>>
>> On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
>> renatoj.marroquin@gmail.com> wrote:
>>
>> > Hi all,
>> >
>> > I am trying to read some parquet files using local mode, but I can not
>> tell
>> > the sqlline class to use both options. Any idea what I am doing wrong?
>> >
>> > This works:
>> > ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
>> >
>> > This also works:
>> > ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
>> >
>> > This doesn't work:
>> > ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin -p
>> admin
>> >
>> > Thanks!
>> >
>> >
>> > Renato M.
>> >
>>
>
>
Re: Passing commands to sqline
Posted by Jacques Nadeau <ja...@apache.org>.
Woh, i don't think that is the problem. I'm not even sure why that command
line would work.
I think you need to quote.
Can you try ./bin/sqlline -u "jdbc:drill:zk=local:schema=parquet-local"
What are your guys Confluence ids? I'll get you edit rights.
On Wed, Jun 4, 2014 at 8:44 AM, Yash Sharma <ya...@gmail.com> wrote:
> Please try:
>
> ./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local -n
> admin -p admin
>
>
> Peace,
> Yash
>
>
> On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
> renatoj.marroquin@gmail.com> wrote:
>
> > Hi all,
> >
> > I am trying to read some parquet files using local mode, but I can not
> tell
> > the sqlline class to use both options. Any idea what I am doing wrong?
> >
> > This works:
> > ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
> >
> > This also works:
> > ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
> >
> > This doesn't work:
> > ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin -p
> admin
> >
> > Thanks!
> >
> >
> > Renato M.
> >
>
Re: Passing commands to sqline
Posted by Yash Sharma <ya...@gmail.com>.
Please try:
./bin/sqlline -u jdbc:drill:zk=local jdbc:drill:schema=parquet-local -n
admin -p admin
Peace,
Yash
On Wed, Jun 4, 2014 at 9:08 PM, Renato Marroquín Mogrovejo <
renatoj.marroquin@gmail.com> wrote:
> Hi all,
>
> I am trying to read some parquet files using local mode, but I can not tell
> the sqlline class to use both options. Any idea what I am doing wrong?
>
> This works:
> ./bin/sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
>
> This also works:
> ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
>
> This doesn't work:
> ./bin/sqlline -u jdbc:drill:schema=parquet-local:zk=local -n admin -p admin
>
> Thanks!
>
>
> Renato M.
>