For the release notes of previous versions, or of other components of Jethro, visit Jethro Product Documentation.

To make sure all your Jethro components are compatible with each other, visit the Product Compatibility Matrix page.

Version 3.4.1

RELEASE DATE: Jan 22, 2018

- Support table move between schemas
- Cubes usage visibility improvements
- Cache query results over cubes
- Important bug fixes

Compatibility

See 3.4.0 release notes

Upgrade Instructions

Upgrade from pre-3.4.0 - see 3.4.0 release notes.

Improvements

JD-4451 Explicity show cubes usage in query plan
JD-5014 Show cubes - add creation time and update time
JD-5457 Create results cache entries for queries over cubes for slow queries
JD-5510 ALTER TABLE RENAME support move between schemas

Bug Fixes

JD-4968 Cubes rebuild is not preserving the cube original tag
JD-5394 Cubes generation stop sending requests following failure in cube check request
JD-5459 Cubes generation stop sending requests following failure to send requests to server
JD-5460 Load from external table mapped to file failed is number of columns GT 512
JD-5477 Query fails on internal error ("could not find the virtual object of the virtual column") due to wrong handle of literal expression
JD-5487 Accuracy - where expression with function on string that contain IS NULL ignores null values in column (function to index optimization issue)
JD-5491 Potential wrong results when filter include CASE and condition expressions in CASE contain AND operator
JD-5513 Select from external table reject numeric values of the format "+12345" (fail to convert value to INT/BIGINT)
JD-5544 CAST on literal within SUM aggregation cause cube not to be matched
JD-5547 Cubes generation stop sending requests following rebuild error caused by race condition
JD-5545 Too big assertion when cube generation reach cube size limit is not working since version 3.3.2
JD-5546 JethroServer failure when NULL from subquery passed as target column of IN
JD-5552 Fix for upgrade tool from pre-3.4.0 releases: correct handling of uppercase passwords and increase wait time for server to start

Version 3.4.0

RELEASE DATE: Dec 25, 2017

- Support multiple schemas.
- Fix environment settings for JAVA to simplfy initial setup 
- Bug fixes

Compatibility

Server version 3.4 is NOT compatible with previous version of ODBC, JDBC and JethroManager. All client components must be upgraded.

Compatible client versions: 

ODBC 3.7
JDBC 3.6
JethroManager 1.5

Upgrade Instructions

Before upgrade: stop all loads and stop JethroLoadsScheduler service (service jethro stop instance-name] loadscheduler)
Confirm the load scheduler event drop folder is empty (ls storage-root-path]/instance-name]/loads/drop)

After upgrade to 3.4 it is mandatory to run upgrade tool over each existing instance.
Usage:
upgradeTo3.4_MultiSchema <instance> <ip/localhost>:<port> -u <user> -p <pass>

This tool create system schema "sys" and move jethro system tables to "sys" schema

New Features

JD-1137 Multiple Schames support
JD-4653 Schema related DDL commands: CREATE SCHEMA, DROP SCHEMA, SHOW SCHEMA, USE

Improvements

JD-5197 CREATE EXTERNAL TABLE to allow setting file format spec (delimiter)
JD-5234 Fix jethro CLASSPATH issues
JD-5267 JethroClient: Allow multiple statements when passing request as argument
JD-4569 Improve environment settings for JAVA to support out of the box range of Hadoop distribution and Hive configurations

Bug Fixes

JD-3653 Query fails due to corrupted cube read with "Error getting unit no by serial no". Occurs when cubes group by uses 128bit CSH Hash
JD-4945 Server failure due to invalid casting of null in INSERT INTO
JD-5019 Query with complex timestamp expression fail with error (cast issue)
JD-5131 Cubes queues status message may show identical status line more then once
JD-5138 Rebuild cubes may not be re-generated following intensive schema changes
JD-5139 Rename of system table is not fully blocked
JD-5235 Cubes are ignored and not recreated following internal exception ("Error getting unit no by serial no")
JD-5239 CREATE EXTERNAL DATA SOURCE doesn't trim with extra space after name appends space to the name
JD-5252 Server failure when INSERT INTO value contains invalid byte sequence ('\0')
JD-5284 INSERT INTO: exception in connector CSV parser due to line > 4K silently causes incomplete load
JD-5286 INSERT INTO: loader incorrectly casts special floating point values: nan, infinite
JD-5351 Server failure following intesive autentication try when calling openldap method
JD-5398 Cube update will fail following rename of table and cube will not be updated
JD-5415 SHOW FULL TABLES is missing in collect statistics
JD-5446 Maint push "Starting Garbage Collector Cycle" message every second

Minor Bug Fixes

JD-5186 Fix message typo for: referenital integrity optimization
JD-5340 Schedule loads log contains repated occurences of the messages "The version was null, therefore will not read the file"