SQL Server big data clusters
Installation instructions for SQL Server 2019 big data clusters can be found here.
Before you begin, load the sample data into your big data cluster. For instructions, see Load sample data into a SQL Server 2019 big data cluster.
Executing the sample scripts
The scripts should be executed in a specific order to test the various features. Execute the scripts from each folder in below order:
SQL Server 2019 big data cluster contains a data pool which consists of many SQL Server instances to store data & query in a scale-out manner.
Data ingestion using Spark
The sample script data-pool/data-ingestion-spark.sql shows how to perform data ingestion from Spark into data pool table(s).
Data ingestion using sql
The sample script data-pool/data-ingestion-sql.sql shows how to perform data ingestion from T-SQL into data pool table(s).
SQL Server 2019 or SQL Server 2019 big data cluster can use PolyBase external tables to connect to other data sources.
External table over Generic ODBC data source
The data-virtualization/generic-odbc folder contains samples that demonstrate how to query data in MySQL & PostgreSQL using external tables and generic ODBC data source. The generic ODBC data soruce can be used only in SQL Server 2019 on Windows.
External table over Hadoop
The data-virtualization/hadoop folder contains samples that demonstrate how to query data in HDFS using external tables. This demonstrates the functionality available from SQL Server 2016 using the HADOOP data source.
External table over Oracle
The data-virtualization/oracle folder contains samples that demonstrate how to query data in Oracle using external tables.
External table over Storage Pool
SQL Server 2019 big data cluster contains a storage pool consisting of HDFS, Spark and SQL Server instances. The data-virtualization/storage-pool folder contains samples that demonstrate how to query data in HDFS inside SQL Server 2019 big data cluster.
The deployment folder contains the scripts for deploying a Kubernetes cluster for SQL Server 2019 big data cluster.
SQL Server 2016 added support executing R scripts from T-SQL. SQL Server 2017 added support for executing Python scripts from T-SQL. SQL Server 2019 adds support for executing Java code from T-SQL. SQL Server 2019 big data cluster adds support for executing Spark code inside the big data cluster.
SQL Server Machine Learning Services
The machine-learning\sql folder contains the sample SQL scripts that show how to invoke R, Python, and Java code from T-SQL.
Spark Machine Learning
The machine-learning\spark folder contains the Spark samples.