- com.fasterxml.jackson.core:jackson-databind ......... 2.20.1 -> 2.21.1
- org.apache.hadoop:hadoop-common ....................... 3.4.2 -> 3.4.3
- org.apache.hadoop:hadoop-mapreduce-client-core ........ 3.4.2 -> 3.4.3
- org.apache.parquet:parquet-avro ..................... 1.16.0 -> 1.17.0
- org.apache.parquet:parquet-hadoop ................... 1.16.0 -> 1.17.0
- org.apache.parquet:parquet-variant .................. 1.16.0 -> 1.17.0
- org.junit.jupiter:junit-jupiter ....................... 6.0.1 -> 6.0.3
- org.mockito:mockito-core ............................ 5.20.0 -> 5.23.0
- improved JDBC compliance for supported statement creation overloads, statement closed-state reporting, and connection validation
- replaced unsupported connection factory sentinel values with proper JDBC exceptions and wrapper behavior
- aligned driver, CLI, and metadata version reporting with manifest-derived runtime metadata
- expanded Parquet pushdown observability with documented
PushdownInforeporting and broader pruning coverage tests JParqStatementno longer exposes its accidentalBasicThreadFactory.Builderinheritance; downstream code should not rely on that implementation detail
- add support for batch execution in prepared statements
- Implemented full positional parameter binding for prepared statements with safe literal rendering to block SQL injection.
- add support for named parameters in prepared statements
- several minor bug fixes and improvements
- improved test coverage and add more edge case tests
- create a fat jar so the driver can be used in tools that require adding a jar to the classpath
- optimize dependency footprint by excluding more transitive dependencies
- improved schema support
- parquet files in the root dir will have the schema PUBLIC
- subdirectories correspond to a schema
- Improve test coverage to >= 80%
- Improve metadata support and accuracy
- refactored function support for increased coherence and reduced coupling
- add function mapping from jdbc escape syntax to sql standard function names for numeric, string, datetime, and system functions
- several minor bug fixes and improvements
- Improved support for quoted identifiers throughout the codebase
- added a cli interface for interactive querying
- Additional Derived Tables support:
- LATERAL derived tables
- VALUES table constructors
- Support TABLE wrapper for UNNEST table functions
- Complete set-operation coverage.
- INTERSECT ALL
- EXCEPT ALL
- Support for nested set operations
- Add simple schema validation
- Bug fixes to UNNEST, CTE, EXCEPT
- Add SQL compliance test suite to verify that all works
- support || operator for string and binary concatenations
- support for explicit NULLS FIRST and NULLS LAST in ORDER BY
- Add ARRAY constructor function support
- Fix column names and types in ResultSetMetaData
- Adhere JParqDatabaseMetaData specifications for getColumns and getTables methods to the JDBC standard
- Add support for derived tables
- UNNEST with and without ordinality
- Add support for grouping sets, rollup, and cube in the GROUP BY clause
- Add support for qualified wildcards (table.*) in SELECT statements
- Add support for the ARRAY constructor function to create array literals
- Add support for Windowing functions i.e:
- Ranking functions
- ROW_NUMBER, RANK, DENSE_RANK, PERCENT_RANK, CUME_DIST, NTILE
- Aggregate window functions
- SUM, AVG, MIN, MAX, COUNT
- Analytic Value/Navigation Functions
- LAG, LEAD, FIRST_VALUE, LAST_VALUE, NTH_VALUE
- Ranking functions
- Add support for JOIN USING clause
- Add support for CTE (Common Table Expressions)
- Add support for self joins.
- Add support for UNION, and UNION ALL
- Add support for INTERSECT and EXCEPT
- Add support for INNER, LEFT, RIGHT, FULL, and CROSS Join
The following Additional SQL statements are now supported:
OFFSETandLIMITsupportDISTINCTsupport- Functions support
- Date functions
- Aggregate functions (count, sum, avg, max, min)
- CAST support
- coalesce (The COALESCE() function returns the first non-null value in a list.)
- String functions (all SQL standard string function supported)
- Numeric functions (abs, ceil, floor, round, sqrt, truncate, mod, power, exp, log, rand, sign, sin, cos, tan, asin, acos, atan, atan2, degrees, radians)
- comments (line --) and block (/* */)
- Subquery support
- In the SELECT, FROM, WHERE, and HAVING Clause
GROUP BYsupportCOUNT(*)aggregationHAVINGclause with conditions- support aggregation functions and case statements in the
GROUP BYandSELECTclause
- exists support
- any and all support
The following SQL statements are supported:
SELECTwith support for*to select all columns- alias support for columns and tables
SELECTstatements withWHEREsupporting:BETWEEN,IN,LIKEoperatorsAND,OR,NOTlogical operators- Comparison operators:
=,!=,<,>,<=,>= - Null checks:
IS NULL,IS NOT NULL
ORDER BYclause with multiple columns andASC/DESCoptions