Support Questions
Find answers, ask questions, and share your expertise

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

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

108998-1559108975828.png

109007-1559109037235.png


5 REPLIES 5

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

Super 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".

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

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

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

New Contributor

facing similar issue. Did you resolve this

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

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.

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

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