QUERY

query

Name

query

description

Query table function (table-valued-function, tvf) can be used to transparently transmit query statements directly to a catalog for data query

note

Supported by Doris version 2.1.3, currently only transparent query jdbc catalog is supported. You need to create the corresponding catalog in Doris first.

syntax

query(
  "catalog" = "catalog_name",
  "query" = "select * from db_name.table_name where condition"
  );

Parameter Description

Each parameter in the query table function tvf is a "key"="value" pair. Related parameters:

• catalog: (required) catalog name, which needs to be filled in according to the name of the catalog.
• query: (required) The query statement to be executed.

Example

Use the query function to query tables in the jdbc data source

select * from query("catalog" = "jdbc", "query" = "select * from db_name.table_name where condition");

Can be used with desc function

desc function query("catalog" = "jdbc", "query" = "select * from db_name.table_name where condition");

Keywords

query, table-valued-function, tvf

Best Prac

Transparent query for tables in jdbc catalog data source

select * from query("catalog" = "jdbc", "query" = "select * from test.student");
+------+---------+
| id   | name    |
+------+---------+
| 1    | alice   |
| 2    | bob     |
| 3    | jack    |
+------+---------+
select * from query("catalog" = "jdbc", "query" = "select * from test.score");
+------+---------+
| id   | score   |
+------+---------+
| 1    | 100     |
| 2    | 90      |
| 3    | 80      |
+------+---------+

Transparent join query for tables in jdbc catalog data source

select * from query("catalog" = "jdbc", "query" = "select a.id, a.name, b.score from test.student a join test.score b on a.id = b.id");
+------+---------+---------+
| id   | name    | score   |
+------+---------+---------+
| 1    | alice   | 100     |
| 2    | bob     | 90      |
| 3    | jack    | 80      |
+------+---------+---------+