retikulum commented on issue #3211: URL: https://github.com/apache/arrow-datafusion/issues/3211#issuecomment-1287363180
Hi. As this issue is not closed or proceed, I will suggest following explanation for it. Is it enough? # CREATE VIEW View is a virtual table based on the result of a SQL query. It can be created from an existing table or values list <pre> CREATE VIEW <i><b>view_name</i></b> AS statement; </pre> ```sql CREATE TABLE users AS VALUES(1,2),(2,3),(3,4),(4,5); CREATE VIEW test AS SELECT column1 FROM users; SELECT * FROM test; +---------+ | column1 | +---------+ | 1 | | 2 | | 3 | | 4 | +---------+ ``` ```sql CREATE VIEW test AS VALUES(1,2),(5,6); SELECT * FROM test; +---------+---------+ | column1 | column2 | +---------+---------+ | 1 | 2 | | 5 | 6 | +---------+---------+ ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
