Package org.hivedb.meta

Examples of org.hivedb.meta.SecondaryIndex

69
70
71
72
73
74
75
76
77
  class SecondaryIndexRowMapper implements RowMapper {
    public Object mapRow(ResultSet rs, int index) throws SQLException{
      int jdbcType = Types.OTHER;
      jdbcType = JdbcTypeMapper.parseJdbcType(rs.getString("db_type"));
     
      SecondaryIndex si = new SecondaryIndex(rs.getInt("id"),
          rs.getString("column_name"), jdbcType);
      return si;
    }
View Full Code Here
129
130
131
132
133
134
135
136
137
    resource.setPartitionDimension(createEmptyPartitionDimension());
    return resource;
  }

  protected SecondaryIndex createSecondaryIndex() {
    SecondaryIndex index = new SecondaryIndex("FOO", java.sql.Types.VARCHAR);
    index.setResource(createResource());
    return index;
  }
View Full Code Here
135
136
137
138
139
140
141
142
143
    index.setResource(createResource());
    return index;
  }

  protected SecondaryIndex createSecondaryIndex(int id) {
    SecondaryIndex index = new SecondaryIndex(id, "FOO", java.sql.Types.VARCHAR);
    index.setResource(createResource());
    return index;
  }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    Collection<SecondaryIndex> secondaryIndexes = new ArrayList<SecondaryIndex>();
    if (indexes != null) {
      for (Map<String, String> index : indexes) {
        String name = index.get("name");
        String type = index.get("type");
        SecondaryIndex secondaryIndex = new SecondaryIndex(name, JdbcTypeMapper.parseJdbcType(stringToVarchar(type)));
        secondaryIndexes.add(secondaryIndex);
      }
    }
    return secondaryIndexes;
  }
View Full Code Here
190
191
192
193
194
195
196
      throw new HiveRuntimeException(e.getMessage(), e);
    }
  }

  private SecondaryIndex createSecondaryIndex(EntityIndexConfig config) {
    return new SecondaryIndex(config.getIndexName(), JdbcTypeMapper.primitiveTypeToJdbcType(config.getIndexClass()));
  }
