public SubqueryCursor(TableFilter filter, SearchRow first, SearchRow last) {
StringBuilder buff = new StringBuilder("SELECT * FROM ");
buff.append(filter.getTable().getSQL());
Expression filterCondition = filter.getFilterCondition();
if (filterCondition != null) {
buff.append(" WHERE ").append(StringUtils.unEnclose(filterCondition.getSQL()));
}
Prepared prepared = filter.getSession().prepare(buff.toString(), true);
subqueryResult = prepared.query(-1);
}
public HBaseSecondaryIndexCursor(
HBaseSecondaryIndex index, TableFilter filter, byte[] startKey, byte[] endKey) {
defaultColumnFamilyName =
Bytes.toBytes(((HBaseTable) filter.getTable()).getDefaultColumnFamilyName());
secondaryIndex = index;
session = (HBaseSession) filter.getSession();
Prepared p = filter.getPrepared();
if (p instanceof WithWhereClause) {
regionName = Bytes.toBytes(((WithWhereClause) p).getWhereClauseSupport().getRegionName());
}
if (regionName == null) throw new RuntimeException("regionName is null");
fetchSize = filter.getPrepared().getFetchSize();
// 非查询的操作一般不设置fetchSize，此时fetchSize为0，所以要设置一个默认值
// if (fetchSize < 1 && !filter.getPrepared().isQuery())
if (fetchSize < 1) fetchSize = SysProperties.SERVER_RESULT_SET_FETCH_SIZE;
if (filter.getSelect() != null) columns = filter.getSelect().getColumns(filter);
else columns = Arrays.asList(filter.getTable().getColumns());
if (startKey == null) startKey = HConstants.EMPTY_BYTE_ARRAY;
if (endKey == null) endKey = HConstants.EMPTY_BYTE_ARRAY;
Scan scan = new Scan();
scan.setMaxVersions(1);
try {
HRegionInfo info = session.getRegionServer().getRegionInfo(regionName);
if (Bytes.compareTo(startKey, info.getStartKey()) >= 0) scan.setStartRow(startKey);
else scan.setStartRow(info.getStartKey());
if (Bytes.equals(endKey, HConstants.EMPTY_BYTE_ARRAY)) scan.setStopRow(info.getEndKey());
else if (Bytes.compareTo(endKey, info.getEndKey()) < 0) scan.setStopRow(endKey);
else scan.setStopRow(info.getEndKey());
scan.addColumn(HBaseSecondaryIndex.PSEUDO_FAMILY, HBaseSecondaryIndex.PSEUDO_COLUMN);
scannerId = session.getRegionServer().openScanner(regionName, scan);
} catch (Exception e) {
throw new RuntimeException(e);
}
}