Quick Start
Simulate Time Series Scenarios
Standard Cluster Deployment
Data Modeling
Connecting to The database
Data Writing
Data Migration
Data Query
Scene Application Examples
Federal Query
Maintenance and Monitoring
Global Maintenance
Partition Maintenance
Backup and Restore
Cluster Expansion
Monitoring
Performance Tuning
Troubleshooting
Reference Guide
Tool Guide
Data Type
Storage Engine
Execution Engine
Configuration Parameters
SQL Reference
FAQ
Federated queries allow YMatrix to access external data sources such as MySQL, PostgreSQL, and other databases. The process of reading and writing data is similar to accessing internal tables in YMatrix.
Federated queries are implemented using Foreign Data Wrapper (FDW). FDW is the PostgreSQL implementation of the SQL/MED (SQL Management of External Data) standard. It provides a unified set of public interfaces that enable extensions to deeply integrate with core components of Postgres, including query optimization, execution, scanning, updates, and statistics. This integration allows external data sources to be queried and manipulated directly using SQL statements. For example, with FDW for MySQL, you can directly query, sort, group, filter, join, insert, and update MySQL data just like working with local tables. The community has developed many FDW extensions supporting common databases, as well as access to local files, HDFS, and more.
This section describes how to use FDW to access PostgreSQL, MySQL, and MongoDB, and how to use PXF to access HDFS, Hive ORC, and other data sources.
