CPC G06F 16/2423 (2019.01) [G06F 3/0605 (2013.01); G06F 3/067 (2013.01); G06F 3/0644 (2013.01); G06F 16/2393 (2019.01); G06F 16/24535 (2019.01); G06F 16/24542 (2019.01); G06F 16/254 (2019.01)] | 17 Claims |
1. A method performed by a database platform executing instructions on at least one hardware processor, the method comprising:
receiving a query comprising one or more predicates, the query directed at least to data in an external table that is stored in an external storage platform that is external to the database platform, the external table being based on a source directory of the external storage platform, the source directory comprising a hierarchical structure of storage locations in which data of the external table is stored in the external storage platform, the storage locations defining a plurality of partitions of the external table;
identifying, based on metadata that summarizes the data in the external table, one or more partitions in the plurality of partitions of the external table to be scanned for data satisfying the one or more predicates;
identifying, from the one or more identified partitions, data satisfying the one or more predicates;
generating a materialized view over the external table;
storing the materialized view in an internal storage platform that is internal to the database platform; and
sending a response to the query to the client, the response comprising the data satisfying the one or more predicates, the response further comprising data from the stored materialized view.
|