AnsweredAssumed Answered

Drill - enabling maprdb format plugin

Question asked by gesgeorge on Feb 10, 2016
Latest reply on Apr 27, 2016 by gesgeorge
Hi,
In the link below, under available databases, it talks about a maprdb database type. When I run show databases, I do not see a maprdb database type, only hbase.

http://doc.mapr.com/display/MapR/Lesson+1%3A+Learn+About+the+Data+Set

I'm using the latest drill that was available with the mapr installation, 1.4.0.

    0: jdbc:drill:> show databases;
    +---------------------+
    |     SCHEMA_NAME     |
    +---------------------+
    | INFORMATION_SCHEMA  |
    | cp.default          |
    | dfs.default         |
    | dfs.root            |
    | dfs.tmp             |
    | hbase               |
    | sys                 |
    +---------------------+
    7 rows selected (14.211 seconds)

Later in the page it talks about using maprdb and describing tables. I tried describing my table but the description of the table returns empty results.

    0: jdbc:drill:> describe hbase.`/core/order`;
    +--------------+------------+--------------+
    | COLUMN_NAME  | DATA_TYPE  | IS_NULLABLE  |
    +--------------+------------+--------------+
    +--------------+------------+--------------+
    No rows selected (18.602 seconds)

Also, the only way I'm able to query my maprdb table is using a query of this form

    select * from hbase.`/core/order`;
This is different from the results shows in the link when describing a "maprdb" table.

Could you please tell me how I enable the maprdb database type and be able to describe the maprdb tables correctly?

I've attached a screenshot of my storage plugins from drill web.
![alt text][1]

This is the description of the dfs storage plugin which describes a maprdb format

    {
      "type": "file",
      "enabled": true,
      "connection": "maprfs:///",
      "workspaces": {
        "root": {
          "location": "/",
          "writable": false,
          "defaultInputFormat": null
        },
        "tmp": {
          "location": "/tmp",
          "writable": true,
          "defaultInputFormat": null
        }
      },
      "formats": {
        "psv": {
          "type": "text",
          "extensions": [
            "tbl"
          ],
          "delimiter": "|"
        },
        "csv": {
          "type": "text",
          "extensions": [
            "csv"
          ],
          "delimiter": ","
        },
        "tsv": {
          "type": "text",
          "extensions": [
            "tsv"
          ],
          "delimiter": "\    "
        },
        "parquet": {
          "type": "parquet"
        },
        "json": {
          "type": "json"
        },
        "maprdb": {
         "type": "maprdb"
        }
      }
    }

  [1]: /storage/temp/380-2016-02-10-09-32-33-apache-drill-firefox-developer.png



Outcomes