我在相对较小的集群(4个16gb节点)中使用apachedrill对100gb数据集执行查询。当我尝试运行某个查询时,它会显示以下错误:
错误:系统错误:indexoutofboundsexception:索引:88,长度:4(应为:范围(0,64))。
我使用标准的tpch-h数据模型,错误发生在查询12中。当我使用较小的数据集时,相同的查询成功运行。有人能告诉我为什么会这样吗?
查询:
select
l_shipmode,
sum(case
when o_orderpriority = '1-URGENT'
or o_orderpriority = '2-HIGH'
then 1
else 0
end) as high_line_count,
sum(case
when o_orderpriority <> '1-URGENT'
and o_orderpriority <> '2-HIGH'
then 1
else 0
end) as low_line_count
from
pq_orders,
pq_lineitem
where
o_orderkey = l_orderkey
and l_shipmode in ('REG AIR', 'MAIL')
and l_commitdate < l_receiptdate
and l_shipdate < l_commitdate
and l_receiptdate >= '1995-01-01'
and l_receiptdate < '1996-01-01'
group by
l_shipmode
order by
l_shipmode;
暂无答案!
目前还没有任何答案,快来回答吧!