drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "tooptoop4 (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2744) Provide error message when trying to query MapR-DB or HBase tables with insufficient priviliges
Date Wed, 01 Nov 2017 12:28:00 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16234004#comment-16234004
] 

tooptoop4 commented on DRILL-2744:
----------------------------------

anyone looking at this?

> Provide error message when trying to query MapR-DB or HBase tables with insufficient
priviliges
> -----------------------------------------------------------------------------------------------
>
>                 Key: DRILL-2744
>                 URL: https://issues.apache.org/jira/browse/DRILL-2744
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - HBase
>    Affects Versions: 0.8.0
>            Reporter: Andries Engelbrecht
>            Priority: Major
>              Labels: security
>             Fix For: Future
>
>
> When creating MapR-DB tables with different privileges Drill will return no results for
tables with insufficient privileges. Propose an error is returned so the user is aware of
the issue, instead of simply no data being returned. 
> This can be a serious issue with complex queries when joining data across multiple data
sources.
> Creating 2 tables - one with mapr user and the other as root.
> lr--------. 1 mapr mapr 2 Apr  9 17:51 customers -> mapr::table::2057.45.1574734
> lr--------. 1 root root 2 Apr 10 00:21 test -> mapr::table::2057.48.1574740
> hbase(main):005:0> get "test", "r1"
> COLUMN                            CELL
>  col1:                            timestamp=1428625497000, value=a
>  col2:                            timestamp=1428625506268, value=b
> 2 row(s) in 0.0380 seconds
> 0: jdbc:drill:zk=drilldemo:5181> show tables;
> +--------------+------------+
> | TABLE_SCHEMA | TABLE_NAME |
> +--------------+------------+
> | maprdb       | test       |
> | maprdb       | customers  |
> +--------------+------------+
> 2 rows selected (0.098 seconds)
> querying test tables simply returns no results instead of an error.
> 0: jdbc:drill:zk=drilldemo:5181> select * from test;
> +--+
> |  |
> +--+
> +--+
> No rows selected (0.059 seconds)
> Customers does return data due to sufficient privileges.
> 0: jdbc:drill:zk=drilldemo:5181> select * from customers limit 1;
> +------------+------------+------------+------------+
> |  row_key   |  address   |  loyalty   |  personal  |
> +------------+------------+------------+------------+
> | [B@6e22c013 | {"state":"InZhIg=="} | {"agg_rev":"MTk3","membership":"InNpbHZlciI="}
| {"age":"IjE1LTIwIg==","gender":"IkZFTUFMRSI=","name":"IkNvcnJpbmUgTWVjaGFtIg=="} |
> +------------+------------+------------+------------+
> 1 row selected (0.236 seconds)



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message