private List<byte[]> getCurrentValue( PalantirSqlConnection connection, Cell cell, long ts, String prefixedTableName) { String sqlString = "/* SELECT (" + prefixedTableName + ") */" + " SELECT val FROM " + prefixedTableName + " WHERE row_name = ?" + " AND col_name = ?" + " AND ts = ?"; try (AgnosticLightResultSet results = connection.selectLightResultSetUnregisteredQuery( sqlString, cell.getRowName(), cell.getColumnName(), ts)) { List<byte[]> actualValues = Lists.newArrayList(); results.forEach(row -> actualValues.add(row.getBytes(DbKvs.VAL))); return actualValues; } } }
public ClosableIterator<AgnosticLightResultRow> getRowsColumnRange( Map<byte[], BatchColumnRangeSelection> columnRangeSelectionsByRow, long ts) { if (columnRangeSelectionsByRow.isEmpty()) { return ClosableIterators.emptyImmutableClosableIterator(); } else { FullQuery query = queryFactory.getRowsColumnRangeQuery(columnRangeSelectionsByRow, ts); AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery(query.getQuery(), query.getArgs()); int totalSize = columnRangeSelectionsByRow.values().stream().mapToInt( BatchColumnRangeSelection::getBatchHint).sum(); results.setFetchSize(Math.min(totalSize, MAX_ROW_COLUMN_RANGES_FETCH_SIZE)); return ClosableIterators.wrap(results.iterator(), results); } }
private ClosableIterator<AgnosticLightResultRow> run(FullQuery query) { AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery( query.getQuery(), query.getArgs()); return ClosableIterators.wrap(results.iterator(), results); }
private ClosableIterator<AgnosticLightResultRow> select(ConnectionSupplier conns, FullQuery query) { AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery( query.getQuery(), query.getArgs()); return ClosableIterators.wrap(results.iterator(), results); }
public ClosableIterator<AgnosticLightResultRow> getRowsColumnRangeCounts( List<byte[]> rows, long ts, ColumnRangeSelection columnRangeSelection) { if (rows.isEmpty()) { return ClosableIterators.emptyImmutableClosableIterator(); } else { FullQuery query = queryFactory.getRowsColumnRangeCountsQuery(rows, ts, columnRangeSelection); AgnosticLightResultSet results = conns.get() .selectLightResultSetUnregisteredQuery(query.getQuery(), query.getArgs()); results.setFetchSize(Math.min(rows.size(), MAX_ROW_COLUMN_RANGES_FETCH_SIZE)); return ClosableIterators.wrap(results.iterator(), results); } }
private ClosableIterator<AgnosticLightResultRow> selectNextPage(ConnectionSupplier conns) { FullQuery query = getRangeQuery(conns); AgnosticLightResultSet resultSet = conns.get().selectLightResultSetUnregisteredQueryWithFetchSize( query.getQuery(), maxRowsPerPage, query.getArgs()); return ClosableIterators.wrap(resultSet.iterator(), resultSet); }
private List<byte[]> getCurrentValue( PalantirSqlConnection connection, Cell cell, long ts, String prefixedTableName) { String sqlString = "/* SELECT (" + prefixedTableName + ") */" + " SELECT val FROM " + prefixedTableName + " WHERE row_name = ?" + " AND col_name = ?" + " AND ts = ?"; try (AgnosticLightResultSet results = connection.selectLightResultSetUnregisteredQuery( sqlString, cell.getRowName(), cell.getColumnName(), ts)) { List<byte[]> actualValues = Lists.newArrayList(); results.forEach(row -> actualValues.add(row.getBytes(DbKvs.VAL))); return actualValues; } } }
public ClosableIterator<AgnosticLightResultRow> getRowsColumnRange( RowsColumnRangeBatchRequest rowsColumnRangeBatch, long ts) { FullQuery query = queryFactory.getRowsColumnRangeQuery(rowsColumnRangeBatch, ts); AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery(query.getQuery(), query.getArgs()); results.setFetchSize(MAX_ROW_COLUMN_RANGES_FETCH_SIZE); return ClosableIterators.wrap(results.iterator(), results); }
private ClosableIterator<AgnosticLightResultRow> selectNextPage(ConnectionSupplier conns) { FullQuery query = getRangeQuery(); AgnosticLightResultSet rs = conns.get().selectLightResultSetUnregisteredQuery( query.getQuery(), query.getArgs()); return ClosableIterators.wrap(rs.iterator(), rs); }
public ClosableIterator<AgnosticLightResultRow> getRange(RangeRequest range, long ts, int maxRows) { FullQuery query = queryFactory.getRangeQuery(range, ts, maxRows); AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery( query.getQuery(), query.getArgs()); results.setFetchSize(maxRows); return ClosableIterators.wrap(results.iterator(), results); }
private ClosableIterator<AgnosticLightResultRow> select(ConnectionSupplier conns, FullQuery query) { AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery( query.getQuery(), query.getArgs()); return ClosableIterators.wrap(results.iterator(), results); }
public ClosableIterator<AgnosticLightResultRow> getRowsColumnRange( Map<byte[], BatchColumnRangeSelection> columnRangeSelectionsByRow, long ts) { if (columnRangeSelectionsByRow.isEmpty()) { return ClosableIterators.emptyImmutableClosableIterator(); } else { FullQuery query = queryFactory.getRowsColumnRangeQuery(columnRangeSelectionsByRow, ts); AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery(query.getQuery(), query.getArgs()); int totalSize = columnRangeSelectionsByRow.values().stream().mapToInt( BatchColumnRangeSelection::getBatchHint).sum(); results.setFetchSize(Math.min(totalSize, MAX_ROW_COLUMN_RANGES_FETCH_SIZE)); return ClosableIterators.wrap(results.iterator(), results); } }
private ClosableIterator<AgnosticLightResultRow> run(FullQuery query) { AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery( query.getQuery(), query.getArgs()); return ClosableIterators.wrap(results.iterator(), results); }
public ClosableIterator<AgnosticLightResultRow> getRowsColumnRangeCounts( List<byte[]> rows, long ts, ColumnRangeSelection columnRangeSelection) { if (rows.isEmpty()) { return ClosableIterators.emptyImmutableClosableIterator(); } else { FullQuery query = queryFactory.getRowsColumnRangeCountsQuery(rows, ts, columnRangeSelection); AgnosticLightResultSet results = conns.get() .selectLightResultSetUnregisteredQuery(query.getQuery(), query.getArgs()); results.setFetchSize(Math.min(rows.size(), MAX_ROW_COLUMN_RANGES_FETCH_SIZE)); return ClosableIterators.wrap(results.iterator(), results); } }
private ClosableIterator<AgnosticLightResultRow> selectNextPage(ConnectionSupplier conns) { FullQuery query = getRangeQuery(conns); AgnosticLightResultSet resultSet = conns.get().selectLightResultSetUnregisteredQueryWithFetchSize( query.getQuery(), maxRowsPerPage, query.getArgs()); return ClosableIterators.wrap(resultSet.iterator(), resultSet); }
public ClosableIterator<AgnosticLightResultRow> getRowsColumnRange( RowsColumnRangeBatchRequest rowsColumnRangeBatch, long ts) { FullQuery query = queryFactory.getRowsColumnRangeQuery(rowsColumnRangeBatch, ts); AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery(query.getQuery(), query.getArgs()); results.setFetchSize(MAX_ROW_COLUMN_RANGES_FETCH_SIZE); return ClosableIterators.wrap(results.iterator(), results); }
private ClosableIterator<AgnosticLightResultRow> selectNextPage(ConnectionSupplier conns) { FullQuery query = getRangeQuery(); AgnosticLightResultSet rs = conns.get().selectLightResultSetUnregisteredQuery( query.getQuery(), query.getArgs()); return ClosableIterators.wrap(rs.iterator(), rs); }
public ClosableIterator<AgnosticLightResultRow> getRange(RangeRequest range, long ts, int maxRows) { FullQuery query = queryFactory.getRangeQuery(range, ts, maxRows); AgnosticLightResultSet results = conns.get().selectLightResultSetUnregisteredQuery( query.getQuery(), query.getArgs()); results.setFetchSize(maxRows); return ClosableIterators.wrap(results.iterator(), results); }