org.apache.ignite.internal.processors.query.h2

Class IgniteH2Indexing

java.lang.Object

org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing

All Implemented Interfaces:

GridQueryIndexing

public class IgniteH2Indexing
extends Object
implements GridQueryIndexing

Indexing implementation based on H2 database engine. In this implementation main query language is SQL, fulltext indexing can be performed using Lucene.

For each registered GridQueryTypeDescriptor this SPI will create respective SQL table with '_key' and '_val' fields for key and value, and fields from GridQueryTypeDescriptor.fields(). For each table it will create indexes declared in GridQueryTypeDescriptor.indexes().

Field Summary

Fields

Modifier and Type	Field and Description
protected GridKernalContext	ctx

Constructor Summary

Constructors

Constructor and Description
IgniteH2Indexing()

Method Summary

Modifier and Type	Method and Description
void	awaitForReadyTopologyVersion(AffinityTopologyVersion topVer)
IndexingQueryFilter	backupFilter(@Nullable AffinityTopologyVersion topVer, @Nullable int[] parts)
IndexingQueryFilter	backupFilter(@Nullable AffinityTopologyVersion topVer, @Nullable int[] parts, boolean treatReplicatedAsPartitioned) Returns backup filter.
GridSpinBusyLock	busyLock()
ConnectionManager	connections()
DistributedIndexingConfiguration	distributedConfiguration()
void	enableDataPageScan(Boolean dataPageScanEnabled)
ResultSet	executeSqlQueryWithTimer(H2PooledConnection conn, String sql, @Nullable Collection<Object> params, int timeoutMillis, @Nullable GridQueryCancel cancel, Boolean dataPageScanEnabled, H2QueryInfo qryInfo) Executes sql query and prints warning if query is too slow..
ResultSet	executeSqlQueryWithTimer(PreparedStatement stmt, H2PooledConnection conn, String sql, int timeoutMillis, @Nullable GridQueryCancel cancel, Boolean dataPageScanEnabled, H2QueryInfo qryInfo) Executes sql query and prints warning if query is too slow.
UpdateResult	executeUpdateOnDataNode(String schemaName, SqlFieldsQuery qry, IndexingQueryFilter filter, GridQueryCancel cancel, boolean loc) Executes DML request on map node.
UpdateSourceIterator<?>	executeUpdateOnDataNodeTransactional(GridCacheContext<?,?> cctx, int[] ids, int[] parts, String schema, String qry, Object[] params, int flags, int pageSize, int timeout, AffinityTopologyVersion topVer, MvccSnapshot mvccSnapshot, GridQueryCancel cancel)
SqlFieldsQuery	generateFieldsQuery(String cacheName, SqlQuery qry)
HeavyQueriesTracker	heavyQueriesTracker()
boolean	isStreamableInsertStatement(String schemaName, SqlFieldsQuery qry)
GridKernalContext	kernalContext()
GridMapQueryExecutor	mapQueryExecutor()
CacheObjectValueContext	objectContext()
void	onClientDisconnect()
void	onDisconnected(IgniteFuture<?> reconnectFut)
void	onKernalStop()
void	onMessage(UUID nodeId, Object msg)
static int	operationTimeout(int qryTimeout, IgniteTxAdapter tx)
List<JdbcParameterMeta>	parameterMetaData(String schemaName, SqlFieldsQuery qry)
QueryParser	parser()
PartitionExtractor	partitionExtractor()
PartitionReservationManager	partitionReservationManager()
QueryContextRegistry	queryContextRegistry()
<K,V> GridCloseableIterator<IgniteBiTuple<K,V>>	queryLocalText(String schemaName, String cacheName, String qry, String typeName, IndexingQueryFilter filters, int limit)
List<FieldsQueryCursor<List<?>>>	querySqlFields(String schemaName, SqlFieldsQuery qry, @Nullable SqlClientContext cliCtx, boolean keepBinary, boolean failOnMultipleStmts, GridQueryCancel cancel)
AffinityTopologyVersion	readyTopologyVersion()
GridReduceQueryExecutor	reduceQueryExecutor()
void	registerCache(String cacheName, String schemaName, GridCacheContextInfo<?,?> cacheInfo)
void	registerQueryFinishedListener(Consumer<GridQueryFinishedInfo> lsnr)
void	registerQueryStartedListener(Consumer<GridQueryStartedInfo> lsnr)
void	remove(GridCacheContext cctx, GridQueryTypeDescriptor type, CacheDataRow row)
List<GridQueryFieldMetadata>	resultMetaData(String schemaName, SqlFieldsQuery qry)
RunningQueryManager	runningQueryManager()
H2SchemaManager	schemaManager()
boolean	send(Object topic, int topicOrd, Collection<ClusterNode> nodes, Message msg, @Nullable IgniteBiClosure<ClusterNode,Message,Message> specialize, @Nullable IgniteInClosure2X<ClusterNode,Message> locNodeHnd, byte plc, boolean runLocParallel)
boolean	serverTopologyChanged(AffinityTopologyVersion readyVer)
void	start(GridKernalContext ctx, GridSpinBusyLock busyLock)
void	stop()
void	store(GridCacheContext cctx, GridQueryTypeDescriptor type, CacheDataRow row, @Nullable CacheDataRow prevRow, boolean prevRowAvailable)
List<Long>	streamBatchedUpdateQuery(String schemaName, String qry, List<Object[]> params, SqlClientContext cliCtx, String qryInitiatorId)
long	streamUpdateQuery(String schemaName, String qry, @Nullable Object[] params, IgniteDataStreamer<?,?> streamer, String qryInitiatorId)
void	unregisterCache(GridCacheContextInfo<?,?> cacheInfo)
boolean	unregisterQueryFinishedListener(Object lsnr)
boolean	unregisterQueryStartedListener(Object lsnr)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ctx

