Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Drill >> mail # user >> quick start guide


Copy link to this message
-
Re: quick start guide
Thank you for your reply. It caused by the env variable, HADOOP_HOME
pointing to /home/rajika/project/accumulo/hadoop-1.0.4. I removed this and
that error is gone. I am still getting the
line, /home/rajika/.sqlline/sqlline.properties (but I hope it will not
affect the functionality)  and the same exception when trying to execute a
query.

loaded singnal handler: SunSignalHandler
/home/rajika/.sqlline/sqlline.properties (No such file or directory)
scan complete in 38ms
scan complete in 2709ms
Connecting to jdbc:drill:schema=parquet-local
Connected to: Drill (version 1.0)
Driver: Apache Drill JDBC Driver (version 1.0)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
sqlline version ??? by Marc Prud'hommeaux
0: jdbc:drill:schema=parquet-local>

On Mon, Dec 16, 2013 at 1:01 AM, Jacques Nadeau <[EMAIL PROTECTED]> wrote:

> The line at the top:
>
> ls: cannot access /home/rajika/project/accumulo/hadoop-1.0.4/lib/*jar: No
> such file or directory
>
> Seem a bit strange.  What are your env variables?
>
>
> On Sat, Dec 14, 2013 at 5:18 PM, Rajika Kumarasiri <
> [EMAIL PROTECTED]> wrote:
>
> > BTW, there is a typo in the following log line.
> >
> > Loaded singnal handler: SunSignalHandler
> >
> >
> > Rajika
> >
> >
> > On Sat, Dec 14, 2013 at 8:10 PM, Rajika Kumarasiri <
> > [EMAIL PROTECTED]> wrote:
> >
> > > log file can be configured using the enviornment varible DRILL_LOG_DIR.
> > > Now the out put is following.
> > >
> > > [rajika@localhost bin]$ ./sqlline -u jdbc:drill:schema=parquet-local
> -n
> > > admin -p admin
> > > ls: cannot access /home/rajika/project/accumulo/hadoop-1.0.4/lib/*jar:
> No
> > > such file or directory
> > >
> > > Loaded singnal handler: SunSignalHandler
> > > /home/rajika/.sqlline/sqlline.properties (No such file or directory)
> > > scan complete in 32ms
> > > scan complete in 2701ms
> > > Connecting to jdbc:drill:schema=parquet-local
> > > Connected to: Drill (version 1.0)
> > > Driver: Apache Drill JDBC Driver (version 1.0)
> > > Autocommit status: true
> > > Transaction isolation: TRANSACTION_REPEATABLE_READ
> > > sqlline version ??? by Marc Prud'hommeaux
> > >
> > >
> > >
> > > And query execution gives;
> > >
> > > 0: jdbc:drill:schema=parquet-local> select * from
> > > "sample-data/region.parquet";
> > > Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure
> > while
> > > running query.[error_id: "e91fcd81-50af-4904-b3a3-eef3c45a13c6"
> > > endpoint {
> > >   address: "localhost"
> > >   user_port: 31010
> > >   bit_port: 31011
> > > }
> > > error_type: 0
> > > message: "Failure while converting logical plan to physical plan. <
> > > OptimizerException:[ Failure while attempting to retrieve storage
> > engine. ]
> > > < FileNotFoundException:[ File sample-data/region.parquet does not
> > exist. ]"
> > > ]
> > > java.lang.RuntimeException: org.apache.drill.exec.rpc.RpcException:
> > Remote
> > > failure while running query.[error_id:
> > > "e91fcd81-50af-4904-b3a3-eef3c45a13c6"
> > > endpoint {
> > >   address: "localhost"
> > >   user_port: 31010
> > >   bit_port: 31011
> > > }
> > > error_type: 0
> > > message: "Failure while converting logical plan to physical plan. <
> > > OptimizerException:[ Failure while attempting to retrieve storage
> > engine. ]
> > > < FileNotFoundException:[ File sample-data/region.parquet does not
> > exist. ]"
> > > ]
> > > at
> > >
> >
> org.apache.drill.sql.client.full.ResultEnumerator.moveNext(ResultEnumerator.java:61)
> > > at
> > >
> >
> net.hydromatic.optiq.runtime.ObjectEnumeratorCursor.next(ObjectEnumeratorCursor.java:44)
> > >  at
> > net.hydromatic.optiq.jdbc.OptiqResultSet.next(OptiqResultSet.java:162)
> > > at sqlline.SqlLine$BufferedRows.<init>(SqlLine.java:2499)
> > >  at sqlline.SqlLine.print(SqlLine.java:1886)
> > > at sqlline.SqlLine$Commands.execute(SqlLine.java:3835)
> > > at sqlline.SqlLine$Commands.sql(SqlLine.java:3738)
> > >  at sqlline.SqlLine.dispatch(SqlLine.java:882)
> > > at sqlline.SqlLine.begin(SqlLine.java:717)