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)
String	getBaseExportSQLString(String catalog, String schema, String table, org.apache.arrow.vector.types.pojo.Schema tableSchema, Constraints constraints)
protected String	getFromClauseWithSplit(String catalog, String schema, String table, Split split)
protected List<String>	getPartitionWhereClauses(Split split)
protected org.apache.calcite.sql.SqlDialect	getSqlDialect()
protected org.apache.calcite.sql.SqlDialect	getSqlDialect(boolean catalogCasingFilterUpperCase)	Returns the SQL dialect to use for query generation with catalog casing filter support.
protected String	quote(String name)
protected String	singleQuote(String name)

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

addPartitionWhereClauses, appendLimitOffset, appendLimitOffsetWithValue, buildSql, buildSQLStringLiteral, extractOrderByClause, prepareStatementWithCalciteSql, prepareStatementWithSql, 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

getBaseExportSQLString

public String getBaseExportSQLString(String catalog,
                                     String schema,
                                     String table,
                                     org.apache.arrow.vector.types.pojo.Schema tableSchema,
                                     Constraints constraints)
                              throws SQLException

Throws:

SQLException

quote

protected String quote(String name)

Overrides:

quote in class JdbcSplitQueryBuilder

singleQuote

protected String singleQuote(String name)

appendLimitOffset

protected String appendLimitOffset(Split split)

Overrides:

appendLimitOffset in class JdbcSplitQueryBuilder

getSqlDialect

protected org.apache.calcite.sql.SqlDialect getSqlDialect()

Overrides:

getSqlDialect in class JdbcSplitQueryBuilder

getSqlDialect

protected org.apache.calcite.sql.SqlDialect getSqlDialect(boolean catalogCasingFilterUpperCase)

Description copied from class: JdbcSplitQueryBuilder

Returns the SQL dialect to use for query generation with catalog casing filter support. Subclasses should override to return a database-specific dialect.

Overrides:

getSqlDialect in class JdbcSplitQueryBuilder

Parameters:

catalogCasingFilterUpperCase - whether to apply catalog casing to quoted identifiers

Returns:

the SqlDialect instance