alamb opened a new pull request #9847:
URL: https://github.com/apache/arrow/pull/9847


   # Rationale
   Accessing the list of tables via `select * from information_schema.tables` 
(introduced in https://github.com/apache/arrow/pull/9818) is a lot to type
   
   See the doc for background: 
https://docs.google.com/document/d/12cpZUSNPqVH9Z0BBx6O8REu7TFqL-NPPAYCUPpDls1k/edit#
   
   # Proposal
   
   Add support for `SHOW TABLES` command.
   
   # Example Use
   
   
   Setup:
   ```
   echo "1,Foo,44.9" > /tmp/table.csv
   echo "2,Bar,22.1" >> /tmp/table.csv
   cargo run --bin datafusion-cli
   ```
   
   Then run :
   
   ```
   CREATE EXTERNAL TABLE t(a int, b varchar, c float)
   STORED AS CSV
   LOCATION '/tmp/table.csv';
   
   > show tables;
   +---------------+--------------------+------------+------------+
   | table_catalog | table_schema       | table_name | table_type |
   +---------------+--------------------+------------+------------+
   | datafusion    | public             | t          | BASE TABLE |
   | datafusion    | information_schema | tables     | VIEW       |
   +---------------+--------------------+------------+------------+
   2 row in set. Query took 0 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.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to