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:
- You now have an application-level setting to specify whether to reuse an open target database connection between query executions.
- An option is now available to trim trailing spaces from strings in a file being imported.
- (If connected to Big SQL) You can achieve faster performance populating the Object Browser with database objects by setting the application to not automatically read certain Hive information for tables in the application options.
- You can turn on a default entity filter to display only relevant database objects in the Object Browser each time you connect to a target database.
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.
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).
- 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
Bug Fixes in Build 18.104.22.1683
|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.|
|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.|