Pivotal Knowledge Base
Does below operations on table is anyway limited or not permitted if a table in Gemfire XD has very large date set.
1) Alter the table to introduce a new column
2) Alter the table to remove a column
3) Alter the table to increase the size of the column
4) Alter the table to change the data type of the column , say from numeric to varchar.
Please sign in to leave a comment.
1 - Yes.
2 - Yes.
3 - No.
4 - No.
It has no relationship with size of the table by the way. Please refer to Alter Table Limitations section at http://gemfirexd.docs.pivotal.io/latest/userguide/index.html?q=/latest/userguide/reference/language_ref/ref-sql-limitations.html
Regards