Release Notes

HP Vertica

Software Version: 7.1.x

 

Updated: August 9, 2016

 

About HP Vertica Release Notes

HP Vertica 7.1.2-20: Resolved Issues

HP Vertica 7.1.2-19: Resolved Issues

HP Vertica 7.1.2-18: Resolved Issues

HP Vertica 7.1.2-17: Resolved Issues

HP Vertica 7.1.2-16: Resolved Issues

HP Vertica 7.1.2-15: Resolved Issues

HP Vertica 7.1.2-14: Resolved Issues

HP Vertica 7.1.2-13: Resolved Issues

HP Vertica 7.1.2-12: Resolved Issues

HP Vertica 7.1.2-11: Resolved Issues

HP Vertica 7.1.2-10: Resolved Issues

HP Vertica 7.1.2-9: Resolved Issues

HP Vertica 7.1.2-8: Resolved Issues

HP Vertica 7.1.2-7: Resolved Issues

HP Vertica 7.1.2-6: Resolved Issues

HP Vertica 7.1.2-5: Resolved Issues

HP Vertica 7.1.2-4: Resolved Issues

HP Vertica 7.1.2-3: Resolved Issues

HP Vertica 7.1.2-2: Resolved Issues

HP Vertica 7.1.2-1: Resolved Issues

HP Vertica 7.1.2: New Features and Resolved Issues

HP Vertica 7.1.1-12: Resolved Issues

HP Vertica 7.1.1-11: Resolved Issues

HP Vertica 7.1.1-10: Resolved Issues

HP Vertica 7.1.1-9: Resolved Issues

HP Vertica 7.1.1-8: Resolved Issues

HP Vertica 7.1.1-7: Resolved Issues

HP Vertica 7.1.1-6: Resolved Issues

HP Vertica 7.1.1-5: Resolved Issues

HP Vertica 7.1.1-4: Resolved Issues

HP Vertica 7.1.1-3: Resolved Issues

HP Vertica 7.1.1-2: Resolved Issues

HP Vertica 7.1.1-1: Resolved Issues

HP Vertica 7.1.1: New Features and Resolved Issues

HP Vertica 7.1.0-4: Resolved Issues

HP Vertica 7.1.0-3: Resolved Issues

HP Vertica 7.1.0-2: Resolved Issues

HP Vertica 7.1.0-1: Resolved Issues

HP Vertica 7.1.0: New Features and Resolved Issues

HP Vertica 7.1.x: Known Issues

 

About HP Vertica Release Notes

The Release Notes contain the latest information on new features, changes, fixes, and known issues in HP Vertica 7.1.x.

They also contain information about issues resolved in:

Downloading Major and Minor Releases, and Service Packs

The Enterprise Edition of HP Vertica is available for download at my.vertica.com.

The Community Edition of HP Vertica is available for download at the following sites:

The documentation is available at http://my.vertica.com/docs/7.1.x/HTML/index.htm.

Downloading Hotfixes

Unless otherwise indicated, hotfixes are made available via the customer FTP site. Hotfixes are available to Enterprise Edition customers only.

To download a hotfix, Premium Edition customers can access the ftp site using the credentials available in the HP Vertica Hotfix release notice email.

On rare occasions, HP Vertica replaces the software on the my .vertica.com/downloads site with a particular hotfix. Refer to these Release Notes to learn where you can access a particular hotfix.

HP Vertica 7.1.2-20: Resolved Issues

Release Date: 8/9/2016

Issue

Component

Description

VER-48058 Data load / COPY Vertica did not clean up the empty rejected row files that COPY statements created. This issue has been resolved.
VER-47358 Data load / COPY For apportioned loads from HDFS Connector, input_file_size and parse_complete_percentage in table load_streams contained incorrect values. This issue has been resolved.
VER-48059 Execution Engine Enabling parallelism in DataTarget processing caused projections to lose rows and caused mismatched row counts for projections. Previously, the workaround for this issue was to disable DataTargetParallelism. This issue has been resolved.
VER-47516 Hadoop hcatUtil failed to copy jar files if the path name contained “test” or “source”. This issue has been resolved.
VER-47617 Optimizer During serialization, input strings could exceed the 2G size limit and cause the database to fail. With this fix, Vertica splits a large input string into 2G strings, then concatenates them into a single string after deserialization.
VER-48086 ResourceManager In some circumstances, Vertica continually allocated unused virtual memory, which slowed performance. This issue has been resolved.

HP Vertica 7.1.2-19: Resolved Issues

Release Date: 6/15/2016

Issue

Component

Description

VER-46240 Catalog Engine, DDL Previously, Vertica took an exclusive global catalog lock while running a CREATE LOCAL TEMPORARY VIEW statement, which could slow performance. This issue has been resolved.
VER-46484 Catalog Engine, DDL Previously, Vertica took an exclusive global catalog lock while running a CREATE SCHEMA statement, even if the schema already existed. To improve performance, Vertica no longer takes the lock if the schema already exists.

HP Vertica 7.1.2-18: Resolved Issues

Release Date: 5/31/2016

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-45523 Optimizer Previously, delete optimization caused intermittent violations in data integrity. This issue occurred when the query c ontained analytic functions and the result was not sorted on all result expressions. This fix addresses this issue by disabling delete optimization in these situations.

HP Vertica 7.1.2-17: Resolved Issues

Release Date: 4/29/2016

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-45271 Execution Engine, ResourceManager If a query’s join predicate order and column sort order were not the same in a projection, the query could produce wrong results when join spill occurred. This issue has been resolved.
VER-45233 Client Drivers - JDBC Previously, the values of TIMESTAMPTZ columns returned by the JDBC driver could be incorrect if the timezone specified in a query was different from the Vertica server's timezone. This issue has been resolved.
VER-45187 Tuple Mover Previously, the configuration parameter MergeOutCache had to be re-enabled after a node restarted. With this fix, MergeOutCache is enabled by default.

HP Vertica 7.1.2-16: Resolved Issues

Release Date: 4/7/2016

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-44665 Client Drivers - JDBC Attempting to cancel a JDBC statement sometimes did not work during long query planning phases. This fix allows current JDBC statements to be canceled earlier.
VER-44761 Database Designer Core If a table had multiple unsegmented projections with unique definitions, rebalancing the cluster after adding new nodes caused only one of the projections to be replicated on the new nodes. The other unsegmented projections were ignored. Now, rebalance operations replicate all unique unsegmented projections across all nodes.
VER-44807 DDL - Projection After upgrading from Vertica 5.x to 7.x, Vertica could incorrectly generate errors instead of an informational message if you attempted to create an existing projection using CREATE PROJECTION IF NOT EXISTS. This issue has been resolved.
VER-44863 ResourceManager In some cases, running a query against a resource pool with CPUAFFINITYSET specified generated a warning message. This issue has been resolved.

HP Vertica 7.1.2-15: Resolved Issues

Release Date: 3/8/2016

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-44330 DDL In some cases, if a user connected to a database and then dbadmin dropped that user, the user could still continue using indirect privileges if the session persisted and roles remained the same. If the user attempted to create an object, the server could fail. This issue has been resolved.
VER-43663 Hadoop Previously, Vertica could not correctly read specific ORC files using COPY. An Apache update to the ORC Reader API resolves this issue: https://issues.apache.org/jira/browse/ORC-24 With this fix, Vertica uses the latest version of the ORC Reader API.
VER-43697 ResourceManager Queries selecting from rejected-data tables often requested too much memory and impacted performance, even if the tables were empty. This fix reduces the width of the rejected_data column. This may truncate results in your existing queries. If so, use ALTER COLUMN to extend the width of the rejected_data column.

