The SELECT
statement fetches data from a table and predictions from a model.
Here we go over example of selecting data from tables of connected data sources. To learn how to select predictions from a model, visit this page.
In this example, query contains only tables from one integration. This query will be executed on this integration database (where integration name will be cut from the table name).
It is also possible to send native queries to integration that use syntax native to a given integration. It is useful when a query can not be parsed as SQL.
Here is an example of selecting from a Mongo integration using Mongo-QL syntax:
It can be useful in cases when integration engine doesn’t support some functions, for example, grouping, as shown below. In this case, all data from raw select are passed to MindsDB and then subselect performs operations on them inside MindsDB.
It is possible to use UNION
and UNION ALL
operators. It this case, every subselect from union will be fetched and merged to one result-set on MindsDB side.