Zoomdata Version

Zoomdata Version 2.6 Release Notes

These release notes cover changes and fixes made to releases under Zoomdata version 2.6. The latest updates are available in v2.6.30. You can identify your release version on the Login screen.

Zoomdata version 4 is the long-term support (LTS) Active Support release. Zoomdata version 3 is the LTS Passive Support release. For more information, see Zoomdata Release Vehicles and Licensing Management.

Version 2.6 is no longer supported.

For information about features that have been deprecated over the last several versions, see Deprecated Zoomdata Features.

Zoomdata Version 2.6.30

What's Fixed/Changed?

  • Upgrades were made to Zoomdata back-end dependencies and libraries.

Zoomdata Version 2.6.29

What's Fixed/Changed?

  • Upgrades were made to Zoomdata back-end dependencies and libraries.

Zoomdata Version 2.6.28

What's Fixed/Changed?

  • Corrected a problem in which flat file data sources did not appear in the output of the /api/groups/<groupid>/sources API endpoint.

Zoomdata Version 2.6.27

What's Fixed/Changed?

  • Resolved an account synchronization issue for users logging into Zoomdata via SAML SSO.

Zoomdata Version 2.6.26

What's Fixed/Changed?

  • Resolved a problem in which auto-provisioned SAML users were granted user roles instead of group-only roles.

Zoomdata Version 2.6.25

What's Fixed/Changed?

  • Resolved a logout problem when SAML authentication is used.

  • The version of jQuery UI packaged with Zoomdata has been upgraded to address a jQuery UI application vulnerability.

Zoomdata Version 2.6.24

What's Fixed/Changed?

  • Attempts to delete the last chart on a shared dashboard now happen correctly.

  • Resolved a problem in which the Spring session is persisted after a user logs out when Zoomdata is used as an OAuth provider.

Zoomdata Version 2.6.23

What's Fixed/Changed?

  • Corrected the Volume metric label in exported CSV files to use the custom metric label, when one is specified.

  • Revised error messages produced when creating a new user so that enough information is provided to debug the error without displaying sensitive user information.

Zoomdata Version 2.6.22

What's Fixed/Changed?

  • Removed passwords in the query-engine-activity.log and query-engine-websocket.log files. They are now replaced with asterisks.

Zoomdata Version 2.6.21

What's Fixed/Changed?

  • Reduced the time it took to export a Map:World Countries chart to PDF or PNG format. The export now takes the same time as it does for the default chart type.

  • Corrected a problem in which the tooltip for a calculation (custom metric) on a stacked bar chart was listed as an attribute instead of a metric.

  • Corrected a problem in which an LDAP user's group-only configuration was changed to a regular user configuration after the user's initial login to Zoomdata.

Zoomdata Version 2.6.20

What's Fixed/Changed?

  • Corrected a problem in which a custom favicon was not appearing correctly on open dashboards.

  • Corrected a problem in which the Apache Solr version could not be enforced using the Version connection parameter.

Zoomdata Version 2.6.19

What's New?

  • A new color palette option named RdOrYl has been added for use in charts. It can be selected on the Charts tab when a data source is defined and in the Color dialog for existing charts. It includes the eight colors shown in the picture below, but may use as few as three of the colors shown.

What's Fixed/Changed?

  • Fixed a problem that caused the Zoomdata chart metric label to overlap the Y-axis value in environments where Zoomdata was run in Internet Explorer 11.

  • Fixed a problem in which users could not successfully execute PUT, PATCH or POST API requests when X.509 authentication was configured and enabled.

  • Resolved a problem in which the MongoDB connector could not read a nested field value in a raw data table request, and displayed the data as null.

Zoomdata Version 2.6.18

What’s Fixed/Changed?

  • Corrected a problem in which bar chart gridlines could not be manipulated after a filter was removed from the chart when it displayed no data.

  • Line trend lines no longer collapse after you set the grid line values manually.

  • It is no longer possible to use the API to create a bookmark key for a data source you are not authorized to access.

  • Added validation to PUTs using the /api/bookmarks/{id} endpoint to ensure that multiple visualizations cannot be created with the same widgetIds.

  • Corrected a problem that would not allow you change the settings of a KPI chart twice.

  • Removed the login pop-up and login requirement when exporting a map chart to a PNG or PDF file.

