dask-sql icon indicating copy to clipboard operation
dask-sql copied to clipboard
verified publisher icon dask-contrib

[DF] Support `CREATE TABLE x AS TABLE y`

Open sarahyurick opened this issue 3 years ago • 4 comments

Hi, I'd like to be able to parse a statement like CREATE TABLE films2 AS TABLE films as from the second Postgres example found at this source. I currently get a parser error, which is why I originally opened an issue with SQLParser (https://github.com/sqlparser-rs/sqlparser-rs/issues/614).

sarahyurick avatar Sep 19 '22 18:09 sarahyurick

Now that https://github.com/sqlparser-rs/sqlparser-rs/pull/704 has been merged, this is dependent on DataFusion bumping to the next SQLParser version and then us bumping to the next DataFusion version 🙂

sarahyurick avatar Dec 01 '22 18:12 sarahyurick

DataFusion now uses the most recently SQLParser changes with https://github.com/apache/arrow-datafusion/pull/4799. Now we are waiting on the next DataFusion release 16.0.0 with these changes.

sarahyurick avatar Jan 04 '23 17:01 sarahyurick

Can be added once https://github.com/dask-contrib/dask-sql/pull/998 is merged.

sarahyurick avatar Jan 26 '23 17:01 sarahyurick

Looks like I'll need to make some new changes on the DataFusion side first.

https://github.com/apache/arrow-datafusion/blob/3cc607de4ce6e9e1fd537091e471858c62f58653/datafusion/sql/src/set_expr.rs

sarahyurick avatar Feb 14 '23 20:02 sarahyurick