apache钻取错误索引超出界限

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

我在相对较小的集群(4个16gb节点)中使用apachedrill对100gb数据集执行查询。当我尝试运行某个查询时,它会显示以下错误:
错误:系统错误:indexoutofboundsexception:索引:88,长度:4(应为:范围(0,64))。
我使用标准的tpch-h数据模型,错误发生在查询12中。当我使用较小的数据集时,相同的查询成功运行。有人能告诉我为什么会这样吗?
查询:

  1. select
  2. l_shipmode,
  3. sum(case
  4. when o_orderpriority = '1-URGENT'
  5. or o_orderpriority = '2-HIGH'
  6. then 1
  7. else 0
  8. end) as high_line_count,
  9. sum(case
  10. when o_orderpriority <> '1-URGENT'
  11. and o_orderpriority <> '2-HIGH'
  12. then 1
  13. else 0
  14. end) as low_line_count
  15. from
  16. pq_orders,
  17. pq_lineitem
  18. where
  19. o_orderkey = l_orderkey
  20. and l_shipmode in ('REG AIR', 'MAIL')
  21. and l_commitdate < l_receiptdate
  22. and l_shipdate < l_commitdate
  23. and l_receiptdate >= '1995-01-01'
  24. and l_receiptdate < '1996-01-01'
  25. group by
  26. l_shipmode
  27. order by
  28. l_shipmode;

暂无答案!

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

相关问题