AnsweredAssumed Answered

Drill and MapR DB Table not Found

Question asked by mandoskippy on Aug 1, 2015
Latest reply on Feb 8, 2016 by maprcommunity
Hey all - I've added the storage pluging to dfs per the drill docs, and I had this working for a while. (I tried to do something and my drill crashed, had to restart it)  Now I can't seem to get things working. I can query out of other directories on DFS, Hive works file  etc.  But when I  try to do a mapr table located at  */pcaps_maprdb/current*  (which by the way, works fine when I make an external table in hive and query it here) Then I get,

    2015-08-01 20:09:19,5485 ERROR Client fs/client/fileclient/cc/client.cc:1415 Thread: 7204 Open failed for file /pcaps_maprdb/current, attempt to open a kvstore file
    Aug 01, 2015 8:09:19 PM org.apache.calcite.sql.validate.SqlValidatorException
    SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table '/pcaps_maprdb/current' not found
    Aug 01, 2015 8:09:19 PM org.apache.calcite.runtime.CalciteException
    SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 37: Table '/pcaps_maprdb/current' not found

I even created a workspace at *pcaps_maprdb* (current is the mapr table) I see the files in there fine with a show files,

    0: jdbc:drill:zk=hadoopmapr1:5181> use dfs.pcaps;
    +-------+----------------------------------------+
    |  ok   |                summary                 |
    +-------+----------------------------------------+
    | true  | Default schema changed to [dfs.pcaps]  |
    +-------+----------------------------------------+
    1 row selected (0.105 seconds)
    
    0: jdbc:drill:zk=hadoopmapr1:5181> show files
    . . . . . . . . . . . . . . . . .> ;
    +----------+--------------+---------+---------+-----------+-----------+--------------+------------------------+--------------------------+
    |   name   | isDirectory  | isFile  | length  |   owner   |   group   | permissions  |       accessTime       |     modificationTime     |
    +----------+--------------+---------+---------+-----------+-----------+--------------+------------------------+--------------------------+
    | archive  | true         | false   | 1       | darkness  | darkness  | rwxrwxr-x    | 2015-08-01 13:10:42.0  | 2015-08-01 20:03:36.103  |
    | current  | false        | true    | 2       | darkness  | darkness  | r--------    | 2015-08-01 13:12:35.0  | 2015-08-01 13:12:35.768  |
    +----------+--------------+---------+---------+-----------+-----------+--------------+------------------------+--------------------------+
    2 rows selected (0.171 seconds)

then I get

    0: jdbc:drill:zk=hadoopmapr1:5181> select * from `/current` limit 1;
    Error: PARSE ERROR: From line 1, column 15 to line 1, column 24: Table '/current' not found








Outcomes