Sungwook,
What's the column family permission? You probably want to do
something like this to give r/w permissions:
maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
-readperm 'u:root|u:mapr'
maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe'
-writeperm 'u:root|u:mapr'
-James
On 12/11/14, 3:24 PM, Sungwook Yoon wrote:
I've done that already.. still I am seeing the error.
I will double check though.
Thanks,
Sungwook
On Thu, Dec 11, 2014 at 2:23 PM, Aditya <[email protected]> wrote:
Please add the setting "size.calculator.enabled" : false to the plugin
configuration.
i.e.
{
"type" : "hbase",
"enabled" : true,
"size.calculator.enabled": false,
"config" : {
"hbase.table.namespace.mappings" : "*:/tables"
}
}
On Thu, Dec 11, 2014 at 1:39 PM, Sungwook Yoon <[email protected]> wrote:
Thanks, I made user mapr owned table.
Here is what I got from drill sqlline.
0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> describe lecxe;
+-------------+------------+-------------+
| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
+-------------+------------+-------------+
| row_key | ANY | NO |
| dependent_vars | (VARCHAR(1), ANY) MAP | NO |
| independent_vars | (VARCHAR(1), ANY) MAP | NO |
+-------------+------------+-------------+
3 rows selected (0.197 seconds)
0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from lecxe limit
2;
Query failed: Failure while setting up Foreman.
Error: exception while executing query: Failure while executing query.
(state=,code=0)
I guess, this is due to hbase version 0.98???
Sungwook
On Thu, Dec 11, 2014 at 1:26 PM, Kunal Khatua <[email protected]>
wrote:
If Drill doesnt show any results, and no errors... it's a permissions
issue. By design, MapRDB will not reveal anything about the requested
table
due to security reasons.
You can try running the following on all of the tables you wish to
query.
maprcli table cf edit -path ${tblPath} -cfname ${colFam} -readperm
"u:mapr|u:root"
Expand this to allow other users that you wish to grant read
permissions
to.
~ Kunal
On 12/11/2014 1:16:50 PM, Abhishek Girish <
[email protected]>
wrote:
What about the permissions for the table on MFS?
On Thu, Dec 11, 2014 at 1:11 PM, Sungwook Yoon wrote:
drillbit is running on mapr
Sungwook
On Thu, Dec 11, 2014 at 1:01 PM, Steven Phillips
wrote:
Can you check what user drillbit is running as?
On Thursday, December 11, 2014, Sungwook Yoon
wrote:
Here is how I invoke sqlline,
sqlline -u jdbc:drill:zk=10.180.98.244:5181,10.180.98.245:5181,
10.180.98.246:5181
Sungwook
On Thu, Dec 11, 2014 at 12:50 PM, Aditya
wrote:
On Thu, Dec 11, 2014 at 12:47 PM, Sungwook Yoon
wrote:
The sqlline is executed under root too.
What about DrillBits? Or are you running Drill in embedded
mode?
--
Steven Phillips
Software Engineer
mapr.com
