Package com.amazonaws.athena.connectors.snowflake

Class SnowflakeQueryStringBuilder

java.lang.Object

com.amazonaws.athena.connectors.jdbc.manager.JdbcSplitQueryBuilder

com.amazonaws.athena.connectors.snowflake.SnowflakeQueryStringBuilder

public class SnowflakeQueryStringBuilder
extends JdbcSplitQueryBuilder

Extends JdbcSplitQueryBuilder and implements MySql specific SQL clauses for split. MySql provides named partitions which can be used in a FROM clause.

Field Summary

Fields inherited from class com.amazonaws.athena.connectors.jdbc.manager.JdbcSplitQueryBuilder

emptyString

Constructor Summary

Constructors

Constructor	Description
SnowflakeQueryStringBuilder(String quoteCharacters, FederationExpressionParser federationExpressionParser)

Method Summary

Modifier and Type	Method	Description
protected String	appendLimitOffset(Split split)	logic to apply limits in query, if partition value does not contain "-", no limit and offset condition to be applied, else apply limits and offset as per "p-limit-3000-offset-0" pattern.
protected String	getFromClauseWithSplit(String catalog, String schema, String table, Split split)
protected List<String>	getPartitionWhereClauses(Split split)

Methods inherited from class com.amazonaws.athena.connectors.jdbc.manager.JdbcSplitQueryBuilder

appendLimitOffset, buildSql, extractOrderByClause, prepareStatementWithSql, quote, toPredicate

Methods inherited from class java.lang.Object

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

Constructor Detail

SnowflakeQueryStringBuilder

public SnowflakeQueryStringBuilder(String quoteCharacters,
                                   FederationExpressionParser federationExpressionParser)

Method Detail

getFromClauseWithSplit

protected String getFromClauseWithSplit(String catalog,
                                        String schema,
                                        String table,
                                        Split split)

Specified by:

getFromClauseWithSplit in class JdbcSplitQueryBuilder

getPartitionWhereClauses

protected List<String> getPartitionWhereClauses(Split split)

Specified by:

getPartitionWhereClauses in class JdbcSplitQueryBuilder

appendLimitOffset

protected String appendLimitOffset(Split split)

logic to apply limits in query, if partition value does not contain "-", no limit and offset condition to be applied, else apply limits and offset as per "p-limit-3000-offset-0" pattern.

Overrides:

appendLimitOffset in class JdbcSplitQueryBuilder

Parameters:

split -

Returns: