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，<[email protected]> > <[email protected]> 写道： > > 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 <[email protected] <mailto:[email protected]>> > Sent: Monday, May 3, 2021 10:41 PM > To: [email protected] <mailto:[email protected]> > Cc: Gim,Jinseong (MED BDS) NBI-JP-T <[email protected] > <mailto:[email protected]>> > 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，[email protected] > <mailto:[email protected]> 写道： > > 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
