Jethro Server Release Notes
Version 3.4.8 | Version 3.4.7 | Version 3.4.6 | Version 3.4.5 | Version 3.4.4 | Version 3.4.3 | Version 3.4.2 | Version 3.4.1 | Version 3.4.0
Version 3.3.0 | Version 3.2.0 | Version 3.1.0 | Version 3.0.0
Version 1.6.0 | Version 1.5.0 | Version 1.4.0 | Version 1.3.0 | Version 1.2.0 | Version 1.1.0
RELEASE DATE: Jul, 2023
Improvements
JD-6443 Improve TRACE message to monitor cubes scenarios
JD-6444 Cubes Generation Optimization
JD-6448 Tableau connector integration - minor compliance fix
Bug Fixes
JD-6010 Composed string function reach size limitations
JD-6092 Server fail to handle corrupted compressed map
JD-6442 Connector load failed due to log4j issue
JD-6447 Server resource manager non-optimal calculation may cause query rejection
RELEASE DATE: Jun, 2022
New Features
JD-6426 Implement SHOW PRIMARY KEY and PK ODBC API
JD-6423 SPLIT function
Improvements
JD-6439 Loader - allow remove profile file and and add schema name to report file name. Set via parameters
JD-6434 Connector: use latest log4j (2.17.0) - mitigation for log4j vulnerability CVE-2021-44228
JD-6419 Handle pass through ODBC syntax at server level via host substitute fie (Tableau 2020.3)
Bug Fixes
JD-6440 Fix scheduled load lock corruption. The scheduled load service stop when encountering lock corruption and some scheduled jobs were not executed
JD-6433 Fix cube generation issue for queries with escaped single quote \('\) inside string literal that failed due to show cubes syntax error. Query sent to show cubes has non-escaped single quote
JD-6432 Fix inconsistent results: when join query has non-standard case expression that return 0 or 1 instead of true/false
JD-6427 Fix wrong result: day function over trunk function return wrong value
JD-6425 Fix case were count distinct query internally fails but keeps running in a loop filling logs with error message
JD-6422 Minor fix for JethroAdmin collect logs - correct handling of symbolic links in log folders
JD-6421 Fix nested Case When with internal Boolean expression that return numeric value (0 or 1) fails with "Double conversion for result of Case-When clause was requested"
JD-6420 Fix wrong results: group by show -1 values in more than one group following issue with fix JD-6386 in version 3.6.1
JD-6418 Fix server core - case with string range condition
- Cubes cleanup by usage important improvements
- Support Tableau 2020.3
- Important bug fixes
RELEASE DATE: May, 2021
New Features
JD-6409 Support Having expression with non-aggregate group by expression (Tableau 2020.3)
JD-6410 Support function over group by expression in target list. Currently fails with: "Expression not in GROUP BY key" (Tableau 2020.3)
Improvements
JD-6398 Cubes cleanup by usage to drop unused rebuild cubes - cubes rebuild/update to keep cubes creation date
JD-6404 Notify in log on rows duplication in join
JD-6414 Support centos/rhel 8 - handle libgcrupt.so.11
JD-6416 Support Boolean expression that return numeric value (1 or 0) instead of true/false (Tableau 2020.3)
Bug Fixes
JD-6391 Server terminated when deleting from local cache
JD-6392 Server core - left join and complex if expression in where referencing to right table (outer to inner join optimization issue)
JD-6394 Bad decimal values fetch from Parquet via connector for high precision decimal column (38,10)
JD-6395 Repeated input stream error messages in log due to invalid adaptive entries causing server memory to inflate until server is killed
JD-6399 Cubes/adaptive usage info may be incomplete/inaccurate in some cases (new usage info is ignored)
JD-6400 Flatten query cause segmentation fault
JD-6401 Wrong value loaded to table when input data contains very long text (>4096) + 4096 max string size no imposed when using default (simple) tokenizer
JD-6402 Wrong results: join is wrongly removed by optimizer
JD-6408 Query with IN expression inside GB function fails with "expression is not in GROUP BY" error (Tableau 2020.3)
JD-6412 Join of sub-query with join key being literal fails with request execution failed (Join column wasn't found in left table) (Tableau 2020.3)
JD-6415 Group by on curdate() fails (Tableau 2020.3)
JD-6417 Aggregation query with having count(1)>1 and cross join returns large results set - should return single line (Tableau 2020.3)
RELEASE DATE: Aug, 2020
Improvements
JD-6379 Jethro folders and files permissions tightening
JD-6381 Add GPG key to rpm
JD-6383 Support query text substitute (beta)
JD-6385 Cube maintenance: monitor adaptive entries usage and auto drop unused cubes and cache entries
Bug Fixes
JD-6351 Reset keys initial hash default
JD-6371 Server failure caused by query with cross join
JD-6372 Multiple "cancel event initiated" and "reached limit event" in log. Issue with query cancellation
JD-6373 Possible wrong result when flatten optimization applied on left join and right table is a sub-query with join (following 3.6 JD-6355)
JD-6374 Server failure on show cube query following duplicate alias error when query contains special characters
JD-6375 Concurrent loads fail due to lock issue - exception raised while trying to unlock lock
JD-6378 Parquet file read failed with: libsnappyjava.so: failed to map segment from shared object
JD-6386 Duplicated rows fetched on select * from join in a specific scenario
JD-6388 Possible wrong results when flatten optimization applied on join of multi table sub-query (following 3.6 JD-6355)
JD-6389 Query fails when filter comparing timestamp to date before 1/1/1970