Package org.apache.hadoop.hbase.hbql.client

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

69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
    }

    private static void insertRecords(final HConnection connection,
                                      final int cnt) throws HBqlException {

        HPreparedStatement stmt = connection.prepareStatement("insert into tab4 " +
                                                              "(keyval, val1, val2, val3, val4) values " +
                                                              "(:key, :val1, :val2, :val3, :val4)");

        for (int i = 0; i < cnt; i++) {

            int val = 10 + i;

            final String keyval = Util.getZeroPaddedNonNegativeNumber(i, 15);

            stmt.setParameter("key", keyval);
            stmt.setParameter("val1", Util.getZeroPaddedNonNegativeNumber(val * 100, 15));
            stmt.setParameter("val2", val);
            stmt.setParameter("val3", randomVal.nextInt());
            stmt.setParameter("val4", (i % 2) == 0);
            stmt.execute();
        }
    }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
    }

    private static void insertRecords(final HConnection connection,
                                      final int cnt) throws HBqlException {

        HPreparedStatement stmt = connection.prepareStatement("insert into tab3 " +
                                                              "(keyval, val1, val2, val3) values " +
                                                              "(:key, :val1, :val2, DEFAULT)");

        for (int i = 0; i < cnt; i++) {

            int val = 10 + i;

            final String keyval = Util.getZeroPaddedNonNegativeNumber(i, TestSupport.keywidth);

            stmt.setParameter("key", keyval);
            stmt.setParameter("val1", "" + val);
            stmt.setParameter("val2", val);
            stmt.execute();
        }
    }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
        else if (this.getSystemMappingsMap().get(mappingName) != null)
            return true;
        else {
            // Do not check cached mappings map, go to the server for answer
            final String sql = "SELECT mapping_name FROM " + SYSTEM_MAPPINGS + " WITH KEYS ?";
            final HPreparedStatement stmt = this.getConnection().prepareStatement(sql);
            ((HStatementImpl)stmt).setIgnoreQueryExecutor(true);
            stmt.setParameter(1, mappingName);
            final List<HRecord> recs = stmt.executeQueryAndFetch();
            stmt.close();
            final boolean retval = recs.size() > 0;

            if (!retval) {
                // Remove from cached mappings map if it was dropped by another user
                if (this.getCachedMappingsMap().containsKey(mappingName))
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
            // Remove from cached mappings map
            if (this.getCachedMappingsMap().containsKey(mappingName))
                this.getCachedMappingsMap().remove(mappingName);

            final String sql = "DELETE FROM " + SYSTEM_MAPPINGS + " WITH KEYS ?";
            final HPreparedStatement stmt = this.getConnection().prepareStatement(sql);
            stmt.setParameter(1, mappingName);
            final int cnt = stmt.executeUpdate().getCount();
            return cnt > 0;
        }
    }
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
179
180
        }
        else {
            this.getCachedMappingsMap().put(mappingName, tableMapping);

            final String sql = "INSERT INTO " + SYSTEM_MAPPINGS + " (mapping_name, mapping_obj) VALUES (?, ?)";
            final HPreparedStatement stmt = this.getConnection().prepareStatement(sql);
            stmt.setParameter(1, tableMapping.getMappingName());
            stmt.setParameter(2, tableMapping);
            stmt.execute();
        }

        return tableMapping;
    }
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
201
202
        else if (this.getCachedMappingsMap().containsKey(mappingName)) {
            return this.getCachedMappingsMap().get(mappingName);
        }
        else {
            final String sql = "SELECT mapping_obj FROM " + SYSTEM_MAPPINGS + " WITH KEYS ?";
            final HPreparedStatement stmt = this.getConnection().prepareStatement(sql);
            stmt.setParameter(1, mappingName);
            List<HRecord> recs = stmt.executeQueryAndFetch();

            if (recs.size() == 0)
                throw new HBqlException("Mapping not found: " + mappingName);
            else
                return (TableMapping)recs.get(0).getCurrentValue("mapping_obj");
View Full Code Here
TOP

Related Classes of org.apache.hadoop.hbase.hbql.client.HPreparedStatement

  • org.apache.hadoop.hbase.hbql.AggregateTest
  • org.apache.hadoop.hbase.hbql.AnnotationAllTypesTest
  • org.apache.hadoop.hbase.hbql.ConnectionPoolTest
  • org.apache.hadoop.hbase.hbql.DeleteTest
  • org.apache.hadoop.hbase.hbql.ExamplesTest
  • org.apache.hadoop.hbase.hbql.impl.MappingManager
  • org.apache.hadoop.hbase.hbql.InsertTest
  • org.apache.hadoop.hbase.hbql.InsertWithSelectTest
  • org.apache.hadoop.hbase.hbql.NullValuesTest
  • org.apache.hadoop.hbase.hbql.RecordAllTypesTest
    • Copyright © 2018 www.massapicom. 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.