Presto with Azure Cosmos DB, Azure SQL Database, MySQL, PostgreSQL, and Azure Blob Storage

In this example, I’m showing how to configure Presto connectors to query and join data from Azure Cosmos DB (using MongoDB API), Azure SQL Database, Azure Database for MySQL, and Azure Database for PostgreSQL while storing the joined results in Azure Blob Storage. Take a look at the video walkthrough below and the source code…

0

Presto querying data in Azure Blob Storage and Azure Data Lake Store

Recently, I created a simple POC of a single-node Presto querying data in Azure Blob Storage (WASB) and Azure Data Lake Store (ADLS). In my example, Presto (version 0.167 or 0.178) is accessing these data stores via Presto’s hive-hadoop2 connector (with a few additional JARs) and needs Hive metastore service to store the metadata about…

0