Adding pipes and grep|like in output

[matteoredaelli]

It would be nice to have a "grep" or "like" function for filtering the output

Something like

!tables | grep "^DWH_" or !tables | like 'DWH_%'
!columns | grep "DESC" or !columns | like '%DESCR%'

Thanks
Matteo

[julianhyde]

An alternative is to use SQL. E.g. in Calcite,

> select * from "metadata".TABLES where "tableName" like '%S';
+----------+------------+-----------+--------------+---------+---------+-----------+----------+------------------------+---------------+
| tableCat | tableSchem | tableName |  tableType   | remarks | typeCat | typeSchem | typeName | selfReferencingColName | refGeneration |
+----------+------------+-----------+--------------+---------+---------+-----------+----------+------------------------+---------------+
|          | metadata   | COLUMNS   | SYSTEM TABLE |         |         |           |          |                        |               |
|          | metadata   | TABLES    | SYSTEM TABLE |         |         |           |          |                        |               |
+----------+------------+-----------+--------------+---------+---------+-----------+----------+------------------------+---------------+
2 rows selected (0.186 seconds)

[snuyanzin]

it even works for !tables without like, grep, e.g.

> !tables %MP%
+-----------+-------------+--------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
| TABLE_CAT | TABLE_SCHEM |  TABLE_NAME  | TABLE_TYPE | REMARKS | TYPE_CAT | TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
+-----------+-------------+--------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
|           | SALES       | EMPS         | TABLE      |         |          |            |           |                           |                |
|           | SALES       | SAMPLE_SALES | TABLE      |         |          |            |           |                           |                |
+-----------+-------------+--------------+------------+---------+----------+------------+-----------+---------------------------+----------------+

while without filter

> !tables 
+-----------+-------------+--------------+--------------+---------+----------+------------+-----------+---------------------------+----------------+
| TABLE_CAT | TABLE_SCHEM |  TABLE_NAME  |  TABLE_TYPE  | REMARKS | TYPE_CAT | TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
+-----------+-------------+--------------+--------------+---------+----------+------------+-----------+---------------------------+----------------+
|           | SALES       | DEPTS        | TABLE        |         |          |            |           |                           |                |
|           | SALES       | EMPS         | TABLE        |         |          |            |           |                           |                |
|           | SALES       | SAMPLE_SALES | TABLE        |         |          |            |           |                           |                |
|           | SALES       | SDEPTS       | TABLE        |         |          |            |           |                           |                |
|           | metadata    | COLUMNS      | SYSTEM TABLE |         |          |            |           |                           |                |
|           | metadata    | TABLES       | SYSTEM TABLE |         |          |            |           |                           |                |
+-----------+-------------+--------------+--------------+---------+----------+------------+-----------+---------------------------+----------------+

in case of !columns it also filters however it tries to filter by TABLE_NAME column and may be that is what makes sense to fix

[matteoredaelli]

Thanks!

Yes I agree with you about fixing !columns

[snuyanzin]

merged as 32c974a