Examples of HStatement

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

133
134
135
136
137
138
139
140
141
142
143
144
                              + "TIME RANGE NOW()-DAY(25) TO NOW()+DAY(1) "
                              + "VERSIONS 3 "
                              //+ "SERVER FILTER WHERE author LIKE '.*val.*' OR LENGTH(author) > 4 "
                              + "CLIENT FILTER WHERE author LIKE '.*val.*' OR LENGTH(author) > 4";

        HStatement stmt = conn.createStatement();
        HResultSet<TestObject> results2 = stmt.executeQuery(query2, TestObject.class);

        for (TestObject val2 : results2) {
            System.out.println("Current Values: " + val2.keyval + " - " + val2.author + " - " + val2.title);

            System.out.println("Historicals");
View Full Code Here

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

146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
    @Test
    public void selectExpressions() throws HBqlException {

        final String query1 = "SELECT val1, val5, (val5 - val5 + val5) as val6, (val5+val5) as val7 FROM tab8";

        HStatement stmt = connection.createStatement();
        HResultSet<HRecord> results1 = stmt.executeQuery(query1);

        List<String> testKeyVals = Lists.newArrayList();
        List<String> testVal1Vals = Lists.newArrayList();
        List<Integer> testVal5Vals = Lists.newArrayList();
        List<Integer> testVal6Vals = Lists.newArrayList();

        int rec_cnt = 0;
        for (HRecord rec : results1) {

            String keyval = (String)rec.getCurrentValue("keyval");
            String val1 = (String)rec.getCurrentValue("val1");
            Integer val5 = (Integer)rec.getCurrentValue("val5");
            Integer val6 = (Integer)rec.getCurrentValue("val6");

            testKeyVals.add(keyval);
            testVal1Vals.add(val1);
            testVal5Vals.add(val5);
            testVal6Vals.add(val6);

            System.out.println("Current Values: " + keyval
                               + " - " + rec.getCurrentValue("val1")
                               + " - " + rec.getCurrentValue("val5")
                               + " - " + rec.getCurrentValue("val6")
            );
            rec_cnt++;
        }

        assertTrue(testKeyVals.equals(keyList));
        assertTrue(testVal1Vals.equals(val1List));
        assertTrue(testVal5Vals.equals(val5List));
        assertTrue(testVal6Vals.equals(val5List));

        stmt = connection.createStatement();
        List<HRecord> recList2 = stmt.executeQueryAndFetch(query1);

        assertTrue(recList2.size() == rec_cnt);

        final String query3 = "SELECT val1, val5, (val5 - val5 + val5) as val6, (val5+val5) as val7 FROM tab8 " +
                              "WITH KEYS '0000000001' , '0000000002'";

        stmt = connection.createStatement();
        List<HRecord> recList3 = stmt.executeQueryAndFetch(query3);
        assertTrue(recList3.size() == 2);

        final String query4 = "SELECT val1, val5, (val5 - val5 + val5) as val6, (val5+val5) as val7 FROM tab8 " +
                              "WITH KEYS :key1";
View Full Code Here

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

87
88
89
90
91
92
93
94
95
96
97
98
    private static void showValues() throws HBqlException {

        final String query1 = "SELECT keyval, val1, val2, val3 FROM tab3";

        HStatement stmt = connection.createStatement();
        HResultSet<HRecord> results = stmt.executeQuery(query1);

        int rec_cnt = 0;
        for (HRecord rec : results) {

            String keyval = (String)rec.getCurrentValue("keyval");
View Full Code Here

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

114
115
116
117
118
119
120
121
122
123
124
125
        List<AnnotatedAllTypes> vals = insertSomeData(cnt, true);

        assertTrue(vals.size() == cnt);

        HStatement stmt = conn.createStatement();
        HResultSet<AnnotatedAllTypes> recs = stmt.executeQuery("select * from alltypes2", AnnotatedAllTypes.class);

        int reccnt = 0;
        for (final AnnotatedAllTypes rec : recs)
            assertTrue(rec.equals(vals.get(reccnt++)));

View Full Code Here

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

131
132
133
134
135
136
137
138
139
140
141
142
        List<AnnotatedAllTypes> vals = insertSomeData(cnt, false);

        assertTrue(vals.size() == cnt);

        HStatement stmt = conn.createStatement();
        HResultSet<AnnotatedAllTypes> recs = stmt.executeQuery("select * from alltypes2", AnnotatedAllTypes.class);

        int reccnt = 0;
        for (final AnnotatedAllTypes rec : recs)
            assertTrue(rec.equals(vals.get(reccnt++)));

View Full Code Here

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

108
109
110
111
112
113
114
115
116
117
118
119
        List<RecordAllTypes> vals = insertSomeData(cnt, true);

        assertTrue(vals.size() == cnt);

        HStatement stmt = conn.createStatement();
        HResultSet<HRecord> recs = stmt.executeQuery("select * from alltypes");

        int reccnt = 0;
        for (final HRecord rec : recs)
            assertTrue((new RecordAllTypes(rec)).equals(vals.get(reccnt++)));

View Full Code Here

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

125
126
127
128
129
130
131
132
133
134
135
136
        List<RecordAllTypes> vals = insertSomeData(cnt, false);

        assertTrue(vals.size() == cnt);

        HStatement stmt = conn.createStatement();
        HResultSet<HRecord> recs = stmt.executeQuery("select * from alltypes");

        int reccnt = 0;
        for (final HRecord rec : recs)
            assertTrue((new RecordAllTypes(rec)).equals(vals.get(reccnt++)));

View Full Code Here

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

146
147
148
149
150
151
152
153
154
155
156
157
    }

    @Test
    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.HStatement

158
159
160
161
162
163
164
165
166
167
168
169
    @Test
    public void selectMax() throws HBqlException {

        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.HStatement

171
172
173
174
175
176
177
178
179
180
181
182
    @Test
    public void selectMin() throws HBqlException {

        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");
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.