HP Vertica 7.1.2-14: Resolved Issues

Release Date: 2/8/2016

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-43738 Execution Engine, Optimizer Using IN lists with constant NUMERIC expressions (such as date_part) within CREATE TABLE AS SELECT sometimes caused core dump under certain circumstances. This issue has been resolved.

HP Vertica 7.1.2-13: Resolved Issues

Release Date: 2/2/2016

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-43662 Client Drivers - JDBC Previously, when using the JDBC driver, a compound statement that included a COPY LOCAL statement resulted in a server core dump. The JDBC driver no longer allows compound statements which include COPY LOCAL to be sent to the server. Instead, those statements throw an exception that is caught by the user's application. Additionally, users who upgrade their server version, but continue using a previously-released version of the JDBC driver, do not incur a core dump when executing this type of compound statement.
VER-43559 FlexTable Certain flex table functions, such as FDelimitedParser, were able to access invalid memory regions in some cases. This could cause the node to fail. This issue has been resolved.
VER-43608 ResourceManager Reducing MAXMEMORYSIZE or MAXCONCURRENCY of a pool while cascading was enabled could cause queries to fail due to insufficient resources, and in some cases caused the cluster to fail. This issue has been resolved.
VER-43561 SDK Previously, some UDx side processes did not close and instead remained as defunct processes. This issue has been resolved.

HP Vertica 7.1.2-12: Resolved Issues

Release Date: 1/28/2016

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-42345 Execution Engine In rare cases, an issue with network multiplexing resulted in segmentation fault errors that caused node failure. This issue has been resolved. If you disabled network multiplexing as a workaround, enable it after upgrading to this fix.
VER-43251 Data load / COPY If an exception was thrown during COPY LOCAL, a built-in filter attempting to allocate memory when COPY LOCAL re-ran the load stack could cause segfault under certain circumstances. This issue has been resolved.
VER-43382 Optimizer Internal errors sometimes occurred if queries with multi-level aggregates (MLAs) had HAVING clauses containing both grouping functions and complex GROUP BY expressions. This issue has been resolved.

HP Vertica 7.1.2-11: Resolved Issues

Release Date: 12/15/2015

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-42434 Hadoop Occasionally, when copying data from Hadoop with the HDFS Connector, the copy query would hang and you could not terminate the query with CLOSE_SESSION(). This issue has been resolved.
VER-41970 Hadoop When creating a shared storage location for an external HDFS table, Vertica appended a node name sub-directory to this location. This has been fixed.
VER-42934 Security When loading data using the HDFS Connector, the load could fail if the username parameter was different from the cached principal. Vertica now ignores the username parameter in Kerberos authentication.
VER-42463 Recovery Vertica would sometimes perform an incremental recovery rather than a recovery by container for a node performing a complete recovery. This issue has been resolved.

HP Vertica 7.1.2-10: Resolved Issues

Release Date: 11/19/2015

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-42175 Optimizer, Security Previously, MERGE or COPY could not be performed on a table column that contained an Access Policy. You can now perform MERGE or COPY on a column if the enabled access policy allows you to access all the data in the column.
VER-42226 Data load / COPY, Hadoop Copying through the HDFS Connector sometimes failed with error 3399 if a wildcard was used and the location contained empty files. This failure no longer occurs.

HP Vertica 7.1.2-9: Resolved Issues

Release Date: 11/2/2015

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-42138 UDX External procedures that wrote over 255 characters to standard output and returned a nonzero exit code caused the UDx zygote process to fail. This issue has been resolved.

HP Vertica 7.1.2-8: Resolved Issues

Release Date: 10/23/2015

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-41752 Catalog Engine An assertion occurred if a historical query was run at a time that did not fall in the epoch range. The assert has been changed into an error.
VER-40976 Hadoop

Previously, the HDFS connector redundantly requested the status of files on HDFS on every node. This could affect performance and cause timeout errors when the source contained a large number of files. This issue has been resolved. The HDFS connector now requests file status once per file.

HP Vertica 7.1.2-7: Resolved Issues

Release Date: 10/6/2015

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-41364 Basics

The HP Vertica server node allowed the client to make an SSL connection before the server node initialization completed. In some cases, the premature connection could cause the server to fail. This issue has been resolved.

HP Vertica 7.1.2-6: Resolved Issues

Release Date: 9/24/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-40931, VER-41418 Catalog Engine, Tuple Mover

When a large number of projections were eligible for mergeout, Tuple Mover was sometimes slow to pick a mergeout job. This hotfix introduces a new configuration parameter, MergeoutCache, to resolve this issue. Enable MergeoutCache to take advantage of this fix.

Example:

ALTER DATABASE exampledb SET MergeoutCache = 1;

VER-40533 Hadoop, Security ANALYZE_EXTERNAL_ROW_COUNT sometimes did not run in a Kerberos environments. This issue has been resolved.
VER-40326 UI - Management Console In previous versions, upgrading Management Console (MC) on an HP Vertica host required stopping the database if MC was installed on an Ubuntu or Debian platform. You will still need to stop the database to complete this upgrade to hotfix 7.1.2-6 on these platforms. MC upgrades from version 7.1.2-6 and future versions will no longer require stopping the database.

HP Vertica 7.1.2-5: Resolved Issues

Release Date: 9/1/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-40905, VER-40908 Execution Engine Previously, certain queries took an extremely long time to cancel. This issue has been resolved.
VER-38291 Optimizer - LAP Creating live aggregate projections containing columns with unusual names, such as timestamp, previously failed with an error. This issue has been resolved.
VER-40902 SDK Previously, calling external procedures sometimes caused nodes to hang when forking from the main HP Vertica process. With this fix, external procedures are now executed by forking the program from the zygote process.
VER-40901 Security In HP Vertica versions 7.1.x and up, SSL authentication sometimes failed due to incorrect handling of certificate chains. This issue has been resolved.

HP Vertica 7.1.2-4: Resolved Issues

Release Date: 8/11/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-39153 Execution Engine Operating in low free-memory conditions could sometimes cause a node to fail. With this hotfix, the conditions that caused failure are detected and the query is aborted.
VER-40448 Hadoop If a COPY statement using the HDFS Connector includes multiple URLs with at least one URL that contains 0 files, the query fails. In this case, the HDFS connector previously returned a ‘No files match’ error with the entire URL set. The error message has been improved to indicate the exact URL that causes this failure.
VER-40386 Optimizer When an access policy was enabled on a table, dbadmin users sometimes received suboptimal query plans for INSERT... SELECT statements on that table. This issue has been resolved.

HP Vertica 7.1.2-3: Resolved Issues

