[
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)
