[jira] [Commented] (SPARK-7493) ALTER TABLE statement
[ https://issues.apache.org/jira/browse/SPARK-7493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15430821#comment-15430821 ] Dongjoon Hyun commented on SPARK-7493: -- Thank you! > 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] [Commented] (SPARK-7493) ALTER TABLE statement
[ 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] [Commented] (SPARK-7493) ALTER TABLE statement
[ https://issues.apache.org/jira/browse/SPARK-7493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15429910#comment-15429910 ] Dongjoon Hyun commented on SPARK-7493: -- Also, this seems to be supported in 1.6.2 for non-timestamp types. {code} scala> sc.version res7: String = 1.6.2 scala> sql("create table default.t2(i int) partitioned by (p int)") scala> sql("alter table default.t2 add partition(p=2)") scala> sql("show partitions default.t2").show +--+ |result| +--+ | p=2| +--+ {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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-7493) ALTER TABLE statement
[ 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org