Release Date: 8/3/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-40023 Client Drivers - VSQL This hotfix improves performance of \d in vsql for databases with large catalogs.
VER-40393 Database Designer Core Users granted the pseudosuperuser role could not run Database Designer. This issue has been resolved.
VER-39674 Hadoop Previously, the HCatalog connector could not support Hive versions 0.14 and higher. This issue has been resolved.
VER-40274 Hadoop Copying a table using the HP Vertica Connector for HDFS sometimes returned a “File does not exist” error if the URL contained wildcards that were not at the bottom of the directory hierarchy. For example: http://host:50070/webhdfs/v1/foo/*/bar/*.txt. This issue has been resolved.
VER-40239 Optimizer Analytic functions sometimes returned different results depending on whether multilevelnetworkroutingfactor was enabled. This issue has been resolved.
VER-39530 Security The version of Python shipped with the HP Vertica RPM has been updated from Python release 2.7.0 to release 2.7.10, which includes fixes for Common Vulnerabilities and Exposures (CVEs). See the following link for the Python release notes: https://hg.python.org/cpython/raw-file/15c95b7d81dc/Misc/NEWS
VER-40174 Security With this hotfix, the HP Vertica server no longer supports SSLv3 for TLS communication between client and server.
VER-40187 Security, UI - Management Console With this hotfix, the Java Runtime Environment shipped with HP Vertica Management Console has been updated from JRE 1.7.0_51 to JRE 1.7.0_80.
VER-40198 Security In this hotfix, RC4 ciphers are disabled by default in TLS configuration. A new configuration parameter, EnabledCipherSuites, has been added, which allows you to set what cipher-suites the server supports for TLS.

HP Vertica 7.1.2-2: Resolved Issues

Release Date: 7/8/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-39484 Client Drivers - JDBC The HP Vertica 7.1 server sometimes had an issue responding to the HP Vertica 4.1 JDBC driver’s batch insert protocol, causing the server to fail. This issue has been resolved.
VER-39515 Client Drivers - JDBC The JDBC driver encountered a deadlock caused by closing a connection when reading table metadata. This issue has been resolved.
VER-39671 Client Drivers - ODBC The ODBC driver on Mac OS X sometimes returned an error if an application passed inaccurate length values for null-terminated strings to SQLTables(). This issue has been resolved.
VER-39709 Client Drivers - JDBC The JDBC driver encountered a deadlock caused by closing a connection when reading table metadata. This issue has been resolved.
VER-39650 Optimizer If a meta-function was incorrectly used in a query with a set operator, it was not rejected, causing the cluster to fail. This issue has been resolved.
VER-39104 SDK When vt_creatFuncObject instantiated a UDL object, a destructor for the object was not always called. This issue has been resolved. After you implement this upgrade, remove workarounds in UDx code that explicitly invoke object destructors.

HP Vertica 7.1.2-1: Resolved Issues

Release Date: 6/23/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-39361 Recovery Node recovery was sometimes slow on databases that had undergone many move partition operations. This hotfix resolves the issue and improves the efficiency of event pruning.
VER-39069 UI - Management Console Management Console previously performed continuous license audits, which could negatively affect performance of other queries. This issue has been resolved.
VER-39314 Optimizer - Statistics and Histogram Previously, running IMPORT_STATISTICS and EXPORT_STATISTICS functions could fail when tables contained user defined data types. With this hotfix, these functions ignore columns with user defined data types.

HP Vertica 7.1.2: New Features and Resolved Issues

Release Date: 6/13/2015

The list below describes some of the new features introduced in HP Vertica 7.1.2. To see a complete list of additions and changes introduced in this release, refer to the HP Vertica 7.1.x New Features Guide.

HP Vertica 7.1.2: Resolved Issues

Issue

Component

Description

VER-35678

Backup/DR

If external password files were used for backup or restore, the administrator had to copy the password files manually to all database nodes and backup hosts. With this fix, the vbr.py utility copies the password files automatically.

VER-36999

Backup/DR

In vbr.py, "ulimit -u" produced an error if unlimited was provided. This issue has been resolved.

VER-37529

Client Drivers - JDBC

Previously, using the display_license meta-function through a JDBC connection returned NULL. This issue has been resolved.

VER-35923

DDL

When grouping functions were aliased (for example: "grouping(c) as g1") they were not recognized as functions on aggregated data and were pushed down below aggregation, causing the HP Vertica server to fail. This issue has been resolved.

VER-36712

DDL

In some cases, the CREATE statement did not work when a cast operator was used. This issue has been resolved.

VER-35976

Error Handling

Previously, if you used the export_statistics function to export the table statistics of a table with no defined projection, subsequently trying to import statistics by performing an import_statistics would fail with an error message. This issue has been resolved.

VER-36189

Execution Engine

Running the COUNT(DISTINCT) function negatively affected the performance of the APPROXIMATE_COUNT_DISTINCT function. This issue has been resolved.

VER-37704

Execution Engine

Internal tables incorrectly handled certain combinations of permissions and objects, which in rare scenarios caused node failure. This issue has been resolved.

VER-35517

Front end - Parse and Analyze

When using a fixed-length binary as a data type, queries were sometimes slow if an IN clause was used within the HEX_TO_BINARY function. This issue has been resolved.
VER-38987, VER-38985 Front end - Parse & Analyze When outer queries referenced subqueries with constant columns and aggregation, outer query predicates that included those constant columns sometimes were applied incorrectly to the subqueries' aggregations. This issue has been resolved.

VER-36668

Hadoop

Copying an empty data file from HDFS produced the following error message, "ERROR 5118: UDL specified no execution nodes." This issue has been resolved, and now behaves the same way as copying from other empty files.

VER-36694

Installation Program

Previously, running 'sudo install_vertica' when sudo required a password could result in an installation failure. This issue occurred only when remote hosts required password authentication for sudo. This issue has been resolved.

VER-36845

Installation Program

The installer failed when network interfaces had the same name but different IP addresses. This issue has been resolved.

VER-35947

Monitoring

If users made changes to Data Collector policies in HP Vertica versions 7.0.1 through 7.1, any policy settings existing prior to those changes were lost when nodes were restarted. This issue has been resolved.

VER-36142

Optimizer

Enclosing a TIMESERIES clause within a WITH clause caused an error. This problem has been resolved.

VER-36274

Optimizer

Queries using a large number of COUNT(DISTINCT) functions could not be completed. This issue has been resolved.

VER-36368

Optimizer

A query with multiple RANGE clauses that operated on different data types returned an error. This issue has been resolved.

VER-36541

Optimizer

Queries ran slowly when an empty table (with zero rows) was set as the outer table in a join. This issue has been resolved so the empty table is set as the inner table in the join.

VER-36682

Optimizer

CREATE statements with a CAST operator sometimes did not work. This issue has been resolved.

VER-36687

Optimizer

When HP Vertica performed a hash join using a dual projection as the outer join input, the query sometimes failed due to insufficient memory for the inner join input. This issue has been resolved.

VER-36913

Optimizer

Running ANALYZE_HISTOGRAM with a percentage less than 100 returned 0 (success) but the query plan description lacked statistics. This issue has been resolved.
VER-38703 Optimizer In certain cases, NOT NULL constraints were not respected when subqueries were used to update a table. This issue has been resolved.

VER-37221

Procedural Languages

When a non-superuser ran an external procedure, one of the following warnings appeared: - WARNING 6513: Could not retrieve superuser flag for procedure - WARNING VX001/6513: Could not retrieve superuser flag for procedure. This issue has been resolved.

VER-36144

SDK

Using a User Defined Aggregate in a statement containing a GROUP BY clause may impact the performance of the aggregate function. This performance impact is caused by HP Vertica passing the function one row of data per call. This release adds a special integer parameter named _minimizeCallCount that your UDA can declare to force HP Vertica to batch several rows together before calling your UDA. This parameter can increase performance in cases where the overhead of invoking your UDA is greater than the overhead of having HP Vertica batch the rows together. However, always test the performance of your UDA if you choose to add this parameter to ensure the performance has improved. See "UDA Performance in Statements Containing a GROUP BY Clause" in the Extending HP Vertica guide for detailed information.

VER-36885

SDK

