Update DROP Table example in Delta document
@@ -79,17 +79,13 @@ table location in an S3 bucket named ``db-sa-datasets`` using Delta Lake connect
.. code-block:: sql
- CREATE TABLE hive.apac.sales_data_new (dummyColumn INT)
+ CREATE TABLE sales.apac.sales_data_new (dummyColumn INT)
WITH (external_location = 's3://db-sa-datasets/presto/sales_data_new');
To register a partition Delta table in Hive metastore, use the ``CREATE TABLE`` same as above.
Only ``external_location`` is required in the properties, no need to specify ``partitioned_by`` in
``CREATE TABLE``
-In the above query
-
-* ``hive`` refers to the Hive catalog.
-
Another option is querying the table directly using the table location as table name.
.. code-block:: sql
@@ -119,3 +115,10 @@ as suffix to the table name.
Above query reads data from the latest snapshot as of timestamp ``2021-11-18 09:45:00``
in the table ``sales.apac.sales_data``.
+
+.. code-block:: sql
+
+ DROP TABLE sales.apac.sales_data_new;
+
+Above query drops the external table ``sales.apac.sales_data_new``. This only drops the
+metadata for the table. The referenced data directory is not deleted.
