SQL on Hadoop

In openGauss, you can use FDW to access external data sources. You can also create read-only foreign tables containing structured data in HDFS, which inherit all the existing SQL query syntax and capabilities, to query HDFS data.

• Interconnection Configuration

• Accessing HDFS Data Using a Foreign Table

• Supported Data Types

• Statistics Collection

• Foreign Table Usage

• Querying HDFS Data Using the Acceleration Database Instance