1. Home
  2. Previous Releases
  3. Latest Release
  4. Guides
  5. Concepts
  6. Tools
  7. References
    1. Apache Spark
    2. Built-in Functions
      1. Aggregation Functions
      2. Analytic Functions
      3. Boolean Functions
      4. Conditional Statements
      5. Conversion Functions
      6. Filter Functions
      7. Miscellaneous Functions
      8. Arithmetic Functions
      9. Date Functions
      10. String Functions
      11. Query Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Data Studio
    7. Public API
    8. Security
    9. SQL Interface
    10. Visualizations
    11. Other
  8. Integrations
  9. Data applications
  10. Releases
  11. Incorta Premium

Built-in Functions → Query Functions

A query function queries a column and returns values or distinct values with the option to apply additional filters to narrow down the results.

Query functions are available when creating the query expressions of global variables, internal session variables, and In-Query filters. For more details, refer to Concepts → Internal Query Expression.

FunctionSignatureDescription
query()query(column, filter1, filter2, ...)Returns values of a given column that satisfy one or more optional filter conditions.
queryWithLimit()query(column, limit, filter1, filter2, ...)Returns a limited number of values of a given column that satisfy one or more optional filter conditions.
queryDistinct()queryDistinct(column, filter1, filter2, ...)Returns distinct values of a given column that satisfy one or more optional filter conditions.
queryDistinctWithLimit()query(column, limit, filter1, filter2, ...)Returns a limited number of distinct values of a given column that satisfy one or more optional filter conditions.