In some cases, calling a fenced-mode UDx within a CASE statement could cause HP Vertica to exit with an error message. This issue has been resolved.

VER-35479

SDK-Java

The HP Vertica Java SDK could, in some situations, fail to properly rotate the Java UDx log files. This situation has been resolved.

VER-36033

SDK-Java

In Release 7.1.1, the buffer moving data between Java UDLs would sometimes incorrectly copy data by adding additional bytes onto the end of the buffer. This behavior could result in incorrect parsing of some values. This behavior was casued by a data type conversion issue and has been fixed.

VER-35915

SDK-R

Previously, queries sometimes hung indefinitely when an R process failed. With this fix, queries terminate with an error.

VER-36710

Transactions

A DROP_PARTITION operation is expected to interrupt or cancel a conflicting MERGEOUT operation. In some instances the MERGEOUT operation does not cancel and the DROP_PARTITION times out waiting for a table lock. Furthermore, a race condition in error reporting can sometimes result in a CANCEL error message being returned instead of the expected LOCK TIMEOUT error message. This issue has been resolved.

VER-35486

Tuple Mover

The MOVE_PARTITIONS_TO_TABLE and SWAP_PARTITIONS_BETWEEN_TABLES functions previously performed a moveout operation on all the data in the WOS, which sometimes caused errors in busy databases. This issue has been resolved.

VER-37144

Tuple Mover

The epoch management process sometimes caused very long exclusive locks. The lock time has now been reduced.

VER-38013

UI-Agent

The version of Python shipped with HP Vertica in this release has been updated to link against OpenSSL v0.9.8za to coincide with the version used by HP Vertica.

 

HP Vertica 7.1.1-12: Resolved Issues

Release Date: 5/5/2015

Updated: 5/7/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

This hotfix has been updated to include VER-38586, VER-38589, and VER-38593.

Issue

Component

Description

VER-38422 Admin Tools, Database Designer Core This fix resolves an issue with how Database Designer (DBD) in admintools used the global catalog lock. As a result, the output file schema_dump.xml has been removed. The information it contained can be found in catalog_dump.sql.
VER-35682 Client Drivers - JDBC When connected using the HP Vertica JDBC driver, a TCP deadlock sometimes caused COPY LOCAL statements to hang while handling exceptions. This issue has been resolved.
VER-37230 Communications/messaging, Execution Engine A race condition when implementing the UNION operator could occasionally cause the operator to hang at the end of executing the query. This issue is resolved.
VER-38988 Documentation, Execution Engine, Optimizer, Query Generator CASE statement queries could sometimes return incorrect results. This issue has been resolved.
VER-38466 Execution Engine HP Vertica sometimes took an extremely long time to parse complicated nested scalar expressions. This fix improves performance when parsing certain types of scalar expressions.
VER-38586 Hadoop When copying though a secured HDFS connector from Kerberos HDFS, repeatedly running queries within a short amount of time could sometimes result in a concurrency issue that caused HP Vertica to reject rows. This issue has been resolved.
VER-38589 Hadoop When copying an empty file from the HDFS connector, HP Vertica returned an error. With this fix, copying empty files now returns 0 rows instead of an error.
VER-38593 Hadoop Previously, the HP Vertica HDFS connector did not escape special characters in usernames for WebHDFS. This resulted in malformed URLs. With this fix, reserved characters are converted to percent-encoded characters.
VER-38240 Resource Manager When a query cascaded from one resource pool to another, queued queries in the source pool were not subsequently granted resources. This issue has been resolved.
VER-31047 Security LDAP parameters with special characters were sometimes incorrectly parsed, causing the server to fail. This issue has been resolved.

HP Vertica 7.1.1-11: Resolved Issues

Release Date: 4/24/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-38009 Basics Concurrent ALTER PROJECTION and DROP TABLE CASCADE statements sometimes caused nodes to panic. This issue has been resolved.
VER-37625 Execution Engine, Optimizer During planning of ANALYZE_STATISTICS, excessive memory usage sometimes caused nodes to fail. With this fix, peak memory usage in this case has been reduced substantially.

 

HP Vertica 7.1.1-10: Resolved Issues

Release Date: 3/24/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-26624 Communications/messaging This fix improves HP Vertica's estimate of the number of entries that can fit into a network buffer. Because of this improved estimate, turning on network compression, which is off by default, can significantly reduce network consumption.
VER-37320 DDL - Projection When multiple CREATE PROJECTION statements with the "/*+createtype(L)*/" hint were issued simultaneously, both statements created projections with the same name, resulting in duplicate projections. This issue has been resolved.
VER-37705 Execution Engine Internal tables incorrectly handled certain combinations of permissions and objects, which in rare scenarios caused node failure. This issue has been resolved.
VER-37139 Error Handling HP Vertica 7.1.1-6 and 7.1.1-7 sometimes incorrectly logged failure errors. This issue has been resolved.

 

HP Vertica 7.1.1-9: Resolved Issues

Release Date: 3/3/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-37000 Backup/DR In vbr.py, "ulimit -u" produced an error if unlimited was provided. This issue has been resolved.
VER-37017 Backup/DR When running copycluster on a remote cluster of nodes vbr.py was not copied to the node's remote temporary directory and resulted in an error. This issue has been resolved.
VER-37105 DDL In some cases, the CREATE statement did not work when a cast operator was used. This issue has been resolved.
VER-37143 Tuple Mover The epoch management process sometimes caused very long exclusive locks. With this hotfix, the lock time is reduced.
VER-36699 Procedural Languages In HP Vertica 7.1.0 and above, when non-superusers ran external procedures, a warning was sometimes thrown. This issue has been resolved.

HP Vertica 7.1.1-8: Resolved Issues

Release Date: 2/17/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-36200 Backup/DR When performing a backup on a database with a large catalog the backup requested a buffer size that caused the backup to fail. This issue has been resolved.
VER-36876 Error Handling HP Vertica 7.1.1-6 and 7.1.1-7 sometimes incorrectly logged failure errors. This issue has been resolved.
VER-36877 Optimizer In databases with more than 4 billion rows in a table, ANALYZE_HISTOGRAM sometimes updated columns with no statistics. This issue has been resolved.

 

HP Vertica 7.1.1-7: Resolved Issues

Release Date: 2/10/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-36664, VER-36684 AP-Geospatial Previously, when processing queries with multiple ST_Intersects predicates, queries would require large amounts of memory to run, and would intermittently bring the database down. This issue has been resolved.
VER-36503 Data load / COPY In certain situations, queries that perform merge joins did not return correct results. This issue has been resolved.

VER-36708

Transactions

In some instances, a DROP_PARTITION operation did not successfully cancel a conflicting MERGEOUT operation, and the DROP_PARTITION timed out waiting for a table lock. Additionally, incorrect TIMEOUT error messages sometimes occurred when the server was actually successful in canceling the MERGEOUT operation. This issue has been resolved.
 

HP Vertica 7.1.1-6: Resolved Issues

Release Date: 1/21/2015

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-36039 Backup/DR Preparing HP Vertica nodes for backup took longer in proportion to the number of nodes in the cluster. This has been resolved by preparing nodes for backup in parallel.

VER-35861

DDL