Zoomdata Version 2.6.17

What's Changed/Fixed?

  • Corrected a problem recognizing Impala partitions, which prevented Zoomdata from creating Impala data sources.

  • Corrected a problem in which an attempt to delete a keyset was not passed to Zoomdata if a previous attempt failed because the keyset was used by other dashboards.

  • Added information to the keyset filter informational dialog about a keyset's sort, limit, and group specifications.

  • Adjusted the error message produced when the maximum job timeout is exceeded to clarify for users that the maximum timeout value they will see is actually the sum of the values of the zoomdata.source.update.timeoutSeconds property and the scheduler.progress.timeout.bufferMillis property.

  • Resolved a problem in which all filter functionality failed after the user who created a keyset was removed from the system.

  • Corrected a problem in which Amazon Redshift connections were not being properly closed.

Zoomdata Version 2.6.16

What's New?

Two new properties have been added to the zoomdata.properties file in this release. Use these two properties to change the following data export limits:

  • zoomdata.export.data.max.rows=<nnnn>: Use this property to define the maximum number of rows that can be exported for charts. Zoomdata enforces this limit for chart data. However, for raw data, Zoomdata produces an error if the number of rows requested for export exceeds this setting. The distributed default for this setting is 100000 rows. Valid values can range from 0 through 2147483647 rows.

    In the Zoomdata UI, you can specify how many rows are exported when you select Export from the sidebar of a dashboard chart and elect to export raw data. The number of rows you can specify is now limited by the zoomdata.export.data.max.rows property.

  • zoomdata.export.data.max.cols=<nnnn>: Use this property to define the maximum number of columns that can be exported for two-dimensional chart visualizations (such as a pivot table). Zoomdata enforces this limit for chart data, but does not enforce it for raw data. The distributed default for this setting is 1000 columns. Valid values can range from 0 through 2147483647 columns.

See Managing Configurations in Zoomdata and Managing Configurations Using Zoomdata Properties for more information about the location and function of the zoomdata.properties file. For information about the properties in the zoomdata.properties file, see Configuration Property Files and Their Corresponding Variables.

What's Fixed?

  • Resolved a problem with forward slashes in data source names.

  • Resolved a problem exporting a dashboard configuration.

  • Resolved a problem in which the next execution time was not displaying in Coordinated Universal Time (UTC) when the Zoomdata Scheduler was set up using a cron expression.

  • Corrected a problem that occurred when an attempt was made to view detail (raw) data from a bar chart set to view data using any rolling preset time.

  • A problem reading the query-engine.jvm file has been resolved.

ZoomData Version 2.6.15

What's Changed/Fixed?

  • Resolved a problem that would not allow connection names to be changed in the Manage Connections area of the Zoomdata user interface.

  • Resolved a performance problem when attempting to load some small CSV flat files.

  • An error that occurred during attempts to change the start or end time for a dashboard using a live mode data source has been resolved.

  • Resolved a problem caused when a user visualization was created that had the same name or type as a Zoomdata-supplied (built-in) visualization. When such attempts are made now, the user visualization is automatically changed to a custom visualization and will be entirely rejected if the visualization name is the same as the built-in visualization. Appropriate error messages are issued.

Zoomdata Version 2.6.14

What's Changed/Fixed?

  • Lightweight Directory Access Protocol (LDAP) users can now be imported successfully when the LDAP user name matches an existing Zoomdata user account name if a new configuration setting, ldap-user-overwrites-local, is enabled. If this setting is enabled and a Zoomdata user account exists with the same name as an LDAP user you are trying to import, the LDAP user definition will override the Zoomdata user account. See Configuring Server-Level Variables.

  • Charts are now exported correctly when using a custom pivot table.

  • You are now prompted to save an unsaved dashboard prior to exporting it.

  • You are no longer required to sign in when opening a shared interactive or non-interactive link in a private window.

  • Columns on the Home page now size properly after switching to and from List view.

