v0.8.0
Highlights
Cassandra Support
Cassandra is now supported as an external data source.
-- external table
CREATE EXTERNAL TABLE <table_name> FROM cassandra OPTIONS (
host = '<host>',
keyspace = '<keyspace>',
table = '<table>'
);
-- external database
CREATE EXTERNAL DATABASE <db_name> FROM cassandra OPTIONS (
host = '<host>',
);
-- table function
SELECT * FROM read_cassandra('<host>', '<keyspace>', '<table>')
Clickhouse Support
GlareDB now supports ClickHouse as an external data source. Learn more in our ClickHouse docs.
Table Functions
Initial FlightSQL Protocol Support
glaredb server
now includes support for the experimental FlightSQL protocol.
Enable it with:
glaredb server --enable-flight-api
then use your favorite FlightSQL client to connect to the server.
Installing or Updating
CLI
To install or update just run the following command in the directory you want the binary:
curl https://glaredb.com/install.sh | sh
Python
pip install glaredb
Node.js
npm install @glaredb/glaredb
What's Changed
- fix: Hybrid planning when the root plan has local preference by @vrongmeal in #2183
- chore(ci): nodejs bindings yarn version mismatch by @greyscaled in #2212
- chore: consolidating path validation logic by @seve-martinez in #2200
- chore: Fix error message for invalid copy-to by @vrongmeal in #2216
- chore: remove py-glaredb cruft by @tychoish in #2215
- chore: refactor udfs into sqlbuiltins by @universalmind303 in #2214
- feat: add --logs flag to local command by @Lilit0x in #2187
- chore(deps): Bump deps by @scsmithr in #2233
- chore: small cleanup to
ComputeServer
by @universalmind303 in #2232 - chore: Add go package option to protobuf definitions by @scsmithr in #2241
- chore: Remove logical plan serialization by @scsmithr in #2244
- chore(deps): bump actions/setup-python from 4 to 5 by @dependabot in #2229
- fix: Properly exit SimpleExecuteQueryStream on stream end by @scsmithr in #2243
- Better formatting for FixedSizeList (#2058) by @hemanth94 in #2223
- feat: flightsql initial support by @universalmind303 in #2219
- fix: some broken tests by @universalmind303 in #2249
- feat: allow for tests over flightsql by @universalmind303 in #2240
- fix: truncate long floats in cli formatting for display by @hemanth94 in #2253
- fix: cases sensitivity for statement options keywords by @seve-martinez in #2231
- chore: Detect client disconnect in pg proxy by @scsmithr in #2256
- chore(deps): Bump deps by @scsmithr in #2271
- feat: high level integration testing framework by @tychoish in #2258
- chore(pg proxy): update cloud cert by @greyscaled in #2272
- chore: Bump rust to 1.74.1 by @scsmithr in #2275
- fix: Skip external SLTs for external contributors by @vrongmeal in #2247
- feat(bson): add COPY TO support for writing bson files by @tychoish in #2166
- chore: isolate execution of snowflake integration tests by @tychoish in #2278
- fix: Don't parse version-hint as a number for iceberg tables by @vrongmeal in #2281
- chore(deps): upgrade actions by @tychoish in #2282
- chore(deps): bump zerocopy from 0.7.18 to 0.7.31 by @dependabot in #2257
- chore(deps): bump rustls-pemfile from 1.0.4 to 2.0.0 by @dependabot in #2190
- chore(deps): bump webpki-roots from 0.25.3 to 0.26.0 by @dependabot in #2191
- fix: filter unknown oids for Postgres types by @hemanth94 in #2283
- feat: encrypted flight api via cloud proxy by @universalmind303 in #2279
- chore: Default to compact logs by @scsmithr in #2287
- chore(deps): Bump deps by @scsmithr in #2297
- feat(bson): add table function for bson files by @tychoish in #2202
- fix: Hacky fix for running the experimental scheduler when spawning task by @vrongmeal in #2284
- chore: Remote
fn runtime_preference()
fromTableFunc
trait. by @vrongmeal in #2288 - feat: Add
read_sqlserver
table returning function by @vrongmeal in #2310 - chore: Add .clang-format by @scsmithr in #2312
- fix: bson type handling cleanup by @tychoish in #2313
- feat: cli highlighting improvements. by @universalmind303 in #2307
- feat: Support virtual listing for SQL server. by @vrongmeal in #2311
- feat: Clickhouse data source by @scsmithr in #2300
- fix: scalar udf function argument handling by @tychoish in #2304
- feat: add non-cryptographic hash function by @tychoish in #2298
- feat: partition results helper by @tychoish in #2299
- test: Add datatypes test for SQL Server by @vrongmeal in #2317
- feat: Add support for Azure data dir by @vrongmeal in #2319
- test: Add SLTs for sqlserver <> virtual listing by @vrongmeal in #2320
- chore(deps): Bump deps by @scsmithr in #2331
- chore: Bump rust to 1.75 by @scsmithr in #2335
- chore: Make bucket name required in storage config by @vrongmeal in #2336
- Revert "chore: Make bucket name required in storage config" by @vrongmeal in #2337
- fix: bson builder should handle schema flexibly by @tychoish in #2334
- fix: bson type inference fixes by @tychoish in #2339
- chore: mongo -> mongodb in symbol naming by @tychoish in #2343
- fix: complex bson types by @tychoish in #2341
- feat:
read_cassandra
table function by @universalmind303 in #2344 - chore(deps): Bump deps by @scsmithr in #2359
- chore: Allow specifying aliases for table functions by @scsmithr in #2364
- feat: Allow specifying alt delimiter when reading csv by @scsmithr in #2365
- chore: Misc builtin function refactoring by @scsmithr in #2367
- feat: Clickhouse followup items by @vrongmeal in #2340
- feat: external table for cassandra by @universalmind303 in #2361
- chore: Add alias map for functions by @scsmithr in #2370
- ci: speed up ci by introducing precompiled slt binary by @universalmind303 in #2363
- fix: add signature for read_excel by @universalmind303 in #2376
- feat: cassandra external database by @universalmind303 in #2374
- fix: excel options by @universalmind303 in #2377
- feat: Allow reading csv files without a header by @scsmithr in #2380
- release: v0.8.0 by @tychoish in #2381
- Revert "release: v0.8.0" by @greyscaled in #2383
- chore: Add slt for asserting builtin tables by @scsmithr in #2387
- chore: Switch to klickhouse by @scsmithr in #2388
- release: v0.8.0 by @greyscaled in #2391
- chore: add check for dynamic linking on linux by @tychoish in #2386
- Revert "release: v0.8.0" by @greyscaled in #2398
- ci: downgrade upload-artifact v4->v3 by @greyscaled in #2400
- release: v0.8.0 by @greyscaled in #2403
New Contributors
- @seve-martinez made their first contribution in #2200
- @hemanth94 made their first contribution in #2223
Full Changelog: v0.7.1...v0.8.0