When grouping functions were aliased (for example: "grouping(c) as g1") they were not recognized as functions on aggregated data and were pushed down below aggregation, causing the HP Vertica server to fail. This issue has been resolved.
VER-35975 Error Handling If the EXPORT_STATISTICS function was used to export table statistics of a table without a super projection, importing those statistics failed with an error message. With this fix, the EXPORT_STATISTICS function no longer exports statistics of tables that do not have super projections.
VER-36099 Execution Engine Nodes sometimes failed if the HP Vertica server encountered a corrupted ROS file, and produced a PANIC error. With this fix, HP Vertica produces an INTERNAL error, and node failure is prevented.
VER-36191 Execution Engine Running the COUNT(DISTINCT) function negatively affected the performance of the APPROXIMATE_COUNT_DISTINCT function. This issue has been resolved.
VER-36092 Front end - Parse & Analyze When using a fixed-length binary as a data type, queries were sometimes slow if an IN clause was used within the HEX_TO_BINARY function. This issue has been resolved.

HP Vertica 7.1.1-5: Resolved Issues

Release Date: 1/22/2015

The 7.1.1-5 hotfix is a hotfix for the R_lang pack only and provides support for HP Vertica Distributed R. The 7.1.1-5 R_lang hotfix is available on the HP Vertica Distributed R downloads page.

 

HP Vertica 7.1.1-4: Resolved Issues

Release Date: 12/18/2014

This hotfix addresses the issue that appears below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-36009

Client Drivers - ODBC

Previously, when WindowsAuthentication was set to True, the ODBC driver incorrectly encoded the username passed to the server. This resulted in an authentication failure. This issue has been resolved.

HP Vertica 7.1.1-3: Resolved Issues

Release Date: 12/9/2014

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-35844

Backup/DR

Previously, restoring an object-level backup while invoking another storage-related operation could, in rare circumstances, cause the loss of a restored file. This issue has been resolved.

VER-35684

Client Drivers - JDBC

Previously, the HDFS UDSource could not be used from a JDBC client when HDFS and Vertica were both configured to authenticate with kerberos because JDBC did not request forwardable kerberos tickets. The issue has been fixed.
VER-35925 Communications/messaging If a node left a cluster due to a network connectivity issue and went into a DOWN state, other nodes and admintools incorrectly saw it in SHUTDOWN state. This prevented restarting the node from admintools. This issue has been resolved.
VER-35924 Data load / COPY Bulk loading data using the COPY command sometimes resulted in sequence exceeded max value error. This issue has been resolved.
VER-35549 Execution Engine An error that caused analytic functions to return different results depending on whether multilevelnetworkroutingfactor enabled multilevel networking or not has been resolved.
VER-35933 Monitoring If users made changes to Data Collector policies in HP Vertica versions 7.0.1 through 7.1, any policy settings existing prior to those changes were lost when nodes were restarted. This issue has been resolved.
VER-35690 SDK-R Previously, queries sometimes hung indefinitely when an R process failed. With this fix, queries terminate with an error.
VER-35834 Storage and Access Layer Hadoop In some cases, HDFS under heavy load takes a long time to respond to HTTP requests, which is indistinguishable from a hung request. A new configuration parameter, HadoopFSStalledConnectionTimeout, has been added. This parameter sets the maximum number of seconds to wait, without progress, for a response from HDFS before timing out. The default is 60 seconds.
VER-35836 Hadoop When reading from large data sets in HDFS storage, the query could hang if HDFS incorrectly finished the HTTP request before the end of file was reached. This issue has been resolved.

HP Vertica 7.1.1-2: Resolved Issues

Release Date: 11/25/2014

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-35818

Client Drivers - ADO

Previously, attempting to use connection pooling with SSL enabled resulted in an error when a pooled connection was selected. This problem has been corrected.

VER-35513

SDK

Previously, some user defined extensions running in fenced mode could sometimes cause the server to fail. This issue has been resolved.

VER-35419

Security

The HP Vertica server has updated to the OpenSSL library version 0.9.8za.

HP Vertica 7.1.1: New Features and Resolved Issues

Release Date: 10/29/2014

The list below describes some of the new features introduced in HP Vertica 7.1.1. To see a complete list of additions and changes introduced in this release, refer to the HP Vertica 7.1.x New Features Guide.

 

HP Vertica 7.1.1: Resolved Issues

Issue

Component

Description

VER-31024

Security Backup/DR

Previously, vbr.py left rsyncd running without authentication. This issue has been resolved.

VER-32576

Backup/DR

In a database with a large number of storage containers, the garbage collection stage after a backup was sometimes very slow. This issue has been resolved.

VER-33305

Backup/DR

During a lengthy backup run, the SSH sessions between the parent vbr process and its children on other nodes was sometimes disconnected due to inactivity. In version 7.1.1, the ServerAliveInterval is set to 60 seconds for these sessions.

VER-33557

Backup/DR

When copying a database between HP Vertica 7.x clusters using the vbr.py utility, the spread configuration was overwritten, sometimes leaving the target database unusable. This issue has been resolved.

VER-27479

Catalog Engine

Previously, some DDL statements, such as CREATE TABLE and DROP TABLE, were incorrectly reported as node state changes in the Management Console message center. This issue has been resolved.

VER-33026

Client Drivers - JDBC

The unused date portion of a java.sql.Time object returned by the driver during ResultSet.getTime (int, Calendar) was sometimes incorrect, This occurred in situations when the application requested the driver to convert the time into a timezone different than the JVM timezone.

VER-34370

Client Drivers - JDBC

Previously, a deadlock in the JDBC driver sometimes occurred when the close() methods of a Connection and a child PreparedStatement were called concurrently. The issue has been resolved.

VER-34535

Client Drivers - JDBC

Previously, PreparedStatement.addBatch() sometimes failed when using JDBC4 pooled statements. This issue has been resolved.

VER-20314

Communications/messaging

Cluster would hang when node rejoined the cluster and the catalog was large. This issue has been resolved.

VER-34149

Communications/messaging

An internal error was incorrectly reported in some rebalance operations. The error in the HP Vertica log contained the following text: <INTERNAL> ... 5445: VIAssert(_currentMessage.buf.avail() >= _currentMessage.getBufferDataSize()) failed. This issue has been resolved.

VER-33997

DDL - Projection

Dropping a column in a table occasionally modified the segmentation expression of a non-super projection that did not use the column being dropped.

VER-34003

Data load / COPY

Data for HP Vertica COPY rejection tables is now stored in data storage locations (similar to ordinary tables), rather than in a special catalog directory. HDFS-based data storage locations are not used by rejection tables in this release.

VER-35135

Data load / COPY

An issue occurred when users ran ALTER COLUMN SET DATA TYPE to change the column width of a string column, and applied one of four encoding types (BLOCK_DICT, COMMONDELTA_COMP, DELTARANGE_COMP, or NONE) to the column. In these cases, running queries on the column sometimes caused the database to fail or caused incorrect strings to be returned. This issue has been resolved.

VER-33634

Database Designer Core

Nodes sometimes failed if you dropped a database design before Database Designer finished executing. This issue has been resolved.

VER-33689, VER-34669

Execution Engine

The TO_CHAR function formatted results incorrectly when using pattern string '000.00' with numbers between 9.5 and 9.9. This issue has been resolved.

VER-33911

Execution Engine

When nodes joined or left the cluster during the execution of a DDL operation, the DDL sometimes rolled back with the error "A node has entered/left the database cluster." This issue has been resolved.

VER-33924

Execution Engine

Queries calculating the total number of results in a TIMESTAMPTZ column returned inconsistent results. This issue has been resolved.

VER-34212

Execution Engine

After upgrading from 7.0 to 7.1.0, spaces added to the SnmpTraps configuration parameter prevented the database from restarting. This issue has been resolved.