View Full Code Here
86
87
88
89
90
91
92
93
    return new HiveDiff(missingResources, indexMap);
  }
  private Unary<EntityIndexConfig, SecondaryIndex> configToIndex() {
    return new Unary<EntityIndexConfig, SecondaryIndex>(){
      public SecondaryIndex f(EntityIndexConfig item) {
        return new SecondaryIndex(item.getIndexName(), JdbcTypeMapper.primitiveTypeToJdbcType(item.getIndexClass()));
      }};
  }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
  private SecondaryIndex getSecondaryIndex(String resourceName, String secondaryIndexName) {
    return getResource(resourceName).getSecondaryIndex(secondaryIndexName);
  }

  public void deleteSecondaryIndexKey(String resource, String secondaryIndex, Object secondaryIndexKey, Object resourceId) throws HiveLockableException {
    SecondaryIndex index = getSecondaryIndex(resource, secondaryIndex);
    Preconditions.isWritable(directory.getKeySemaphoresOfResourceId(getResource(resource), resourceId), semaphore);
    if (!directory.doesSecondaryIndexKeyExist(index, secondaryIndexKey, resourceId))
      throw new HiveKeyNotFoundException(
          String.format(
              "Secondary index key %s of secondary index %s does not exist",
              secondaryIndexKey, index.getName()), secondaryIndexKey);

    directory.deleteSecondaryIndexKey(index, secondaryIndexKey, resourceId);
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
    // Add it to the Hive
    product = hive.addResource(product);

    //Now create a SecondaryIndex
    SecondaryIndex nameIndex = new SecondaryIndex("name", Types.VARCHAR);
    //Add it to the Hive
    nameIndex = hive.addSecondaryIndex(product, nameIndex);
    //Note: SecondaryIndexes are identified by ResourceName.IndexColumnName

    //Now lets add a product to the hive.
    Product spork = new Product(23, "Spork", "Cutlery");
    //First we have to add a primary index entry in order to get allocated to a data node.
    //While it is possible to write a record to multiple locations within the Hive, the default implementation
    //inserts a single copy.
    hive.directory().insertPrimaryIndexKey(spork.getType());
    //Next we insert the record into the assigned data node
    Collection<SimpleJdbcDaoSupport> sporkDaos = hive.connection().daoSupport().get(spork.getType(), AccessType.ReadWrite);
    PreparedStatementCreatorFactory stmtFactory =
      new PreparedStatementCreatorFactory(productInsertSql, new int[]{Types.INTEGER, Types.VARCHAR, Types.VARCHAR});
    Object[] parameters = new Object[]{spork.getId(), spork.getName(), spork.getType()};
    for (JdbcDaoSupport dao : sporkDaos)
      dao.getJdbcTemplate().update(stmtFactory.newPreparedStatementCreator(parameters));

    //Update the resource id so that the hive can locate it
    hive.directory().insertResourceId(resourceName, spork.getId(), spork.getType());
    //Finally we update the SecondaryIndex
    hive.directory().insertSecondaryIndexKey(resourceName, "name", spork.getName(), spork.getId());

    //Retrieve spork by Primary Key
    sporkDaos = hive.connection().daoSupport().get(spork.getType(), AccessType.ReadWrite);
    parameters = new Object[]{spork.getId()};

    //Here I am taking advantage of the fact that I know there is only one copy.
    Product productA = (Product) Atom.getFirst(sporkDaos).getJdbcTemplate().queryForObject(selectProductById, parameters, new ProductRowMapper());
    //Make sure its a spork
    Assert.assertEquals(spork.getName(), productA.getName());

    //Retrieve the spork by Name
    sporkDaos = (Collection<SimpleJdbcDaoSupport>) hive.connection().daoSupport().get(resourceName, nameIndex.getName(), spork.getName(), AccessType.Read);
    parameters = new Object[]{spork.getName()};
    Product productB = (Product) Atom.getFirst(sporkDaos).getJdbcTemplate().queryForObject(selectProductByName, parameters, new ProductRowMapper());
    //Make sure its a spork
    Assert.assertEquals(spork.getId(), productB.getId());
View Full Code Here
21
22
23
24
25
26
27
28
29
30
  public void testDelete() throws Exception {
    SecondaryIndexDao d = new SecondaryIndexDao(getDataSource(getConnectString(getHiveDatabaseName())));
    int initialSize = d.loadAll().size();
    int id = d.create(createSecondaryIndex());
    assertEquals(initialSize+1,d.loadAll().size());
    SecondaryIndex s = createSecondaryIndex(id);
    s.setResource(createResource());
    d.delete(s);
    assertEquals(initialSize,d.loadAll().size());
  }
View Full Code Here
93
94
95
96
97
98
99
100
    return resource;
  }

  private Collection<SecondaryIndex> createSecondaryIndexes() {
    return Arrays.asList(
      new SecondaryIndex("name", Types.VARCHAR),
      new SecondaryIndex("num", Types.INTEGER));
  }
View Full Code Here
TOP

Related Classes of org.hivedb.meta.SecondaryIndex

  • org.hivedb.ExampleHiveTest
  • org.hivedb.hibernate.ConfigurationReader
  • org.hivedb.meta.directory.DbDirectoryTest
  • org.hivedb.meta.directory.DirectoryWrapper
  • org.hivedb.meta.persistence.ColumnInfo
  • org.hivedb.meta.persistence.SecondaryIndexDao$SecondaryIndexRowMapper
  • org.hivedb.persistence.TestSecondaryIndexPersistence
  • org.hivedb.util.BourneHive
  • org.hivedb.util.database.test.HiveTest
  • org.hivedb.util.HiveSyncer
    • 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.