Zoomdata version 2.6.13

What's Fixed/Changed?

  • Addressed an issue where fields were incorrectly shown when a dashboard was shared with an interactive link.
  • Resolved a problem with configuration of a time field that was set to use a custom time pattern.
  • Fixed a bug which prevented a customization on the radial menu from working.
  • Resolved an issue where a user associated with a certain group wasn’t able to import dashboards.
  • Addressed a problem with usage of the coalesce function in calculation expressions.
  • Fixed a bug where Zoomdata failed to start when service discovery was disabled.

Zoomdata Version 2.6.12

What's Fixed/Changed?

  • Resolved a problem where switching between Kerberos and LDAP configuration pages resulted in errors for a Supervisor.
  • Addressed an issue to keep the CORS configuration in situations when REST API endpoint requests contain invalid credentials.
  • Fixed a problem where the dialog to delete a data source could not be opened if it was used in another Fusion source.
  • Fixed a bug related to a missing string for a warning message related to use of the time bar.

Zoomdata Version 2.6.11

What's Fixed/Changed?

  • Enabled Debug level logging when the Zoomdata server is setup to use Kerberos style single sign on, in order to help troubleshoot any sign on issues.
  • Addressed a logout problem when an LDAP user was setup to use Kerberos single sign on.
  • Resolved a bug with the Color setting control where sliders could not be moved to setup a color range.
  • Fixed a problem with the JSON contained in REST API docs so that it conforms to the Swagger 2 specification.
  • Reduced the default Rows per Fetch setting from 500 to 250 for the Raw Data Table to aid in performance when dealing with raw data display of very wide tables. This change has no impact to existing data sources and does not limit the user’s ability to incrementally load more data than what is initially fetched.
  • Addressed a bug in order to enable the Zoomdata WebSocket to handle large payload sizes.
  • Added support for configurable encryption (introduced in 2.6.9) for existing installations such that encryption settings can be updated during an upgrade from an older Zoomdata version to 2.6.11 and beyond.
  • Added the ability to configure the Initialization Vector used for encryption in Zoomdata.

Zoomdata Version 2.6.10

What's Fixed/Changed?

  • Fixed an issue that occurred intermittently with scrolling on custom charts.
  • Addressed a problem with activity logging related to creation and updates of data sources.
  • Resolved a bug which prevented dashboards from being shared for a user who uses the “keep me logged in” option.
  • Fixed a problem where certain dashboard interactions caused extra HTML elements to be added and slow down performance.
  • Modified behavior for a source, that uses custom SQL, to preserve data source and field configuration settings when the custom SQL is changed without affecting the data source schema.
  • Addressed a bug where re-ordering the Raw Data table columns resulted in display of cached data.

Zoomdata Version 2.6.9

What's Fixed/Changed?

  • Introduced configurable encryption properties for new Zoomdata installations. Configuration settings will largely depend on the JVM in use for an installation. This feature targets customers with specific security requirements and is likely not applicable for most deployments. Contact Zoomdata application support to get more details.
  • Applied security fixes and updates.

Zoomdata Version 2.6.8

What's Fixed?

  • Resolved an issue with export of raw data table results when using a text search filter.
  • Added IP address and user information when logging raw data export activity.
  • Addressed a couple of bugs with pivot table related to granularity set for a time attribute.
  • Fixed a problem with typing dashboard names when saving on touchscreen interfaces.
  • Resolved a problem with editing a derived field that is named the same as an existing field.
  • Fixed the resolution at which screenshots are taken for dashboard thumbnails on the home page.
  • Addressed an issue where the renamed label for Volume was not updated properly in some areas.
  • Made a few performance improvements related to browser caching of resources and jobs run by scheduler.
  • Made a couple of security related updates.

Zoomdata Version 2.6.7

What's Fixed?

  • Fixed a couple of problems with uploading file based data with certain input values.
  • Resolved a scrolling issue on Internet Explorer version 11 when using the raw data table field selection controls.
  • Addressed a bug with deletion of disabled users when OAuth tokens existed for them.
  • Fixed an issue with deletion of accounts created in a previous version.
  • Introduced a configurable maximum number of fields setting when using the file upload service to upload files with a large number of fields.
  • Added user attribute in the request activity entries in zoomdata-access.log file to allow easy mapping of users to requests.

