Versions Compared

Old Version 16

changes.mady.by.user Juliane Wetzel

Saved on

compared with

New Version 17

changes.mady.by.user Juliane Wetzel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
titleINFO

Within these release notes Datameer X provides information and resolutions on improvements, bug fixes, and visual changes for 11.1.x maintenance release versions.  

Visit Datameer's Help Center for additional information or contact your customer service representative. 

...

Section

Datameer X 11.1.7

New Features

1

Admin: Job Scheduler - Introduce a control ability to schedule jobs DAP-42008

We introduce a new capability for Datameer X users which can schedule jobs. This capability can be enabled/ disabled in the 'Admin' tab → 'Roles'. 


Improvements

1Export: PostgreSQL/ MySQL/ ClickHouse - Show new textbook for 'Pre-Hook SQL Statement' if the capability is setDAP-41856

You can now enter one SQL statement to be executed before performing an export in the section 'Pre-Hook' when configuring an export job. If the pre-hook fails, the whole export job will be failing. This will also fail, when the export job has a defined pre-hook statement but the job owner does not have the capability to enter it. Note that the SQL statement is not restricted in any way and it has no unintended effects. 


2Export: New capablity 'SQL statement before export execution'DAP-41857

The new capability 'Pre-Hook SQL' allows to create, edit and delete a pre-hook SQL statement before an export job execution and can be set in the 'Admin' tab → 'Roles'. This capability is only set per default for the admin user. 

Bug Fixes

1

Import: Google BigQuery - Datameer X can not convert Google BigQuery DATE to Datameer X DATE formatDAP-42220

When importing data from Google BigQuery to Datameer X, the correct pattern is used to convert from Google BigQuery DATE format to Datameer X DATE format. 

(tick) Bug fixed.


2File Browser: Artifacts details sorting issuesDAP-42191

Sorting artifacts in the File Browser works properly for all columns again and does not reset when scrolling. 

(tick) Bug fixed.


3Documentation: Broken documentation link for the export job configuration dialogDAP-42188

The documentation link for 'File Path and File Name Patterns' within the export job wizard now points to the correct documentation page. 

(tick) Bug fixed.


4REST API: Curl command for uploading a license should not create a user sessionDAP-41581

Using the curl command for uploading a license does not increase the session count for user sessions any more. (tick) Bug fixed.


5File Backup: Error when backing up folder in the GUIDAP-42241

A file backup works as expected again after patching Datameer X. (tick) Bug fixed.


6Setup: 'Enable-ssl-customization.sh' should actually create 'ssl.ini'DAP-42199

When executing the 'enable-ssl' script, the HTTP module ist automatically disabled and the HTTPS/ SSL module enabled. Furthermore the 'start.d' file and 'ssl.ini' are created to contain all default values and standard properties.(tick) Bug fixed.


...

Section

Datameer X 11.1.5

New Features

1Import/ Export: Salesforce Bulk API importsDAP-21069

The Salesforce Connector now uses the Bulk API 2 to import data via a REST API. For running bigger datasets, custom properties for the import job are required, e.g. 'datameer.salexforce.maxrecord-per-result-request.  



2Execution Engine: Allow jobs bypassing the Job Scheduler queueDAP-41875

Jobs can now be moved in the Job Scheduler queue. For that a new checkbox is included in the scheduling sections in Import/ Export/ Workbook Details wizard: 'Bypass Job Queue'. Jobs with that configuration will be picked always first by the Job Scheduler and ignore the maximal concurrent running jobs. A new role capability controls whether a user is allowed to use this option. 



3Workbook functions: New 'REGEXTRACT_LIST' functionDAP-42147

You can now use the 'REGEXTRACT_LIST' function. Using the function with data type 'string' extracts tokens that match a regular expression. It returns 'null' in case the string has no RegEx matches and returns a list instead of a string. If the string has a single RegEx match, the function returns a single element list. If the string has no RegEx matches, the function returns an empty list and if the string has multiple RegEx matches, the function returns all of them as the list elements.

Improvements

1

Supported Hadoop Distributions: Add support for Amazon EMR v6.3.0DAP-42063

Datameer X now supports Amazon EMR version 6.3.0.



2Supported Hadoop Distributions: Add support for Amazon EMR v5.33.0DAP-42064

Datameer X now supports Amazon EMR version 5.33.0. 


