Skip to main content

How to change column types

Steve A.

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:
  1. Identify the column(s) that needs to be changed
  2. Use the following command./opt/interana/backend/import_server/change_column_type -t 'Table_name' -n 'Column' -f 'conversion_type'
  3. Re-ingest the data.
  • Was this article helpful?