Skip to main content
Interania

How to change column types

0votes
8updates
118views

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?