April 4, 2017
Added support for S3 data encryption and released JDBC driver update (version 1.0.1) with encryption support, improvements, and bug fixes.
Added the following encryption features (for more information, see Configuring Encryption Options):
- Support for querying encrypted data in Amazon S3.
- Support for encrypting Athena query results.
A new version of the JDBC driver (AthenaJDBC41-1.0.1.jar) supports new encryption features, adds improvements, and fixes issues.
Added the ability to add, replace, and change columns using
ALTER TABLE. See Alter Column in Hive documentation.
Added support for querying LZO-compressed data.
- Better JDBC query performance with page-size improvements, returning 1,000 rows instead of 100.
- Added ability to cancel a query using the JDBC driver interface.
- Added ability to specify JDBC options in the JDBC connection URL. For more information, see JDBC Driver Options.
- Added PROXY setting in the driver which can now be set using the ClientConfiguration in the AWS SDK for Java.
Fixed the following bugs:
- Throttling errors would occur when multiple queries were issued using the JDBC driver interface.
- The JDBC driver would abort when projecting a decimal data type.
- The JDBC driver would return every data type as a string, regardless of how the data type was defined in the table. For example, selecting a column defined as an
INTdata type using
resultSet.GetObject()would return a
STRINGdata type instead of
- The JDBC driver would verify credentials at the time a connection was made, rather than at the time a query would run.
- Queries made through the JDBC driver would fail when a schema was specified along with the URL.