Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - ALTER INDEX factmemberperiod_idx ON factmemberperiod REBUILD failed with Can't set bits out of order with EWAHCompressedBitmap


Copy link to this message
-
ALTER INDEX factmemberperiod_idx ON factmemberperiod REBUILD failed with Can't set bits out of order with EWAHCompressedBitmap
Vengala Reddy 2014-01-08, 17:30
Hi,
BITMAP index created and dung REBUILD it failed with below error.

CREATE INDEX factmemberperiod_idx ON TABLE
factmemberperiod(dimmembereffectiveperiodid)
AS 'BITMAP'
WITH DEFERRED REBUILD;

ALTER INDEX factmemberperiod_idx ON factmemberperiod REBUILD; Please help
me on this.

2014-01-08 11:08:09,076 FATAL ExecMapper:
org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error
while processing row
{"factmembersubscribermonthid":null,"dimclientid":null,"dimmemberid":null,"dimsubscriberid":null,"dimmembereffectiveperiodid":20110701,"dimmembereffperiodacctphysicianid":null,"dimmembereffperiodacctphysiciangroupingid":null,"memberperiodcount":null,"block__offset__inside__file":135345496,"input__file__name":"hdfs://nameservice1/dev1/clients/ibc/ibcdw_rc/factmemberperiod/part-m-00000","row__offset__inside__block":58}
at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:675)
at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:141)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:417)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)
at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408)
at org.apache.hadoop.mapred.Child.main(Child.java:262)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.RuntimeException: Can't set bits out of order with
EWAHCompressedBitmap
at org.apache.hadoop.hive.ql.exec.GroupByOperator.processOp(GroupByOperator.java:824)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:474)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:800)
at org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.java:84)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:474)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:800)
at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:83)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:474)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:800)
at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:654)
... 9 more
Caused by: java.lang.RuntimeException: Can't set bits out of order
with EWAHCompressedBitmap
at org.apache.hadoop.hive.ql.udf.generic.GenericUDAFEWAHBitmap$GenericUDAFEWAHBitmapEvaluator.addBitmap(GenericUDAFEWAHBitmap.java:189)
at org.apache.hadoop.hive.ql.udf.generic.GenericUDAFEWAHBitmap$GenericUDAFEWAHBitmapEvaluator.iterate(GenericUDAFEWAHBitmap.java:138)
at org.apache.hadoop.hive.ql.udf.generic.GenericUDAFEvaluator.aggregate(GenericUDAFEvaluator.java:139)
at org.apache.hadoop.hive.ql.exec.GroupByOperator.updateAggregations(GroupByOperator.java:658)
at org.apache.hadoop.hive.ql.exec.GroupByOperator.processHashAggr(GroupByOperator.java:854)
at org.apache.hadoop.hive.ql.exec.GroupByOperator.processKey(GroupByOperator.java:751)
at org.apache.hadoop.hive.ql.exec.GroupByOperator.processOp(GroupByOperator.java:819)
... 18 more