Hey, Images haven't come through (usually attachments aren't supported in mailing lists). Can you please find another way of sharing them?
Also, can you share how you deployed Drill - did you build from source or download packages from MapR? The message usually means your DFS storage plugin is unable to talk to MapR-FS. Please share the DFS storage plugin contents, the drill-env.sh [and distrib-env.sh] files. Also, a verbose version of the error message you observe. Regards, Abhishek On Thu, Feb 1, 2018 at 10:57 AM, Willian Ribeiro < [email protected]> wrote: > Good morning, > > I've tried a lot of suggestions for this error, but i couldn't find any > solution for my problem. > > - I have a mapr cluster with hive tables in it. > > - I need to use the Drill to query those tables outside the cluster. > > - I have a CentOS VM configured with distributed Drill but as a single > node (just for now). > > - I can see the tables and query them when they are empty like this one: > > [image: Inline image 1] > > > but when i try to query a table that isn't empty, i get this error: > > [image: Inline image 4] > > > My question is: I can query hive tables (located in a mapr cluster) from > Drill that is installed in a VM (CentOS) outside this cluster? > > > This is how i setup Drill: > > STORAGE PLUGIN: > > [image: Inline image 5] > > drill-override.conf (Configured as a cluster single node) > > [image: Inline image 7] > > DRILL JARS: > > [image: Inline image 8] > > > 3rparty JARS: > > 3rdparty/antlr-2.7.7.jar > > 3rdparty/antlr-runtime-3.4.jar > > 3rdparty/apacheds-i18n-2.0.0-M15.jar > > 3rdparty/apacheds-kerberos-codec-2.0.0-M15.jar > > 3rdparty/api-asn1-api-1.0.0-M20.jar > > 3rdparty/api-util-1.0.0-M20.jar > > 3rdparty/asm-debug-all-5.0.3.jar > > 3rdparty/async-1.4.1.jar > > 3rdparty/avro-1.7.7.jar > > 3rdparty/avro-ipc-1.7.7.jar > > 3rdparty/avro-ipc-1.7.7-tests.jar > > 3rdparty/avro-mapred-1.7.7.jar > > 3rdparty/aws-java-sdk-1.7.4.jar > > 3rdparty/bcpkix-jdk15on-1.52.jar > > 3rdparty/bcprov-jdk15on-1.52.jar > > 3rdparty/bonecp-0.8.0.RELEASE.jar > > 3rdparty/calcite-avatica-1.4.0-drill-r23.jar > > 3rdparty/calcite-core-1.4.0-drill-r23.jar > > 3rdparty/calcite-linq4j-1.4.0-drill-r23.jar > > 3rdparty/commons-beanutils-1.8.3.jar > > 3rdparty/commons-beanutils-core-1.8.0.jar > > 3rdparty/commons-cli-1.2.jar > > 3rdparty/commons-codec-1.10.jar > > 3rdparty/commons-collections-3.2.1.jar > > 3rdparty/commons-compiler-2.7.6.jar > > 3rdparty/commons-compress-1.4.1.jar > > 3rdparty/commons-configuration-1.6.jar > > 3rdparty/commons-dbcp-1.4.jar > > 3rdparty/commons-digester-1.8.1.jar > > 3rdparty/commons-httpclient-3.1.jar > > 3rdparty/commons-io-2.4.jar > > 3rdparty/commons-lang-2.6.jar > > 3rdparty/commons-lang3-3.1.jar > > 3rdparty/commons-math-2.2.jar > > 3rdparty/commons-math3-3.1.1.jar > > 3rdparty/commons-net-3.6.jar > > 3rdparty/commons-pool-1.5.4.jar > > 3rdparty/commons-pool2-2.1.jar > > 3rdparty/commons-validator-1.4.1.jar > > 3rdparty/config-1.0.0.jar > > 3rdparty/converter-jackson-2.1.0.jar > > 3rdparty/curator-client-2.7.1.jar > > 3rdparty/curator-framework-2.7.1.jar > > 3rdparty/curator-recipes-2.7.1.jar > > 3rdparty/curator-x-discovery-2.7.1.jar > > 3rdparty/datanucleus-api-jdo-3.2.6.jar > > 3rdparty/datanucleus-core-3.2.10.jar > > 3rdparty/datanucleus-rdbms-3.2.9.jar > > 3rdparty/de.huxhorn.lilith.data.converter-0.9.44.jar > > 3rdparty/de.huxhorn.lilith.data.eventsource-0.9.44.jar > > 3rdparty/de.huxhorn.lilith.data.logging-0.9.44.jar > > 3rdparty/de.huxhorn.lilith.data.logging.protobuf-0.9.44.jar > > 3rdparty/de.huxhorn.lilith.logback.appender.multiplex-classic-0.9.44.jar > > 3rdparty/de.huxhorn.lilith.logback.appender.multiplex-core-0.9.44.jar > > 3rdparty/de.huxhorn.lilith.logback.classic-0.9.44.jar > > 3rdparty/de.huxhorn.lilith.logback.converter-classic-0.9.44.jar > > 3rdparty/de.huxhorn.lilith.sender-0.9.44.jar > > 3rdparty/de.huxhorn.sulky.codec-0.9.17.jar > > 3rdparty/de.huxhorn.sulky.formatting-0.9.17.jar > > 3rdparty/de.huxhorn.sulky.io-0.9.17.jar > > 3rdparty/derby-driver.jar > > 3rdparty/disruptor-3.3.0.jar > > 3rdparty/dom4j-1.6.1.jar > > 3rdparty/eigenbase-properties-1.1.5.jar > > 3rdparty/esri-geometry-api-2.0.0.jar > > 3rdparty/findbugs-annotations-1.3.9-1.jar > > 3rdparty/foodmart-data-json-0.4.jar > > 3rdparty/freemarker-2.3.26-incubating.jar > > 3rdparty/gson-2.2.4.jar > > 3rdparty/guava-18.0.jar > > 3rdparty/hadoop-annotations-2.7.1.jar > > 3rdparty/hadoop-auth-2.7.1.jar > > 3rdparty/hadoop-aws-2.7.1.jar > > 3rdparty/hadoop-client-2.7.1.jar > > 3rdparty/hadoop-common-2.7.1.jar > > 3rdparty/hadoop-hdfs-2.7.1.jar > > 3rdparty/hadoop-mapreduce-client-app-2.7.1.jar > > 3rdparty/hadoop-mapreduce-client-common-2.7.1.jar > > 3rdparty/hadoop-mapreduce-client-core-2.7.1.jar > > 3rdparty/hadoop-mapreduce-client-jobclient-2.7.1.jar > > 3rdparty/hadoop-mapreduce-client-shuffle-2.7.1.jar > > 3rdparty/hadoop-yarn-client-2.7.1.jar > > 3rdparty/hadoop-yarn-common-2.7.1.jar > > 3rdparty/hadoop-yarn-server-common-2.7.1.jar > > 3rdparty/hamcrest-core-1.3.jar > > 3rdparty/hbase-annotations-1.1.3.jar > > 3rdparty/hbase-client-1.1.3.jar > > 3rdparty/hbase-common-1.1.3.jar > > 3rdparty/hbase-common-1.1.3-tests.jar > > 3rdparty/hbase-hadoop2-compat-1.1.3.jar > > 3rdparty/hbase-hadoop-compat-1.1.3.jar > > 3rdparty/hbase-prefix-tree-1.1.3.jar > > 3rdparty/hbase-procedure-1.1.3.jar > > 3rdparty/hbase-protocol-1.1.3.jar > > 3rdparty/hbase-server-1.1.3.jar > > 3rdparty/hive-contrib-1.2.1.jar > > 3rdparty/hive-exec-2.1.1-mapr-1707-c25ea1308fbe694dcd8067f0b439c0 > 8d8a46eff2e3b59d46d5de5d15d39a37ba.jar > > 3rdparty/hive-hbase-handler-1.2.1.jar > > 3rdparty/hive-metastore-1.2.1.jar > > 3rdparty/hppc-0.7.1.jar > > 3rdparty/htrace-core-3.1.0-incubating.jar > > 3rdparty/httpclient-4.2.5.jar > > 3rdparty/httpcore-4.2.4.jar > > 3rdparty/httpdlog-parser-2.4.jar > > 3rdparty/interface-annotations-1.3.0.jar > > 3rdparty/jackson-annotations-2.7.9.jar > > 3rdparty/jackson-core-2.7.9.jar > > 3rdparty/jackson-core-asl-1.9.13.jar > > 3rdparty/jackson-databind-2.7.9.1.jar > > 3rdparty/jackson-jaxrs-1.9.13.jar > > 3rdparty/jackson-jaxrs-base-2.7.9.jar > > 3rdparty/jackson-jaxrs-json-provider-2.7.9.jar > > 3rdparty/jackson-mapper-asl-1.9.13.jar > > 3rdparty/jackson-module-afterburner-2.7.9.jar > > 3rdparty/jackson-module-jaxb-annotations-2.7.9.jar > > 3rdparty/jackson-xc-1.9.13.jar > > 3rdparty/janino-2.7.6.jar > > 3rdparty/java-sizeof_2.11-0.1.jar > > 3rdparty/javassist-3.16.1-GA.jar > > 3rdparty/javax.inject-1.jar > > 3rdparty/jcl-over-slf4j-1.7.6.jar > > 3rdparty/jcodings-1.0.8.jar > > 3rdparty/jcommander-1.30.jar > > 3rdparty/jdo-api-3.0.1.jar > > 3rdparty/jetty-continuation-9.1.1.v20140108.jar > > 3rdparty/jetty-http-9.1.5.v20140505.jar > > 3rdparty/jetty-io-9.1.5.v20140505.jar > > 3rdparty/jetty-security-9.1.5.v20140505.jar > > 3rdparty/jetty-server-9.1.5.v20140505.jar > > 3rdparty/jetty-servlet-9.1.5.v20140505.jar > > 3rdparty/jetty-servlets-9.1.5.v20140505.jar > > 3rdparty/jetty-util-9.1.5.v20140505.jar > > 3rdparty/jetty-webapp-9.1.1.v20140108.jar > > 3rdparty/jetty-xml-9.1.1.v20140108.jar > > 3rdparty/jline-2.10.jar > > 3rdparty/jna-4.5.0.jar > > 3rdparty/joda-time-2.9.jar > > 3rdparty/joni-2.1.2.jar > > 3rdparty/jopt-simple-5.0.3.jar > > 3rdparty/jpam-1.1.jar > > 3rdparty/jsch-0.1.42.jar > > 3rdparty/json-simple-1.1.1.jar > > 3rdparty/jsp-api-2.1.jar > > 3rdparty/jsr305-3.0.0.jar > > 3rdparty/jta-1.1.jar > > 3rdparty/jul-to-slf4j-1.7.6.jar > > 3rdparty/kafka_2.11-0.11.0.1.jar > > 3rdparty/kafka-clients-0.11.0.1.jar > > 3rdparty/kerb-admin-1.0.0-RC2.jar > > 3rdparty/kerb-client-1.0.0-RC2.jar > > 3rdparty/kerb-common-1.0.0-RC2.jar > > 3rdparty/kerb-core-1.0.0-RC2.jar > > 3rdparty/kerb-crypto-1.0.0-RC2.jar > > 3rdparty/kerb-identity-1.0.0-RC2.jar > > 3rdparty/kerb-server-1.0.0-RC2.jar > > 3rdparty/kerb-simplekdc-1.0.0-RC2.jar > > 3rdparty/kerb-util-1.0.0-RC2.jar > > 3rdparty/kerby-asn1-1.0.0-RC2.jar > > 3rdparty/kerby-config-1.0.0-RC2.jar > > 3rdparty/kerby-pkix-1.0.0-RC2.jar > > 3rdparty/kerby-util-1.0.0-RC2.jar > > 3rdparty/kudu-client-1.3.0.jar > > 3rdparty/leveldbjni-all-1.8.jar > > 3rdparty/libfb303-0.9.2.jar > > 3rdparty/libpam4j-1.8-rev1.jar > > 3rdparty/libthrift-0.9.2.jar > > 3rdparty/log4j-over-slf4j-1.7.6.jar > > 3rdparty/lz4-1.3.0.jar > > 3rdparty/metrics-core-2.2.0.jar > > 3rdparty/metrics-core-3.0.1.jar > > 3rdparty/metrics-healthchecks-3.0.1.jar > > 3rdparty/metrics-json-3.0.1.jar > > 3rdparty/metrics-jvm-3.0.1.jar > > 3rdparty/metrics-servlets-3.0.1.jar > > 3rdparty/mockito-core-1.9.5.jar > > 3rdparty/mongo-java-driver-3.2.0.jar > > 3rdparty/msgpack-0.6.6.jar > > 3rdparty/netty-buffer-4.0.48.Final.jar > > 3rdparty/netty-codec-4.0.48.Final.jar > > 3rdparty/netty-common-4.0.48.Final.jar > > 3rdparty/netty-handler-4.0.48.Final.jar > > 3rdparty/netty-transport-4.0.48.Final.jar > > 3rdparty/netty-transport-native-epoll-4.0.48.Final-linux-x86_64.jar > > 3rdparty/objenesis-1.0.jar > > 3rdparty/ojdbc6-11.2.0.4.0.jar > > 3rdparty/okhttp-3.3.0.jar > > 3rdparty/okio-1.8.0.jar > > 3rdparty/paranamer-2.5.6.jar > > 3rdparty/parquet-column-1.8.1-drill-r0.jar > > 3rdparty/parquet-common-1.8.1-drill-r0.jar > > 3rdparty/parquet-encoding-1.8.1-drill-r0.jar > > 3rdparty/parquet-format-2.3.0-incubating.jar > > 3rdparty/parquet-generator-1.8.1-drill-r0.jar > > 3rdparty/parquet-hadoop-1.8.1-drill-r0.jar > > 3rdparty/parquet-jackson-1.8.1-drill-r0.jar > > 3rdparty/parser-core-2.4.jar > > 3rdparty/pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar > > 3rdparty/protobuf-java-2.5.0.jar > > 3rdparty/protostuff-api-1.0.8.jar > > 3rdparty/protostuff-core-1.0.8.jar > > 3rdparty/protostuff-json-1.0.8.jar > > 3rdparty/retrofit-2.1.0.jar > > 3rdparty/scala-library-2.11.0.jar > > 3rdparty/scala-parser-combinators_2.11-1.0.4.jar > > 3rdparty/serializer-2.7.1.jar > > 3rdparty/slf4j-api-1.7.6.jar > > 3rdparty/snappy-java-1.1.2.6.jar > > 3rdparty/sqljdbc42.jar > > 3rdparty/sqlline-1.1.9-drill-r7.jar > > 3rdparty/stax-api-1.0-2.jar > > 3rdparty/stringtemplate-3.2.1.jar > > 3rdparty/univocity-parsers-1.3.0.jar > > 3rdparty/validation-api-1.1.0.Final.jar > > 3rdparty/velocity-1.7.jar > > 3rdparty/xalan-2.7.1.jar > > 3rdparty/xercesImpl-2.11.0.jar > > 3rdparty/xml-apis-1.4.01.jar > > 3rdparty/xmlenc-0.52.jar > > 3rdparty/xz-1.0.jar > > 3rdparty/zkclient-0.10.jar > > >