Zoomdata Version 2.6.6

With the release of 2.6.6, Zoomdata version 2.6 has been declared the long-term supported (LTS) release of Zoomdata. The previous LTS release, Zoomdata version 2.5, will continue to be supported until August 1, 2018. Customers using earlier versions of Zoomdata are encouraged to upgrade to Zoomdata 2.6. For questions on upgrading, contact Zoomdata Application Support.

What's New?

  • Keysets is a brand new Zoomdata feature available for preview in 2.6.6. With this feature, data explorers can significantly expand on use cases where data exploration requires tying multiple data sources together. Analysts can now create a set of keys using the result of one chart and feed the keys into a completely different chart or dashboard, which uses different (or the same) data sources. Imagine use cases, such as in healthcare, where a hospital wants to analyze readmission rates for a cohort of patients who were in the same drug trial where data on readmission rates and drug trials was stored in different data sources. Contact your Zoomdata representative to learn more about this feature and give it a test drive.
  • All charts that allow multiple groupings now support grouping on multiple time fields, as long as the underlying data source supports this functionality.
  • Dashboards can now have a Refresh Data button for users to bypass any dashboard cache and get the latest data from the underlying data source.
  • SQL Server now supports derived fields (row level calculations). For more information, see Creating Calculations in Zoomdata.
  • Impala connector now supports accessing Kudu tables in addition to Impala tables.
  • Hive 2.x connector now supports the Hive on LLAP configuration.
  • Zoomdata Query Engine can now be deployed using an externalized Spark on Yarn configuration on Hortonworks clusters.
  • Numeric filters now support the “NOTEQUALS” operator for specifying a filter condition.
  • SQL Server data sources in Zoomdata now support the use of Unicode characters.

What's Fixed?

  • Fixed an issue where UNIX timestamp fields stored as a float or decimal number in SQL Server were not handled correctly for grouping.
  • Addressed a problem with logging of user authentication events in certain cases.
  • Resolved a bug where multiple connections were created to SQL Server when using Windows authentication.
  • Addressed a bug where derived fields are not visible on some data sources.
  • Fixed an issue where the time range shown on the time bar could be sometimes incorrect.
  • Resolved a UI problem where the scroll bar style wasn’t consistent on a Windows machine.
  • Addressed an issue with an AVG calculation when dealing with Decimal types on a data source using the Spark SQL connector.
  • Fixed a bug with using Japanese characters in fused attribute names inside a Fusion source.
  • Resolved an issue with type detection for certain fields when uploading file data into Zoomdata.

What's Removed?

  • Support for older versions (2.x) of Elasticsearch has now been deprecated since Elastic has dropped support for this version of Elasticsearch.
  • Removed the option for a user to specify whether a dashboard would “Remember Time Position” when it’s saved. Time position is now automatically remembered every time a dashboard is saved. Users can specify dynamic ranges on their time filters to auto-update time filters on their dashboards.

Zoomdata Version 2.6.5

What's New?

  • HDFS and S3 now support derived fields (row level calculations). For more information, see Creating Calculations in Zoomdata.
  • Elasticsearch 6.x connector is now installed by default.
  • SQL Server connector no longer requires a separate JDBC driver.
  • Added ability to search in attribute, metric and filter pickers when working with large number of fields.
  • Enhancements to cache handling to support larger number of dashboard viewers.

What's Fixed?

  • Fixed an issue related to log rotation in connector logs.

What's Removed?

  • Deprecated support for older versions of Spark (1.5/1.6) in the Spark SQL connector.
  • Elasticsearch 2.x connector is no longer installed by default, it must be installed manually.
  • Removed the ability to set and change fonts on charts.
  • Removed support for exporting to XLS file format.

Zoomdata Version 2.6.4

