You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@kudu.apache.org by Ajai Omtri <aj...@gmail.com> on 2016/06/22 02:01:27 UTC

DROP Table in KUDU

Hi,

 

I have create a table in KUDU Impala session and then dropped that table
from the regular Impala session. 

 

Now when I say "show tables" I don't see the table in both the sessions but
I can't re-create the table as KUDU thinks the table still exists. Any idea
how to fix this please?

 

I also see the table present in the KUDU webUI.

 

Below is the error message that I get from KUDU - Impala session:

 

Table "XXX" already exists in Kudu master xxxxxx:7051

 

Thanks,

Ajai Omtri

Re: DROP Table in KUDU

Posted by Darren Hoo <da...@gmail.com>.

there's already an issue tracking this:

https://issues.cloudera.org/browse/IMPALA-3424


On Wed, Jun 22, 2016 at 7:14 PM, Ajai Omtri <aj...@gmail.com> wrote:

> Thank you. Was able to delete it by below command:
>
>
>
> kudu-admin -master_addresses <Kudu-Master-hostname> delete_table
> <table-name>
>
>
>
> Wondering is this an expected behavior that regular impala and the Kudu
> Impala are not in sync?
>
>
>
>
>
>
>
> *From:* Darren Hoo [mailto:darren.hoo@gmail.com]
> *Sent:* Tuesday, June 21, 2016 10:13 PM
> *To:* user@kudu.incubator.apache.org
> *Subject:* Re: DROP Table in KUDU
>
>
>
> Hi,
>
>
>
> you can use kudu-admin to delete tables in kudu then try create again in
> impala.
>
>
>
> On Wed, Jun 22, 2016 at 10:01 AM, Ajai Omtri <aj...@gmail.com> wrote:
>
> Hi,
>
>
>
> I have create a table in KUDU Impala session and then dropped that table
> from the regular Impala session.
>
>
>
> Now when I say “show tables” I don’t see the table in both the sessions
> but I can’t re-create the table as KUDU thinks the table still exists. Any
> idea how to fix this please?
>
>
>
> I also see the table present in the KUDU webUI.
>
>
>
> Below is the error message that I get from KUDU – Impala session:
>
>
>
> Table “XXX” already exists in Kudu master xxxxxx:7051
>
>
>
> Thanks,
>
> Ajai Omtri
>
>
>

RE: DROP Table in KUDU

Posted by Ajai Omtri <aj...@gmail.com>.

Thank you. Was able to delete it by below command:

 

kudu-admin -master_addresses <Kudu-Master-hostname> delete_table <table-name>

 

Wondering is this an expected behavior that regular impala and the Kudu Impala are not in sync?

 

 

 

From: Darren Hoo [mailto:darren.hoo@gmail.com] 
Sent: Tuesday, June 21, 2016 10:13 PM
To: user@kudu.incubator.apache.org
Subject: Re: DROP Table in KUDU

 

Hi,

 

you can use kudu-admin to delete tables in kudu then try create again in impala.

 

On Wed, Jun 22, 2016 at 10:01 AM, Ajai Omtri <aj...@gmail.com> wrote:

Hi,

 

I have create a table in KUDU Impala session and then dropped that table from the regular Impala session. 

 

Now when I say “show tables” I don’t see the table in both the sessions but I can’t re-create the table as KUDU thinks the table still exists. Any idea how to fix this please?

 

I also see the table present in the KUDU webUI.

 

Below is the error message that I get from KUDU – Impala session:

 

Table “XXX” already exists in Kudu master xxxxxx:7051

 

Thanks,

Ajai Omtri

Re: DROP Table in KUDU

Posted by Darren Hoo <da...@gmail.com>.

Hi,

you can use kudu-admin to delete tables in kudu then try create again in
impala.

On Wed, Jun 22, 2016 at 10:01 AM, Ajai Omtri <aj...@gmail.com> wrote:

> Hi,
>
>
>
> I have create a table in KUDU Impala session and then dropped that table
> from the regular Impala session.
>
>
>
> Now when I say “show tables” I don’t see the table in both the sessions
> but I can’t re-create the table as KUDU thinks the table still exists. Any
> idea how to fix this please?
>
>
>
> I also see the table present in the KUDU webUI.
>
>
>
> Below is the error message that I get from KUDU – Impala session:
>
>
>
> Table “XXX” already exists in Kudu master xxxxxx:7051
>
>
>
> Thanks,
>
> Ajai Omtri
>