public class RedshiftDriver extends PostgresDriver
Modifier and Type | Field and Description |
---|---|
static int |
MAX_CHAR_SIZE
The maximum char size.
|
static int |
MAX_NUMBER_PREC_SIZE
The maximum precision size.
|
static int |
MAX_NUMBER_SCALE_SIZE
The maximum scale size.
|
static int |
MAX_STRING_LITERAL_SIZE
The maximum string literal size.
|
static int |
MAX_VARCHAR_SIZE
The maximum varchar size.
|
BEGIN, BEGIN_SPLITED, DECLARE, END, END_LOOP, END_SPLITED, IF, IF_BEGIN, IF_ELSE, IF_END, INIT_SQL, LINES_LIMIT, ON_EXCEPTION, ON_EXCEPTION_BEGIN, ON_EXCEPTION_END, POSTGRES_DATE_FORMAT, POSTGRES_HOME_PROP, POSTGRES_HOME_VAR, POSTGRES_TIME_FORMAT, START_LOOP
ALLOWED_IDENT_CHARS
BASE_CLASS_PATH, CASE_SENSITIVE_LOWER, CASE_SENSITIVE_LOWER_STR, CASE_SENSITIVE_UNDEFINED, CASE_SENSITIVE_UPPER, CASE_SENSITIVE_UPPER_STR, CMD_OPTIONS_PARAM, DB_PARAM, DDL_TYPE, ETL_CODE, FUNC_TYPE, PROC_TYPE, SERVER_PARAM, TABLE_TYPE
APP, COMMAND, ETL_DRIVER, FORMATTER, IDE_NODE, NO_RANK, WIDGET
Constructor and Description |
---|
RedshiftDriver() |
Modifier and Type | Method and Description |
---|---|
protected int |
_getMaxCharSize()
Gets max char size.
|
protected int |
_getMaxPrecision()
Gets max precision.
|
protected int |
_getMaxScale()
Gets the max scale.
|
protected int |
_getMaxStringLiteralSize()
Gets the max string literal size.
|
protected int |
_getMaxVarcharSize()
Gets the max varchar size.
|
String |
getCreateTableSql(String name,
DataSet dataSet,
boolean isTemporary,
String key,
FieldsRepository fieldsRepository)
Gets the "create table" sql.
|
String |
getMergeStatement(TypedKeyValue<List<String>,List<Object>> fieldsAndValues,
String tableName,
String key)
Gets the merge statement.
|
String |
getName()
Gets the name of the driver.
|
String |
getNativeType(FieldDef fieldDef,
String key,
FieldsRepository fieldsRepository)
Gets the native field from native field type.
|
String |
getType(FieldDef fieldDef,
String key,
FieldsRepository fieldsRepository)
Gets the native field type.
|
boolean |
supportsIndexes()
Supports indexes.
|
boolean |
supportsPreparedStatementInParallelThreads()
Supports prepared statement in parallel threads.
|
boolean |
supportsPreparedStatementInTransaction()
Supports prepared statement in transaction.
|
_getInitSql, _getLinesLimit, convertStringForStorage, convertValueForStorage, getAutotrace, getBegin, getBeginSplited, getCallSql, getCmdForExternalTool, getCursorLoopEndSql, getCursorLoopStartSql, getCursorRecAccessSql, getCursorVarName, getDbName, getDeclare, getDeclareCursorEndSql, getDeclareCursorSql, getDeclareCursorVarSql, getDefaultFunctionClass, getDefaultType, getDropSql, getEnd, getEndSplited, getErrorLinePattern, getExplainPlan, getExternalToolName, getHome, getIconPath, getIf, getIfBegin, getIfElse, getIfEnd, getJdbcDriverClassName, getLicensePropertyName, getMetadataClassName, getMetadataSelectClause, getMetadataWhereClause, getOnException, getOnExceptionBegin, getOnExceptionEnd, getParamType, getPrecision, getProperties, getPropsWizardResource, getSqlForExplainPlan, getSqlForExternalTool, getSqlKeywordsFileName, getTempTableName, getTopSelectClause, getTopTrailClause, getTopWhereClause, getUrlPattern, getVarDeclare, getVendor, getVersion, getXmlConfigFileName, ignoreExceptionsDuringInit, isMergeInNonCallableSupported, requiresRollbackAfterSqlError, supportedJoinTypes, supportedSetOperations, supportsAnonymousBlocks, supportsAutotrace, supportsBinaryInProc, supportsCallableStatement, supportsExplainPlan, supportsExternalTool, supportsInnerFunctions, supportsParamsInAnonymousBlocks, supportsParentDriver, supportsRollbackAfterDDL, typeHasSize
deleteStagingBinary, getBlob, getCharUsedForColumnsWithSpaces, getClob, getDestinationInfo, getInitSql, getLinesLimit, getMaxCharSize, getMaxPrecision, getMaxScale, getMaxStringLiteralSize, getMaxVarcharSize, getObject, getParentDriverName, getVarName, getWrongScale, replaceOnException, setBlob, setClob, setInitSql, setLinesLimit, setMaxCharSize, setMaxPrecision, setMaxScale, setMaxStringLiteralSize, setMaxVarcharSize, setParentDriverName, supportsScripts, updateStagingBlob, updateStagingClob, value2StorageValue
alwaysEncloseTableAndColumnsInQuotes, captureLog, compareTo, externalToolRequiresRedirect, filter, getAddColumnSql, getAllowedIdentifierChars, getAlterTableAddColumnSql, getAlterTableAddColumnSql, getCaseSensitive, getCmdOptions, getColumns, getConfigFileName, getConnectionFile, getDefaultNull, getDeleteStatement, getDelimiter, getDisplayName, getExtensionRank, getIdentifierName, getIdentifierName, getInsertStatement, getLocalUnitClassPath, getObjectCheckSql, getParentDriver, getPostDeclareSql, getSafeDelimiter, getSafeSql, getSelectStatement, getSqlForAutotrace, getStartTransactionSql, getStringFieldSizeMultiplier, getTableName, getTablePrefixWhenAddingTable, getType, getUpdateStatement, isEqualDriver, needSeparateConnectionForDdl, requiresExecuteQuery, requiresSeparateConnectionForIndexes, setAlwaysEncloseTableAndColumnsInQuotes, setCaseSensitive, setStringFieldSizeMultiplier, setUpConnection, supportColonInFormatter, supportsLogging, supportsNotNullable, supportsParallelExtract, supportsParallelLoad, supportsPreparedStatement, tableName2Name
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
disableMetadataOnWrite, getIoProcessorClassName, ifDoesNotExistSql, ifExistsSql, openCloseConnectionOnDdl, requiresSemicolonInMerge
public static int MAX_VARCHAR_SIZE
public static int MAX_CHAR_SIZE
public static int MAX_STRING_LITERAL_SIZE
public static int MAX_NUMBER_PREC_SIZE
public static int MAX_NUMBER_SCALE_SIZE
public String getName()
Driver
getName
in interface Driver
getName
in class PostgresDriver
public String getCreateTableSql(String name, DataSet dataSet, boolean isTemporary, String key, FieldsRepository fieldsRepository)
Driver
getCreateTableSql
in interface Driver
getCreateTableSql
in class PostgresDriver
name
- the table namedataSet
- the data setisTemporary
- if true the table is temporarykey
- the key field(s)fieldsRepository
- the fields repositoryFieldsRepository
protected int _getMaxCharSize()
CallableDriver
_getMaxCharSize
in class PostgresDriver
protected int _getMaxStringLiteralSize()
CallableDriver
_getMaxStringLiteralSize
in class PostgresDriver
protected int _getMaxPrecision()
CallableDriver
_getMaxPrecision
in class PostgresDriver
protected int _getMaxScale()
CallableDriver
_getMaxScale
in class PostgresDriver
protected int _getMaxVarcharSize()
CallableDriver
_getMaxVarcharSize
in class PostgresDriver
public String getNativeType(FieldDef fieldDef, String key, FieldsRepository fieldsRepository)
Driver
getNativeType
in interface Driver
getNativeType
in class AbstractDriver
fieldDef
- the field definitionkey
- the key field(s)fieldsRepository
- the fields repositorypublic String getType(FieldDef fieldDef, String key, FieldsRepository fieldsRepository)
Driver
getType
in interface Driver
getType
in class PostgresDriver
fieldDef
- the field definitionkey
- the key field(s)fieldsRepository
- the fields repositorypublic String getMergeStatement(TypedKeyValue<List<String>,List<Object>> fieldsAndValues, String tableName, String key)
Driver
getMergeStatement
in interface Driver
getMergeStatement
in class PostgresDriver
fieldsAndValues
- the fields and valuestableName
- the table namekey
- the key field(s)public boolean supportsPreparedStatementInTransaction()
Driver
supportsPreparedStatementInTransaction
in interface Driver
supportsPreparedStatementInTransaction
in class AbstractDriver
public boolean supportsPreparedStatementInParallelThreads()
Driver
supportsPreparedStatementInParallelThreads
in interface Driver
supportsPreparedStatementInParallelThreads
in class AbstractDriver
public boolean supportsIndexes()
Driver
supportsIndexes
in interface Driver
supportsIndexes
in class CallableDriver
Copyright © 2010-2020 Toolsverse. All Rights Reserved.