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