protected volatile GridKernalContext ctx

Constructor Detail

IgniteH2Indexing

public IgniteH2Indexing()

Method Detail

kernalContext

public GridKernalContext kernalContext()

Returns:

Kernal context.

parameterMetaData

public List<JdbcParameterMeta> parameterMetaData(String schemaName,
                                                 SqlFieldsQuery qry)
                                          throws IgniteSQLException

Specified by:

parameterMetaData in interface GridQueryIndexing

Throws:

IgniteSQLException

resultMetaData

public List<GridQueryFieldMetadata> resultMetaData(String schemaName,
                                                   SqlFieldsQuery qry)
                                            throws IgniteSQLException

Specified by:

resultMetaData in interface GridQueryIndexing

Throws:

IgniteSQLException

store

public void store(GridCacheContext cctx,
                  GridQueryTypeDescriptor type,
                  CacheDataRow row,
                  @Nullable
                  @Nullable CacheDataRow prevRow,
                  boolean prevRowAvailable)
           throws IgniteCheckedException

Specified by:

store in interface GridQueryIndexing

Throws:

IgniteCheckedException

remove

public void remove(GridCacheContext cctx,
                   GridQueryTypeDescriptor type,
                   CacheDataRow row)
            throws IgniteCheckedException

Specified by:

remove in interface GridQueryIndexing

Throws:

IgniteCheckedException

queryLocalText

public <K,V> GridCloseableIterator<IgniteBiTuple<K,V>> queryLocalText(String schemaName,
                                                                      String cacheName,
                                                                      String qry,
                                                                      String typeName,
                                                                      IndexingQueryFilter filters,
                                                                      int limit)
                                                               throws IgniteCheckedException

Specified by:

queryLocalText in interface GridQueryIndexing

Throws:

IgniteCheckedException

operationTimeout

public static int operationTimeout(int qryTimeout,
                                   IgniteTxAdapter tx)

Parameters:

qryTimeout - Query timeout in milliseconds.

tx - Transaction.

Returns:

Timeout for operation in milliseconds based on query and tx timeouts.

streamUpdateQuery

public long streamUpdateQuery(String schemaName,
                              String qry,
                              @Nullable
                              @Nullable Object[] params,
                              IgniteDataStreamer<?,?> streamer,
                              String qryInitiatorId)
                       throws IgniteCheckedException

Specified by:

streamUpdateQuery in interface GridQueryIndexing

Throws:

IgniteCheckedException

streamBatchedUpdateQuery

public List<Long> streamBatchedUpdateQuery(String schemaName,
                                           String qry,
                                           List<Object[]> params,
                                           SqlClientContext cliCtx,
                                           String qryInitiatorId)
                                    throws IgniteCheckedException

Specified by:

streamBatchedUpdateQuery in interface GridQueryIndexing

Throws:

IgniteCheckedException

executeSqlQueryWithTimer