What's New?

  • Smart axis formatting is now applied to charts to automatically roll up large numbers to the most appropriate scale, for example millions and billions.
  • You can now group by numeric fields within your charts.
  • Elasticsearch 6, Spark SQL and Hive on Tez now support derived fields (row level calculations). For more information, see Creating Calculations in Zoomdata.

What's Fixed?

  • Fixed an issue related to handling of PreviousPeriod() in calculations.
  • Resolved a problem related to displaying HTML formatted text in raw data table.
  • Addressed an issue related to rendering lines based on calculations in line trend chart.

Zoomdata version 2.6.3

What's New?

  • Zoomdata now offers a command line interface (CLI) for developers to create custom charts in a development environment of their choice. The CLI is an alternative to the Chart Studio web-based interface and helps developers manage all aspects of custom charts created within your environment.
  • You can now use non-Latin characters in expressions and calculations. To see what characters are supported, see Creating Calculations in Zoomdata.
  • The Elasticsearch connector has been updated to support ES versions 5.6.x and 6.0.x
  • The Spark version bundled with Zoomdata is upgraded to Spark version 2.2.1.
  • Data sources public REST API was updated to v2 and the prior v1 public data sources API was deprecated. Note this change requires updates to client applications to pass in v2 content type header.

What's Fixed?

  • Resolved a problem with the Lines Trend chart style where using calculated values on the Y axis of the chart cased the chart to not render properly.
  • Fixed a bug related to the Raw Data Table chart style where HTML formatted strings were no longer automatically converted to hyperlinks within the chart.
  • Addressed an issue with using the time transform calculation where applying a shifted timezone to a particular time field in the data source resulted in charts that grouped by time to not properly display data for the timezone shift.

What's Removed?

  • Zoomdata’s Chart Studio is now deprecated. You can continue to make custom charts and carry out other developer tools using the new custom chart CLI. If you want to create custom charts in Chart Studio, a Supervisor can toggle it on.

Zoomdata Version 2.6.2

What's New?

  • You can now filter on metrics within your data set, as well as on previously created calculations. In addition, filtering capabilities have been split into filtering on data source fields and filtering on metrics and calculations. Data source field filters are now referred to as row level filters and metrics and calculations filters are called group filters. For more information about group filters, see Filtering data.
  • Administrators can define the type of formatting for number sets within a data set, which is done at the level of the data source. This allows for greater control over the formatting of decimal points, numeric units, and negative numbers. In addition, Administrators can now format the following:
    • Plain number formats
    • Money
    • Percentage
    • Computer storage units
    • Scientific notation

  • When defining the format of fields, Administrators can also set the required locale for users to display the correct format for their geographical location. For more information, see Users and Groups.
  • The Solr data connector in Zoomdata has been upgraded to include support for Solr 6.4+ and Solr 7 versions.
  • When exporting chart data from visualizations from your environment, they are now exported in CSV file formats instead of Excel sheets format (.xls). For more information, see Exporting Charts and Dashboards.
  • Improved tooltips for visualizations by updating the positioning and color indicator.
  • When upgrading from previous versions, the default port for Zoomdata has changed from 8443/HTTPS to 8080/HTTP. HTTPS can be configured using the steps in Configuring Zoomdata Property Files. In addition, prior releases of Zoomdata supported running both https and http simultaneously, this dual port configuration is no longer supported by Zoomdata but can be achieved using a proxy front ending Zoomdata.

What's Fixed?

  • Resolved an issue with OAUTH token handling.
  • Fixed a bug related to the Upload API where concurrent REST API requests were not supported and caused HTTP errors to be thrown.
  • Addressed a problem with loading visualizations.
  • Resolved a problem with previewing data for a CSV upload data source where different columns in preview mode were incorrectly shown as identical.
  • Addressed a problem with color selection in visualizations where changing the color palette from gradient to distinct colors would not update the color scale.
  • Fixed a bug related to Line & Bar and Floating Bubbles chart styles where in-visualization tooltips would not disappear after expanding the chart to full screen.
  • Resolved a problem with MongoDB Atlas where data collections were not retrieved after the initial connection.

What's Removed?

  • HATEOAS links are no longer provided with the public API endpoints.
  • HTTP redirect has been deprecated.

Zoomdata Version 2.6.1

What's New?

  • Controls inside a dashboard widget are now responsive to widget size and are minimized when not needed. The toolbar controls are now only shown on the dashboard canvas when hovering over the widget. Also, dashboard widget controls and group or metric pickers collapse or disappear depending on the size of the widget.

  • Zoomdata Administrators now receive earlier notifications about the status of the license expiration date for their environment. For more information about requesting a new license key, see Managing Licensing for your Environment.

  • An SAP Hana connector is now available from Zoomdata (subject to license), which supports Row Level Calculations. For more information, see Managing your SAP Hana connectors.
  • Added a REST API endpoint to programmatically create personal OAUTH tokens for use in embedded scenarios.
  • Updated the public REST API for connections.

What's Fixed?

  • Resolved an issue around calculations yielding null values where the null values were displayed on the color legend range, instead of including numeric values.
  • Addressed a problem around the Raw Data Table chart type in data source configuration where modifying or removing and re-adding the index of the underlying data source would cause the chart to error out when trying to render.
  • Fixed a bug related to upgrading metadata from version 2.3 to version 2.6.

Zoomdata version 2.6.0

Charts and Dashboards

  • You can now create derived fields within calculations for your charts and dashboards. This allows you to build visualizations using both the fields in your data source and also derived values of your data to enrich your insights. You can use derived fields and row-level expressions as arguments or aggregation functions in calculations, allowing you to create advanced calculations. This functionality is supported on Impala and PostgreSQL. For steps and information, see Creating Calculations in Zoomdata.
  • Dashboards have an improved chart layout, make the responsiveness faster and increasing the ease of interaction. The layout improvements also enables smaller sized chart widgets within a dashboard, meaning you can view more data at one time.

Server and Client Application

  • Zoomdata now uses Apache Spark as its internal processing engine. For more information, see How Zoomdata uses Spark.
  • The Query Engine is now a standalone service within the Zoomdata environment and offers its own deployment and configuration options. For more information about how Query Engine performs, see Managing your Query Engine.
  • If you have an existing externalized Spark cluster, specifically Spark on Yarn on Cloudera clusters, you can use your existing cluster for use with Zoomdata.
  • You can now leverage FluentD as a unified logging layer in conjunction with Zoomdata, meaning that you can direct your log files to a central repository using FluentD. For more information, see Setting up Unified Logging.

Data Connectivity

  • The Upload API connector no longer requires MongoDB for data storage. Data for Upload API is now stored in PostgreSQL. For more information, see Using Upload API.
  • The Flat File (CSV) upload functionality now utilizes PostgreSQL as a data store.
  • Amazon S3 and HDFS data sources now use their own embedded Spark instance for data processing.
  • The SparkIt capability for data sources is now fully removed and is no longer available.
  • Amazon S3, HDFS, and MongoDB data sources are now migrated over to use Zoomdata's own microservice architecture.

Security and Account Management

  • For users imported in to Zoomdata via SAML or LDAP, the auto-creation of groups that map to users existing groups is now configurable.
  • Security scanning for your Zoomdata environment is improved.

Developer Resources: SDK and REST APIs

  • Custom visualizations can now be defined to use up to 10 group-bys within a chart.
  • REST API to append data to an existing Upload data source is now supported.

Known Limitations and Issues as of 2.6.0

  • Upload API and File Upload interpret values which include a currency symbol such as $10.00 as attributes (text), not as numbers.
  • Upload API and File Upload do not calculate date and time properly when your PostgreSQL server is not in UTC time format.
  • HDFS and S3 connectors have known limitations around grouping time fields that were converted from strings.
  • Upload API and File Upload only support upload of individual files less than 200MB. For larger file sizes, split the files up into smaller files and add them incrementally to an existing File Upload source.
  • Derived fields have the following limitations in 2.6.0:
    • Play mode, Live mode, and data sharpening are not supported.
    • Data profiling is not supported.
    • Derived fields cannot be used on fusion sources made of Impala and PostgreSQL.
    • The following chart types are not supported: Histogram, Boxplot, Percentile, and Last Value.

Was this topic helpful?