cloud-fan commented on a change in pull request #26304: [SPARK-29592][SQL]
ALTER TABLE (set partition location) should look up catalog/table like v2
commands
URL: https://github.com/apache/spark/pull/26304#discussion_r340738720
##########
File path:
sql/core/src/test/scala/org/apache/spark/sql/execution/SQLViewSuite.scala
##########
@@ -136,14 +136,21 @@ abstract class SQLViewSuite extends QueryTest with
SQLTestUtils {
assertNoSuchTable(s"ALTER TABLE $viewName SET SERDE 'whatever'")
assertNoSuchTable(s"ALTER TABLE $viewName PARTITION (a=1, b=2) SET SERDE
'whatever'")
assertNoSuchTable(s"ALTER TABLE $viewName SET SERDEPROPERTIES ('p' =
'an')")
- assertNoSuchTable(s"ALTER TABLE $viewName PARTITION (a='4') SET LOCATION
'/path/to/home'")
assertNoSuchTable(s"ALTER TABLE $viewName ADD IF NOT EXISTS PARTITION
(a='4', b='8')")
assertNoSuchTable(s"ALTER TABLE $viewName DROP PARTITION (a='4', b='8')")
assertNoSuchTable(s"ALTER TABLE $viewName PARTITION (a='4') RENAME TO
PARTITION (a='5')")
assertNoSuchTable(s"ALTER TABLE $viewName RECOVER PARTITIONS")
// For v2 ALTER TABLE statements, we have better error message saying
view is not supported.
- assertViewNotSupported(s"ALTER TABLE $viewName SET LOCATION
'/path/to/your/lovely/heart'")
+ assertAnalysisExceptionThrown(
+ s"ALTER TABLE $viewName SET LOCATION '/path/to/your/lovely/heart'",
+ s"'$viewName' is a view not a table")
+
+ // For the following v2 ALERT TABLE statements, unsupported operations
are checked first
+ // before resolving the relations.
+ assertAnalysisExceptionThrown(
+ s"ALTER TABLE $viewName PARTITION (a='4') SET LOCATION
'/path/to/home'",
+ "ALTER TABLE SET LOCATION does not support partition for v2 tables")
Review comment:
looks reasonable to me
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
