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
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)
at
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
at
io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
at
io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)
at
io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:173)
at
io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
at
io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)
at
io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:785)
at
io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:100)
at
io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:497)
at
io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:465)
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:359)
at
io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:101)
at java.lang.Thread.run(Thread.java:724)
0: jdbc:drill:schema=parquet-local>
On Thu, Dec 12, 2013 at 5:42 AM, Rajika Kumarasiri <
[EMAIL PROTECTED]> wrote:

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