This is an automated email from the ASF dual-hosted git repository.
jiayuliu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/master by this push:
new 7905926 add the document (#1348)
7905926 is described below
commit 790592611738470c551ec51465ffc17daaa2295d
Author: Kun Liu <[email protected]>
AuthorDate: Mon Nov 22 23:08:17 2021 +0800
add the document (#1348)
---
docs/source/user-guide/cli.md | 12 ++++++++++++
docs/source/user-guide/sql/ddl.md | 28 ++++++++++++++++++++++++++++
2 files changed, 40 insertions(+)
diff --git a/docs/source/user-guide/cli.md b/docs/source/user-guide/cli.md
index 049573f..1d2d6b7 100644
--- a/docs/source/user-guide/cli.md
+++ b/docs/source/user-guide/cli.md
@@ -106,3 +106,15 @@ Available commands inside DataFusion CLI are:
```
> \quiet [true|false]
```
+
+- list function
+
+```bash
+> \h
+```
+
+- Search and describe function
+
+```bash
+> \h function_table
+```
diff --git a/docs/source/user-guide/sql/ddl.md
b/docs/source/user-guide/sql/ddl.md
index b48179d..eb10f40 100644
--- a/docs/source/user-guide/sql/ddl.md
+++ b/docs/source/user-guide/sql/ddl.md
@@ -54,3 +54,31 @@ STORED AS CSV
WITH HEADER ROW
LOCATION '/path/to/aggregate_test_100.csv';
```
+
+## CREATE MEMORY TABLE
+
+Memory table can be created with query.
+
+```
+CREATE TABLE TABLE_NAME AS [SELECT | VALUES LIST]
+```
+
+```sql
+CREATE TABLE valuetable AS VALUES(1,'HELLO'),(12,'DATAFUSION');
+
+CREATE TABLE memtable as select * from valuetable;
+```
+
+## DROP TABLE
+
+The table can be deleted.
+
+```
+DROP TABLE [ IF EXISTS ] name
+```
+
+```sql
+CREATE TABLE users AS VALUES(1,2),(2,3);
+
+DROP TABLE users;
+```
