Search in sources :

Example 16 with EXISTS

use of org.apache.ignite.internal.processors.query.h2.sql.GridSqlOperationType.EXISTS in project ignite by apache.

the class GridH2Table method proposeUserIndex.

/**
 * Add index that is in an intermediate state and is still being built, thus is not used in queries until it is
 * promoted.
 *
 * @param idx Index to add.
 * @throws IgniteCheckedException If failed.
 */
public void proposeUserIndex(Index idx) throws IgniteCheckedException {
    assert idx instanceof GridH2IndexBase;
    lock(true);
    try {
        ensureNotDestroyed();
        Index idxExist = checkIndexPresence(idx);
        if (idxExist != null) {
            String idxCols = Stream.of(idxExist.getIndexColumns()).map(k -> k.columnName).collect(Collectors.joining(", "));
            U.warn(log, "Index with the given set or subset of columns already exists " + "(consider dropping either new or existing index) [cacheName=" + cacheInfo.name() + ", " + "schemaName=" + getSchema().getName() + ", tableName=" + getName() + ", newIndexName=" + idx.getName() + ", existingIndexName=" + idxExist.getName() + ", existingIndexColumns=[" + idxCols + "]]");
        }
        Index oldTmpIdx = tmpIdxs.put(idx.getName(), (GridH2IndexBase) idx);
        assert oldTmpIdx == null;
    } finally {
        unlock(true);
    }
}
Also used : DbObject(org.h2.engine.DbObject) QueryUtils(org.apache.ignite.internal.processors.query.QueryUtils) H2IndexType(org.apache.ignite.internal.processors.query.h2.database.H2IndexType) IndexingQueryFilter(org.apache.ignite.spi.indexing.IndexingQueryFilter) DbException(org.h2.message.DbException) H2Utils(org.apache.ignite.internal.processors.query.h2.H2Utils) Index(org.h2.index.Index) SCAN_INDEX_NAME_SUFFIX(org.apache.ignite.internal.processors.query.h2.opt.H2TableScanIndex.SCAN_INDEX_NAME_SUFFIX) IndexKeyDefinition(org.apache.ignite.internal.cache.query.index.sorted.IndexKeyDefinition) SysProperties(org.h2.engine.SysProperties) Map(java.util.Map) Row(org.h2.result.Row) IndexingQueryCacheFilter(org.apache.ignite.spi.indexing.IndexingQueryCacheFilter) PARTITIONED(org.apache.ignite.cache.CacheMode.PARTITIONED) IndexProcessor(org.apache.ignite.internal.cache.query.index.IndexProcessor) QueryTable(org.apache.ignite.internal.processors.cache.query.QueryTable) CachePeekMode(org.apache.ignite.cache.CachePeekMode) QueryField(org.apache.ignite.internal.processors.query.QueryField) GridToStringExclude(org.apache.ignite.internal.util.tostring.GridToStringExclude) IgniteCheckedException(org.apache.ignite.IgniteCheckedException) IgniteException(org.apache.ignite.IgniteException) ConcurrentHashMap(java.util.concurrent.ConcurrentHashMap) SortOrder(org.h2.result.SortOrder) CacheDataRow(org.apache.ignite.internal.processors.cache.persistence.CacheDataRow) Collectors(java.util.stream.Collectors) Insert(org.h2.command.dml.Insert) Nullable(org.jetbrains.annotations.Nullable) List(java.util.List) H2TreeIndex(org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex) IndexColumn(org.h2.table.IndexColumn) Stream(java.util.stream.Stream) DataType(org.h2.value.DataType) CreateTableData(org.h2.command.ddl.CreateTableData) GridCacheContext(org.apache.ignite.internal.processors.cache.GridCacheContext) LongAdder(java.util.concurrent.atomic.LongAdder) AtomicIntegerFieldUpdater(java.util.concurrent.atomic.AtomicIntegerFieldUpdater) SchemaObject(org.h2.schema.SchemaObject) U(org.apache.ignite.internal.util.typedef.internal.U) HashMap(java.util.HashMap) IgniteLogger(org.apache.ignite.IgniteLogger) ReentrantReadWriteLock(java.util.concurrent.locks.ReentrantReadWriteLock) QueryRetryException(org.apache.ignite.cache.query.QueryRetryException) IndexInformation(org.apache.ignite.internal.processors.query.h2.database.IndexInformation) ArrayList(java.util.ArrayList) ConcurrentMap(java.util.concurrent.ConcurrentMap) GridKernalContext(org.apache.ignite.internal.GridKernalContext) LinkedHashMap(java.util.LinkedHashMap) Column(org.h2.table.Column) ObjectStatistics(org.apache.ignite.internal.processors.query.stat.ObjectStatistics) Session(org.h2.engine.Session) IgniteH2Indexing(org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing) IndexType(org.h2.index.IndexType) IgniteInterruptedException(org.apache.ignite.IgniteInterruptedException) IndexName(org.apache.ignite.internal.cache.query.index.IndexName) H2TableDescriptor(org.apache.ignite.internal.processors.query.h2.H2TableDescriptor) Table(org.h2.table.Table) StatisticsKey(org.apache.ignite.internal.processors.query.stat.StatisticsKey) F(org.apache.ignite.internal.util.typedef.F) AffinityTopologyVersion(org.apache.ignite.internal.processors.affinity.AffinityTopologyVersion) H2TreeIndexBase(org.apache.ignite.internal.processors.query.h2.database.H2TreeIndexBase) GridCacheContextInfo(org.apache.ignite.internal.processors.cache.GridCacheContextInfo) TableType(org.h2.table.TableType) TimeUnit(java.util.concurrent.TimeUnit) AtomicLong(java.util.concurrent.atomic.AtomicLong) SpatialIndex(org.h2.index.SpatialIndex) Lock(java.util.concurrent.locks.Lock) IgniteSQLException(org.apache.ignite.internal.processors.query.IgniteSQLException) IndexDefinition(org.apache.ignite.internal.cache.query.index.IndexDefinition) TableBase(org.h2.table.TableBase) PK_HASH_IDX_NAME(org.apache.ignite.internal.processors.query.h2.H2TableDescriptor.PK_HASH_IDX_NAME) Index(org.h2.index.Index) H2TreeIndex(org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex) SpatialIndex(org.h2.index.SpatialIndex)

Aggregations

IgniteSQLException (org.apache.ignite.internal.processors.query.IgniteSQLException)6 IndexColumn (org.h2.table.IndexColumn)5 IgniteCheckedException (org.apache.ignite.IgniteCheckedException)4 GridH2Table (org.apache.ignite.internal.processors.query.h2.opt.GridH2Table)4 Column (org.h2.table.Column)4 SQLException (java.sql.SQLException)3 Map (java.util.Map)3 IgniteException (org.apache.ignite.IgniteException)3 IgniteH2Indexing (org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing)3 H2TreeIndex (org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex)3 GridSqlSubquery (org.apache.ignite.internal.processors.query.h2.sql.GridSqlSubquery)3 Index (org.h2.index.Index)3 ArrayList (java.util.ArrayList)2 HashMap (java.util.HashMap)2 LinkedHashMap (java.util.LinkedHashMap)2 ConcurrentHashMap (java.util.concurrent.ConcurrentHashMap)2 ConcurrentMap (java.util.concurrent.ConcurrentMap)2 IgniteSystemProperties.getString (org.apache.ignite.IgniteSystemProperties.getString)2 GridCacheContext (org.apache.ignite.internal.processors.cache.GridCacheContext)2 H2TableDescriptor (org.apache.ignite.internal.processors.query.h2.H2TableDescriptor)2