I upgrade spark cluster from 1.6.2 to spark 2.0.2 and test spark2 sql syntax.I found some grammar that spark 2.0.2 not support.but it work in spark 1.6.2. Hive metastore version is 1.2.1. such as： 1、ALTER TABLE table_name ADD COLUMNS(m_id STRING); spark 2.0.2 throw an exception :Operation not allowed: alter table add columns(line 1, pos 0) 2、MSCK command not allowed to use;
Should I need to config some properties to enable the sql support ? Or just put all hive jar in $SPARK_HOME/jars. Thanks. -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Does-Spark-2-0-2-sql-syntax-not-support-hive-sql-syntax-any-more-tp28207.html Sent from the Apache Spark User List mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe e-mail: user-unsubscr...@spark.apache.org
