spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew K Long (Jira)" <j...@apache.org>
Subject [jira] [Commented] (SPARK-30053) Add support for vacuum to V2 datasources
Date Mon, 02 Dec 2019 19:27:00 GMT

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

Andrew K Long commented on SPARK-30053:
---------------------------------------

I don't own the ansi docs so i can't answer that unfortunately but vacuum is a very common
command.  for example .

* https://www.sqlite.org/lang_vacuum.html
* https://www.postgresql.org/docs/9.1/sql-vacuum.html
* https://docs.aws.amazon.com/redshift/latest/dg/r_VACUUM_command.html
* https://docs.databricks.com/spark/latest/spark-sql/language-manual/vacuum.html


Another option would the optimize key word which databricks uses for delta.

* https://docs.databricks.com/spark/latest/spark-sql/language-manual/optimize.html



> Add support for vacuum to V2 datasources
> ----------------------------------------
>
>                 Key: SPARK-30053
>                 URL: https://issues.apache.org/jira/browse/SPARK-30053
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Andrew K Long
>            Priority: Major
>
> Currently there is no way for a user to vacuum a table via SQL for a v2 Datasource. 
This issue would Add support for vacuum to V2 datasources.
> > VACUUM table_name
> Example vacuum sql command.
> https://docs.aws.amazon.com/redshift/latest/dg/r_VACUUM_command.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message