You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by George Lu <lu...@gmail.com> on 2015/05/31 03:45:32 UTC
Delete table in Drill
Hi all,
After I create table using CTAS in dfs.tmp, can I delete it? Or next time
override it?
Currently, I go to the /tmp folder in the all the machines and delete them
one by one.
Thanks!
George Lu
Re: Delete table in Drill
Posted by George Lu <lu...@gmail.com>.
Yeah, that make sense.
Thanks!
On Sun, May 31, 2015 at 11:07 AM, Tomer Shiran <ts...@maprtech.com> wrote:
> No. This is referring to the distributed file system. 'hadoop fs -rm
> /path/to/file' should do it
>
>
>
> > On May 30, 2015, at 7:50 PM, George Lu <lu...@gmail.com> wrote:
> >
> > The files created are put around all the nodes in Drill.
> > I need to go through each of them and delete one by one?
> >
> >> On Sun, May 31, 2015 at 10:49 AM, Jinfeng Ni <jn...@apache.org> wrote:
> >>
> >> There is no DELETE TABLE command supported yet.
> >>
> >> The only option available is to go through file system command to delete
> >> the parquet files created from CTAS.
> >>
> >>
> >>
> >>> On Sat, May 30, 2015 at 6:45 PM, George Lu <lu...@gmail.com>
> wrote:
> >>>
> >>> Hi all,
> >>>
> >>> After I create table using CTAS in dfs.tmp, can I delete it? Or next
> time
> >>> override it?
> >>> Currently, I go to the /tmp folder in the all the machines and delete
> >> them
> >>> one by one.
> >>>
> >>> Thanks!
> >>>
> >>> George Lu
> >>
>
Re: Delete table in Drill
Posted by Tomer Shiran <ts...@maprtech.com>.
No. This is referring to the distributed file system. 'hadoop fs -rm /path/to/file' should do it
> On May 30, 2015, at 7:50 PM, George Lu <lu...@gmail.com> wrote:
>
> The files created are put around all the nodes in Drill.
> I need to go through each of them and delete one by one?
>
>> On Sun, May 31, 2015 at 10:49 AM, Jinfeng Ni <jn...@apache.org> wrote:
>>
>> There is no DELETE TABLE command supported yet.
>>
>> The only option available is to go through file system command to delete
>> the parquet files created from CTAS.
>>
>>
>>
>>> On Sat, May 30, 2015 at 6:45 PM, George Lu <lu...@gmail.com> wrote:
>>>
>>> Hi all,
>>>
>>> After I create table using CTAS in dfs.tmp, can I delete it? Or next time
>>> override it?
>>> Currently, I go to the /tmp folder in the all the machines and delete
>> them
>>> one by one.
>>>
>>> Thanks!
>>>
>>> George Lu
>>
Re: Delete table in Drill
Posted by George Lu <lu...@gmail.com>.
The files created are put around all the nodes in Drill.
I need to go through each of them and delete one by one?
On Sun, May 31, 2015 at 10:49 AM, Jinfeng Ni <jn...@apache.org> wrote:
> There is no DELETE TABLE command supported yet.
>
> The only option available is to go through file system command to delete
> the parquet files created from CTAS.
>
>
>
> On Sat, May 30, 2015 at 6:45 PM, George Lu <lu...@gmail.com> wrote:
>
> > Hi all,
> >
> > After I create table using CTAS in dfs.tmp, can I delete it? Or next time
> > override it?
> > Currently, I go to the /tmp folder in the all the machines and delete
> them
> > one by one.
> >
> > Thanks!
> >
> > George Lu
> >
>
Re: Delete table in Drill
Posted by Jinfeng Ni <jn...@apache.org>.
There is no DELETE TABLE command supported yet.
The only option available is to go through file system command to delete
the parquet files created from CTAS.
On Sat, May 30, 2015 at 6:45 PM, George Lu <lu...@gmail.com> wrote:
> Hi all,
>
> After I create table using CTAS in dfs.tmp, can I delete it? Or next time
> override it?
> Currently, I go to the /tmp folder in the all the machines and delete them
> one by one.
>
> Thanks!
>
> George Lu
>