What are in the log files when you run drill-embedded? Does the drillbit actually come up?
The drill-embedded script should start sqlline and you should end up in the sqlline shell. If you want to start with sqlline instead of drill-embedded use the following ./sqlline -u jdbc:drill:zk=local NOTE: You can not start the drillbit with drill-embedded and then try to use a different sqlline to access, as it will try to start the drillbit again and will give an error. If you look in DRILL_HOME/log/drillbit.log you should see this if Drill started successfully 2015-05-21 08:36:43,824 [main] INFO o.apache.drill.exec.server.Drillbit - Drillbit environment: java.compiler=<NA> 2015-05-21 08:36:43,824 [main] INFO o.apache.drill.exec.server.Drillbit - Drillbit environment: os.name=Mac OS X 2015-05-21 08:36:43,824 [main] INFO o.apache.drill.exec.server.Drillbit - Drillbit environment: os.arch=x86_64 2015-05-21 08:36:43,824 [main] INFO o.apache.drill.exec.server.Drillbit - Drillbit environment: os.version=10.9.5 2015-05-21 08:36:43,824 [main] INFO o.apache.drill.exec.server.Drillbit - Drillbit environment: user.name=aengelbrecht 2015-05-21 08:36:43,824 [main] INFO o.apache.drill.exec.server.Drillbit - Drillbit environment: user.home=/Users/aengelbrecht 2015-05-21 08:36:43,824 [main] INFO o.apache.drill.exec.server.Drillbit - Drillbit environment: user.dir=/Users/aengelbrecht/drill/apache-drill-1.0.0/bin 2015-05-21 08:36:44,555 [main] INFO o.apache.drill.exec.server.Drillbit - Construction completed (731 ms). 2015-05-21 08:36:48,182 [main] INFO o.a.d.e.e.f.FunctionImplementationRegistry - Function registry loaded. 2360 functions loaded in 3292 ms. 2015-05-21 08:36:49,449 [main] INFO o.apache.drill.exec.server.Drillbit - Startup completed (4893 ms). —Andries On May 20, 2015, at 8:48 PM, Davide Giannella <[email protected]> wrote: > On 20/05/2015 15:37, Andries Engelbrecht wrote: >> Drill in embedded mode does not use zookeeper. >> >> Have you tried to just run just bin/drill-embedded from the Drill >> Home directory? > this is what I did following the drill 10 minutes >> This works fine for me on OSX, and I followed the documentation outlined in >> http://drill.apache.org/docs/drill-in-10-minutes/ >> >> I didn’t use sudo to extract the tar package. > I didn't as well. > > Nevertheless today I got a different error and I guess it's not a > problem with either permissions or previously running processes as I > kill -9 any drill process and I tried running drill with sudo, which > should clear the permissions issues if any. > > The new error follows below. > > I tried running bin/sqlline and it went up without errors but then I > fail in connecting with !connect 127.0.0.1 admin admin as it says it's > missing a jdbc class. I tried providing as well the jdbc:drill:zk. My > hunch is that I didn't provide the correct -cp when firing up the script > but as I don't have much time I didn't investigate any further. > > Thank you > Davide > > Error: Failure in starting embedded Drillbit: > java.net.UnknownHostException: davide-osx: davide-osx: nodename nor > servname provided, or not known (state=,code=0) > java.sql.SQLException: Failure in starting embedded Drillbit: > java.net.UnknownHostException: davide-osx: davide-osx: nodename nor > servname provided, or not known > at > org.apache.drill.jdbc.DrillConnectionImpl.<init>(DrillConnectionImpl.java:102) > at > org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection.<init>(DrillJdbc41Factory.java:97) > at > org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:60) > at > org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:46) > at > org.apache.drill.jdbc.DrillFactory.newConnection(DrillFactory.java:54) > at > net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126) > at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167) > at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213) > at sqlline.Commands.connect(Commands.java:1083) > at sqlline.Commands.connect(Commands.java:1015) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) > at sqlline.SqlLine.dispatch(SqlLine.java:734) > at sqlline.SqlLine.initArgs(SqlLine.java:519) > at sqlline.SqlLine.begin(SqlLine.java:587) > at sqlline.SqlLine.start(SqlLine.java:366) > at sqlline.SqlLine.main(SqlLine.java:259) > Caused by: java.net.UnknownHostException: davide-osx: davide-osx: > nodename nor servname provided, or not known > at java.net.InetAddress.getLocalHost(InetAddress.java:1473) > at > org.apache.drill.exec.service.ServiceEngine.start(ServiceEngine.java:66) > at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:241) > at > org.apache.drill.jdbc.DrillConnectionImpl.<init>(DrillConnectionImpl.java:97) > ... 19 more > Caused by: java.net.UnknownHostException: davide-osx: nodename nor > servname provided, or not known > at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) > at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:901) > at > java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1293) > at java.net.InetAddress.getLocalHost(InetAddress.java:1469) > ... 22 more >
