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

Switch to Plain View
Drill, mail # user - How to load data in Drill


+
Madhu Borkar 2013-11-19, 06:16
+
Ben Becker 2013-11-19, 17:34
+
Madhu Borkar 2013-11-20, 02:36
Copy link to this message
-
Re: How to load data in Drill
Ben Becker 2013-11-21, 17:50
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
+
Madhu Borkar 2013-11-22, 02:12
+
Tom Seddon 2013-11-27, 22:52
+
Madhu Borkar 2013-11-20, 02:31
+
Jinfeng Ni 2013-12-02, 06:34
+
Madhu Borkar 2013-12-02, 23:15
+
Jinfeng Ni 2013-12-03, 05:38
+
Jason Altekruse 2013-12-03, 06:03
+
Jinfeng Ni 2013-12-03, 06:21
+
Madhu Borkar 2013-12-03, 07:38
+
Tom Seddon 2013-12-04, 15:02
+
Jinfeng Ni 2013-12-04, 17:14
+
Jason Altekruse 2014-01-13, 05:42
+
Madhu Borkar 2014-01-14, 20:10
+
Jason Altekruse 2014-01-14, 22:42
+
Madhu Borkar 2014-01-15, 02:08
+
Jason Altekruse 2014-01-15, 05:55