VER-34307

Execution Engine

When processing a query that was terminated, the database sometimes failed during the error recovery process. This issue has been resolved.

VER-34573

Execution Engine

Functions called on a TIMESTAMP that was truncated to a date sometimes caused HP Vertica to fail when the input for TIMESTAMP was NULL. This issue has been resolved.

VER-34626

Execution Engine

Joins with a large sorted inner relation and a sorted outer relation occasionally failed in SIPS. This issue has been resolved.

VER-34961

Security Hadoop

When retrieving data from an HDFS cluster with Kerberos enabled, the HDFS connector failed with an error, or returned fewer rows than expected. This issue has been resolved.

VER-30272

Optimizer

Previously, multi-character operators followed the wrong order of operations, resulting in errors when multiple such operators were used in a single statement without parentheses. This issue has been resolved.

VER-33463

Optimizer

Queries with the IN/NOT IN operator using non-default locale produced the wrong results. This issue has been resolved.

VER-33874

Optimizer

An HP Vertica node sometimes ran out of memory while running EXPLAIN because: 1) duplicate segmentation expressions were populated for various paths; 2) memory was not freed up immediately after going out of scope; 3) there was improper use of data structure; or 4) an object of a class was created inside a nested for loop. This issue has been resolved.

VER-34628

Optimizer

HP Vertica truncates nanosecond precision timestamps to microsecond precision timestamps, but the truncation failed in some cases with "ERROR 2992: Date/time field value out of range". This issue has been resolved.

VER-33173

Optimizer Query Generator

Previously, after a pre-join projection that satisfied a join in the query was found, the optimizer replaced the join with that projection. Due to an error, the optimizer did not perform as expected. The issue has been resolved.
VER-29216 Place Previously, indexing large polygon data sets consumed large amounts of memory causing some indexes to not finish. Index creation can now be done in parallel when a user segments a table or projection across cluster nodes.

VER-33459

Recovery

After a manual system recovery was unsuccessful, the node was restarted to re-join the cluster. Then after the node was restarted, the buddy projections had differing numbers of total rows. This issue has been resolved.
VER-30550 SDK AnalyticPartitionWriter's method getNumRows() used to give incorrect results. This has been fixed.

VER-31900

SDK-Java

Previously, SizedColumnTypes.getColumnName(index INT) returned NULL when called inside the setup method of a UDx (user-defined extension). In version 7.1.1, it now returns the column name.

VER-33883

SDK-Java

PartitionWriter.setNumericNull sometimes incorrectly produced a negative value rather than null output. This issue has been resolved.

VER-33657

SDK-R

When the close argument was issued, a User Defined Extension (UDx) in R created defunct Vertica-R processes that were not cleaned up immediately. This issue has been resolved.

VER-35269

Security

When using multiple Organizational Units (OU) LDAP Authentication sometimes failed. If the user did not exist in the directory searched in the first string, an error was logged and the connection attempt was immediately failed. This issue has been resolved.

VER-32201

UI - Management Console UI - Agent

Checking cluster status using admintools caused erroneous FATAL messages to be logged in the DC_ERROR_MESSAGES table. This condition sometimes caused the DC_ERROR_MESSAGES table to fill beyond its fixed size, thus causing other messages to expire.

VER-33470

UI - Management Console

After importing an HP Vertica 7.0.x database into version 7.1.0 of Management Console (MC) , JDBC errors occurred when MC graphs displayed. This issue has been resolved.

VER-33914

UI - Management Console

The Table Treemap chart, found on Management Console's Activity Page, previously displayed an incorrect number for unsegmented projections. This issue has been resolved.

VER-33915

UI - Management Console

The Table Treemap chart, found on Management Console's Activity Page, previously displayed an incorrect number for total projections. This issue has been resolved.

HP Vertica 7.1.0-4: Resolved Issues

Release Date: 10/15/2014

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-34799

Execution Engine

The Vertica COPY LOCAL process using SAS via ODBC could exhaust memory and cause Vertica to fail when loading a large number of records. This issue has been resolved.

VER-34922 Execution Engine A DROP_PARTITION operation is expected to interrupt or cancel a conflicting MERGEOUT operation. In some instances the MERGEOUT operation does not cancel and the DROP_PARTITION times out waiting for a table lock. Furthermore, a race condition in error reporting can sometimes result in a CANCEL error message being returned instead of the expected LOCK TIMEOUT error message. This issue has been resolved.
VER-35051 Security When using multiple Organizational Units (OU) LDAP Authentication would fail. If the user did not exist in the directory that was searched in the first string, then an error was logged and the connection attempt was immediately failed. This issue has been resolved.
VER-35123 Data load / COPY COPY rejections were not being saved due to the inability to access a user defined storage location. This issue has been resolved.
VER-35193 Basics to_date and to_timestamp were returning incorrect results when Sunday was used in the query. This issue has been resolved.
VER-35199 Execution Engine When DELTARANGE_COMP or COMMONDELTA_COMP compression types were applied to float columns, reading from those columns would sometimes return incorrect results. This issue has been resolved.

HP Vertica 7.1.0-3: Resolved Issues

Release Date: 9/16/2014

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-34421

Execution Engine

Queries calculating the total number of results in a TIMESTAMPZ column returned inconsistent results. This issue has been resolved.

VER-34294 Execution Engine After upgrading from HP Vertica 7.0.x to 7.1.0, users could not restart the database when spaces were added to the SnmpTraps configuration parameter. This issue has been resolved.
VER-34727 Optimizer Analytic clauses used as a parameter that have a window definition containing PARTITION BY or ORDER BY in a user-defined SQL function (UDF) generated an internal error. This issue has been resolved.

HP Vertica 7.1.0-2: Resolved Issues

Release Date: 8/12/2014

This hotfix addresses the issues that appear below. Contact HP Vertica Technical Support to obtain this hotfix.

Issue

Component

Description

VER-33769

Communications/
Messaging

An internal error was incorrectly reported in some rebalance operations. The error in the HP Vertica log contained the following text:

<INTERNAL> ... 5445: VIAssert(_currentMessage.buf.avail() >= _currentMessage.getBufferDataSize()) failed

This issue has been resolved.

VER-34198

Client Drivers - ODBC

In the ODBC driver, the SQLGetData() call incorrectly returned SQL_SUCCESS when the buffer length argument equaled  zero. This issue has been resolved.

VER-34727

Optimizer

Projections with expressions showed incorrect results after recovery. This issue has been resolved.

HP Vertica 7.1.0-1: Resolved Issues

Release Date: 8/6/2014

HP has integrated hotfix 7.1.0-1 into the Enterprise Edition downloads page on my.vertica.com to address a vulnerability in the initial HP Vertica 7.1.0 server. This vulnerability has been resolved and the fix has been integrated into the current HP Vertica downloads. HP strongly recommends the application of this update as soon as possible.

This hotfix addresses the issues listed below:

Issue

Component

Description

VER-34004

Installation Program

Although Debian Linux 7.0 is a supported platform for HP Vertica, the 7.1.0 installer failed on this platform. This issue has been resolved.

VER-33952

Security

The PRIORITY field of a client authentication record was not persistent and reset to 0 upon database or node restart. This issue has been resolved.

HP Vertica 7.1.0: New Features and Resolved Issues

Release Date: 7/31/2014

What’s New in HP Vertica 7.1.0

The list below describes some of the new features introduced in HP Vertica 7.1.0. To see a complete list of additions and changes introduced in this release, refer to the HP Vertica 7.1.x New Features Guide.

