Aginity Workbench for Hadoop 4.7 Release Notes

These release notes summarize the changes in Aginity Workbench for Hadoop version 4.7. The release notes also contain system requirements and list the known issues with the release.

What's New? (Also See Full List of Changes)

This section provides information about the main new features in version 4.7:

Technical Details and Changes

This section contains details of specific functions and changes that are included in Aginity Workbench 4.7.

Upgrading from Prior Versions

Workbench automatically checks for new updates and displays a dialog box if an update is available. In the dialog box, select Install this update now to download and install the update.

You can also choose to postpone installation of the update until the next time you run Workbench or suppress the update alert.

You can also check for updates manually by clicking Check for Updates on the Help menu and then install an available update by following the instructions in a wizard.

Hardware and Software Support

Aginity Workbench has been tested on Hive 1.1 (CDH 5.4), Hive 0.14, Hive 0.12, and Big SQL (BigInsights 3 and 4).

System Requirements

  • Windows XP or later
  • Windows Installer 3.1
  • .NET Framework 3.5 SP1
  • The IBM Data Server Driver Package is installed on your client computer (for Big SQL connections).
  • Memory: 256 MB RAM
  • Disk space: 100 MB, plus any necessary space for .NET Framework and Windows Installer

Full List of Changes Since Aginity Workbench 4.6

Bug Fixes in Build

Severity Reference Description Existed Since Version Resolution
Major WPD-357 A line "ODBC Version: Unknown or not installed" is displayed in the System Information dialog box when an ODBC driver is not used. 4.6 Fixed. The ODBC Version line is now hidden when an ODBC driver is not used.
Moderate WPD-637 Importing a file into Big SQL causes an error because the length of string columns in the file is calculated in characters. 4.5 Fixed. The length of string columns is now calculated in bytes.
Moderate WPD-699 An error occurs when a user attempts to use the Compare Schemas feature. 4.6 Fixed. The feature now works as expected.
Minor WPD-681 Using semicolons in subqueries causes Workbench to crash. 4.4 Fixed.
Minor WPD-550 In the event of failure to import a CSV file, a user attempts to reopen the file in the Import Wizard from the Job Monitor, but gets an error. 4.5 Fixed. On failure to import a file, a user can now reopen the file to the initial parameters in the Import Wizard by using the failed job in the Job Monitor.
Minor WPD-216 The Help menu contains an empty item under "Check for Updates" and a delimiter followed by no menu items under “Follow us ...” 4.4 Fixed.

Known Issues in Build

Severity Reference Description Workaround
Major WPD-618 Import into Workbench for Hive fails if a user chooses the BIGDECIMAL or NUMERIC data type for the import. These data types are present in Workbench but are not supported by Hive. The BIGDECIMAL and NUMERIC data types will be removed in a future version of Workbench. For now, replace them with other appropriate data types for your import.
Moderate WPD-348 When connected to the Hadoop cluster through Big SQL, a user attempts to insert data into an existing table, but the INSERT statement returns a message saying "0 rows affected" although the rows are in fact inserted. N/A
Trivial APD-3711 When the field type is Date, the year 0 (for example, 0000-01-01) causes an error “Year, Month, and Day parameters describe an un-representable DateTime.” Either cast the date as a VARCHAR or do not use the year 0.
Have more questions? Submit a request


Please sign in to leave a comment.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk