public Class HANAColumnStoreDialect

Overrides org.hibernate.dialect.Dialect.getCreateTableString.

Doc from org.hibernate.dialect.Dialect.getCreateTableString.

The command used to create a table, usually create table.

Returns:String

The command used to create a table.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getFallbackSqmInsertStrategy.

Doc from org.hibernate.dialect.Dialect.getFallbackSqmInsertStrategy.

The SqmMultiTableInsertStrategy to use when not specified by org.hibernate.query.spi.QueryEngineOptions#getCustomSqmMultiTableInsertStrategy.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getFallbackSqmMutationStrategy.

Doc from org.hibernate.dialect.Dialect.getFallbackSqmMutationStrategy.

The SqmMultiTableMutationStrategy to use when not specified by org.hibernate.query.spi.QueryEngineOptions#getCustomSqmMultiTableMutationStrategy.

Annotations

@Override

Overrides org.hibernate.dialect.AbstractHANADialect.getMaxVarcharLength.

Doc from org.hibernate.dialect.Dialect.getMaxVarcharLength.

The biggest size value that can be supplied as argument to a java.sql.Types#VARCHAR-like type.

For longer column lengths, use some sort of text-like type for the column.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getSupportedTemporaryTableKind.

Doc from org.hibernate.dialect.Dialect.getSupportedTemporaryTableKind.

The kind of temporary tables that are supported on this database.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getTemporaryTableCreateCommand.

Doc from org.hibernate.dialect.Dialect.getTemporaryTableCreateCommand.

The command to create a temporary table.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getTemporaryTableCreateOptions.

Doc from org.hibernate.dialect.Dialect.getTemporaryTableCreateOptions.

An arbitrary SQL fragment appended to the end of the statement to create a temporary table, specifying dialect-specific options, or null if there are no options to specify.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getTemporaryTableTruncateCommand.

Doc from org.hibernate.dialect.Dialect.getTemporaryTableTruncateCommand.

The command to truncate a temporary table.

Annotations

@Override

Overrides org.hibernate.dialect.AbstractHANADialect.initializeFunctionRegistry.

Doc from org.hibernate.dialect.Dialect.initializeFunctionRegistry.

Initialize the given registry with any dialect-specific functions.

Support for certain SQL functions is required, and if the database does not support a required function, then the dialect must define a way to emulate it.

These required functions include the functions defined by the JPA query language specification:

• avg(arg) - aggregate function
• count([distinct ]arg) - aggregate function
• max(arg) - aggregate function
• min(arg) - aggregate function
• sum(arg) - aggregate function

• coalesce(arg0, arg1, ...)
• nullif(arg0, arg1)

• lower(arg)
• upper(arg)
• length(arg)
• concat(arg0, arg1, ...)
• locate(pattern, string[, start])
• substring(string, start[, length])
• trim([[spec ][character ]from] string)

• abs(arg)
• mod(arg0, arg1)
• sqrt(arg)

• current date
• current time
• current timestamp

• any(arg) - aggregate function
• every(arg) - aggregate function

• var_samp(arg) - aggregate function
• var_pop(arg) - aggregate function
• stddev_samp(arg) - aggregate function
• stddev_pop(arg) - aggregate function

• cast(arg as Type)
• extract(field from arg)

• ln(arg)
• exp(arg)
• power(arg0, arg1)
• floor(arg)
• ceiling(arg)

• position(pattern in string)
• substring(string from start[ for length])
• overlay(string placing replacement from start[ for length])

• local date
• local time
• local datetime
• offset datetime
• instant

• left(string, length)
• right(string, length)
• replace(string, pattern, replacement)
• pad(string with length spec[ character])
• repeat(string, times)

• pi
• log10(arg)
• log(base, arg)
• sign(arg)
• sin(arg)
• cos(arg)
• tan(arg)
• asin(arg)
• acos(arg)
• atan(arg)
• atan2(arg0, arg1)
• round(arg0[, arg1])
• truncate(arg0[, arg1])
• sinh(arg)
• tanh(arg)
• cosh(arg)
• least(arg0, arg1, ...)
• greatest(arg0, arg1, ...)
• degrees(arg)
• radians(arg)

• format(datetime as pattern)
• collate(string as collation)
• str(arg) - synonym of cast(a as String)
• ifnull(arg0, arg1) - synonym of coalesce(a, b)

• second(arg) - synonym of extract(second from a)
• minute(arg) - synonym of extract(minute from a)
• hour(arg) - synonym of extract(hour from a)
• day(arg) - synonym of extract(day from a)
• month(arg) - synonym of extract(month from a)
• year(arg) - synonym of extract(year from a)

Annotations

@Override

Overrides org.hibernate.dialect.AbstractHANADialect.isUseUnicodeStringTypes.

Annotations

@Override