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 < [email protected]>: > 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 <[email protected]>: > > 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 <[email protected]> >> 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 <[email protected]> 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 < >> >> [email protected]> 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. >> >> > >> >> >> > >> > >> > >
