Github user cloud-fan commented on the issue:
https://github.com/apache/spark/pull/15983
> Should we support EXTERNAL for data source tables?
I'd like to hide the `EXTERNAL` concept to users, and only expose the
`path` option or `LOCATION` syntax, for both data source and hive serde tables.
It's pretty weird to have a managed table with a custom location, or an
external table without custom location, and I don't think Hive's behavior makes
sense when we rename, drop, alterLocation, ... these tables.
After we unify the CREATE TABLE syntax, we will only document the new
syntax(which doesn't have the `EXTERNAL` concept), and leave the legacy hive
syntax undocumented(but still supported).
> CTAS always repairs the table but InsertInto does not do it
As hive can't append a table with CTAS, we can define our own semantic
here. InsertInto only update the involved partitions, I think it makes more
sense to follow it for CTAS, which will be done in
https://github.com/apache/spark/pull/15996
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