public ResultSet executeSqlQueryWithTimer(H2PooledConnection conn,
                                          String sql,
                                          @Nullable
                                          @Nullable Collection<Object> params,
                                          int timeoutMillis,
                                          @Nullable
                                          @Nullable GridQueryCancel cancel,
                                          Boolean dataPageScanEnabled,
                                          H2QueryInfo qryInfo)
                                   throws IgniteCheckedException

Executes sql query and prints warning if query is too slow..

Parameters:

conn - Connection,

sql - Sql query.

params - Parameters.

timeoutMillis - Query timeout.

cancel - Query cancel.

dataPageScanEnabled - If data page scan is enabled.

Returns:

Result.

Throws:

IgniteCheckedException - If failed.

enableDataPageScan

public void enableDataPageScan(Boolean dataPageScanEnabled)

Parameters:

dataPageScanEnabled - If data page scan is enabled.

executeSqlQueryWithTimer

public ResultSet executeSqlQueryWithTimer(PreparedStatement stmt,
                                          H2PooledConnection conn,
                                          String sql,
                                          int timeoutMillis,
                                          @Nullable
                                          @Nullable GridQueryCancel cancel,
                                          Boolean dataPageScanEnabled,
                                          H2QueryInfo qryInfo)
                                   throws IgniteCheckedException

Executes sql query and prints warning if query is too slow.

Parameters:

stmt - Prepared statement for query.

conn - Connection.

sql - Sql query.

timeoutMillis - Query timeout.

cancel - Query cancel.

dataPageScanEnabled - If data page scan is enabled.

Returns:

Result.

Throws:

IgniteCheckedException - If failed.

generateFieldsQuery

public SqlFieldsQuery generateFieldsQuery(String cacheName,
                                          SqlQuery qry)

Specified by:

generateFieldsQuery in interface GridQueryIndexing

querySqlFields

public List<FieldsQueryCursor<List<?>>> querySqlFields(String schemaName,
                                                       SqlFieldsQuery qry,
                                                       @Nullable
                                                       @Nullable SqlClientContext cliCtx,
                                                       boolean keepBinary,
                                                       boolean failOnMultipleStmts,
                                                       GridQueryCancel cancel)

Specified by:

querySqlFields in interface GridQueryIndexing

registerQueryStartedListener

public void registerQueryStartedListener(Consumer<GridQueryStartedInfo> lsnr)

Parameters:

lsnr - Listener.

unregisterQueryStartedListener

public boolean unregisterQueryStartedListener(Object lsnr)

Parameters:

lsnr - Listener.

registerQueryFinishedListener

public void registerQueryFinishedListener(Consumer<GridQueryFinishedInfo> lsnr)

Parameters:

lsnr - Listener.

unregisterQueryFinishedListener

public boolean unregisterQueryFinishedListener(Object lsnr)

Parameters:

lsnr - Listener.

executeUpdateOnDataNodeTransactional

public UpdateSourceIterator<?> executeUpdateOnDataNodeTransactional(GridCacheContext<?,?> cctx,
                                                                    int[] ids,
                                                                    int[] parts,
                                                                    String schema,
                                                                    String qry,
                                                                    Object[] params,
                                                                    int flags,
                                                                    int pageSize,
                                                                    int timeout,
                                                                    AffinityTopologyVersion topVer,
                                                                    MvccSnapshot mvccSnapshot,
                                                                    GridQueryCancel cancel)

Specified by:

executeUpdateOnDataNodeTransactional in interface GridQueryIndexing

executeUpdateOnDataNode

public UpdateResult executeUpdateOnDataNode(String schemaName,
                                            SqlFieldsQuery qry,
                                            IndexingQueryFilter filter,
                                            GridQueryCancel cancel,
                                            boolean loc)
                                     throws IgniteCheckedException

Executes DML request on map node. Happens only for "skip reducer" mode.

Parameters:

schemaName - Schema name.

qry - Query.

filter - Filter.

cancel - Cancel state.

loc - Locality flag.

Returns:

Update result.

Throws:

IgniteCheckedException - if failed.

isStreamableInsertStatement

public boolean isStreamableInsertStatement(String schemaName,
                                           SqlFieldsQuery qry)
                                    throws SQLException

Specified by:

isStreamableInsertStatement in interface GridQueryIndexing

Throws:

SQLException

busyLock

public GridSpinBusyLock busyLock()

Returns:

Busy lock.

mapQueryExecutor

