OPERATING A DISTRIBUTED DATABASE WITH FOREIGN TABLES

摘要

A system and method for performing queries in a distributed database with foreign table extensions containing semi-structured data. In a preferred embodiment, a coordinator node communicates with worker nodes; worker nodes store data blocks that contains data in a semi-structured format and further contains an associated foreign table metadata that specifies conversion of the data from the semi-structured format into a database format in response to a SQL query; a query processor of the coordinator node that produces and executes a query search plan; and sub-queries executed by worker nodes.