package brickhouse.udf.hll; /** * Copyright 2012,2013 Klout, Inc * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * **/ import com.clearspring.analytics.stream.cardinality.HyperLogLogPlus; import org.apache.hadoop.hive.ql.exec.Description; import org.apache.hadoop.hive.ql.exec.UDFArgumentException; import org.apache.hadoop.hive.ql.metadata.HiveException; import org.apache.hadoop.hive.ql.udf.generic.GenericUDF; import org.apache.hadoop.hive.serde2.objectinspector.ObjectInspector; import org.apache.hadoop.hive.serde2.objectinspector.ObjectInspector.Category; import org.apache.hadoop.hive.serde2.objectinspector.PrimitiveObjectInspector; import org.apache.hadoop.hive.serde2.objectinspector.PrimitiveObjectInspector.PrimitiveCategory; import org.apache.hadoop.hive.serde2.objectinspector.primitive.BinaryObjectInspector; import org.apache.hadoop.hive.serde2.objectinspector.primitive.PrimitiveObjectInspectorFactory; import org.apache.log4j.Logger; /** * Interpret a list of strings as a sketch_set * and return an estimated reach number */ @Description(name = "hll_est_cardinality", value = "_FUNC_(x) - Estimate reach from a HyperLogLog++. " ) public class EstimateCardinalityUDF extends GenericUDF { private static final Logger LOG = Logger.getLogger(EstimateCardinalityUDF.class); private BinaryObjectInspector binaryInspector; @Override public Object evaluate(DeferredObject[] arg0) throws HiveException { try { Object blobObj = arg0[0].get(); ///ByteArrayRef bref = this.binaryInspector.getPrimitiveJavaObject(blobObj); ///HyperLogLogPlus hll = HyperLogLogPlus.Builder.build( bref.getData() ); byte[] bref = this.binaryInspector.getPrimitiveJavaObject(blobObj); if (bref == null) return null; HyperLogLogPlus hll = HyperLogLogPlus.Builder.build(bref); return hll.cardinality(); } catch (Exception e) { LOG.error("Error", e); throw new HiveException(e); } } @Override public String getDisplayString(String[] arg0) { StringBuilder sb = new StringBuilder("hll_est_cardinality( "); for (int i = 0; i < arg0.length - 1; ++i) { sb.append(arg0[i]); sb.append(" , "); } sb.append(arg0[arg0.length - 1]); sb.append(" )"); return sb.toString(); } @Override public ObjectInspector initialize(ObjectInspector[] arg0) throws UDFArgumentException { if (arg0.length != 1) { throw new UDFArgumentException("hll_est_cardinality takes a binary object which was created with the hyperloglog UDAF"); } if (arg0[0].getCategory() != Category.PRIMITIVE) { throw new UDFArgumentException("hll_est_cardinality takes a binary object which was created with the hyperloglog UDAF"); } PrimitiveObjectInspector primInsp = (PrimitiveObjectInspector) arg0[0]; if (primInsp.getPrimitiveCategory() != PrimitiveCategory.BINARY) { throw new UDFArgumentException("hll_est_cardinality takes a binary object which was created with the hyperloglog UDAF"); } this.binaryInspector = (BinaryObjectInspector) primInsp; return PrimitiveObjectInspectorFactory.javaLongObjectInspector; } }