Examples of HRecord

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

124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
            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

133
134
135
136
137
138
139
140
141
142
143
144
                           + ") "
                           + ") 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

149
150
151
152
153
154
155
156
157
    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

161
162
163
164
165
166
167
168
169
170
        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

174
175
176
177
178
179
180
181
182
183
184
185
        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

190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
        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

234
235
236
237
238
239
240
241
242
243
244
245
246
247
        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

569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
        }

        // 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

108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
    @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

126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
    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.