Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB