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

Switch to Threaded View
Drill >> mail # user >> How to load data in Drill


Copy link to this message
-
Re: How to load data in Drill
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