[
https://issues.apache.org/jira/browse/SPARK-6043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trystan Leftwich updated SPARK-6043:
------------------------------------
Priority: Minor (was: Major)
> Error when trying to rename table with alter table after using INSERT
> OVERWITE to populate the table
> ----------------------------------------------------------------------------------------------------
>
> Key: SPARK-6043
> URL: https://issues.apache.org/jira/browse/SPARK-6043
> Project: Spark
> Issue Type: Bug
> Affects Versions: 1.2.1
> Reporter: Trystan Leftwich
> Priority: Minor
>
> If you populate a table using INSERT OVERWRITE and then try to rename the
> table using alter table it fails with:
> {noformat}
> Error: org.apache.spark.sql.execution.QueryExecutionException: FAILED:
> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
> Unable to alter table. (state=,code=0)
> {noformat}
> Using the following SQL statement creates the error:
> {code:sql}
> CREATE TABLE `tmp_table` (salesamount_c1 DOUBLE);
> INSERT OVERWRITE table tmp_table SELECT
> MIN(sales_customer.salesamount) salesamount_c1
> FROM
> (
> SELECT
> SUM(sales.salesamount) salesamount
> FROM
> factinternetsales sales
> ) sales_customer;
> ALTER TABLE tmp_table RENAME to not_tmp;
> {code}
> But if you change the 'OVERWRITE' to be 'INTO' the SQL statement works.
> This is happening on our CDH5.3 cluster with multiple workers, If we use the
> CDH5.3 Quickstart VM the SQL does not produce an error. Both cases were spark
> 1.2.1 built for hadoop2.4+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
