同样的一条sql,传统数据库在建立索引的情况下,耗时2s,但是spark+hbase 耗时10+分钟。
SELECT
t1.bsm,
bt2.bsm
FROM
testtable t1
JOIN testtable t2 ON t1.LEFT BETWEEN t2.LEFT
AND t2.RIGHT
AND (
t1.top BETWEEN t2.top
AND t2.bottom
OR t1.bottom BETWEEN t2.top
AND t2.bottom
请问各位。是我这边少了些什么嘛?还是说spark+hbase范围查询就是这么慢的。