You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by ji...@boehringer-ingelheim.com on 2021/05/03 12:22:22 UTC
Drill Question : DROP TABLE (Deleting dataset)
Dear User Supporter.
I have 1 question about deleting dataset in Drill Explorer.
I checked https://drill.apache.org/docs/alter-system/ and DROP TABLE can remove dataset from database.
So I tried to delete 0_0_144_1.csv in below tree and wrote SQL as follows.
[cid:image001.png@01D74062.65802AB0]
[cid:image002.png@01D74062.65802AB0]
[cid:image003.png@01D74062.65802AB0]
There were no error in executing SQL so it is hard to me why 0_0_144_1.csv folder and its subcategory file cannot be deleted.
It is very appreciated if I can get feedback to delete specific files from database.
Many thanks in advance,
Jinseong
Re: Drill Question : DROP TABLE (Deleting dataset)
Posted by luoc <lu...@apache.org>.
Hi Jinseong,
Could you please check the below key point:
1. Must have the appropriate permissions. (To delete)
2. Enable the `writable` in storage configuration. (Set to true)
3. The drillbit.log exist the error message. (Y / N?)
4. Apply the Dropping a table created from a file <https://drill.apache.org/docs/drop-table/#example-3-dropping-a-table-created-as-a-directory>. (CTAS command first, then drop command)
> 2021年5月3日 下午10:19，<ji...@boehringer-ingelheim.com> <ji...@boehringer-ingelheim.com> 写道：
>
> Dear User Supporter.
>
> Thank you for your reply.
> I had attached some image files.
>
> I have 1 question about deleting dataset in Drill Explorer.
> I checked https://drill.apache.org/docs/alter-system/ <https://drill.apache.org/docs/alter-system/> and DROP TABLE can remove dataset from database.
>
> So I tried to delete 0_0_144_1.csv in below tree and wrote SQL as image1 and image2 file.
>
>
> There were no error in executing SQL so it is hard to me why 0_0_144_1.csv folder and its subcategory file cannot be deleted.
> I also tried to delete it in WinSCP as image3, but it was not possible.
> It is a little confused as I could add new files in corresponding WinSCP folder even I cannot delete which I had added.
> (In other words, I could add files in this folder, but not delete them in it)
>
> It is very appreciated if I can get feedback to delete specific files from database or correct my program code syntax.
>
> Many thanks in advance,
>
> Jinseong
>
>
> From: luoc <luoc@apache.org <ma...@apache.org>>
> Sent: Monday, May 3, 2021 10:41 PM
> To: user@drill.apache.org <ma...@drill.apache.org>
> Cc: Gim,Jinseong (MED BDS) NBI-JP-T <jinseong.gim@boehringer-ingelheim.com <ma...@boehringer-ingelheim.com>>
> Subject: Re: Drill Question : DROP TABLE (Deleting dataset)
>
> CAUTION! Please do not click links or open attachments unless you recognize the sender, this email is from anExternal Sender (outside Boehringer-Ingelheim)
> Hi Jinseong,
> Do not paste the image to apache email directly, this is not supported. As an attachment file is a good way.
>
>
> 2021年5月3日 下午8:22，jinseong.gim@boehringer-ingelheim.com <ma...@boehringer-ingelheim.com> 写道：
>
> Dear User Supporter.
>
> I have 1 question about deleting dataset in Drill Explorer.
> I checked https://drill.apache.org/docs/alter-system/ <https://drill.apache.org/docs/alter-system/> and DROP TABLE can remove dataset from database.
>
> So I tried to delete 0_0_144_1.csv in below tree and wrote SQL as follows.
>
>
>
>
>
>
> There were no error in executing SQL so it is hard to me why 0_0_144_1.csv folder and its subcategory file cannot be deleted.
> It is very appreciated if I can get feedback to delete specific files from database.
>
> Many thanks in advance,
>
> Jinseong
RE: Drill Question : DROP TABLE (Deleting dataset)
Posted by ji...@boehringer-ingelheim.com.
Dear User Supporter.
Thank you for your reply.
I had attached some image files.
I have 1 question about deleting dataset in Drill Explorer.
I checked https://drill.apache.org/docs/alter-system/ and DROP TABLE can remove dataset from database.
So I tried to delete 0_0_144_1.csv in below tree and wrote SQL as image1 and image2 file.
There were no error in executing SQL so it is hard to me why 0_0_144_1.csv folder and its subcategory file cannot be deleted.
I also tried to delete it in WinSCP as image3, but it was not possible.
It is a little confused as I could add new files in corresponding WinSCP folder even I cannot delete which I had added.
(In other words, I could add files in this folder, but not delete them in it)
It is very appreciated if I can get feedback to delete specific files from database or correct my program code syntax.
Many thanks in advance,
Jinseong
From: luoc <lu...@apache.org>
Sent: Monday, May 3, 2021 10:41 PM
To: user@drill.apache.org
Cc: Gim,Jinseong (MED BDS) NBI-JP-T <ji...@boehringer-ingelheim.com>
Subject: Re: Drill Question : DROP TABLE (Deleting dataset)
CAUTION! Please do not click links or open attachments unless you recognize the sender, this email is from an External Sender (outside Boehringer-Ingelheim)
Hi Jinseong,
Do not paste the image to apache email directly, this is not supported. As an attachment file is a good way.
2021年5月3日 下午8:22，jinseong.gim@boehringer-ingelheim.com<ma...@boehringer-ingelheim.com> 写道：
Dear User Supporter.
I have 1 question about deleting dataset in Drill Explorer.
I checked https://drill.apache.org/docs/alter-system/ and DROP TABLE can remove dataset from database.
So I tried to delete 0_0_144_1.csv in below tree and wrote SQL as follows.
[cid:image001.png@01D74062.65802AB0]
[cid:image002.png@01D74062.65802AB0]
[cid:image003.png@01D74062.65802AB0]
There were no error in executing SQL so it is hard to me why 0_0_144_1.csv folder and its subcategory file cannot be deleted.
It is very appreciated if I can get feedback to delete specific files from database.
Many thanks in advance,
Jinseong
Re: Drill Question : DROP TABLE (Deleting dataset)
Posted by luoc <lu...@apache.org>.
Hi Jinseong,
Do not paste the image to apache email directly, this is not supported. As an attachment file is a good way.
> 2021年5月3日 下午8:22，jinseong.gim@boehringer-ingelheim.com 写道：
>
> Dear User Supporter.
>
> I have 1 question about deleting dataset in Drill Explorer.
> I checked https://drill.apache.org/docs/alter-system/ <https://drill.apache.org/docs/alter-system/> and DROP TABLE can remove dataset from database.
>
> So I tried to delete 0_0_144_1.csv in below tree and wrote SQL as follows.
>
>
>
>
>
>
> There were no error in executing SQL so it is hard to me why 0_0_144_1.csv folder and its subcategory file cannot be deleted.
> It is very appreciated if I can get feedback to delete specific files from database.
>
> Many thanks in advance,
>
> Jinseong