Examples of org.apache.pig.builtin.COUNT

org.apache.pig.builtin.COUNT
Generates the count of the number of values in a bag. This count does not include null values, and thus matches SQL semantics for COUNT(a) (where a is field) but not for COUNT(*) (where * in SQL indicates all).
This class implements {@link org.apache.pig.Algebraic}, so if possible the execution will performed in a distributed fashion.
There are no restrictions as to the data types inside the bag to be counted.
COUNT implements the {@link org.apache.pig.Accumulator} interface as well.While this will never be the preferred method of usage it is available in case the combiner can not be used for a given calculation.

    @Test
    public void testCOUNT() throws Exception {
        Integer input[] = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, null };
        long expected = input.length - 1;


        EvalFunc<Long> count = new COUNT();
        Tuple tup = Util.loadNestTuple(TupleFactory.getInstance().newTuple(1), input);
        Long output = count.exec(tup);


        assertTrue(output == expected);
    }

View Full Code Here

    @Test
    public void testCOUNT() throws Exception {
        Integer input[] = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, null };
        long expected = input.length - 1;


        EvalFunc<Long> count = new COUNT();
        Tuple tup = Util.loadNestTuple(TupleFactory.getInstance().newTuple(1), input);
        Long output = count.exec(tup);


        assertTrue(output == expected);
    }

View Full Code Here

    @Test
    public void testCOUNT() throws Exception {
        Integer input[] = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, null };
        long expected = input.length - 1;


        EvalFunc<Long> count = new COUNT();
        Tuple tup = Util.loadNestTuple(TupleFactory.getInstance().newTuple(1), input);
        Long output = count.exec(tup);


        assertTrue(output == expected);
    }

View Full Code Here

    @Test
    public void testCOUNT() throws Exception {
        Integer input[] = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, null };
        long expected = input.length - 1;


        EvalFunc<Long> count = new COUNT();
        Tuple tup = Util.loadNestTuple(TupleFactory.getInstance().newTuple(1), input);
        Long output = count.exec(tup);


        assertTrue(output == expected);
    }

View Full Code Here

                udfArgs[i] = input.get(i + 4);
            }
        }


        if ("count".equalsIgnoreCase(agg)) {
            func = new COUNT();
        } else if ("sum(double)".equalsIgnoreCase(agg) || 
            "sum(float)".equalsIgnoreCase(agg)) {
            func = new DoubleSum();
        } else if ("sum(int)".equalsIgnoreCase(agg) || 
            "sum(long)".equalsIgnoreCase(agg)) {

View Full Code Here

    @Test
    public void testCOUNT() throws Exception {
        Integer input[] = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, null };
        long expected = input.length - 1;


        EvalFunc<Long> count = new COUNT();
        Tuple tup = Util.loadNestTuple(TupleFactory.getInstance().newTuple(1), input);
        Long output = count.exec(tup);


        assertTrue(output == expected);
    }

View Full Code Here

    @Test
    public void testCOUNTBagNullCheck() throws Exception{
        DataBag b = null;
        Tuple t = TupleFactory.getInstance().newTuple(b);


        EvalFunc<Long> count = new COUNT();
        assertNull(count.exec(t));
       }

View Full Code Here

                udfArgs[i] = input.get(i + 4);
            }
        }


        if ("count".equalsIgnoreCase(agg)) {
            func = new COUNT();
        } else if ("sum(double)".equalsIgnoreCase(agg) || 
            "sum(float)".equalsIgnoreCase(agg)) {
            func = new DoubleSum();
        } else if ("sum(int)".equalsIgnoreCase(agg) || 
            "sum(long)".equalsIgnoreCase(agg)) {

View Full Code Here

import org.apache.pig.data.Tuple;


public class HelperEvalFuncUtils {
    public static class AlgCOUNT extends AlgFunc<Long> {
        public AlgCOUNT() {
            super(new COUNT());
        }

View Full Code Here

        }
    }


    public static class AccCOUNT extends AccFunc<Long> {
        public AccCOUNT() {
            super(new COUNT());
        }

View Full Code Here

0 1

TOP

Related Classes of org.apache.pig.builtin.COUNT

org.apache.pig.data.DataAtom

org.apache.pig.data.DataBag

org.apache.pig.data.Datum

org.apache.pig.data.Tuple

org.apache.pig.FuncSpec

org.apache.pig.impl.logicalLayer.schema.AtomSchema

org.apache.pig.impl.logicalLayer.schema.Schema

org.apache.pig.piggybank.evaluation.Over

org.apache.pig.test.TestBuiltin

org.apache.pig.test.utils.HelperEvalFuncUtils$AccCOUNT

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.