Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

query never response in apache drill

Re: query never response in apache drill

Super Collaborator

this is the output but i dont understand, so please anyone could help me????

0: jdbc:drill:> explain plan for select cod_nrbe,id_interno_pe,mi_fecha_fin_mes from desercion_clientes where id_interno_pe='1974003';
+------+------+
| text | json |
+------+------+
| 00-00    Screen
00-01      Project(cod_nrbe=[$0], id_interno_pe=[$1], mi_fecha_fin_mes=[$2])
00-02        UnionExchange
01-01          Project(cod_nrbe=[$0], id_interno_pe=[$1], mi_fecha_fin_mes=[$2])
01-02            SelectionVectorRemover
01-03              Filter(condition=[=($1, '1974003')])
01-04                Scan(groupscan=[HiveScan [table=Table(dbName:default, tableName:desercion_clientes), columns=[`cod_nrbe`, `id_interno_pe`, `mi_fecha_fin_mes`], numPartitions=0, partitions= null, inputDirectories=[hdfs://lnxbig05.cajarural.gcr:8020/RSI/tables/desercion_clientes]]])
 | {
  "head" : {
    "version" : 1,
    "generator" : {
      "type" : "ExplainHandler",
      "info" : ""
    },
    "type" : "APACHE_DRILL_PHYSICAL",
    "options" : [ ],
    "queue" : 0,
    "resultMode" : "EXEC"
  },
  "graph" : [ {
    "pop" : "hive-scan",
    "@id" : 65540,
    "userName" : "root",
    "hive-table" : {
      "table" : {
        "tableName" : "desercion_clientes",
        "dbName" : "default",
        "owner" : "hive",
        "createTime" : 1465970780,
        "lastAccessTime" : 0,
        "retention" : 0,
          "location" : "hdfs://lnxbig05.cajarural.gcr:8020/RSI/tables/desercion_clientes",
          "inputFormat" : "org.apache.hadoop.hive.ql.io.orc.OrcInputFormat",
          "outputFormat" : "org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat",
          "compressed" : false,
          "numBuckets" : 60,
          "serDeInfo" : {
            "name" : null,
            "serializationLib" : "org.apache.hadoop.hive.ql.io.orc.OrcSerde",
            "parameters" : {
              "serialization.format" : "1"
            }
          },
          "sortCols" : [ ],
          "parameters" : { }
        },
        "partitionKeys" : [ ],
        "parameters" : {
          "orc.create.index" : "true",
          "numRows" : "51639071",
          "rawDataSize" : "0",
          "orc.compress" : "ZLIB",
          "transient_lastDdlTime" : "1465973128",
          "immutable" : "false",
          "orc.stripe.size" : "67108864",
          "totalSize" : "1314614315",
          "EXTERNAL" : "TRUE",
          "COLUMN_STATS_ACCURATE" : "true",
          "numFiles" : "60",
          "orc.row.index.stride" : "25000",
          "transactional" : "true"
        },
        "viewOriginalText" : null,
        "viewExpandedText" : null,
        "tableType" : "EXTERNAL_TABLE"
      },
      "partitions" : null
    },
    "columns" : [ "`cod_nrbe`", "`id_interno_pe`", "`mi_fecha_fin_mes`" ],
    "cost" : 5.1639071E7
  }, {
    "pop" : "filter",
    "@id" : 65539,
    "child" : 65540,
    "expr" : "equal(`id_interno_pe`, '1974003') ",
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 7745860.649999999
  }, {
    "pop" : "selection-vector-remover",
    "@id" : 65538,
    "child" : 65539,
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 7745860.649999999
  }, {
    "pop" : "project",
    "@id" : 65537,
    "exprs" : [ {
      "ref" : "`cod_nrbe`",
      "expr" : "`cod_nrbe`"
    }, {
      "ref" : "`id_interno_pe`",
      "expr" : "`id_interno_pe`"
    }, {
      "ref" : "`mi_fecha_fin_mes`",
      "expr" : "`mi_fecha_fin_mes`"
    } ],
    "child" : 65538,
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 7745860.649999999
  }, {
    "pop" : "union-exchange",
    "@id" : 2,
    "child" : 65537,
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 7745860.649999999
  }, {
    "pop" : "project",
    "@id" : 1,
    "exprs" : [ {
      "ref" : "`cod_nrbe`",
      "expr" : "`cod_nrbe`"
    }, {
      "ref" : "`id_interno_pe`",
      "expr" : "`id_interno_pe`"
    }, {
      "ref" : "`mi_fecha_fin_mes`",
      "expr" : "`mi_fecha_fin_mes`"
    } ],
    "child" : 2,
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 7745860.649999999
  }, {
    "pop" : "screen",
    "@id" : 0,
    "child" : 1,
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 7745860.649999999
  } ]
} |
+------+------+
1 row selected (0.637 seconds)
0: jdbc:drill:>
Highlighted

Re: query never response in apache drill

Super Collaborator

hi:

the tabla has 51 millions of rows, and it has 50 column, any suggestion for apache drill to make the query propertly???

thanks

Don't have an account?
Coming from Hortonworks? Activate your account here