AnsweredAssumed Answered

Not able to query MapR-DB Document table using Apache Drill

Question asked by PuneetBabbar on Jan 5, 2017
Latest reply on Jun 7, 2017 by john.humphreys

I'm using the MapR-DB document database to work on a JSON table. I'm able to create and query the json table using the

mapr dbshell

or using the

OJAI API

MapR DB shell screenshot

 

But now when i try to query the table using the Apache drill

And referring to the below link: Apache drill to query MapR-DB json table

https://www.mapr.com/blog/apache-drill-16-mapr-converged-platform-gearing-new-generation-stack-json-enabled-big-data

I'm only able to see the first the column i.e. is the _id column and no other field is shown.

As per the link, i have also updated the Storage Plugins and in the dfs storage plugin have made the below entry

"maprdb_document": {   "location": "/apps",   "writable": true,   "defaultInputFormat": "maprdb" }

And when i execute below query, it only shows the _id colum.

SELECT * FROM dfs.maprdb_document.`./user_profiles

####

Outcomes