Drill 1.16.1.100-2101 (EEP 7.0.1) Release Notes

The notes below relate specifically to the HPE Ezmeral Data Fabric Distribution for Apache Drill. You may also be interested in the Apache Drill homepage and the Apache Drill release notes:

Version	1.16.1.100
Release Date	January 2021
HPE Version Interoperability	See Component Versions for Released MEPs.
Package Names	Navigate to https://package.ezmeral.hpe.com/releases/MEP/, and select your MEP and OS to view the list of package names.

New in This Release

Drill 1.16.1.100-2101 introduces the following enhancements or HPE platform-specific behavior changes:

None.

Fixes

This HPE release includes the following fixes on the base release:

Commit	Date (YYYY-MM-DD)	Comment
90e5ecb	2021-01-04	MD-6096: Partition pruning not happening after Upgrade and causing OversizedAllocationException failure
94675b6 b898b86	2020-12-15 2020-12-11	MD-6086:CVE-2019-14262: metadata extractor vulnerability fixed
dd051ab	2020-12-11	MD-6084: CVE-2017-12610,CVE-2018-17196: kafka-clients vulnerability (kafka-clients updated to 2.3.1)
f4bf0cb	2020-12-10	MD-6094: WS-2019-0490: jcommander vulnerability
0386778	2020-12-10	MD-6095:CVE-2019-17359: bcprov-jdk15on-1.60.jar library vulnerability
9f0ac5a	2020-12-09	MD-6091: CVE-2017-5929: logback vulnerability
55b4ad0	2020-12-07	MD-6089:CVE-2018-1272 etc. vulnerabilities in Spring
8457e19	2020-11-26	MD-6072: SchemaChangeException due to a REPEATED MAP field
7c6f90e	2020-11-25	MD-6069: updated not equal ComparisonPredicate because of wrong logic inside
228775b	2020-11-17	MD-6070: Fixed problem with NPE in index picking by adding extra checking
c420ba6	2020-11-17	MD-6057: Positional alias is not working in Group by clause for Nested CASE expressions
58047ca	2020-11-13	MD-6066: Changes due to fix performance issue.
fe00ddf	2020-10-29	MD-6073:CVE-2019-10172 and CVE-2019-10202 - jackson-mapper-asl vulnrability

Known Issues

MapR Tracking Number	Description
MD-6052	Prttn_Prnng_TC1.sql.explain test failed.
MD-6028	Property 'MAPR_JMXSSL' in 'env_override.sh' by default set as "false"
MD-6020	Error while using Drill
MD-5792	TPCH query 5 runs 10-20% slower at sf100/sf1000, possibly due to hash join ordering
MD-5786	TPCDS query 98 is 2x slower with Statistics enabled due to hash join order for sf100 and sf1000
MD-5770	TPCH query 9 runs 18% slower at sf 100/sf1000, possibly due to hash join
MD-5758	TPCDS query 78 runs 30x slower with Statistics enabled at sf100
MD-5694	select query takes too long after metadata refresh
MD-5684	Drill timeout when querying a large number of files
MD-5646	Modification needed in Drill dependencies/scripts to support hadoop decoupling
MD-5518	Semi-Join performance is slower with default settings for TPCH 16
MD-5309	Query on complex data fails with SYSTEM ERROR: SchemaChangeException: Failure while materializing expression. Error in expression at index -1. Error: Missing function implementation: [min(MAP-REPEATED)]. Full expression: --UNKNOWN EXPRESSION--.
MD-4906	SI Selectivity Queries hit ForemanException: One more more nodes lost connectivity during query
MD-4738	Incorrect parallelism determination for index plans (SI and Complex SI)
MD-4504	DRILL-6465: Transitive closure is not working in Drill for Join with multiple local conditions
MD-2294	DRILL-1162: 25 way join ended up with OOM

Known Issues and Limitations

Due to Drill version changes (3-digit to 4-digit), you cannot upgrade from Drill in MEP 7.0.0 (Drill 1.16.1) to Drill in MEP 7.0.1 (Drill 1.16.1.5) or later. You must perform a new installation of Drill. Alternatively, if you are running Drill on CentOS or RHEL, you can issue the following command as a workaround to upgrade Drill:
```
rpm -Uv --<old-package> <path/to/packages>/*.rpm
```
See Upgrading Drill.
Older versions of Drill, such as Drill 1.10.0, supported the HBase plug-in, but Drill versions 1.11.0 through 1.16.0.x do not support queries on HBase tables.