​
Axiom Docs

​
Query reference

  • arg_max: This page explains how to use the arg_max aggregation in APL.
  • arg_min: This page explains how to use the arg_min aggregation in APL.
  • avg: This page explains how to use the avg aggregation function in APL.
  • avgif: This page explains how to use the avgif aggregation function in APL.
  • count: This page explains how to use the count aggregation function in APL.
  • countif: This page explains how to use the countif aggregation function in APL.
  • dcount: This page explains how to use the dcount aggregation function in APL.
  • dcountif: This page explains how to use the dcountif aggregation function in APL.
  • histogram: This page explains how to use the histogram aggregation function in APL.
  • make_list: This page explains how to use the make_list aggregation function in APL.
  • make_list_if: This page explains how to use the make_list_if aggregation function in APL.
  • make_set: This page explains how to use the make_set aggregation function in APL.
  • make_set_if: This page explains how to use the make_set_if aggregation function in APL.
  • max: This page explains how to use the max aggregation function in APL.
  • maxif: This page explains how to use the maxif aggregation function in APL.
  • min: This page explains how to use the min aggregation function in APL.
  • minif: This page explains how to use the minif aggregation function in APL.
  • percentile: This page explains how to use the percentile aggregation function in APL.
  • percentileif: This page explains how to use the percentileif aggregation function in APL.
  • percentiles_array: This page explains how to use the percentiles_array function in APL.
  • percentiles_arrayif: This page explains how to use the percentiles_array function in APL.
  • rate: This page explains how to use the rate aggregation function in APL.
  • Aggregation functions: This section explains how to use and combine different aggregation functions in APL.
  • stdev: This page explains how to use the stdev aggregation function in APL.
  • stdevif: This page explains how to use the stdevif aggregation function in APL.
  • sum: This page explains how to use the sum aggregation function in APL.
  • sumif: This page explains how to use the sumif aggregation function in APL.
  • topk: This page explains how to use the topk aggregation function in APL.
  • topkif: This page explains how to use the topkif aggregation in APL.
  • variance: This page explains how to use the variance aggregation function in APL.
  • varianceif: This page explains how to use the varianceif aggregation function in APL.
  • All features of Axiom Processing Language (APL): This page gives an overview about all the features of Axiom Processing Language (APL).
  • Map fields: This page explains what map fields are and how to query them.
  • Null values: This page explains how APL represents missing values.
  • Scalar data types: This page explains the data types in APL.
  • Entity names: This page explains how to use entity names in your APL query.
  • Migrate from SQL to APL: This guide helps you migrate SQL to APL, helping you understand key differences and providing you with query examples.
  • Migrate from Sumo Logic Query Language to APL: This guide dives into why APL could be a superior choice for your data needs, and the differences between Sumo Logic and APL.
  • Migrate from Splunk SPL to APL: This step-by-step guide provides a high-level mapping from Splunk SPL to APL.
  • Axiom Processing Language (APL): This section explains how to use the Axiom Processing Language to get deeper insights from your data.
  • Set statement: The set statement is used to set a query option in your APL query.
  • Special field attributes: This page explains how to implement special fields within APL queries to enhance the functionality and interactivity of datasets. Use these fields in APL queries to add unique behaviors to the Axiom user interface.
  • Array functions: This section explains how to use array functions in APL.
  • array_concat: This page explains how to use the array_concat function in APL.
  • array_extract: This page explains how to use the array_extract function in APL.
  • array_iff: This page explains how to use the array_iff function in APL.
  • array_index_of: This page explains how to use the array_index_of function in APL.
  • array_length: This page explains how to use the array_length function in APL.
  • array_reverse: This page explains how to use the array_reverse function in APL.
  • array_rotate_left: This page explains how to use the array_rotate_left function in APL.
  • array_rotate_right: This page explains how to use the array_rotate_right function in APL.
  • array_select_dict: This page explains how to use the array_select_dict function in APL.
  • array_shift_left: This page explains how to use the array_shift_left function in APL.
  • array_shift_right: This page explains how to use the array_shift_right function in APL.
  • array_slice: This page explains how to use the array_slice function in APL.
  • array_sort_asc: This page explains how to use the array_sort_asc function in APL.
  • array_sort_desc: This page explains how to use the array_sort_desc function in APL.
  • array_split: This page explains how to use the array_split function in APL.
  • array_sum: This page explains how to use the array_sum function in APL.
  • bag_has_key: This page explains how to use the bag_has_key function in APL.
  • bag_keys: This page explains how to use the bag_keys function in APL.
  • bag_pack: This page explains how to use the bag_pack and pack functions in APL.
  • isarray: This page explains how to use the isarray function in APL.
  • len: This page explains how to use the len function in APL.
  • pack_array: This page explains how to use the pack_array function in APL.
  • pack_dictionary: This page explains how to use the pack_dictionary function in APL.
  • strcat_array: This page explains how to use the strcat_array function in APL.
  • Conditional functions: Learn how to use and combine different conditional functions in APL
  • Conversion functions: Learn how to use and combine different conversion functions in APL
  • toarray: This page explains how to use the toarray function in APL.
  • todynamic: This page explains how to use the todynamic function in APL.
  • Datetime functions: Learn how to use and combine different timespan functions in APL
  • unixtime_microseconds_todatetime: This page explains how to use the unixtime_microseconds_todatetime function in APL.
  • unixtime_milliseconds_todatetime: This page explains how to use the unixtime_milliseconds_todatetime function in APL.
  • unixtime_nanoseconds_todatetime: This page explains how to use the unixtime_nanoseconds_todatetime function in APL.
  • unixtime_seconds_todatetime: This page explains how to use the unixtime_seconds_todatetime function in APL.
  • week_of_year: This page explains how to use the week_of_year function in APL.
  • Hash functions: Learn how to use and combine various hash functions in APL
  • hash: This page explains how to use the hash function in APL.
  • IP functions: This section explains how to use IP functions in APL.
  • format_ipv4: This page explains how to use the format_ipv4 function in APL.
  • format_ipv4_mask: This page explains how to use the format_ipv4_mask function in APL.
  • geo_info_from_ip_address: This page explains how to use the geo_info_from_ip_address function in APL.
  • has_any_ipv4: This page explains how to use the has_any_ipv4 function in APL.
  • has_any_ipv4_prefix: This page explains how to use the has_any_ipv4_prefix function in APL.
  • has_ipv4: This page explains how to use the has_ipv4 function in APL.
  • has_ipv4_prefix: This page explains how to use the has_ipv4_prefix function in APL.
  • ipv4_compare: This page explains how to use the ipv4_compare function in APL.
  • ipv4_is_in_any_range: This page explains how to use the ipv4_is_in_any_range function in APL.
  • ipv4_is_in_range: This page explains how to use the ipv4_is_in_range function in APL.
  • ipv4_is_match: This page explains how to use the ipv4_is_match function in APL.
  • ipv4_is_private: This page explains how to use the ipv4_is_private function in APL.
  • ipv4_netmask_suffix: This page explains how to use the ipv4_netmask_suffix function in APL.
  • ipv6_compare: This page explains how to use the ipv6_compare function in APL.
  • ipv6_is_in_any_range: This page explains how to use the ipv6_is_in_any_range function in APL.
  • ipv6_is_in_range: This page explains how to use the ipv6_is_in_range function in APL.
  • ipv6_is_match: This page explains how to use the ipv6_is_match function in APL.
  • parse_ipv4: This page explains how to use the parse_ipv4 function in APL.
  • parse_ipv4_mask: This page explains how to use the parse_ipv4_mask function in APL.
  • Mathematical functions: Learn how to use and combine different mathematical functions in APL.
  • max_of: This page explains how to use the max_of function in APL.
  • min_of: This page explains how to use the min_of function in APL.
  • rand: This page explains how to use the rand function in APL.
  • set_difference: This page explains how to use the set_difference function in APL.
  • set_has_element: This page explains how to use the set_has_element function in APL.
  • set_intersect: This page explains how to use the set_intersect function in APL.
  • set_union: This page explains how to use the set_union function in APL.
  • column_ifexists: This page explains how to use the column_ifexists function in APL.
  • ingestion_time: This page explains how to use the ingestion_time function in APL.
  • Pair functions: Learn how to use and combine different pair functions in APL
  • Rounding functions: Learn how to use and combine different rounding functions in APL
  • SQL functions: Learn how to use SQL functions in APL
  • String functions: Learn how to use and combine different string functions in APL
  • base64_decode_toarray: This page explains how to use the base64_decode_toarray function in APL.
  • base64_encode_fromarray: This page explains how to use the base64_encode_fromarray function in APL.
  • indexof_regex: This page explains how to use the indexof_regex function in APL.
  • isascii: This page explains how to use the isascii function in APL.
  • parse_path: This page explains how to use the parse_path function in APL.
  • quote: This page explains how to use the quote function in APL.
  • regex_quote: This page explains how to use the regex_quote function in APL.
  • trim_space: This page explains how to use the trim_space function in APL.
  • Type funtions: This section explains how to use type functions in APL.
  • iscc: This page explains how to use the iscc function in APL to check if a string is a valid credit card number.
  • isimei: This page explains how to use the isimei function in APL.
  • ismap: This page explains how to use the ismap function in APL.
  • isreal: This page explains how to use the isreal function in APL.
  • isstring: This page explains how to use the isstring function in APL.
  • isutf8: This page explains how to use the isutf8 function in APL.
  • Logical operators: Learn how to use and combine different logical operators in APL.
  • Numerical operators: Learn how to use and combine numerical operators in APL.
  • String operators: Learn how to use and combine different query operators for searching string data types.
  • count: This page explains how to use the count operator function in APL.
  • distinct: This page explains how to use the distinct operator function in APL.
  • extend: This page explains how to use the extend operator in APL.
  • extend-valid: This page explains how to use the extend-valid operator in APL.
  • externaldata: This page explains how to use the externaldata operator in APL.
  • getschema: This page explains how to use the getschema operator in APL.
  • join: This page explains how to use the join operator in APL.
  • limit: This page explains how to use the limit operator in APL.
  • lookup: This page explains how to use the lookup operator in APL.
  • order: This page explains how to use the order operator in APL.
  • Tabular operators: This section explains how to use and combine tabular operators in APL.
  • parse: This page explains how to use the parse operator function in APL.
  • project-away: This page explains how to use the project-away operator function in APL.
  • project-keep: This page explains how to use the project-keep operator function in APL.
  • project: This page explains how to use the project operator in APL.
  • project-reorder: This page explains how to use the project-reorder operator in APL.
  • redact: This page explains how to use the redact operator in APL.
  • sample: This page explains how to use the sample operator function in APL.
  • search: This page explains how to use the search operator in APL.
  • sort: This page explains how to use the sort operator function in APL.
  • summarize: This page explains how to use the summarize operator function in APL.
  • take: This page explains how to use the take operator in APL.
  • top: This page explains how to use the top operator function in APL.
  • union: This page explains how to use the union operator in APL.
  • where: This page explains how to use the where operator in APL.
  • Sample queries: Explore how to use APL in Axiom’s Query tab to run queries using Tabular Operators, Scalar Functions, and Aggregation Functions.