Package com.amazonaws.athena.connectors.jdbc.manager

Class JdbcRecordHandler

java.lang.Object

com.amazonaws.athena.connector.lambda.handlers.RecordHandler

com.amazonaws.athena.connectors.jdbc.manager.JdbcRecordHandler

All Implemented Interfaces:

com.amazonaws.services.lambda.runtime.RequestStreamHandler

Direct Known Subclasses:

DataLakeGen2RecordHandler, Db2As400RecordHandler, Db2RecordHandler, HiveRecordHandler, HiveRecordHandler, ImpalaRecordHandler, MultiplexingJdbcRecordHandler, MySqlRecordHandler, OracleRecordHandler, PostGreSqlRecordHandler, SaphanaRecordHandler, SnowflakeRecordHandler, SqlServerRecordHandler, SynapseRecordHandler, TeradataRecordHandler

public abstract class JdbcRecordHandler
extends RecordHandler

Abstracts JDBC record handler and provides common reusable split records handling.

Field Summary

Fields

Modifier and Type	Field	Description
protected JdbcQueryPassthrough	queryPassthrough

Fields inherited from class com.amazonaws.athena.connector.lambda.handlers.RecordHandler

configOptions

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	JdbcRecordHandler(com.amazonaws.services.s3.AmazonS3 amazonS3, com.amazonaws.services.secretsmanager.AWSSecretsManager secretsManager, com.amazonaws.services.athena.AmazonAthena athena, DatabaseConnectionConfig databaseConnectionConfig, JdbcConnectionFactory jdbcConnectionFactory, Map<String,String> configOptions)
protected	JdbcRecordHandler(String sourceType, Map<String,String> configOptions)	Used only by Multiplexing handler.

Method Summary

Modifier and Type	Method	Description
PreparedStatement	buildQueryPassthroughSql(Connection jdbcConnection, Constraints constraints)
abstract PreparedStatement	buildSplitSql(Connection jdbcConnection, String catalogName, TableName tableName, org.apache.arrow.vector.types.pojo.Schema schema, Constraints constraints, Split split)	Builds split SQL string and returns prepared statement.
protected JdbcCredentialProvider	getCredentialProvider()
protected JdbcConnectionFactory	getJdbcConnectionFactory()
protected Extractor	makeExtractor(org.apache.arrow.vector.types.pojo.Field field, ResultSet resultSet, Map<String,String> partitionValues)	Creates an Extractor for the given field.
protected FieldWriterFactory	makeFactory(org.apache.arrow.vector.types.pojo.Field field)	Create a field extractor for complex List type.
void	readWithConstraint(BlockSpiller blockSpiller, ReadRecordsRequest readRecordsRequest, QueryStatusChecker queryStatusChecker)	A more stream lined option for reading the row data associated with the provided Split.

Methods inherited from class com.amazonaws.athena.connector.lambda.handlers.RecordHandler

doHandleRequest, doReadRecords, getSecret, getSpillConfig, handleRequest, onPing, resolveSecrets

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

queryPassthrough

protected final JdbcQueryPassthrough queryPassthrough

Constructor Detail

JdbcRecordHandler

protected JdbcRecordHandler(String sourceType,
                            Map<String,String> configOptions)

Used only by Multiplexing handler. All invocations will be delegated to respective database handler.

JdbcRecordHandler

protected JdbcRecordHandler(com.amazonaws.services.s3.AmazonS3 amazonS3,
                            com.amazonaws.services.secretsmanager.AWSSecretsManager secretsManager,
                            com.amazonaws.services.athena.AmazonAthena athena,
                            DatabaseConnectionConfig databaseConnectionConfig,
                            JdbcConnectionFactory jdbcConnectionFactory,
                            Map<String,String> configOptions)

Method Detail

getJdbcConnectionFactory

protected JdbcConnectionFactory getJdbcConnectionFactory()

getCredentialProvider

protected JdbcCredentialProvider getCredentialProvider()

readWithConstraint

public void readWithConstraint(BlockSpiller blockSpiller,
                               ReadRecordsRequest readRecordsRequest,
                               QueryStatusChecker queryStatusChecker)
                        throws Exception

Description copied from class: RecordHandler

A more stream lined option for reading the row data associated with the provided Split. This method differs from doReadRecords(...) in that the SDK handles more of the request lifecycle, leaving you to focus more closely on the task of actually reading from your source.

Specified by:

readWithConstraint in class RecordHandler

Parameters:

blockSpiller - A BlockSpiller that should be used to write the row data associated with this Split. The BlockSpiller automatically handles chunking the response, encrypting, and spilling to S3.

readRecordsRequest - Details of the read request, including: 1. The Split 2. The Catalog, Database, and Table the read request is for. 3. The filtering predicate (if any) 4. The columns required for projection.

queryStatusChecker - A QueryStatusChecker that you can use to stop doing work for a query that has already terminated

Throws:

Exception

makeFactory

protected FieldWriterFactory makeFactory(org.apache.arrow.vector.types.pojo.Field field)

Create a field extractor for complex List type.

Parameters:

field - Field's metadata information.

Returns:

Extractor for the List type.

makeExtractor

protected Extractor makeExtractor(org.apache.arrow.vector.types.pojo.Field field,
                                  ResultSet resultSet,
                                  Map<String,String> partitionValues)

Creates an Extractor for the given field. In this example the extractor just creates some random data.

buildSplitSql

public abstract PreparedStatement buildSplitSql(Connection jdbcConnection,
                                                String catalogName,
                                                TableName tableName,
                                                org.apache.arrow.vector.types.pojo.Schema schema,
                                                Constraints constraints,
                                                Split split)
                                         throws SQLException

Builds split SQL string and returns prepared statement.

Parameters:

jdbcConnection - jdbc connection. See Connection

catalogName - Athena provided catalog name.

tableName - database table name.

schema - table schema.

constraints - constraints to push down to the database.

split - table split.

Returns:

prepared statement with sql. See PreparedStatement

Throws:

SQLException - JDBC database exception.

buildQueryPassthroughSql

public PreparedStatement buildQueryPassthroughSql(Connection jdbcConnection,
                                                  Constraints constraints)
                                           throws SQLException

Throws:

SQLException