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

["Dongjoon Hyun (JIRA)" <ji...@apache.org>]

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

Dongjoon Hyun commented on SPARK-7493:
--------------------------------------

Hi, [~ssemichev].
Just FYI, Spark 2.0 supports this now.
{code}
scala> sql("create table default.t(i int) partitioned by (p timestamp)")
scala> sql("alter table default.t add partition(p='2013-01-02 01:00')")
scala> sql("select * from default.t").show
+---+---+
|  i|  p|
+---+---+
+---+---+
scala> sql("show partitions default.t").show
+--------------------+
|           partition|
+--------------------+
|p=2013-01-02 01%3A00|
+--------------------+
{code}

> 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org