;
```
There are no changes in the way you run SQL statements or make JDBC API calls to the driver. The driver passes the workgroup name to Athena.
For information about differences introduced with workgroups, see [Use Athena workgroup APIs](workgroups-api-list.md) and [Troubleshoot workgroup errors](workgroups-troubleshooting.md).
+ Improved the JSON OpenX SerDe used in Athena. The improvements include, but are not limited to, the following:
+ Support for the `ConvertDotsInJsonKeysToUnderscores` property. When set to `TRUE`, it allows the SerDe to replace the dots in key names with underscores. For example, if the JSON dataset contains a key with the name `"a.b"`, you can use this property to define the column name to be `"a_b"` in Athena. The default is `FALSE`. By default, Athena does not allow dots in column names.
+ Support for the `case.insensitive` property. By default, Athena requires that all keys in your JSON dataset use lowercase. Using `WITH SERDE PROPERTIES ("case.insensitive"= FALSE;)` allows you to use case-sensitive key names in your data. The default is `TRUE`. When set to `TRUE`, the SerDe converts all uppercase columns to lowercase.
For more information, see [OpenX JSON SerDe](openx-json-serde.md).
+ Fixed an issue where Athena returned `"access denied"` error messages, when it processed Amazon S3 objects that were archived to Glacier by Amazon S3 lifecycle policies. As a result of fixing this issue, Athena ignores objects transitioned to the `GLACIER` storage class. Athena does not support querying data from the `GLACIER` storage class.
For more information, see [Amazon S3 considerations](creating-tables.md#s3-considerations) and [Transitioning to the GLACIER Storage Class (Object Archival) ](https://docs.aws.amazon.com/AmazonS3/latest/userguide/lifecycle-transition-general-considerations.html#before-deciding-to-archive-objects) in the *Amazon Simple Storage Service User Guide*.
+ Added examples for querying Network Load Balancer access logs that receive information about the Transport Layer Security (TLS) requests. For more information, see [Query Network Load Balancer logs](networkloadbalancer-classic-logs.md).
## Athena release notes for 2018
### November 20, 2018
Published on *2018-11-20*
Released the new versions of the JDBC and ODBC driver with support for federated access to Athena API with the AD FS and SAML 2.0 (Security Assertion Markup Language 2.0). For details, see the [JDBC Driver Release Notes](https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC_2.0.6/docs/release-notes.txt) and [ODBC Driver Release Notes](https://downloads.athena.us-east-1.amazonaws.com/drivers/ODBC/SimbaAthenaODBC_1.0.4/release-notes.txt).
With this release, federated access to Athena is supported for the Active Directory Federation Service (AD FS 3.0). Access is established through the versions of JDBC or ODBC drivers that support SAML 2.0. For information about configuring federated access to the Athena API, see [Enable federated access to the Athena API](access-federation-saml.md).
To download the JDBC driver version 2.0.6 and its documentation, see [Connect to Amazon Athena with JDBC](connect-with-jdbc.md). For information about this version, see [JDBC Driver Release Notes](https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC_2.0.6/docs/release-notes.txt).
To download the ODBC driver version 1.0.4 and its documentation, see [Connect to Amazon Athena with ODBC](connect-with-odbc.md). For information about this version, [ODBC Driver Release Notes](https://downloads.athena.us-east-1.amazonaws.com/drivers/ODBC/SimbaAthenaODBC_1.0.4/release-notes.txt).
For more information about SAML 2.0 support in AWS, see [About SAML 2.0 Federation](https://docs.aws.amazon.com/IAM/latest/UserGuide/id_roles_providers_saml.html) in the *IAM User Guide*.
### October 15, 2018
Published on *2018-10-15*
If you have upgraded to the AWS Glue Data Catalog, there are two new features that provide support for:
+ Encryption of the Data Catalog metadata. If you choose to encrypt metadata in the Data Catalog, you must add specific policies to Athena. For more information, see [Access to Encrypted Metadata in the AWS Glue Data Catalog](access-encrypted-data-glue-data-catalog.md).
+ Fine-grained permissions to access resources in the AWS Glue Data Catalog. You can now define identity-based (IAM) policies that restrict or allow access to specific databases and tables from the Data Catalog used in Athena. For more information, see [Configure access to databases and tables in the AWS Glue Data Catalog](fine-grained-access-to-glue-resources.md).
**Note**
Data resides in the Amazon S3 buckets, and access to it is controlled by [Control access to Amazon S3 from Athena](s3-permissions.md). To access data in databases and tables, continue to use access control policies to Amazon S3 buckets that store the data.
### October 10, 2018
Published on *2018-10-10*
Athena supports `CREATE TABLE AS SELECT`, which creates a table from the result of a `SELECT` query statement. For details, see [Creating a Table from Query Results (CTAS)](https://docs.aws.amazon.com/athena/latest/ug/ctas.html).
Before you create CTAS queries, it is important to learn about their behavior in the Athena documentation. It contains information about the location for saving query results in Amazon S3, the list of supported formats for storing CTAS query results, the number of partitions you can create, and supported compression formats. For more information, see [Considerations and limitations for CTAS queries](ctas-considerations-limitations.md).
Use CTAS queries to:
+ [Create a table from query results](ctas.md) in one step.
+ [Create CTAS queries in the Athena console](ctas-console.md), using [Examples](ctas-examples.md). For information about syntax, see [CREATE TABLE AS](create-table-as.md).
+ Transform query results into other storage formats, such as PARQUET, ORC, AVRO, JSON, and TEXTFILE. For more information, see [Considerations and limitations for CTAS queries](ctas-considerations-limitations.md) and [Use columnar storage formats](columnar-storage.md).
### September 6, 2018
Published on *2018-09-06*
Released the new version of the ODBC driver (version 1.0.3). The new version of the ODBC driver streams results by default, instead of paging through them, allowing business intelligence tools to retrieve large data sets faster. This version also includes improvements, bug fixes, and an updated documentation for *"Using SSL with a Proxy Server"*. For details, see the [Release Notes](https://downloads.athena.us-east-1.amazonaws.com/drivers/ODBC/SimbaAthenaODBC_1.0.3/release-notes.txt) for the driver.
For downloading the ODBC driver version 1.0.3 and its documentation, see [Connect to Amazon Athena with ODBC](connect-with-odbc.md).
The streaming results feature is available with this new version of the ODBC driver. It is also available with the JDBC driver. For information about streaming results, see the [ ODBC Driver Installation and Configuration Guide](https://downloads.athena.us-east-1.amazonaws.com/drivers/ODBC/SimbaAthenaODBC_1.0.3/Simba+Athena+ODBC+Install+and+Configuration+Guide.pdf), and search for **UseResultsetStreaming**.
The ODBC driver version 1.0.3 is a drop-in replacement for the previous version of the driver. We recommend that you migrate to the current driver.
**Important**
To use the ODBC driver version 1.0.3, follow these requirements:
Keep the port 444 open to outbound traffic.
Add the `athena:GetQueryResultsStream` policy action to the list of policies for Athena. This policy action is not exposed directly with the API and is only used with the ODBC and JDBC drivers, as part of streaming results support. For an example policy, see [AWS managed policy: AWSQuicksightAthenaAccess](security-iam-awsmanpol.md#awsquicksightathenaaccess-managed-policy).
### August 23, 2018
Published on *2018-08-23*
Added support for these DDL-related features and fixed several bugs, as follows:
+ Added support for `BINARY` and `DATE` data types for data in Parquet, and for `DATE` and `TIMESTAMP` data types for data in Avro.
+ Added support for `INT` and `DOUBLE` in DDL queries. `INTEGER` is an alias to `INT`, and `DOUBLE PRECISION` is an alias to `DOUBLE`.
+ Improved performance of `DROP TABLE` and `DROP DATABASE` queries.
+ Removed the creation of `_$folder$` object in Amazon S3 when a data bucket is empty.
+ Fixed an issue where `ALTER TABLE ADD PARTITION` threw an error when no partition value was provided.
+ Fixed an issue where `DROP TABLE` ignored the database name when checking partitions after the qualified name had been specified in the statement.
For more about the data types supported in Athena, see [Data types in Amazon Athena](data-types.md).
For information about supported data type mappings between types in Athena, the JDBC driver, and Java data types, see the *"Data Types"* section in the [JDBC Driver Installation and Configuration Guide](https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC_2.0.5/docs/Simba+Athena+JDBC+Driver+Install+and+Configuration+Guide.pdf).
### August 16, 2018
Published on *2018-08-16*
Released the JDBC driver version 2.0.5. The new version of the JDBC driver streams results by default, instead of paging through them, allowing business intelligence tools to retrieve large data sets faster. Compared to the previous version of the JDBC driver, there are the following performance improvements:
+ Approximately 2x performance increase when fetching less than 10K rows.
+ Approximately 5-6x performance increase when fetching more than 10K rows.
The streaming results feature is available only with the JDBC driver. It is not available with the ODBC driver. You cannot use it with the Athena API. For information about streaming results, see the [ JDBC Driver Installation and Configuration Guide](https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC_2.0.5/docs/Simba+Athena+JDBC+Driver+Install+and+Configuration+Guide.pdf), and search for **UseResultsetStreaming**.
For downloading the JDBC driver version 2.0.5 and its documentation, see [Connect to Amazon Athena with JDBC](connect-with-jdbc.md).
The JDBC driver version 2.0.5 is a drop-in replacement for the previous version of the driver (2.0.2). To ensure that you can use the JDBC driver version 2.0.5, add the `athena:GetQueryResultsStream` policy action to the list of policies for Athena. This policy action is not exposed directly with the API and is only used with the JDBC driver, as part of streaming results support. For an example policy, see [AWS managed policy: AWSQuicksightAthenaAccess](security-iam-awsmanpol.md#awsquicksightathenaaccess-managed-policy). For more information about migrating from version 2.0.2 to version 2.0.5 of the driver, see the [JDBC Driver Migration Guide](https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC_2.0.5/docs/Simba+Athena+JDBC+Driver+Migration+Guide.pdf).
If you are migrating from a 1.x driver to a 2.x driver, you will need to migrate your existing configurations to the new configuration. We highly recommend that you migrate to the current version of the driver. For more information, see the [JDBC Driver Migration Guide](https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC_2.0.5/docs/Simba+Athena+JDBC+Driver+Migration+Guide.pdf).
### August 7, 2018
Published on *2018-08-07*
You can now store Amazon Virtual Private Cloud flow logs directly in Amazon S3 in a GZIP format, where you can query them in Athena. For information, see [Query Amazon VPC flow logs](vpc-flow-logs.md) and [ Amazon VPC Flow Logs can now be delivered to S3](https://aws.amazon.com/about-aws/whats-new/2018/08/amazon-vpc-flow-logs-can-now-be-delivered-to-s3/).
### June 5, 2018
Published on *2018-06-05*
**Topics**
+ [Support for Views](#support-for-views)
+ [Improvements and Updates to Error Messages](#improvements)
+ [Bug Fixes](#bug-fixes)
#### Support for Views
Added support for views. You can now use [CREATE VIEW and CREATE PROTECTED MULTI DIALECT VIEW](create-view.md), [DESCRIBE VIEW](describe-view.md), [DROP VIEW](drop-view.md), [SHOW CREATE VIEW](show-create-view.md), and [SHOW VIEWS](show-views.md) in Athena. The query that defines the view runs each time you reference the view in your query. For more information, see [Work with views](views.md).
#### Improvements and Updates to Error Messages
+ Included a GSON 2.8.0 library into the CloudTrail SerDe, to solve an issue with the CloudTrail SerDe and enable parsing of JSON strings.
+ Enhanced partition schema validation in Athena for Parquet, and, in some cases, for ORC, by allowing reordering of columns. This enables Athena to better deal with changes in schema evolution over time, and with tables added by the AWS Glue Crawler. For more information, see [Handle schema updates](handling-schema-updates-chapter.md).
+ Added parsing support for `SHOW VIEWS`.
+ Made the following improvements to most common error messages:
+ Replaced an Internal Error message with a descriptive error message when a SerDe fails to parse the column in an Athena query. Previously, Athena issued an internal error in cases of parsing errors. The new error message reads: "HIVE\$1BAD\$1DATA: Error parsing field value for field 0: java.lang.String cannot be cast to org.openx.data.jsonserde.json.JSONObject".
+ Improved error messages about insufficient permissions by adding more detail.
#### Bug Fixes
Fixed the following bugs:
+ Fixed an issue that enables the internal translation of `REAL` to `FLOAT` data types. This improves integration with the AWS Glue crawler that returns `FLOAT` data types.
+ Fixed an issue where Athena was not converting AVRO `DECIMAL` (a logical type) to a `DECIMAL` type.
+ Fixed an issue where Athena did not return results for queries on Parquet data with `WHERE` clauses that referenced values in the `TIMESTAMP` data type.
### May 17, 2018
Published on *2018-05-17*
Increased query concurrency quota in Athena from five to twenty. This means that you can submit and run up to twenty `DDL` queries and twenty `SELECT` queries at a time. Note that the concurrency quotas are separate for `DDL` and `SELECT` queries.
Concurrency quotas in Athena are defined as the number of queries that can be submitted to the service concurrently. You can submit up to twenty queries of the same type (`DDL` or `SELECT`) at a time. If you submit a query that exceeds the concurrent query quota, the Athena API displays an error message.
After you submit your queries to Athena, it processes the queries by assigning resources based on the overall service load and the amount of incoming requests. We continuously monitor and make adjustments to the service so that your queries process as fast as possible.
For information, see [Service Quotas](service-limits.md). This is an adjustable quota. You can use the [Service Quotas console](https://console.aws.amazon.com/servicequotas/home?region=us-east-1#!/services/athena/quotas) to request a quota increase for concurrent queries.
### April 19, 2018
Published on *2018-04-19*
Released the new version of the JDBC driver (version 2.0.2) with support for returning the `ResultSet` data as an Array data type, improvements, and bug fixes. For details, see the [Release Notes](https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC_2.0.2/docs/release-notes.txt) for the driver.
For information about downloading the new JDBC driver version 2.0.2 and its documentation, see [Connect to Amazon Athena with JDBC](connect-with-jdbc.md).
The latest version of the JDBC driver is 2.0.2. If you are migrating from a 1.x driver to a 2.x driver, you will need to migrate your existing configurations to the new configuration. We highly recommend that you migrate to the current driver.
For information about the changes introduced in the new version of the driver, the version differences, and examples, see the [JDBC Driver Migration Guide](https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC_2.0.2/docs/Simba+Athena+JDBC+Driver+Migration+Guide.pdf).
### April 6, 2018
Published on *2018-04-06*
Use auto-complete to type queries in the Athena console.
### March 15, 2018
Published on *2018-03-15*
Added an ability to automatically create Athena tables for CloudTrail log files directly from the CloudTrail console. For information, see [Use the CloudTrail console to create an Athena table for CloudTrail logs](create-cloudtrail-table-ct.md).
### February 2, 2018
Published on *2018-02-12*
Added an ability to securely offload intermediate data to disk for memory-intensive queries that use the `GROUP BY` clause. This improves the reliability of such queries, preventing "Query resource exhausted" errors.
### January 19, 2018
Published on *2018-01-19*
Athena uses Presto, an open-source distributed query engine, to run queries.
With Athena, there are no versions to manage. We have transparently upgraded the underlying engine in Athena to a version based on Presto version 0.172. No action is required on your end.
With the upgrade, you can now use Presto 0.172 Functions and Operators, including Presto 0.172 Lambda Expressions in Athena.
Major updates for this release, including the community-contributed fixes, include:
+ Support for ignoring headers. You can use the `skip.header.line.count` property when defining tables, to allow Athena to ignore headers. This is supported for queries that use the [LazySimpleSerDe](lazy-simple-serde.md) and [OpenCSV SerDe](csv-serde.md), and not for Grok or Regex SerDes.
+ Support for the `CHAR(n)` data type in `STRING` functions. The range for `CHAR(n)` is `[1.255]`, while the range for `VARCHAR(n)` is `[1,65535]`.
+ Support for correlated subqueries.
+ Support for Presto Lambda expressions and functions.
+ Improved performance of the `DECIMAL` type and operators.
+ Support for filtered aggregations, such as `SELECT sum(col_name) FILTER`, where `id > 0`.
+ Push-down predicates for the `DECIMAL`, `TINYINT`, `SMALLINT`, and `REAL` data types.
+ Support for quantified comparison predicates: `ALL`, `ANY`, and `SOME`.
+ Added functions: [https://prestodb.io/docs/current/functions/array.html#arrays_overlap](https://prestodb.io/docs/current/functions/array.html#arrays_overlap), [https://prestodb.io/docs/current/functions/array.html#array_except](https://prestodb.io/docs/current/functions/array.html#array_except), [https://prestodb.io/docs/current/functions/string.html#levenshtein_distance](https://prestodb.io/docs/current/functions/string.html#levenshtein_distance), [https://prestodb.io/docs/current/functions/string.html#codepoint](https://prestodb.io/docs/current/functions/string.html#codepoint), [https://prestodb.io/docs/current/functions/aggregate.html#skewness](https://prestodb.io/docs/current/functions/aggregate.html#skewness), [https://prestodb.io/docs/current/functions/aggregate.html#kurtosis](https://prestodb.io/docs/current/functions/aggregate.html#kurtosis), and [https://prestodb.io/docs/current/functions/conversion.html#typeof](https://prestodb.io/docs/current/functions/conversion.html#typeof).
+ Added a variant of the [https://prestodb.io/docs/current/functions/datetime.html#from_unixtime](https://prestodb.io/docs/current/functions/datetime.html#from_unixtime) function that takes a timezone argument.
+ Added the [https://prestodb.io/docs/current/functions/aggregate.html#bitwise_and_agg](https://prestodb.io/docs/current/functions/aggregate.html#bitwise_and_agg) and [https://prestodb.io/docs/current/functions/aggregate.html#bitwise_or_agg](https://prestodb.io/docs/current/functions/aggregate.html#bitwise_or_agg) aggregation functions.
+ Added the [https://prestodb.io/docs/current/functions/binary.html#xxhash64](https://prestodb.io/docs/current/functions/binary.html#xxhash64) and [https://prestodb.io/docs/current/functions/binary.html#to_big_endian_64](https://prestodb.io/docs/current/functions/binary.html#to_big_endian_64) functions.
+ Added support for escaping double quotes or backslashes using a backslash with a JSON path subscript to the [https://prestodb.io/docs/current/functions/json.html#json_extract](https://prestodb.io/docs/current/functions/json.html#json_extract) and [https://prestodb.io/docs/current/functions/json.html#json_extract_scalar](https://prestodb.io/docs/current/functions/json.html#json_extract_scalar) functions. This changes the semantics of any invocation using a backslash, as backslashes were previously treated as normal characters.
For more information about functions and operators, see [DML queries, functions, and operators](dml-queries-functions-operators.md) in this guide, and [Functions and operators](https://prestodb.io/docs/current/functions.html) in the Presto documentation.
Athena does not support all of Presto's features. For more information, see [Limitations](other-notable-limitations.md).
## Athena release notes for 2017
### November 13, 2017
Published on *2017-11-13*
Added support for connecting Athena to the ODBC Driver. For information, see [Connect to Amazon Athena with ODBC](connect-with-odbc.md).
### November 1, 2017
Published on *2017-11-01*
Added support for querying geospatial data, and for Asia Pacific (Seoul), Asia Pacific (Mumbai), and EU (London) regions. For information, see [Query geospatial data](querying-geospatial-data.md) and [AWS Regions and Endpoints](https://docs.aws.amazon.com/general/latest/gr/rande.html#athena).
### October 19, 2017
Published on *2017-10-19*
Added support for EU (Frankfurt). For a list of supported regions, see [AWS Regions and Endpoints](https://docs.aws.amazon.com/general/latest/gr/rande.html#athena).
### October 3, 2017
Published on *2017-10-03*
Create named Athena queries with CloudFormation. For more information, see [AWS::Athena::NamedQuery](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-athena-namedquery.html) in the *AWS CloudFormation User Guide*.
### September 25, 2017
Published on *2017-09-25*
Added support for Asia Pacific (Sydney). For a list of supported regions, see [AWS Regions and Endpoints](https://docs.aws.amazon.com/general/latest/gr/rande.html#athena).
### August 14, 2017
Published on *2017-08-14*
Added integration with the AWS Glue Data Catalog and a migration wizard for updating from the Athena managed data catalog to the AWS Glue Data Catalog. For more information, see [Use AWS Glue Data Catalog to connect to your data](data-sources-glue.md).
### August 4, 2017
Published on *2017-08-04*
Added support for Grok SerDe, which provides easier pattern matching for records in unstructured text files such as logs. For more information, see [Grok SerDe](grok-serde.md). Added keyboard shortcuts to scroll through query history using the console (CTRL \$1 ⇧/⇩ using Windows, CMD \$1 ⇧/⇩ using Mac).
### June 22, 2017
Published on *2017-06-22*
Added support for Asia Pacific (Tokyo) and Asia Pacific (Singapore). For a list of supported regions, see [AWS Regions and Endpoints](https://docs.aws.amazon.com/general/latest/gr/rande.html#athena).
### June 8, 2017
Published on *2017-06-08*
Added support for Europe (Ireland). For more information, see [AWS Regions and Endpoints](https://docs.aws.amazon.com/general/latest/gr/rande.html#athena).
### May 19, 2017
Published on *2017-05-19*
Added an Amazon Athena API and AWS CLI support for Athena; updated JDBC driver to version 1.1.0; fixed various issues.
+ Amazon Athena enables application programming for Athena. For more information, see [Amazon Athena API Reference](https://docs.aws.amazon.com/athena/latest/APIReference/). The latest AWS SDKs include support for the Athena API. For links to documentation and downloads, see the *SDKs* section in [Tools for Amazon Web Services](https://aws.amazon.com/tools/).
+ The AWS CLI includes new commands for Athena. For more information, see the [Amazon Athena API Reference](https://docs.aws.amazon.com/athena/latest/APIReference/).
+ A new JDBC driver 1.1.0 is available, which supports the new Athena API as well as the latest features and bug fixes. Download the driver at [ https://downloads.athena.us-east-1.amazonaws.com/drivers/AthenaJDBC41-1.1.0.jar](https://downloads.athena.us-east-1.amazonaws.com/drivers/AthenaJDBC41-1.1.0.jar). We recommend upgrading to the latest Athena JDBC driver; however, you may still use the earlier driver version. Earlier driver versions do not support the Athena API. For more information, see [Connect to Amazon Athena with JDBC](connect-with-jdbc.md).
+ Actions specific to policy statements in earlier versions of Athena have been deprecated. If you upgrade to JDBC driver version 1.1.0 and have customer-managed or inline IAM policies attached to JDBC users, you must update the IAM policies. In contrast, earlier versions of the JDBC driver do not support the Athena API, so you can specify only deprecated actions in policies attached to earlier version JDBC users. For this reason, you shouldn't need to update customer-managed or inline IAM policies.
+ These policy-specific actions were used in Athena before the release of the Athena API. Use these deprecated actions in policies **only** with JDBC drivers earlier than version 1.1.0. If you are upgrading the JDBC driver, replace policy statements that allow or deny deprecated actions with the appropriate API actions as listed or errors will occur:
| Deprecated Policy-Specific Action | Corresponding Athena API Action |
| --- |--- |
| athena:RunQuery
| athena:StartQueryExecution
|
| athena:CancelQueryExecution
| athena:StopQueryExecution
|
| athena:GetQueryExecutions
| athena:ListQueryExecutions
|
#### Improvements
+ Increased the query string length limit to 256 KB.
#### Bug Fixes
+ Fixed an issue that caused query results to look malformed when scrolling through results in the console.
+ Fixed an issue where a `\u0000` character string in Amazon S3 data files would cause errors.
+ Fixed an issue that caused requests to cancel a query made through the JDBC driver to fail.
+ Fixed an issue that caused the AWS CloudTrail SerDe to fail with Amazon S3 data in US East (Ohio).
+ Fixed an issue that caused `DROP TABLE` to fail on a partitioned table.
### April 4, 2017
Published on *2017-04-04*
Added support for Amazon S3 data encryption and released JDBC driver update (version 1.0.1) with encryption support, improvements, and bug fixes.
#### Features
+ Added the following encryption features:
+ Support for querying encrypted data in Amazon S3.
+ Support for encrypting Athena query results.
+ A new version of the driver supports new encryption features, adds improvements, and fixes issues.
+ Added the ability to add, replace, and change columns using `ALTER TABLE`. For more information, see [Alter Column](https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterColumn) in the Hive documentation.
+ Added support for querying LZO-compressed data.
For more information, see [Encryption at rest](encryption.md).
#### Improvements
+ 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. See [Connect to Amazon Athena with JDBC](connect-with-jdbc.md) for the most current JDBC driver.
+ Added PROXY setting in the driver, which can now be set using [ClientConfiguration](https://docs.aws.amazon.com/AWSJavaSDK/latest/javadoc/com/amazonaws/ClientConfiguration.html) in the AWS SDK for Java.
#### Bug Fixes
Fixed the following bugs:
+ Throttling errors would occur when multiple queries were issued using the JDBC driver interface.
+ The JDBC driver would stop 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 `INT` data type using `resultSet.GetObject()` would return a `STRING` data type instead of `INT`.
+ 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.
### March 24, 2017
Published on *2017-03-24*
Added the AWS CloudTrail SerDe, improved performance, fixed partition issues.
#### Features
+ Added the AWS CloudTrail SerDe, which has since been superseded by the [Hive JSON SerDe](hive-json-serde.md) for reading CloudTrail logs. For information about querying CloudTrail logs, see [Query AWS CloudTrail logs](cloudtrail-logs.md).
#### Improvements
+ Improved performance when scanning a large number of partitions.
+ Improved performance on `MSCK Repair Table` operation.
+ Added ability to query Amazon S3 data stored in regions other than your primary Region. Standard inter-region data transfer rates for Amazon S3 apply in addition to standard Athena charges.
#### Bug Fixes
+ Fixed a bug where a "table not found error" might occur if no partitions are loaded.
+ Fixed a bug to avoid throwing an exception with `ALTER TABLE ADD PARTITION IF NOT EXISTS` queries.
+ Fixed a bug in `DROP PARTITIONS`.
### February 20, 2017
Published on *2017-02-20*
Added support for AvroSerDe and OpenCSVSerDe, US East (Ohio) Region, and bulk editing columns in the console wizard. Improved performance on large Parquet tables.
#### Features
+ **Introduced support for new SerDes:**
+ [Avro SerDe](avro-serde.md)
+ [Open CSV SerDe for processing CSV](csv-serde.md)
+ **US East (Ohio)** Region (**us-east-2**) launch. You can now run queries in this region.
+ You can now use the **Create Table From S3 bucket data** form to define table schema in bulk. In the query editor, choose **Create**, **S3 bucket data**, and then choose **Bulk add columns** in the **Column details** section.
![\[The Bulk add columns option.\]](http://docs.aws.amazon.com/athena/latest/ug/images/bulk-add.png)
Type name value pairs in the text box and choose **Add**.
![\[The Bulk add columns text box.\]](http://docs.aws.amazon.com/athena/latest/ug/images/bulk_column.png)
#### Improvements
+ Improved performance on large Parquet tables.