You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Mahesh Sankaran <sa...@gmail.com> on 2015/06/20 07:25:58 UTC
hive-1.1.0 - alter table rename issue
Hi all,
I am using hive-1.1.0 and hadoop-2.6.0.
am trying to rename a existing table in hive but it shows following error.
hive> *altertable testrename rename to testrenamebkp ;*
*FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
method name: 'alter_table_with_cascade'.*
*From this error i followed this jira,*
https://issues.apache.org/jira/browse/HIVE-10552
to connect hive with beeline but stills it shows the same error.
HADOOP_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop
YARN_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop /opt/hive/bin/beeline -u
jdbc:hive2://hostname:10000 username password
org.apache.hive.jdbc.HiveDriver
Connected to: Apache Hive (version 1.1.0)
Driver: Hive JDBC (version 1.1.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.1.0 by Apache Hive
0: jdbc:hive2://hostname:10000> *altertable testrename rename to
testrenamebkp ;*
*FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
method name: 'alter_table_with_cascade'*
Thanks
Mahesh.S
Re: hive-1.1.0 - alter table rename issue
Posted by Mahesh Sankaran <sa...@gmail.com>.
i solved this issue by creating tables in metastore manually.
Thanks
Mahesh
On Mon, Jun 22, 2015 at 10:48 AM, Mahesh Sankaran <sa...@gmail.com>
wrote:
> Yes i upgraded my hive and HMS recently.but there is no mismatch between
> hive and HMS.
>
> On Mon, Jun 22, 2015 at 10:30 AM, Vishnu Viswanath <
> vishnu.viswanath25@gmail.com> wrote:
>
>> from the JIRA comments it looks like there is a miss match between your
>> hive and HMS. Did you upgrade hive recently?
>>
>> On Mon, Jun 22, 2015 at 10:23 AM, Mahesh Sankaran <
>> sankarmahesh37@gmail.com> wrote:
>>
>>> Any thoughts regarding this problem??
>>>
>>> Mahesh
>>>
>>> On Sat, Jun 20, 2015 at 10:55 AM, Mahesh Sankaran <
>>> sankarmahesh37@gmail.com> wrote:
>>>
>>>> Hi all,
>>>>
>>>> I am using hive-1.1.0 and hadoop-2.6.0.
>>>>
>>>> am trying to rename a existing table in hive but it shows following
>>>> error.
>>>>
>>>> hive> *altertable testrename rename to testrenamebkp ;*
>>>> *FAILED: Execution Error, return code 1 from
>>>> org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
>>>> method name: 'alter_table_with_cascade'.*
>>>>
>>>> *From this error i followed this jira,*
>>>> https://issues.apache.org/jira/browse/HIVE-10552
>>>>
>>>> to connect hive with beeline but stills it shows the same error.
>>>>
>>>> HADOOP_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop
>>>> YARN_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop /opt/hive/bin/beeline -u
>>>> jdbc:hive2://hostname:10000 username password
>>>> org.apache.hive.jdbc.HiveDriver
>>>> Connected to: Apache Hive (version 1.1.0)
>>>> Driver: Hive JDBC (version 1.1.0)
>>>> Transaction isolation: TRANSACTION_REPEATABLE_READ
>>>> Beeline version 1.1.0 by Apache Hive
>>>> 0: jdbc:hive2://hostname:10000> *altertable testrename rename to
>>>> testrenamebkp ;*
>>>> *FAILED: Execution Error, return code 1 from
>>>> org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
>>>> method name: 'alter_table_with_cascade'*
>>>>
>>>> Thanks
>>>> Mahesh.S
>>>>
>>>
>>>
>>
>
Re: hive-1.1.0 - alter table rename issue
Posted by Mahesh Sankaran <sa...@gmail.com>.
Yes i upgraded my hive and HMS recently.but there is no mismatch between
hive and HMS.
On Mon, Jun 22, 2015 at 10:30 AM, Vishnu Viswanath <
vishnu.viswanath25@gmail.com> wrote:
> from the JIRA comments it looks like there is a miss match between your
> hive and HMS. Did you upgrade hive recently?
>
> On Mon, Jun 22, 2015 at 10:23 AM, Mahesh Sankaran <
> sankarmahesh37@gmail.com> wrote:
>
>> Any thoughts regarding this problem??
>>
>> Mahesh
>>
>> On Sat, Jun 20, 2015 at 10:55 AM, Mahesh Sankaran <
>> sankarmahesh37@gmail.com> wrote:
>>
>>> Hi all,
>>>
>>> I am using hive-1.1.0 and hadoop-2.6.0.
>>>
>>> am trying to rename a existing table in hive but it shows following
>>> error.
>>>
>>> hive> *altertable testrename rename to testrenamebkp ;*
>>> *FAILED: Execution Error, return code 1 from
>>> org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
>>> method name: 'alter_table_with_cascade'.*
>>>
>>> *From this error i followed this jira,*
>>> https://issues.apache.org/jira/browse/HIVE-10552
>>>
>>> to connect hive with beeline but stills it shows the same error.
>>>
>>> HADOOP_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop
>>> YARN_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop /opt/hive/bin/beeline -u
>>> jdbc:hive2://hostname:10000 username password
>>> org.apache.hive.jdbc.HiveDriver
>>> Connected to: Apache Hive (version 1.1.0)
>>> Driver: Hive JDBC (version 1.1.0)
>>> Transaction isolation: TRANSACTION_REPEATABLE_READ
>>> Beeline version 1.1.0 by Apache Hive
>>> 0: jdbc:hive2://hostname:10000> *altertable testrename rename to
>>> testrenamebkp ;*
>>> *FAILED: Execution Error, return code 1 from
>>> org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
>>> method name: 'alter_table_with_cascade'*
>>>
>>> Thanks
>>> Mahesh.S
>>>
>>
>>
>
Re: hive-1.1.0 - alter table rename issue
Posted by Vishnu Viswanath <vi...@gmail.com>.
from the JIRA comments it looks like there is a miss match between your
hive and HMS. Did you upgrade hive recently?
On Mon, Jun 22, 2015 at 10:23 AM, Mahesh Sankaran <sa...@gmail.com>
wrote:
> Any thoughts regarding this problem??
>
> Mahesh
>
> On Sat, Jun 20, 2015 at 10:55 AM, Mahesh Sankaran <
> sankarmahesh37@gmail.com> wrote:
>
>> Hi all,
>>
>> I am using hive-1.1.0 and hadoop-2.6.0.
>>
>> am trying to rename a existing table in hive but it shows following error.
>>
>> hive> *altertable testrename rename to testrenamebkp ;*
>> *FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
>> method name: 'alter_table_with_cascade'.*
>>
>> *From this error i followed this jira,*
>> https://issues.apache.org/jira/browse/HIVE-10552
>>
>> to connect hive with beeline but stills it shows the same error.
>>
>> HADOOP_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop
>> YARN_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop /opt/hive/bin/beeline -u
>> jdbc:hive2://hostname:10000 username password
>> org.apache.hive.jdbc.HiveDriver
>> Connected to: Apache Hive (version 1.1.0)
>> Driver: Hive JDBC (version 1.1.0)
>> Transaction isolation: TRANSACTION_REPEATABLE_READ
>> Beeline version 1.1.0 by Apache Hive
>> 0: jdbc:hive2://hostname:10000> *altertable testrename rename to
>> testrenamebkp ;*
>> *FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
>> method name: 'alter_table_with_cascade'*
>>
>> Thanks
>> Mahesh.S
>>
>
>
Re: hive-1.1.0 - alter table rename issue
Posted by Mahesh Sankaran <sa...@gmail.com>.
Any thoughts regarding this problem??
Mahesh
On Sat, Jun 20, 2015 at 10:55 AM, Mahesh Sankaran <sa...@gmail.com>
wrote:
> Hi all,
>
> I am using hive-1.1.0 and hadoop-2.6.0.
>
> am trying to rename a existing table in hive but it shows following error.
>
> hive> *altertable testrename rename to testrenamebkp ;*
> *FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
> method name: 'alter_table_with_cascade'.*
>
> *From this error i followed this jira,*
> https://issues.apache.org/jira/browse/HIVE-10552
>
> to connect hive with beeline but stills it shows the same error.
>
> HADOOP_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop
> YARN_CONF_DIR=/opt/hadoop-2.6.0/etc/hadoop /opt/hive/bin/beeline -u
> jdbc:hive2://hostname:10000 username password
> org.apache.hive.jdbc.HiveDriver
> Connected to: Apache Hive (version 1.1.0)
> Driver: Hive JDBC (version 1.1.0)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> Beeline version 1.1.0 by Apache Hive
> 0: jdbc:hive2://hostname:10000> *altertable testrename rename to
> testrenamebkp ;*
> *FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. Invalid
> method name: 'alter_table_with_cascade'*
>
> Thanks
> Mahesh.S
>