...
- Data Extraction Service exposes the data in Big Data DBs to outside via REST API
- Each data exposure is defined via a set of configurations, which contains URL, from which DB to retrieve the data, query sql template, etc
Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. Presto was designed and written from the ground up for interactive analytics and approaches the speed of commercial data warehouses while scaling to the size of organizations like Facebook.
Deployment Prerequisite/dependencies
...
3. create a sql query template you want to query, insert into maridb table: data_exposure. sample like below:
you can refer :https://prestosql.io/docs/current/language/types.html#structural for sql query design.
insert into data_exposure(id, note,sql_template,db_id) values ('test','test_des', ' select event.commonEventHeader.sourceName as name, event.perf3gppFields.measDataCollection.measuredEntityDn as entity from datalake where event.commonEventHeader.sourceName = ''${name}'' ',3);
...