public GridMapQueryExecutor mapQueryExecutor()

Returns:

Map query executor.

reduceQueryExecutor

public GridReduceQueryExecutor reduceQueryExecutor()

Returns:

Reduce query executor.

runningQueryManager

public RunningQueryManager runningQueryManager()

Specified by:

runningQueryManager in interface GridQueryIndexing

start

public void start(GridKernalContext ctx,
                  GridSpinBusyLock busyLock)
           throws IgniteCheckedException

Specified by:

start in interface GridQueryIndexing

Throws:

IgniteCheckedException

onMessage

public void onMessage(UUID nodeId,
                      Object msg)

Parameters:

nodeId - Node ID.

msg - Message.

objectContext

public CacheObjectValueContext objectContext()

Returns:

Value object context.

send

public boolean send(Object topic,
                    int topicOrd,
                    Collection<ClusterNode> nodes,
                    Message msg,
                    @Nullable
                    @Nullable IgniteBiClosure<ClusterNode,Message,Message> specialize,
                    @Nullable
                    @Nullable IgniteInClosure2X<ClusterNode,Message> locNodeHnd,
                    byte plc,
                    boolean runLocParallel)

Parameters:

topic - Topic.

topicOrd - Topic ordinal for GridTopic.

nodes - Nodes.

msg - Message.

specialize - Optional closure to specialize message for each node.

locNodeHnd - Handler for local node.

plc - Policy identifying the executor service which will process message.

runLocParallel - Run local handler in parallel thread.

Returns:

true If all messages sent successfully.

stop

public void stop()

Specified by:

stop in interface GridQueryIndexing

onClientDisconnect

public void onClientDisconnect()

Specified by:

onClientDisconnect in interface GridQueryIndexing

registerCache

public void registerCache(String cacheName,
                          String schemaName,
                          GridCacheContextInfo<?,?> cacheInfo)

Specified by:

registerCache in interface GridQueryIndexing

unregisterCache

public void unregisterCache(GridCacheContextInfo<?,?> cacheInfo)

Specified by:

unregisterCache in interface GridQueryIndexing

backupFilter

public IndexingQueryFilter backupFilter(@Nullable
                                        @Nullable AffinityTopologyVersion topVer,
                                        @Nullable
                                        @Nullable int[] parts)

Specified by:

backupFilter in interface GridQueryIndexing

backupFilter

public IndexingQueryFilter backupFilter(@Nullable
                                        @Nullable AffinityTopologyVersion topVer,
                                        @Nullable
                                        @Nullable int[] parts,
                                        boolean treatReplicatedAsPartitioned)

Returns backup filter.

Parameters:

topVer - Topology version.

parts - Partitions.

treatReplicatedAsPartitioned - true if need to treat replicated as partitioned (for outer joins).

Returns:

Backup filter.

readyTopologyVersion

public AffinityTopologyVersion readyTopologyVersion()

Returns:

Ready topology version.

serverTopologyChanged

public boolean serverTopologyChanged(AffinityTopologyVersion readyVer)

Parameters:

readyVer - Ready topology version.

Returns:

true If pending distributed exchange exists because server topology is changed.

awaitForReadyTopologyVersion

public void awaitForReadyTopologyVersion(AffinityTopologyVersion topVer)
                                  throws IgniteCheckedException

Parameters:

topVer - Topology version.

Throws:

IgniteCheckedException - If failed.

onDisconnected

public void onDisconnected(IgniteFuture<?> reconnectFut)

Specified by:

onDisconnected in interface GridQueryIndexing

onKernalStop

public void onKernalStop()

Specified by:

onKernalStop in interface GridQueryIndexing

queryContextRegistry

public QueryContextRegistry queryContextRegistry()

Returns:

Query context registry.

connections

public ConnectionManager connections()

Returns:

Connection manager.

parser

public QueryParser parser()

Returns:

Parser.

schemaManager

public H2SchemaManager schemaManager()

Returns:

Schema manager.

partitionExtractor

public PartitionExtractor partitionExtractor()

Returns:

Partition extractor.

partitionReservationManager

public PartitionReservationManager partitionReservationManager()

Returns:

Partition reservation manager.

heavyQueriesTracker

public HeavyQueriesTracker heavyQueriesTracker()

Returns:

Heavy queries tracker.

distributedConfiguration

public DistributedIndexingConfiguration distributedConfiguration()

Returns:

Distributed SQL configuration.