Search code examples
hbasemaprstreamsets

I only have row key inside my mapr-db JSON table

I don't know if it is a common problem with mapr-db JSON. I use a Streamsets destination which is a Mapr-DB JSON table to push records containing 10 columns. I precise the first column to become a row key. when I go to

mapr dbshell
find /tmp/my_table

I only see the row key in JSON and no others columns

{"_id":"mykey1"}
{"_id":"mykey2"}
{"_id":"mykey3"}
{"_id":"mykey4"}

Do you have any idea?

Solution

  • I would suggest checking the directory permissions for the user who is trying to access /tmp/my_table. I know /tmp is typically wide-open. But in my experience, you need read permission to get the data, and MapR seems to permit all users to see the row keys, regardless of directory permissions.