|
The following information from a CREATE TABLE statement is needed:
- Presence of indexes
- Table options (specifically the ENGINE=... option)
The most important part is the capability to find out whether a CREATE TABLE statement contains index definitions or explicit ENGINE options. Optionally the following would speed up the processing:
- Table name
- Field names
- Field types (INT, VARCHAR etc.)
- Field attributes (UNSIGNED, NOT NULL)
For the field information, indexes must be identified and removed from the SQL statement as they aren't supported by ColumnStore. Unsupported types must also be converted to supported ones (in practice only SERIAL needs to be replaced with BIGINT UNSIGNED). For the table options, the main goal is to filter out any options that aren't supported by the ColumnStore engine and to remove explicit ENGINE=... options.
|