Hi Madhu, Could you attach the complete logs during this run? The easiest way is probably to edit the sqlline shell script and remove the ' -Dlogback.configurationFile=...' argument like so:
-exec java -Xmx2G -Dlogback.configurationFile=./sqlparser/src/test/resources/logback.xml -cp ./:"$(cat .classpath)" sqlline.SqlLine --verbose=true "$@" *+exec java -Xmx2G -cp ./:"$(cat .classpath)" sqlline.SqlLine --verbose=true "$@"* This will cause all log output to be directed to the console. Alternatively, you may want to log to a file or another facility by editing the aforementioned logback.xml file. One last note -- although unlikely, parts of the dataset may be included in the logs, so be sure to redact any sensitive information from the logs before posting. Thanks, Ben On Tue, Nov 19, 2013 at 6:36 PM, Madhu Borkar <[email protected]> wrote: > Ben, > Here is log snippet using lilith.. > <?xml version='1.0' encoding='UTF-8'?> > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" " > http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> > <html xmlns='http://www.w3.org/1999/xhtml'><head><title>Title</title><link > href='detailsView.css' rel='stylesheet' > type='text/css'/></head><body><table><tr > class='even'><th>Message</th><td><pre>Exception during > query</pre></td></tr><tr class='odd'><th>Throwable</th><td > class='throwableContainer'><div class='throwable'><a > > href='ste://org.apache.drill.exec.rpc.user.QueryResultHandler.batchArrived(QueryResultHandler.java:72)'>org.apache.drill.exec.rpc.RpcException</a><pre><a > > href='ste://org.apache.drill.exec.rpc.user.QueryResultHandler.batchArrived(QueryResultHandler.java:72)'>Remote > failure while running query.[error_id: > "b9ce54dd-085c-435d-b12f-e9896c60e864" > endpoint { > address: "Node-0.etouch.net" > user_port: 31010 > bit_port: 32011 > } > error_type: 0 > message: "Failure while running fragment. < NullPointerException" > ]</a></pre><hr/><a > > href='ste://org.apache.drill.exec.rpc.user.QueryResultHandler.batchArrived(QueryResultHandler.java:72)'>at org.apache.drill.exec.rpc.user.QueryResultHandler.batchArrived(QueryResultHandler.java:72) ~[java-exec-1.0.0-m1-rebuffed.jar:1.0.0-m1]</a><a > > href='ste://org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:79)'>at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:79) ~[java-exec-1.0.0-m1-rebuffed.jar:1.0.0-m1]</a><a > > href='ste://org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:48)'>at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:48) ~[java-exec-1.0.0-m1-rebuffed.jar:1.0.0-m1]</a><a > > href='ste://org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:33)'>at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:33) ~[java-exec-1.0.0-m1-rebuffed.jar:1.0.0-m1]</a><a > > href='ste://org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:142)'>at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:142) ~[java-exec-1.0.0-m1-rebuffed.jar:1.0.0-m1]</a><a > > href='ste://org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:127)'>at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:127) ~[java-exec-1.0.0-m1-rebuffed.jar:1.0.0-m1]</a><a > > href='ste://io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)'>at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) ~[netty-codec-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)'>at io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)'>at io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)'>at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102) ~[netty-codec-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)'>at io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)'>at io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:173)'>at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:173) ~[netty-codec-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)'>at io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)'>at io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:785)'>at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:785) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:100)'>at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:100) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:497)'>at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:497) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:465)'>at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:465) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:359)'>at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:359) ~[netty-transport-4.0.7.Final.jar:na]</a><a > > href='ste://io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:101)'>at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:101) ~[netty-common-4.0.7.Final.jar:na]</a><a > > href='ste://java.lang.Thread.run(Thread.java:744)'>at java.lang.Thread.run(Thread.java:744) ~[na:1.7.0_45]</a></div></td></tr><tr > class='even'><th>Level</th><td>ERROR</td></tr><tr > > class='odd'><th>Logger</th><td>org.apache.drill.sql.client.full.ResultEnumerator</td></tr><tr > class='even'><th>Thread</th><td>main (id=1)</td></tr><tr > class='odd'><th>Timestamp</th><td>2013-11-19 18:26:42.023-0800</td></tr><tr > class='even'><th>Call Location</th><td><a > > href='ste://org.apache.drill.sql.client.full.ResultEnumerator.moveNext(ResultEnumerator.java:43)'>at org.apache.drill.sql.client.full.ResultEnumerator.moveNext(ResultEnumerator.java:43)</a></td></tr><tr > > class='odd'><th>Logger Context</th><td><table><tr><th>Name</th><td>default</td></tr><tr><th>Birthtime</th><td>2013-11-19 > > 18:26:06.371-0800</td></tr><tr><th>Properties</th><td><table><tr><th>Key</th><th>Value</th></tr><tr><td>HOSTNAME</td><td> > Node-0.etouch.net</td></tr></table></td></tr></table></td></tr><tr > > class='even'><th>Source ID</th><td>127.0.0.1-20131119T182606709</td></tr><tr > class='odd'><th>Local ID</th><td>71</td></tr></table></body></html> > > > On Tue, Nov 19, 2013 at 9:34 AM, Ben Becker <[email protected]> wrote: > > > Hi Madhu, > > > > Could you report which version you're using (e.g. 1.0.0-m1.rc3), and > attach > > the logs when this happens? You can use Lilith to view the logs if you > > like (see instructions at the bottom of this > > page< > > > https://cwiki.apache.org/confluence/display/DRILL/How+To+Run+Drill+with+Sample+Data# > > > > > ). > > > > Thanks, > > Ben > > > > > > On Mon, Nov 18, 2013 at 10:16 PM, Madhu Borkar <[email protected] > > >wrote: > > > > > I have devlopment MapR cluster. I have installed Apache Drill using > > > binaries. I could run queries with sample-data. > > > > > > I decided to load test data using pig. Here is my code > > > > > > --------------------------------- > > > > > > REGISTER file:/home/mapr/lib/parquet-pig-bundle-1.2.5.jar > > > > > > data = LOAD '$DATA' > > > > > > USING PigStorage(',') > > > > > > as ( > > > > > > user: chararray, > > > > > > street: chararray, > > > > > > state: chararray, > > > > > > city: chararray, > > > > > > type: chararray > > > > > > ); > > > > > > > > > > > > A = LIMIT data 3; > > > > > > dump A; > > > > > > fs -rmr /mapr-hive/parquet/data; > > > > > > STORE data INTO '/mapr-hive/parquet/data' using > > > parquet.pig.ParquetStorer(); > > > > > > ---------------------- > > > > > > Pig script writes to output. I moved data under apache drill directory. > > > > > > > > > > > > select * from "real-data/users.parquet"; > > > > > > > > > > > > but when I try to query this data I get rpc error? > > > > > > Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure > > while > > > running query.[error_id: "04ac52e4-b49e-45b8-82c5-cf480154eefd" > > > > > > endpoint { > > > > > > address: "Node.etouch.net" > > > > > > user_port: 31010 > > > > > > bit_port: 32011 > > > > > > } > > > > > > error_type: 0 > > > > > > message: "Failure while running fragment. < NullPointerException" > > > > > > ] > > > > > > > > > > > > Please, provide me help how to load data in Apache Drill.? > > > > > > Is there MapR configuration needed for Drill? > > > > > > Regards > > > > > >
