[jira] [Commented] (SPARK-7493) ALTER TABLE statement

[Sergey Semichev (JIRA)]

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

Sergey Semichev commented on SPARK-7493:


Good to know, thanks

> ALTER TABLE statement
> -
>
> Key: SPARK-7493
> URL: https://issues.apache.org/jira/browse/SPARK-7493
> Project: Spark
>  Issue Type: Bug
>  Components: SQL
> Environment: Databricks cloud
>Reporter: Sergey Semichev
>Priority: Minor
>
> Full table name (database_name.table_name) cannot be used with "ALTER TABLE" 
> statement 
> It works with CREATE TABLE
> "ALTER TABLE database_name.table_name ADD PARTITION (source_year='2014', 
> source_month='01')."
> Error in SQL statement: java.lang.RuntimeException: 
> org.apache.spark.sql.AnalysisException: mismatched input 'ADD' expecting 
> KW_EXCHANGE near 'test_table' in alter exchange partition;



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

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Closed] (SPARK-7493) ALTER TABLE statement

[Sergey Semichev (JIRA)]

 [ 
https://issues.apache.org/jira/browse/SPARK-7493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sergey Semichev closed SPARK-7493.
--
Resolution: Fixed

> ALTER TABLE statement
> -
>
> Key: SPARK-7493
> URL: https://issues.apache.org/jira/browse/SPARK-7493
> Project: Spark
>  Issue Type: Bug
>  Components: SQL
> Environment: Databricks cloud
>Reporter: Sergey Semichev
>Priority: Minor
>
> Full table name (database_name.table_name) cannot be used with "ALTER TABLE" 
> statement 
> It works with CREATE TABLE
> "ALTER TABLE database_name.table_name ADD PARTITION (source_year='2014', 
> source_month='01')."
> Error in SQL statement: java.lang.RuntimeException: 
> org.apache.spark.sql.AnalysisException: mismatched input 'ADD' expecting 
> KW_EXCHANGE near 'test_table' in alter exchange partition;



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

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Created] (SPARK-7493) ALTER TABLE statement

[Sergey Semichev (JIRA)]

Sergey Semichev created SPARK-7493:
--

 Summary: ALTER TABLE statement
 Key: SPARK-7493
 URL: https://issues.apache.org/jira/browse/SPARK-7493
 Project: Spark
  Issue Type: Bug
  Components: SQL
 Environment: Databricks cloud
Reporter: Sergey Semichev
Priority: Minor


Full table name (database_name.table_name) cannot be used with "ALTER TABLE" 
statement 
It works with CREATE TABLE

"ALTER TABLE database_name.table_name ADD PARTITION (source_year='2014', 
source_month='01')."

Error in SQL statement: java.lang.RuntimeException: 
org.apache.spark.sql.AnalysisException: mismatched input 'ADD' expecting 
KW_EXCHANGE near 'test_table' in alter exchange partition;



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

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org