Messages and limitations of the Amazon Athena connector

Message code list of AMAZONATHENA category
Exception messages of AMAZONATHENA category
Limitations of AMAZONATHENA category

Message code list of AMAZONATHENA category

The following message codes correspond to errors that occur in Amazon Athena Connector.

This message code is output when an undefined error occurs.

Cause	Solution
An undefined error occurred.	Check the error message or the help of the operation in which the error has occurred.

Corresponding error

None

AMAZONATHENA0001E

This message code corresponds to errors that occur during database processing.

Cause	Solution
The cause differs according to each error message.	Check the error message and perform the following: Check whether the cause/solution of the error is described in "Exception messages" below. Check whether the cause/solution of the error is described in Limitations of the applied connector. Check whether you can find information related to the error in documents of the connected database.

Cause

Solution

The cause differs according to each error message.

Check the error message and perform the following:

Check whether the cause/solution of the error is described in "Exception messages" below.
Check whether the cause/solution of the error is described in Limitations of the applied connector.
Check whether you can find information related to the error in documents of the connected database.

Corresponding error

java.sql.SQLException

AMAZONATHENA0002E

This message code is output when connection to Amazon Athena fails.

Cause	Solution
The cause differs according to each error message.	Check whether the cause/solution of the error is described in "Exception messages" below.

Corresponding error

software.amazon.awssdk.core.exception.SdkClientException

Exception messages of AMAZONATHENA category

Exception name	Cause	Solution
InputDataNotFoundException	Input data isn't specified.	Specify Input data or draw data flow.
InvalidPropertyConfigurationException	SQL statement isn't set.	Specify SQL statement.
InvalidPropertyConfigurationException Target column is not selected.	Target for Schema definition isn't selected in the Write Table operation.	Select one or more Target for Schema definition.
InvalidPropertyConfigurationException Target column is not selected.	Target for Schema definition isn't selected in the Read Table operation.	Select one or more Target for Schema definition.
InvalidPropertyConfigurationException	Table name isn't set.	Specify Table name.
InvalidPropertyConfigurationException [<Property name>] is required.	<Property name> isn't entered.	Enter <property name>.
java.sql.SQLException	A database access error or some other one has occurred.	Check the SQLException message. SQLException message is based on the specifications of the driver. The cause of the error might be output in SQLException message. For details on messages, contact the database vendor.
ResourceNotFoundException Resource definition is not found. Name: []	Destination isn't specified.	Specify Destination.
ResourceNotFoundException Resource definition is not found. Name: [<connection resource name>]	The resource definition selected in Destination isn't found.	Check the connection resource specified in Destination.
java.sql.SQLException Failed to create connection.	Failed to generate a connection.	Check the URL.
software.amazon.awssdk.core.exception.SdkClientException software.amazon.awssdk.core.exception.SdkClientException: Unable to load region from any of the providers in the chain software.amazon.awssdk.regions.providers.DefaultAwsRegionProviderChain@…	The region isn't found.	Specify a region in the URL.

Supported types

This connector supports the following types.

Type name	Support	Remarks
TINYINT	Yes
BIGINT	Yes
BINARY	Yes
CHAR	Yes
DECIMAL	Yes
INT	Yes
SMALLINT	Yes
FLOAT	Yes
DOUBLE	Yes
STRING	Yes
VARCHAR	Yes
BOOLEAN	Yes
DATE	Yes
TIMESTAMP	Yes
MAP	Limited	Data is handled as String.
STRUCT	Limited	Data is handled as String.
ARRAY	Limited	Data is handled as String.

Yes: Supported.
Limited: Supported with limitations.
No: Not supported.

Common to all operations

Specification limits

Due to the specification limits on the AWS service, if a database name specified in the connection contains multi-byte characters, you need to specify a table in the "<database name>.<table name>" format when you specify the table.

Read Table

Specification limits

Display in the table list
- Tables that exist outside the data source specified in the connection are displayed in the format "<data source name>.<database name>.<table name>" .
- Tables that exist outside the data source specified in the connection are displayed in the format "<database name>.<table name>".

Execute Select SQL

Specification limits

None.