hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Watzke (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10552) hive 1.1.0 rename column fails: Invalid method name: 'alter_table_with_cascade'
Date Mon, 04 May 2015 07:13:06 GMT

    [ https://issues.apache.org/jira/browse/HIVE-10552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14526341#comment-14526341
] 

David Watzke commented on HIVE-10552:
-------------------------------------

Hello. Yes, nothing has changed and we still have this problem. We're running a 120-node cluster
on CentOS 6.6. We use MRv1 by default and we're currently experimenting with YARN.

We've installed Hive 1.1.0, linked our relevant cloudera hadoop config files into the hive's
conf dir:
lrwxrwxrwx 1 root root     28 Apr 24 10:33 core-site.xml -> /etc/hive/conf/core-site.xml
lrwxrwxrwx 1 root root     28 Apr 24 10:33 hadoop-env.sh -> /etc/hive/conf/hadoop-env.sh
lrwxrwxrwx 1 root root     28 Apr 24 10:33 hdfs-site.xml -> /etc/hive/conf/hdfs-site.xml
lrwxrwxrwx 1 root root     26 Apr 24 10:33 hive-env.sh -> /etc/hive/conf/hive-env.sh
lrwxrwxrwx 1 root root     28 Apr 24 10:33 hive-site.xml -> /etc/hive/conf/hive-site.xml
lrwxrwxrwx 1 root root     31 Mar 15 13:09 log4j.properties -> /etc/hive/conf/log4j.properties
lrwxrwxrwx 1 root root     30 Apr 24 10:33 mapred-site.xml -> /etc/hive/conf/mapred-site.xml

and then we launched it, forcing it to use YARN like so:

HADOOP_CONF_DIR=/etc/hadoop/conf.cloudera.yarn YARN_CONF_DIR=/etc/hadoop/conf.cloudera.yarn
/opt/hive-1.1.0/bin/hive

then I ran these queries:

CREATE TABLE test_change (a int, b int, c int);
ALTER TABLE test_change CHANGE a a1 INT;

The second one failed as described.

Then I tried to launch the beeline client like so:

HADOOP_CONF_DIR=/etc/hadoop/conf.cloudera.yarn YARN_CONF_DIR=/etc/hadoop/conf.cloudera.yarn
/opt/hive-1.1.0/bin/beeline -u jdbc:hive2://

and the ALTER query worked fine now.

Can you please try it out with Hive CLI 1.1.0 (using YARN) to see if you can reproduce it
as well? It really seems like some kind of regression, as this works fine in Hive 1.0.0.

Thanks.

> hive 1.1.0 rename column fails: Invalid method name: 'alter_table_with_cascade'
> -------------------------------------------------------------------------------
>
>                 Key: HIVE-10552
>                 URL: https://issues.apache.org/jira/browse/HIVE-10552
>             Project: Hive
>          Issue Type: Bug
>          Components: Database/Schema
>    Affects Versions: 1.1.0
>         Environment: centos 6.6, cloudera 5.3.3
>            Reporter: David Watzke
>            Assignee: Chaoyu Tang
>            Priority: Blocker
>
> Hi,
> we're trying out hive 1.1.0 with cloudera 5.3.3 and since hive 1.0.0 there's (what appears
to be) a regression.
> This ALTER command that renames a table column used to work fine in older versions but
in hive 1.1.0 it does throws this error:
> hive> CREATE TABLE test_change (a int, b int, c int);
> OK
> Time taken: 2.303 seconds
> hive> ALTER TABLE test_change CHANGE a a1 INT;
> 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'



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message