drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramana I N <inram...@gmail.com>
Subject Re: [DISCUSS] Drop table support
Date Wed, 05 Aug 2015 18:09:44 GMT
The homogenous check- Will it be just checking for types are homogenous or
if they are actually types that can be read by drill?
Also, is there a good way to determine if a file can be read by drill? And
will there be a perf hit if there are large number of files?

Regards
Ramana


On Wed, Aug 5, 2015 at 11:03 AM, Mehant Baid <baid.mehant@gmail.com> wrote:

> I agree, it is definitely restrictive. We can lift the restriction for
> being able to drop a table (when security is off) only if the Drill user
> owns it. I think the check for homogenous files should give us enough
> confidence that we are not deleting a non Drill directory.
>
> Thanks
> Mehant
>
>
> On 8/4/15 10:00 PM, Neeraja Rentachintala wrote:
>
>> Ted, thats fair point on the recovery part.
>>
>> Regarding the other point by Mehant (copied below) ,there is an
>> implication
>> that user can drop only Drill managed tables (i.e created as Drill user)
>> when security is not enabled. I think this check is too restrictive (also
>> unintuitive). Drill doesn't have the concept of external/managed tables
>> and
>> a user (impersonated user if security is enabled or Drillbit service user
>> if no security is enabled) should be able to drop the table if they have
>> permissions to do so. The above design proposes a check to verify if the
>> files that need to be deleted are readable by Drill and I believe is a
>> good
>> validation to have.
>>
>> /The above check is in the case when security is not enabled. Meaning we
>> are executing as the Drill user. If we are running as the Drill user
>> (which
>> might be root or a super user) its likely that this user has permissions
>> to
>> delete most files and checking for permissions might not suffice. So when
>> security isn't enabled the proposal is to delete only those files that are
>> owned (created) by the Drill user./
>>
>>
>> On Fri, Jul 31, 2015 at 12:09 AM, Ted Dunning <ted.dunning@gmail.com>
>> wrote:
>>
>> On Thu, Jul 30, 2015 at 4:56 PM, Neeraja Rentachintala <
>>> nrentachintala@maprtech.com> wrote:
>>>
>>> Also will there any mechanism to recover once you accidentally drop?
>>>>
>>>> yes.  Snapshots <https://www.mapr.com/resources/videos/mapr-snapshots>.
>>>
>>> Seriously, recovery of data due to user error is a platform thing.  How
>>> can
>>> we recover from turning off the cluster?  From removing a disk on an
>>> Oracle
>>> node?
>>>
>>> I don't think that this is Drill's business.
>>>
>>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message