Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 3 Current »

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

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"


  • No labels