Note: HP Vertica 7.1.0 introduces support for HP Vertica storage locations on HDFS. However, use of HP Vertica software on Hadoop nodes is limited to processing data that is in the Vertica columnar format only.

Upgrade Considerations

Client Authentication

Effective with HP Vertica 7.1, client authentication information is stored in the catalog, along with other metadata about the database. Formerly, these records were stored in the vertica.conf file.

When you upgrade, the vertica.conf file still contains all the client authentication information, but your database does not use it. No client authentication is configured for your database, and anyone can connect to the database without a password.

When you upgrade, you must perform the following steps:

  1. Recreate and reconfigure all client authentication for your database using new SQL statements.
  1. Once you have confirmed that the new client authentication is working, delete all old client authentication records from the vertica.conf file.

See the Upgrading Client Authentication Records from vertica.conf to the Catalog section of the HP Vertica 7.1.x Installation Guide for complete details on how to upgrade.

SSL

In previous releases, HP Vertica obtained SSL certificate and private key data from two files stored in the catalog: server.crt and server.key. In 7.1.0, HP Vertica no longer obtains certificate and key data from these files. Instead, users specify this information using two configuration parameters: SSL Certificate and SSLPrivateKey.

If you are using SSL and are upgrading to HP Vertica 7.1.0 from a previous version, you must set these new parameters using Administration Tools AFTER you upgrade but BEFORE you start the new database. This will ensure that the certificate and key information is distributed across the cluster.

HP Vertica 7.1.0: Resolved Issues

Issue

Component

Description

VER-32243

Admin Tools

Previously, HP Vertica Administration Tools would not allow the database to start if any host was unavailable.  This issue has been resolved.

VER-29394, VER-31608

Catalog Engine Backup/DR

Canceling a vbr.py backup with Ctrl+ C did not always close the session. This issue has been resolved. Interrupting a backup with Ctrl+ C now closes the session immediately. Uninterrupted incremental backups may run faster.

VER-30954

Backup/DR

Schema-level backups failed if a temporary table existed at the checkpoint epoch of the superprojection. This issue has been resolved.

VER-33079

Backup/DR

Restoring an object-level backup could result in removing files of unrelated, uncommitted transactions. Since affected transactions could not commit, the following error could occur later if an operation attempted to read the files:   FileColumnReader: unable to open   position index  /data/v_node0001/005/4503599674477800  5/45035996744778005_0.pidx: No such   file or directory

This issue has been resolved.

VER-33373

Backup/DR

When using vbr.py to copy a database between HP Vertica 7.x clusters, vbr utility could overwrite the spread configuration. Without a spread configuration, the target database was unusable. This issue has been resolved.

VER-28517

Basics

This release improved the performance of many short-running queries, including (but not limited to) short queries making use of hash-joins or sort operators. These queries run more quickly and exhibit less resource contention than in previous releases.

VER-31121

Client Drivers - JDBC

Vertica JDBC had a memory leak in com.vertica.jdbc.sDatabaseMetaData. The issue has been resolved.

VER-31132

Client Drivers - JDBC

Previously, ResultSet.getDate(INT, Calendar) returned an incorrect DateTime due to time zones. This issue has been resolved.

VER-30377

Client Drivers - ODBC

Previously, some Unicode characters in column names were incorrectly encoded by the ODBC driver. The issue has been resolved.

VER-32107

Client Drivers - ODBC

Executing a parameterized query through a a linked server over an ODBC driver on an HP Vertica server generated an error. This issue has been resolved.

VER-32108

Client Drivers - ODBC

Previously, the ODBC batch insert using parameter bind offsets may have failed in certain circumstances due to an issue with bind offset value calculation. The issue has been resolved.

VER-32151

Client Drivers - ODBC

Previously, when returning SQL_SUCCESS_WITH_INFO, the HP Vertica ODBC client did not return the additional information if AUTOCOMMIT was set to false. This has been resolved; the additional information is now returned regardless of the AUTOCOMMIT setting.

VER-33330

Catalog Engine Communications/messaging

When a competing lock request timed out, the attempted lock was sometimes unable to be fully released, which could eventually cause the node to fail. This issue has been resolved.

VER-30721

DDL

Previously, the CREATE TABLE LIKE statement also copied table ownership. When a new table was created using CREATE TABLE LIKE by a user who was not the owner of the source table, but had appropriate permissions to do so, the new table belonged to the owner of the source table. This issue has been resolved.

VER-32383

DDL - Table

Previously, the CREATE TABLE LIKE statement also copied CREATE_TIME. This issue has been resolved.

VER-31068,
VER-32372

Recovery Data Removal - Delete, Purge, Partitioning

HP Vertica 7.1 .0 now supports MOVE_PARTITIONS during node recovery.

VER-4692

Data load/COPY

Data for HP Vertica COPY rejection tables is now stored in data storage locations (similar to ordinary tables), rather than in a special catalog directory as in the previous release.  HDFS-based data storage locations are not used by rejection tables in this release.

VER-28139

Data load / COPY

Previously, if a client chose exports from a large cluster to a small cluster over a subnet, it would sometimes fail. The issue has been resolved.

VER-30645,
VER-31057

Data load / COPY

When a COPY statement included filter and cooperative parsing was disabled, COPY could sometimes silently skip the last several rows in a file. This issue has been resolved.

VER-24277

Database Designer Core

The REBALANCE_CLUSTER meta-function is now more efficient. In addition, refresh operations, which are used to rebalance data, are done in parallel. N unsegmented projections or N tables with inelastic projections are refreshed concurrently (where N=planned concurrency of the refresh pool).

VER-28968

Database Designer Core

Database Designer generated an error when run on an ephemeral node. This issue has been resolved.

VER-29971

Database Designer Core

Occasionally, the Database Designer would generate an error. A subquery used as an expression returned more than one row and terminated while generating the deployment script. This issue has been resolved.

VER-30091,
VER-30602

Database Designer Core

Previously, the dbd_output_add_nodes_rebalance_data_script sometimes dropped projections. This issue has been resolved.

VER-23552

Execution Engine

Queries sometimes incorrectly logged a "cache lookup failed for operator" error in the DC_ERROR table. This issue has been resolved.

 

VER-30101

Execution Engine

This release improved the performance of many short-running queries, including (but not limited to) short queries making use of hash-joins or sort operators. These queries run more quickly and exhibit less resource contention than in previous releases.

VER-30414

Execution Engine

Queries using ranges with integer-bounds, and queries sorted by date and time, sometimes caused an internal optimizer error. The database then failed.

VER-30746

Execution Engine

In cases where NULL values were used frequently and sorted non-RLE column(s) were used in predicates, HP Vertica sometimes returned inconsistent query results. This issue has been resolved.

VER-31054

Execution Engine

Previously, the timezone setting for Moscow was off by one hour. This issue has been resolved.

VER-32156

Communications/messaging Execution Engine

Larger clusters required significant amounts of memory to run queries with resegmented joins.  By employing a new, two-hop network routing scheme, the number of network flows is greatly reduced, resulting in significantly smaller memory requirements.

VER-31002

FlexTable

Loading a flex table could truncate a single large field in the map data, but not the entire map. Single-field truncation did not generate an error. This issue has been resolved.

VER-31385

Hadoop

Previously, the partition key column was not included in the column definitions in catalog, resulting in an error. The partition key column has been added to the column definitions. The issue has been resolved.

VER-8937

