This topic describes the naming conventions of aliases. This topic also provides examples of aliases.

Naming conventions

A column name specified in an SQL statement can contain letters, digits, and underscores (_). The name must start with a letter. If you specify a column name that does not comply with the SQL-92 syntax when you collect logs, you must specify an alias for the column name when you configure indexes. For more information about how to configure indexes, see Configure indexes.

You can specify a short alias for a column whose original name is long and use the alias in an analytic statement.

Notice You can use aliases only in analytic statements. You must use original column names in search statements.
Column aliases


Original column name Alias
User-Agent User_Agent
User.Agent user_agent
123 col
abceefghijklmnopqrstuvw abc