3Workbook/ Export : Enable sliding time window export of files by defining the partition column - partitioned exportDAP-39796

You can now use the new placeholder '%partition%' for the target path and the file names for export jobs. This placeholder can only be used, when the source Workbook sheet is partitioned. When set, the placeholder will be replaced by the partition value returned by a partition filter which is configured in the configuration of the export job. At least, if a filter returns more than one partition, the export job will be creating a separate file or folder for each position. 


4Import: Oracle Eloqua - Importing Data into Datameer XDAP-42077

You can now ingest import data from Oracle Eloqua into Datameer X to receive campaign responses. For that, a JDBC driver is needed. 


5REST API: Admins can pause and resume the job scheduler and auto compactionDAP-36390

You can now pause and resume the job scheduler and auto compaction with REST API commands. 


Bug Fixes

1

Workbook: Repoiting - 'NullPointerException' if the column to be repointed is blankDAP-42141

When repointing columns from a source sheet to a duplicated sheet, there is no 'NullPointerException' error anymore.

(tick) Bug fixed.


2

Upgrading Datameer X: Upgrade to Datameer X version 10.1.9 is blockedDAP-42131

After fixing a swallowed SQL sheet and fixing some minor dependencies, the upgrade could be executed successfully.

(tick) Bug fixed.


3

Workbook: Autocomplete in the 'Formula Builder' offers columns from all sheetsDAP-42105

When inserting a formula in the Workbook's 'Formula Builder' only the sheets and columns for the first reference and only the columns from the current sheet are offered for autocompletion. Furthermore, autocomplete filters out dummy columns, e.g. insert a formula in the second column, apply, and then go to the first column. 

(tick) Bug fixed.


4Workbook: Renaming a column with a long name leads to a shift between the column header and the columnDAP-41921

After renaming a column name, no shift is visible between the column header and the column. (tick) Bug fixed.


5Workbook Health Check: Link to open a Workbook still uses the Workbook ID instead of the file IDDAP-42181

When opening a broken Workbook from the Workbook Health Check page, the file ID is used to open a Workbook now.(tick) Bug fixed.


6Workbook: Folder can't be dragged to the root in the Folder Tree panelDAP-42168

You can now drag a folder to the root in the Folder Tree panel. (tick) Bug fixed.


7Export: CSV partitioned export - improve help text and make the partition pattern option only visible on the CSV exportDAP-42138

The general help text for using a partition pattern export is now improved and visible in the CSV based export wizard: "The placeholder %partition% is only processed if the export sheet is partitioned!"(tick) Bug fixed.


8Login: After a successful login, the user must not be redirected to a Web Socket URLDAP-42062

When logging in after an automatical logout due to a user inactivity, a user is now redirected back to the previous location from before the logout. (tick) Bug fixed.


9Workbook: The Workbook view shows an error of a previous job run when triggering a new jobDAP-42099

The error from the former broken Workbook is not displayed anymore when triggering the fixed Workbook and the job graph is being displayed now instead.  (tick) Bug fixed.


10Workbook Settings: 'Data Driven' in the Workbook settings is not disabled when changing a JDBC connection to a session based DAP-40390

When a connection is configured with a session-based authentication and the Workbook is configured as 'Data Driven' by the source sheet, the Workbook is not triggered when the source is not triggered. (tick) Bug fixed.


11Export: Partition export job does not work in cluster modeDAP-42159

The partitioned export job with the pattern '%partition%' works in the cluster mode as expected. (tick) Bug fixed.


12Workbook: Display the autocomplete list for current sheet and column nameDAP-42180

When using a formula that contains the current sheet name and the column name, the autocomplete list is now displayed. (tick) Bug fixed.


...

Section

Datameer X 11.1.3

New Features

1

Supported Hadoop Distributions: Add support for Google Dataproc version 1.5DAP-40353

Datameer X now supports Google Dataproc version 1.5.


Improvements

1

Supported Hadoop Distributions: Add support for Cloudera Private Cloud/ Cloudera Runtime 7.1.6DAP-41823

Datameer X now supports Cloudera Private Cloud/ Cloudera Runtime 7.1.6.



2Admin Plug-ins: ‘plugin-tez’ - Upgrade to TEZ 0.10DAP-41279

After a plug-in patch, the 'plugin-tez' plug-in is now available for Datameer X distributions again.


3Properties: AWS S3 http client max pool size should be configurableDAP-41912

