You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/10/20 10:19:36 UTC
[GitHub] [arrow-datafusion] francis-du opened a new issue, #3904: [DOC] - There are unsupported DDL in the official documentation
francis-du opened a new issue, #3904:
URL: https://github.com/apache/arrow-datafusion/issues/3904
**Describe the bug**
Found an error when I run this DDL:
```sql
CREATE TABLE valuetable IF NOT EXISTS AS VALUES(1,'HELLO'),(12,'DATAFUSION');
```
Error:
Docs: https://arrow.apache.org/datafusion/user-guide/sql/ddl.html
--
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.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] Dandandan closed issue #3904: [DOC] - There are unsupported DDL in the official documentation
Posted by GitBox <gi...@apache.org>.
Dandandan closed issue #3904: [DOC] - There are unsupported DDL in the official documentation
URL: https://github.com/apache/arrow-datafusion/issues/3904
--
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.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] alamb commented on issue #3904: [DOC] - There are unsupported DDL in the official documentation
Posted by GitBox <gi...@apache.org>.
alamb commented on issue #3904:
URL: https://github.com/apache/arrow-datafusion/issues/3904#issuecomment-1287759881
I think the right syntax is CREATE TABLE IF NOT EXISTST
```sql
❯ CREATE TABLE IF NOT EXISTS valuetable AS VALUES(1,'HELLO'),(12,'DATAFUSION');
0 rows in set. Query took 0.003 seconds.
```
--
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.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] jackwener commented on issue #3904: [DOC] - There are unsupported DDL in the official documentation
Posted by GitBox <gi...@apache.org>.
jackwener commented on issue #3904:
URL: https://github.com/apache/arrow-datafusion/issues/3904#issuecomment-1288007937
```
CREATE [OR REPLACE] TABLE [IF NOT EXISTS] table_name AS [SELECT | VALUES LIST];
```
Doc is right, you have missed `table_name`.
--
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.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] alamb commented on issue #3904: [DOC] - There are unsupported DDL in the official documentation
Posted by GitBox <gi...@apache.org>.
alamb commented on issue #3904:
URL: https://github.com/apache/arrow-datafusion/issues/3904#issuecomment-1288076322
I think the problem is with this example from https://arrow.apache.org/datafusion/user-guide/sql/ddl.html
> CREATE TABLE valuetable IF NOT EXISTS AS VALUES(1,'HELLO'),(12,'DATAFUSION');
--
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.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org