Hi all, Thanks a lot for your helpful suggestions. Finally, got sqlLine connect to jdbc:drill:schema=parquet-local.
Turns out the java version in my machine is 6 in stead of 7. Here is what happened: 1. I install openjdk 7 first. 2. When install maven, openjdk 6 will be installed as well. This will change the java version to 6. The following NEW packages will be installed: ant ant-optional aspectj bsh bsh-gcj fop icedtea-6-jre-cacao icedtea-6-jre-jamvm icedtea-netx junit4 libaether-java libbatik-java libcdi-api-java libdoxia-java libdoxia-sitetools-java libfop-java libgeronimo-interceptor-3.0-spec-java libgeronimo-jpa-2.0-spec-java libgeronimo-osgi-support-java libmaven-plugin-tools-java libmaven-reporting-impl-java libmaven-scm-java libmaven2-core-java libosgi-compendium-java libplexus-bsh-factory-java libplexus-containers1.5-java libplexus-velocity-java libsisu-ioc-java libwagon-java *maven openjdk-6-jre* openjdk-6-jre-headless openjdk-6-jre-lib rhino velocity After switching java version from 6 to 7, and re-do from the beginning, it worked ! :-) I guess the sequence to install the required packages had better to be : 1) install maven 3 and protoc 2.5 2) then install java 7. or use " update-alternatives --config java " to switch the java version if follow the sequence specified in Drill DEMO link. Thanks again for the help! On Sun, Sep 8, 2013 at 2:36 AM, Steven Phillips <[email protected]>wrote: > The .classpath file seems to not have the complete classpath. It only has > parquet jars, and not any of the drill jars or other dependencies. Could > you try deleting the .classpath file and then running sqlline again? The > sqlline script will generate a new .classpath file, using the mvn > dependency:build-classpath command. > > > On Sat, Sep 7, 2013 at 11:08 PM, Ted Dunning <[email protected]> > wrote: > > > On Sat, Sep 7, 2013 at 9:55 PM, joycreek Ni <[email protected]> > wrote: > > > > > However, when I run the following command: > > > > > > ./sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin > > > > > > I hit the following error: > > > > > > ------------------------------------------------ > > > Loaded singnal handler: SunSignalHandler > > > /home/ubuntu/.sqlline/sqlline.properties (No such file or directory) > > > issuing: !connect jdbc:drill:schema=parquet-local admin admin scan > > complete > > > in 72ms scan complete in 849ms No known driver to handle > > > "jdbc:drill:schema=parquet-local" sqlline version ??? by Marc > > Prud'hommeaux > > > > > > > Harumph. > > > > Can you say which version you are trying to run? > > > > Which versions of java and maven do you have? > > > > (I am grasping at straws, obviously) > > >
