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.