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
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)
> at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460)
>  at sqlline.SqlLine.main(SqlLine.java:443)
> Caused by: 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.exec.rpc.user.QueryResultHandler.batchArrived(QueryResultHandler.java:72)
> at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:79)
>  at
> org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:48)
> at
> org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:33)
>  at
> org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:142)
> at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:127)
>  at
> io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
> at
> io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
>  at
> io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)