Admin Tools Communications/
messaging Diagnostics

With this release, client connections with IPv6 are not supported on the following platforms: Solaris, AIX, HP-UX.

VER-24786

Metadata Tables

Previously, there was no way to show projection segmentation expressions using the system tables. A segment_expression column was added in the PROJECTIONS system table. The issue has been resolved.

VER-29404

Optimizer

In previous releases, queries with joins on columns with high data skew that were used in other joins sometimes performed slowly because of join spills to disk. This issue has been resolved.

VER-29414

Optimizer

When a query ran for an extended period, it ran out of memory and failed to retry due to a DDL statement interfering with the query replan. This issue has been resolved.

VER-29798

Optimizer

In previous releases, when HP Vertica performed a sorting operation as a result of a DISTINCT or ORDER BY clause, certain data types (INTEGER, DATE/TIME, NULL) could not be implicitly cast as VARCHAR data. This issue has been resolved.

VER-29980

Optimizer

Queries with WHERE FALSE conditions and subqueries were using plans with unneeded table scans, causing them to take longer to run. This particularly caused problems for some query generation tools that use 'WHERE 1=0', which simplifies to WHERE FALSE, to check queries before running them. The issue has been resolved.

VER-31191

Optimizer

Enclosing a TIMESERIES clause within a WITH clause caused an error. This problem has been resolved.

VER-32230

Optimizer

When the catalog was modified while an EXPORT_STATISTICS function was running, the function could sometimes cause the database server to fail. This issue has been resolved.

VER-32735

Optimizer

Previously, the optimizer would occasionally incorrectly estimate the number of output rows when there was a union on top of the view. The issue has been resolved.

VER-31421

Query Generator

Collecting statistics on large columns with mostly NULL values sometimes produced the incorrect conclusion that the entire column was NULL, ignoring MIN or MAX estimates. This issue has been resolved.

VER-33599

Optimizer Query Generator

Previously, after a pre-join projection that satisfied a join in the query was found, the optimizer replaced the join with that projection. Due to an error, the optimizer did not perform as expected. The issue has been resolved.

VER-30944

Recovery Refresh

Previously, a rebalance operation could run out of memory when run on a large cluster with many storage containers. This issue has been resolved.

VER-30684

SDK

The maximum number of arguments that user-defined functions can take has been increased from 32 to 500.

VER-25632

Storage and Access Layer

You can now use the ADD_LOCATION() function to add a read-only directory for user data. Additionally, an unavailable user location no longer prevents a node from starting up.

VER-31029

Storage and Access Layer

HP Vertica periodically performs various checks on the system for performance and usage. Previously, in certain cases, the check would divide by 0, causing an error. The issue has been resolved.

VER-31220,
VER-31221

UI - Management Console

Previously, the Queries report only listed queries in the minute in which they were started. This has been changed so that a query is listed across all time periods in which it is running.

VER-33247

UI - Management Console

Previously, Management Console on remote non-database nodes imported through the public network. All private IPs showed the database and node state as unknown, but displayed all other details normally. The issue has been resolved.

VER-33265

UI - Management Console

In previous releases, the workload operation did not perform its daily run. The issue has been resolved.

Known issues and limitations in HP Vertica 7.1.x

Updated: December 11, 2015

HP Vertica makes every attempt to provide you with an up-to-date list of significant known issues in each release. We will update this list as we resolve issues and as we learn of new issues.

Known limitations

Backup operations are not currently supported on HP Vertica implementations using HDFS storage locations.

HCatalog connector does not currently support Kerberos authentication. Currently only HDFS Connector supports Kerberos authentication.

Known issues

Issue

Component

Description

VER-31324

Backup/DR

vbr.py allows a maximum total of 500 full- and object-level backups that can exist on one backup host and location. Exceeding this limitation results in the following, error: "at most 500 --link-dest args may be specified"

Workaround:

Manually delete some of the old backups from each backup host.

VER-34540

Catalog Engine

Linux servers using glibc versions 2.12 and later may encounter an issue where a node goes down and the dbLog contains the error "*** glibc detected *** /opt/vertica/bin/vertica: invalid fastbin entry (free)".

This may be due to a bug in glibc. The RedHat Advisories provide additional details. See https://rhn.redhat.com/errata/RHBA-2014-0480.html and https://rhn.redhat.com/errata/RHSA-2014-1391.html

If you encounter this error, first determine if you are using an affected version of glibc:

rpm -qa | grep glibc

If your version of glibc is 2.12 and does not have a .149 or later suffix, then your server may be affected by this issue.

If so, apply the security fix as described by your vendor. For RedHat systems, see: https://rhn.redhat.com/errata/RHSA-2014-1391.html

For other systems, please contact your Linux vendor to determine if there is an update available to fix the issue specified in https://rhn.redhat.com/errata/RHBA-2014-0480.html.

VER-42809 Client Drivers ENABLE_WITH_CLAUSE_MATERIALIZATION is not supported for WITH CLAUSE prepared statements.

VER-33718

Communications/messaging

Some queries involving user defined functions and LIMIT may have significant performance degradation.

VER-31330

Documentation

If you have not defined any authentication methods in the catalog, all users and the DBADMIN user can log in using MD5 authentication. After you create the first authentication method, HP Vertica no longer assumes any authentication. The database now requires that all users have been explicitly granted an authentication method in order to log in. If a user has not been explicitly granted an authentication method, authentication fails.

The DBADMIN user can log in locally, but cannot stop the database or rebalance data using Admintools because Admintools connects to the database over the network. If this happens, the DBADMIN user must take the following steps:

1. Log in locally.

2. Create a default authentication method.

3. Grant that method to DBADMIN, to other users who need access, or to public if you want to include all users.

For example, to allow the DBADMIN and U1 users to access the database using MD5 (hash) authentication from any IP address, enter the following statements:

=> CREATE AUTHENTICATION default_auth METHOD 'md5' HOST '0.0.0.0/0';

=> GRANT AUTHENTICATION default_auth to U1;

=> GRANT AUTHENTICATION default_auth to DBADMIN;

VER-34101

Optimizer

If data is discarded as part of an administrator-specified recovery (ASR) process, affected aggregate and Top-K projections are marked out of date. Run the REFRESH() function to update out of date projections.
VER-32660, VER-32661 Optimizer

HP Vertica 7.1 introduced a feature to distribute evaluation of expressions. For some expressions, this feature slows query performance.

Workaround:

If a UDx has become slower after upgrading to HP Vertica 7.1, you can disable the distribution of expression evaluation for that query using the NO_DISTRIBUTE_EXPR_EVAL hint.

For example: SELECT /* +add_vertica_options(OPT, NO_DISTRIBUTE_EXPR_EVAL) */ my_udf(a) FROM t;

VER-35031 UI - Management Console When profiling certain queries (such as INSERT, UPDATE, and DELETE statements), Management Console sometimes does not generate a Tree Path view for the query plan, and displays an "Error getting tree data - MC did not send tree data back" error. Other views on the Explain page, such as the Profile Information view, are unaffected.

 


Legal Notices

Warranty

The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained herein.

The information contained herein is subject to change without notice.

Restricted Rights Legend

Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license.

Copyright Notice

© Copyright 2006 - 2015 Hewlett-Packard Development Company, L.P.

Trademark Notices

Adobe® is a trademark of Adobe Systems Incorporated.

Microsoft® and Windows® are U.S. registered trademarks of Microsoft Corporation.

UNIX® is a registered trademark of The Open Group.


Send documentation feedback to HPE