public TableFromBuilderImpl(Table table, Query query, DataContext dataContext) { super(query, dataContext); fromItem = new FromItem(table); query.from(fromItem); }
public TableFromBuilderImpl(Table table, Query query, DataContext dataContext) { super(query, dataContext); fromItem = new FromItem(table); query.from(fromItem); }
public Query from(String expression) { return from(new FromItem(expression)); }
public Query from(String expression) { return from(new FromItem(expression)); }
public Query from(Table table) { return from(new FromItem(table)); }
public Query from(Table table) { return from(new FromItem(table)); }
public Query from(Table table, String alias) { return from(new FromItem(table).setAlias(alias)); }
public Query from(Table table, String alias) { return from(new FromItem(table).setAlias(alias)); }
@Override protected DataSet materializeMainSchemaTable(Table table, List<Column> columns, int maxRows) { // find the appropriate datacontext to execute a simple // table materialization query final DataContext dc = _dataContextRetrievalFunction.apply(table); final Query q = new Query().select(columns).from(table); if (maxRows >= 0) { q.setMaxRows(maxRows); } return dc.executeQuery(q); }
@Override protected DataSet materializeMainSchemaTable(Table table, List<Column> columns, int maxRows) { // find the appropriate datacontext to execute a simple // table materialization query final DataContext dc = _dataContextRetrievalFunction.apply(table); final Query q = new Query().select(columns).from(table); if (maxRows >= 0) { q.setMaxRows(maxRows); } return dc.executeQuery(q); }
@Override public SatisfiedFromBuilder on(Column left, Column right) throws IllegalArgumentException { if (left == null) { throw new IllegalArgumentException("left cannot be null"); } if (right == null) { throw new IllegalArgumentException("right cannot be null"); } getQuery().getFromClause().removeItem(leftItem); SelectItem[] leftOn = new SelectItem[] { new SelectItem(left) }; SelectItem[] rightOn = new SelectItem[] { new SelectItem(right) }; FromItem fromItem = new FromItem(joinType, leftItem, rightItem, leftOn, rightOn); getQuery().from(fromItem); return this; }
@Override public SatisfiedFromBuilder on(Column left, Column right) throws IllegalArgumentException { if (left == null) { throw new IllegalArgumentException("left cannot be null"); } if (right == null) { throw new IllegalArgumentException("right cannot be null"); } getQuery().getFromClause().removeItem(leftItem); SelectItem[] leftOn = new SelectItem[] { new SelectItem(left) }; SelectItem[] rightOn = new SelectItem[] { new SelectItem(right) }; FromItem fromItem = new FromItem(joinType, leftItem, rightItem, leftOn, rightOn); getQuery().from(fromItem); return this; }
public Query from(Table leftTable, Table rightTable, JoinType joinType, Column leftOnColumn, Column rightOnColumn) { SelectItem[] leftOn = new SelectItem[] { new SelectItem(leftOnColumn) }; SelectItem[] rightOn = new SelectItem[] { new SelectItem(rightOnColumn) }; FromItem fromItem = new FromItem(joinType, new FromItem(leftTable), new FromItem(rightTable), leftOn, rightOn); return from(fromItem); }
@Override protected RowProcessingQueryOptimizer getQueryOptimizer() { final Table table = getStream().getTable(); final Query q = new Query().from(table).select(table.getColumns()); return new NoopRowProcessingQueryOptimizer(q, getConsumersSorted()); } }
public Query from(Table leftTable, Table rightTable, JoinType joinType, Column leftOnColumn, Column rightOnColumn) { SelectItem[] leftOn = new SelectItem[] { new SelectItem(leftOnColumn) }; SelectItem[] rightOn = new SelectItem[] { new SelectItem(rightOnColumn) }; FromItem fromItem = new FromItem(joinType, new FromItem(leftTable), new FromItem(rightTable), leftOn, rightOn); return from(fromItem); }
private List<Query> splitQueryBasedOnSubQueries(int fromItemIndex) { Query subQuery = _query.getFromClause().getItem(fromItemIndex).getSubQuery(); QuerySplitter subQuerySplitter = new QuerySplitter(_dataContext, subQuery); subQuerySplitter.setMaxRows(_maxRows); List<Query> splitQueries = subQuerySplitter.splitQuery(); List<Query> result = new ArrayList<Query>(splitQueries.size()); for (Query splitQuery : splitQueries) { Query newQuery = _query.clone(); FromClause fromClause = newQuery.getFromClause(); String alias = fromClause.getItem(fromItemIndex).getAlias(); fromClause.removeItem(fromItemIndex); newQuery.from(new FromItem(splitQuery).setAlias(alias)); result.add(newQuery); } return result; }
private List<Query> splitQueryBasedOnSubQueries(int fromItemIndex) { Query subQuery = _query.getFromClause().getItem(fromItemIndex).getSubQuery(); QuerySplitter subQuerySplitter = new QuerySplitter(_dataContext, subQuery); subQuerySplitter.setMaxRows(_maxRows); List<Query> splitQueries = subQuerySplitter.splitQuery(); List<Query> result = new ArrayList<Query>(splitQueries.size()); for (Query splitQuery : splitQueries) { Query newQuery = _query.clone(); FromClause fromClause = newQuery.getFromClause(); String alias = fromClause.getItem(fromItemIndex).getAlias(); fromClause.removeItem(fromItemIndex); newQuery.from(new FromItem(splitQuery).setAlias(alias)); result.add(newQuery); } return result; }
private long getRowCount(Query q) { q = q.clone(); SelectItem countAllItem = SelectItem.getCountAllItem(); if (q.getGroupByClause().getItemCount() > 0) { q = new Query().from(new FromItem(q).setAlias("sq")).select(countAllItem); } else { q.getSelectClause().removeItems(); q.select(countAllItem); } Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q); Number count = (Number) row.getValue(countAllItem); return count.longValue(); }
private long getRowCount(Query q) { q = q.clone(); SelectItem countAllItem = SelectItem.getCountAllItem(); if (q.getGroupByClause().getItemCount() > 0) { q = new Query().from(new FromItem(q).setAlias("sq")).select(countAllItem); } else { q.getSelectClause().removeItems(); q.select(countAllItem); } Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q); Number count = (Number) row.getValue(countAllItem); return count.longValue(); }
public void initialize() { final Table table = _outputDataStreamJob.getOutputDataStream().getTable(); final Query query = new Query(); query.from(table).selectAll(); final List<SelectItem> selectItems = query.getSelectClause().getItems(); final ConsumeRowHandler consumeRowHandler = _publisher.createConsumeRowHandler(); _outputRowCollector = new OutputDataStreamRowCollector(_publisher, selectItems, consumeRowHandler); final OutputDataStream outputDataStream = _outputDataStreamJob.getOutputDataStream(); _component.initializeOutputDataStream(outputDataStream, query, _outputRowCollector); _publisher.getAnalysisListener() .rowProcessingBegin(_publisher.getAnalysisJob(), _publisher.getRowProcessingMetrics()); }