How to change column types
Interana does its best to associate the correct column type with each column. However, should you want to change a column type, Interana allows you to do so manually.
Changing a column type requires a re-ingest of the data to get the correct values.
We have the following conversion types:
| Type | Conversion Function |
|---|---|
| Number | to_int, to_int_set, to_decimal, to_dollars |
| String | to_string, to_string_set, to_lower |
| Date | date_to_milli, to _milli, micro_to_milli, second_to_milli |
| User Agent | to_parsed_user_agent, to_browser_id |
| IP Address | ip_to_geo |
| URL | to_parsed_url |
To change the type of a column:
- Identify the column(s) that needs to be changed
- Use the following command.
/opt/interana/backend/import_server/change_column_type -t 'Table_name' -n 'Column' -f 'conversion_type' - Re-ingest the data.