apache钻取错误索引超出界限

sauutmhj  于 2021-06-26  发布在  Hive
关注(0)|答案(0)|浏览(184)

我在相对较小的集群(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;

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题