![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
alter space name <string> add index ( name <string> [type <string>] fields (<string> (, <string>)*))Use alter space to add a field to an existing space definition, or to add or drop an index from a space definition.
Table 3 alter space Parameters
• name specifies the name of the field to be added.
• type specifies the data type for the field. Must be one of the following: boolean, char, short, integer, long, float, double, string, datetime, blob.
• nullable is optional when adding a field. If you do not specify the nullable parameter, the field is by default not nullable. If you enter nullable, you must enter nullable true.
• name specifies the name of the index.
• type specifies the type of the index, which can be hash or tree.
• fields specifies the fields to be used in the index. alter space name “myspace” add (field name “average” type “double”)
• fields: (field name “average” type “double”)
• index: index (name “index1” type “hash” fields(“a”, “b”, “c”))
You cannot add and drop an index in the same alter space command with as-admin. However, you can do this using the API operations. For an example showing how to do this with the Java API set, see Adding and dropping an index using the Java API in the TIBCO ActiveSpaces Developer’s Guide.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |