GitHub

Sail examples

Sail examples Runnable examples of Spark SQL and DataFrame code on Sail, from querying a file on your laptop to Delta Lake pipelines and AI on images, audio and video. Every example is a folder with a ...
GitHub

sql-server-to-iceberg.mdx

title SQL Server to Apache Iceberg: CDC with OLake Go description Replicate SQL Server to Apache Iceberg with CDC: OLake Go reads the change tables into a Polaris catalog, and Spark, DuckDB and Trino ...

SQL NULL Pitfalls: Why NOT IN Returns Zero Results and 3 Points Where MySQL and Oracle ...

Introduction"I want to list customers who haven't ordered, but I get zero results," or "The count doesn't match when I exclude cancellations." Among SQL bugs, those caused by NULL are often discovered ...
learn

Set the connection properties

You can specify the connection string properties in various ways: As <name>=<value> properties in the connection URL when you connect by using the DriverManager class. For connection string syntax, ...