Examples of HRecord


Examples of org.apache.hadoop.hbase.hbql.client.HRecord

            for (int j = 0; j < intv1.length; j++) {
                intv1[j] = j * 10;
                val8check[j] = intv1[j];
            }

            final HRecord rec = conn.getMapping("tab8").newHRecord();
            rec.setCurrentValue("keyval", keyval);
            rec.setCurrentValue("val1", s_val5);
            rec.setCurrentValue("val2", s_val5 + " " + msg);
            rec.setCurrentValue("val5", val5);
            rec.setCurrentValue("val6", i * 100);
            rec.setCurrentValue("f3mapval1", mapval1);
            rec.setCurrentValue("f3mapval2", mapval2);
            rec.setCurrentValue("val8", intv1);

            batch.insert(rec);
        }

        batch.apply();
View Full Code Here

Examples of org.apache.hadoop.hbase.hbql.client.HRecord

                           + ") "
                           + ") if not mappingexists('pool_test')");

        String sql = "SELECT count() as cnt FROM pool_test WITH CLIENT FILTER WHERE definedinrow(f1:val1)";
        List<HRecord> recs = connection.executeQueryAndFetch(sql);
        HRecord rec = recs.get(0);
        long cnt = (Long)rec.getCurrentValue("cnt");
        assertTrue(cnt == count);

        connection.close();

        System.out.println("Completed: " + id + " - " + iteration);
View Full Code Here

Examples of org.apache.hadoop.hbase.hbql.client.HRecord

    public void selectCount() throws HBqlException {
        final String query1 = "SELECT count() as cnt FROM aggmapping";
        HStatement stmt = connection.createStatement();
        List<HRecord> recList1 = stmt.executeQueryAndFetch(query1);
        assertTrue(recList1.size() == 1);
        HRecord rec = recList1.get(0);
        long cnt = (Long)rec.getCurrentValue("cnt");
        assertTrue(cnt == val5List.size());
    }
View Full Code Here

Examples of org.apache.hadoop.hbase.hbql.client.HRecord

        final String query1 = "SELECT max(val5) as max FROM aggmapping";
        HStatement stmt = connection.createStatement();
        List<HRecord> recList1 = stmt.executeQueryAndFetch(query1);
        assertTrue(recList1.size() == 1);
        HRecord rec = recList1.get(0);
        int max = (Integer)rec.getCurrentValue("max");

        assertTrue(max == val5max);
    }
View Full Code Here

Examples of org.apache.hadoop.hbase.hbql.client.HRecord

        final String query1 = "SELECT min(val5) as min, min(val5+1) as min2 FROM aggmapping";
        HStatement stmt = connection.createStatement();
        List<HRecord> recList1 = stmt.executeQueryAndFetch(query1);
        assertTrue(recList1.size() == 1);
        HRecord rec = recList1.get(0);
        int min = (Integer)rec.getCurrentValue("min");
        int min2 = (Integer)rec.getCurrentValue("min2");

        assertTrue(min == val5min);
        assertTrue(min2 == val5min + 1);
    }
View Full Code Here

Examples of org.apache.hadoop.hbase.hbql.client.HRecord

        final String query1 = "SELECT count() as cnt, max(val5) as max, min(val5) as min, min(val5+1) as min2 " +
                              "FROM aggmapping";
        HStatement stmt = connection.createStatement();
        List<HRecord> recList1 = stmt.executeQueryAndFetch(query1);
        assertTrue(recList1.size() == 1);
        HRecord rec = recList1.get(0);
        long cnt = (Long)rec.getCurrentValue("cnt");
        int max = (Integer)rec.getCurrentValue("max");
        int min = (Integer)rec.getCurrentValue("min");
        int min2 = (Integer)rec.getCurrentValue("min2");

        assertTrue(cnt == val5List.size());
        assertTrue(max == val5max);
        assertTrue(min == val5min);
        assertTrue(min2 == val5min + 1);
View Full Code Here

Examples of org.apache.hadoop.hbase.hbql.client.HRecord

        conn.execute("INSERT INTO fooMapping (keyval, val1, val2) "
                     + "VALUES (ZEROPAD(2, 10), 123, 'test val')");

        // Or using the Record interface
        HRecord rec = conn.getMapping("fooMapping").newHRecord();
        rec.setCurrentValue("keyval", Util.getZeroPaddedNonNegativeNumber(2, 10));
        rec.setCurrentValue("val1", 123);
        rec.setCurrentValue("al2", "testval");

        HBatch<HRecord> batch = conn.newHBatch();
        batch.insert(rec);
        batch.apply();
View Full Code Here

Examples of org.apache.hadoop.hbase.hbql.client.HRecord

        }

        // Add some other records using the Record interface
        final HBatch<HRecord> batch = conn.newHBatch();
        for (int i = 5; i < 10; i++) {
            HRecord rec = conn.getMapping("demo1").newHRecord();
            rec.setCurrentValue("keyval", Util.getZeroPaddedNonNegativeNumber(i, 10));
            rec.setCurrentValue("val1", "Value: " + i);
            rec.setCurrentValue("f1:val2", i);
            batch.insert(rec);
        }
        batch.apply();

        // Query the records just added
        HResultSet<HRecord> records = conn.executeQuery("SELECT * FROM demo1");

        for (HRecord rec : records) {
            System.out.println("Key = " + rec.getCurrentValue("keyval"));
            System.out.println("f1:val1 = " + rec.getCurrentValue("val1"));
            System.out.println("f1:val2 = " + rec.getCurrentValue("f1:val2"));
            System.out.println("f1:val3 = " + rec.getCurrentValue("f1:val3"));
        }

        stmt.close();

        // END SNIPPET: definedExample1
View Full Code Here

Examples of org.apache.hadoop.hbase.hbql.client.HRecord

    @Test
    public void deleteColumn() throws HBqlException {

        String sql = "SELECT count() as cnt FROM delete_test WITH CLIENT FILTER WHERE definedinrow(f1:val1)";
        List<HRecord> recs = connection.executeQueryAndFetch(sql);
        HRecord rec = recs.get(0);
        long cnt = (Long)rec.getCurrentValue("cnt");
        assertTrue(cnt == count);

        connection.executeUpdate("DELETE f1:val1 FROM delete_test");

        recs = connection.executeQueryAndFetch(sql);
        rec = recs.get(0);
        cnt = (Long)rec.getCurrentValue("cnt");
        assertTrue(cnt == 0);
    }
View Full Code Here

Examples of org.apache.hadoop.hbase.hbql.client.HRecord

    public void deleteColumns() throws HBqlException {

        String sql = "SELECT count() as cnt FROM delete_test " +
                     "WITH CLIENT FILTER WHERE definedinrow(val11) AND definedinrow(val12)";
        List<HRecord> recs = connection.executeQueryAndFetch(sql);
        HRecord rec = recs.get(0);
        long cnt = (Long)rec.getCurrentValue("cnt");
        assertTrue(cnt == count);

        connection.executeUpdate("DELETE val11, f2:val2 FROM delete_test");

        recs = connection.executeQueryAndFetch(sql);
        rec = recs.get(0);
        cnt = (Long)rec.getCurrentValue("cnt");
        assertTrue(cnt == 0);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.