The default maximum connection execution amount is now set to 100. With custom properties, you can change this amount to a higher or lower number. The custom count can also be set via Hadoop property in the cluster settings. 


4Workbook: Create Toolbar button to auto-expand all column width to make all column names visibleDAP-41603

Datameer has now a new toolbar button to expand all column width to make all column names fully visible.


5Workbook: Formula sheet repointingDAP-41549

When changing a formula sheet that points to another sheet, Spectrum Datameer X now detects this changes and displays a dialog: The user can apply the changes to only the current column or to all columns. This dialog is only displayed, when when more than one column is affected. 


6Workbook: validate join sheet creation and provide supportive error messagesDAP-40809

If one is trying to create an invalid join definition, the join validation will give the user a hint why the join can not be created in a warning dialog.

Bug Fixes

1

Workbook: Parquet format - Ingesting creates duplicate 'das' metadata columnsDAP-41874

When ingesting a Parquet file into Datameer by a File Upload, Import Job or Datalink, there will be no more duplicated columns displayed in the tab "Define Fields". 

(tick) Bug fixed.


2

Snowflake Export: Tables are not updating when selecting another schemaDAP-41721

When configuring a Snowflake export or import job, the tables are now updated when changing the schema from the drop-down.

(tick) Bug fixed.


3

Workbook synchronisation: Sheet synchronization - Validation error is still showing even after update DAP-41476

After a formerly incorrect formula has been changed into a valid formula, the validation error is no longer displayed. 

(tick) Bug fixed.


4File Browser: Remove the 'Import Job' tab from the tab bar after the job has been deletedDAP-41635

The 'Import Job' tab is now deleted from the tab bar and is no longer displayed, after the job has been deleted. (tick) Bug fixed.


5File Browser: Job status tooltip for queued jobs is missing position informationDAP-41244

The tooltip now shows the position information for the queue status of a job, e.g. position 2 of 5 queued jobs.(tick) Bug fixed.


6Workbook: Active state of the 'encode column' button is brokenDAP-41317

When the 'Encode Column' view in the Workbook Inspector is enabled, the button is in an active state.(tick) Bug fixed.


7FileBrowser: Right-click in an empty area opens the Browser context menu instead of the Folder Tree context menuDAP-41652

Right-clicking in an empty area within the File Browser under the Folder Tree now opens the Folder Tree context menu.(tick) Bug fixed.


8Workbook Inspector: Encoding inspector fly out always shows "Empty Value"DAP-41722

The fly out within the encoding section in the Workbook Inspector now shows the correct value for the different chars.(tick) Bug fixed.


9Upgrading Datameer X: Datameer X stops serving HTTP requests and returns 504 Gateway timeout errorsDAP-41889

After a new fixed release, no more freezes happen and Datameer X works as expected after the upgrade.(tick) Bug fixed.


10Upgrading Datameer X: Upgrade scripts breaks at the ‘Drop Sink Data Table’ step - ‘A foreign key constraint fails’DAP-41955

The upgrading script has been updated to let the Datameer X upgrade work as expected.(tick) Bug fixed.


11Workbook: Fx function in Workbook is not case sensitiveDAP-41992

Selecting a Fx function in a Workbook highlights the function in the Sheet Inspector with upper or lowercase or mixed letters(tick) Bug fixed.


12Workbook: FilesystemRestController#moveFolder causes an endless loopDAP-41989

No endless loop of error messages is caused anymore when moving folders. When trying to move a folder into its own subfolder, an error message is displayed. (tick) Bug fixed.


13Connections: Snowflake - Jobs using the Snowflake connection are failing & exports are failing as wellDAP-41951

After fixing the Snowflake plug-in, the connections are working as expected and exports can be executed as expected.(tick) Bug fixed.


14REST API: JobExecutionRestControllerV2 does not release the EntityManagerDAP-41922

The REST API for job execution is working as expected again. Jobs can be triggered and stopped with REST API commands.(tick) Bug fixed.


15Workbook: SQL sheet - 'COUNT'/ 'SUM'/ 'AVG'/ ... (DISTINCT) aggregates are not supportedDAP-41878

Aggregates with DISTINCT quantifier work again in SQL sheets. Furthermore multiple DISTINCT aggregates in a single SELECT command on the same column are supported while multiple DISTINCT aggregates with multiple different columns are not supported.(tick) Bug fixed.


...