org.hibernate.dialect.HANAColumnStoreDialect Maven / Gradle / Ivy

/*
 * Hibernate, Relational Persistence for Idiomatic Java
 *
 * License: GNU Lesser General Public License (LGPL), version 2.1 or later.
 * See the lgpl.txt file in the root directory or .
 */
package org.hibernate.dialect;

import org.hibernate.dialect.function.SQLFunctionTemplate;
import org.hibernate.dialect.function.StandardSQLFunction;
import org.hibernate.dialect.function.VarArgsSQLFunction;
import org.hibernate.hql.spi.id.IdTableSupportStandardImpl;
import org.hibernate.hql.spi.id.MultiTableBulkIdStrategy;
import org.hibernate.hql.spi.id.global.GlobalTemporaryTableBulkIdStrategy;
import org.hibernate.hql.spi.id.local.AfterUseAction;
import org.hibernate.type.StandardBasicTypes;

/**
 * An SQL dialect for the SAP HANA column store.
 * 
 * For more information on interacting with the SAP HANA database, refer to the
 * SAP HANA SQL and System Views Reference
 * and the SAP
 * HANA Client Interface Programming Reference.
 * 
 * Column tables are created by this dialect when using the auto-ddl feature.
 * 
 * @author Andrew Clemons 
 * @author Jonathan Bregler 
 */
public class HANAColumnStoreDialect extends AbstractHANADialect {

	public HANAColumnStoreDialect() {
		super();

		// full-text search functions
		registerFunction( "score", new StandardSQLFunction( "score", StandardBasicTypes.DOUBLE ) );
		registerFunction( "snippets", new StandardSQLFunction( "snippets" ) );
		registerFunction( "highlighted", new StandardSQLFunction( "highlighted" ) );
		registerFunction( "contains", new VarArgsSQLFunction( StandardBasicTypes.BOOLEAN, "contains(", ",", ") /*" ) );
		registerFunction( "contains_rhs", new SQLFunctionTemplate( StandardBasicTypes.BOOLEAN, "*/" ) );
		registerFunction( "not_contains", new VarArgsSQLFunction( StandardBasicTypes.BOOLEAN, "not contains(", ",", ") /*" ) );
	}

	@Override
	public String getCreateTableString() {
		return "create column table";
	}

	@Override
	public MultiTableBulkIdStrategy getDefaultMultiTableBulkIdStrategy() {
		return new GlobalTemporaryTableBulkIdStrategy( new IdTableSupportStandardImpl() {

			@Override
			public String getCreateIdTableCommand() {
				return "create global temporary column table";
			}

			@Override
			public String getTruncateIdTableCommand() {
				return "truncate table";
			}

		}, AfterUseAction.CLEAN );
	}
}