Support Questions

Find answers, ask questions, and share your expertise

HDP3.1 HIVE bucketId out of range: -1 ???

avatar
Contributor

108998-1559108975828.png

109007-1559109037235.png


5 REPLIES 5

avatar
Master Guru

@jingyong zou

Could you once change the split strategy and then run you select statement.

Set hive.exec.orc.split.strategy=="ETL";

The available options are "BI", "ETL" and "HYBRID".

avatar
Contributor

Thank you, but it's the same after the revision

avatar

facing similar issue. Did you resolve this

avatar

is there any resolution to this.

I am seeing this issue with one of the acid tables which has around 25 M records.

 Other tables have 700 M records and are working fine.  Facing this issue only for few tables.

avatar
Contributor

@jingyong zou,


Is it a new table or an older table created in HDP2.x? if it is the older table created in HDP2.x than there might be chances you are hitting HIVE-20593