AnsweredAssumed Answered

Help with "Error: RESOURCE ERROR: Failed to create schema tree."

Question asked by dave.a.duran on Oct 10, 2016
Latest reply on Oct 11, 2016 by maprcommunity
Branched to a new discussion

Amazon EC2 running 3 nodes Ubuntu 14.04 (I get the same error running 1 node as well)
Modified security group on each node adding "Custom TCP Rule" all ports and ran mapr-setup.sh on each node
Used MapR Installer
MapR 5.2 Community Edition
MEP 1.1
Drill 1.8
Hive 1.2

 

Using NFS Mount, dfs storage plugin is configured with workspace tmp and "connection": "maprfs://mapr/"
fish.csv is in /mapr/my.cluster.com/tmp/

 

Using sqlline
!connect jdbc:drill:drillbit=ip-172-31-3-72.us-west-2.compute.internal mapr mapr

 

Running the query below gives the following error (trying to turn on verbose errors, identify foreman, drill version all give same error):

 

0: jdbc:drill:drillbit=ip-172-31-3-73.us-west> select * from dfs.tmp.`fish.csv`;
Error: RESOURCE ERROR: Failed to create schema tree.

 

[Error Id: bbc95db1-6db8-408d-b092-8804f816e29b on ip-172-31-3-73.us-west-2.compute.internal:31010] (state=,code=0)

 


FROM  /opt/mapr/drill/drill-1.8.0/logs/sqlline.log

 

2016-10-10 11:35:16,297 [main] INFO  o.a.drill.common.config.DrillConfig - Configuration and plugin file(s) identified in 125ms.
Base Configuration:
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-common-1.8.0.jar!/drill-default.conf

 

Intermediate Configuration and Plugin files, in order of precedence:
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/3rdparty/drill-memory-base-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-common-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-java-exec-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-storage-hbase-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-storage-maprdb-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-hive-exec-shaded-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-gis-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-kudu-storage-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-memory-base-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-storage-hive-core-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-mongo-storage-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-jdbc-storage-1.8.0.jar!/drill-module.conf
        - jar:file:/opt/mapr/drill/drill-1.8.0/jars/drill-logical-1.8.0.jar!/drill-module.conf

 

Override File: file:/opt/mapr/drill/drill-1.8.0/conf/drill-override.conf

 

2016-10-10 11:35:16,717 [main] WARN  o.a.drill.exec.metrics.DrillMetrics - Removing old metric since name matched newly registered metric. Metric name: drill.allocator.root.used
2016-10-10 11:35:16,717 [main] WARN  o.a.drill.exec.metrics.DrillMetrics - Removing old metric since name matched newly registered metric. Metric name: drill.allocator.root.peak
2016-10-10 11:35:57,798 [USER-rpc-event-queue] INFO  o.a.d.j.i.DrillResultSetImpl$ResultsListener - [#1] Query failed:
org.apache.drill.common.exceptions.UserRemoteException: RESOURCE ERROR: Failed to create schema tree.

 

[Error Id: bbc95db1-6db8-408d-b092-8804f816e29b on ip-172-31-3-73.us-west-2.compute.internal:31010]
        at org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123) [drill-java-exec-1.8.0.jar:1.8.0]
        at org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:134) [drill-java-exec-1.8.0.jar:1.8.0]
        at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:46) [drill-rpc-1.8.0.jar:1.8.0]
        at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:31) [drill-rpc-1.8.0.jar:1.8.0]
        at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:65) [drill-rpc-1.8.0.jar:1.8.0]
        at org.apache.drill.exec.rpc.RpcBus$RequestEvent.run(RpcBus.java:363) [drill-rpc-1.8.0.jar:1.8.0]
        at org.apache.drill.common.SerializedExecutor$RunnableProcessor.run(SerializedExecutor.java:89) [drill-rpc-1.8.0.jar:1.8.0]
        at org.apache.drill.exec.rpc.RpcBus$SameExecutor.execute(RpcBus.java:240) [drill-rpc-1.8.0.jar:1.8.0]
        at org.apache.drill.common.SerializedExecutor.execute(SerializedExecutor.java:123) [drill-rpc-1.8.0.jar:1.8.0]
        at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274) [drill-rpc-1.8.0.jar:1.8.0]
        at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:245) [drill-rpc-1.8.0.jar:1.8.0]
        at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) [netty-codec-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254) [netty-handler-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) [netty-codec-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242) [netty-codec-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) [netty-transport-4.0.27.Final.jar:4.0.27.Final]
        at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) [netty-common-4.0.27.Final.jar:4.0.27.Final]
        at java.lang.Thread.run(Thread.java:745) [na:1.7.0_111]

Outcomes