Documentation
  • How To
  • Products
    • Fusion Server
    • Fusion AI
    • Fusion Connectors
    • Predictive Merchandiser
    • App Studio
    • Managed Search
    • Lucidworks Cloud
    • Legacy Products
  • Learn More
    • Lucidworks
    • Knowledge Base
    • Blog
    • Webinars
    • Ebooks
    • Training
    • Support
    • Fusion Server 5.3
    • Fusion Server 5.2
    • Fusion Server 5.1
    • Fusion Server 5.0
    • Fusion Server 4.2
    • Fusion Server 4.1
    • Fusion Server 4.0
    • Earlier releases...
    • Architecture
      • Connectors
      • SQL Service
    • Concepts
      • Fusion 5 Survival Guide
      • Dashboards
        • Built-in Dashboards
        • Display Panels
        • Grafana Dashboards
        • Input Panels
      • Deployment
        • Kubernetes
          • Microservices
          • Platforms
      • Indexing
        • Collections
          • Time-Based Partitioning
        • Connectors
        • Data Models
        • Datasources
          • Custom JavaScript Stages For Index Pipelines
          • Index Pipeline Stages
          • Index Pipelines
          • Index Profiles
          • Index Stage SDK
          • Index Workbench
        • Subscriptions
          • Apache Pulsar in Fusion
          • Subscriptions UI
        • Blob Storage
        • Parallel Bulk Loader
        • Data Ingestion and Indexing Overview
      • Jobs
        • Datasource Jobs
        • Job History
        • Schedules
        • Spark Jobs
        • Tasks
      • Querying
        • Apps
          • Autocomplete
          • Building Applications
          • Faceting
          • Search Applications
          • Stopwords Files
          • Synonyms Files
        • Pipelines
          • Custom JavaScript Stages for Query Pipelines
          • Query Pipeline Stages
          • Query Pipelines
          • Query Profiles
          • Stored Parameters Collection
          • Domain Specific Language (DSL)
        • Querying Overview
        • Query Workbench
      • Security
        • Access Control
          • Permissions
          • Roles
          • Security Realms
          • Users
        • Security Overview
      • Spark
        • Spark Administration in Kubernetes
        • Spark Job Drivers
      • Fusion SQL
        • Administration
      • System
        • Monitoring
          • Cluster Monitoring and Troubleshooting
          • Troubleshooting Performance Issues
        • Prometheus and Grafana
        • System Administration with the Fusion UI
        • The DevOps Center
      • Fusion Concepts and Components
      • Fusion UI
      • Jupyter Support in Fusion
      • Config Sync
      • Licensing
      • Object Explorer
      • Template Expressions Overview
    • How-to
    • Reference
      • Collections
        • Configuration Options for Collections Time-based Partitioning
      • Connectors
      • Connectors SDK Javadocs
      • Querying Fusion SQL
        • Search
        • Text Analytics
          • Text Analysis and Analytics (`analyze`)
          • significant_terms`
        • Aggregation
        • Time Series
        • Statistics
          • Co-occurrence Matrices (`co_matrix`)
          • Correlation Matrices (`corr_matrix`)
          • Cumulative Probability (`cumulative_probability`)
          • Gaussfit (`gaussfit`)
          • Geo Clustering (`geo_cluster`)
          • Histogram (`hist`)
          • 2D K-Means Clustering (`kmeans`)
          • Knnfit (`knnfit`)
          • Regression and Residual Plot (`linearfit`)
          • Mann-Whitney (`mann_whitney`)
          • Percentiles (`percentiles`)
          • Polyfit (`polyfit`)
          • Probability (`probability`)
          • qqplot
          • Regression Diagnostics (`regress`)
          • ttest
          • weighted_sum
        • Miscellaneous
          • click_pos
          • concat_text
          • timediff
          • weighted_sum
      • Jobs
        • Jobs Configuration Reference
        • Aggregation Jobs
        • Custom Spark Jobs
        • Download Blob
        • Log Cleanup Jobs
        • REST Call Jobs
        • Script Jobs
      • Kubernetes
        • Licensing for Kubernetes Deployments
      • Parser Stages
        • Apache Tika
        • Archive
        • CSV
        • Fallback
        • Forked Apache Tika
        • Grok
          • Grok
          • Grok Patterns
        • HTML
        • JSON
        • Solr Update
        • Text
        • XML
      • Pipeline Stages
        • Index Pipeline Stages
          • Apache Tika Parser
          • Call Data Model Pipeline
          • Call Pipeline
          • Data Model Mapping
          • Date Parsing
          • Detect Language
          • Detect Sentences
          • Exclude Documents
          • Exclusion Filter
          • Field Mapping
          • Field Parser
          • Filter Short Fields
          • Find and Replace
          • Format Signals
          • Gazetteer Lookup Extraction
          • GeoIP Lookup
          • Include Documents
          • Index Stage SDK
          • JavaScript
          • JDBC
          • Logging Index
          • Machine Learning
          • Managed JavaScript
          • NLP Annotator
          • OpenNLP NER Extraction
          • Regex Field Extraction
          • Regex Field Filter
          • Regex Field Replacement
          • Resolve Multivalued Fields
          • REST Query
          • Send Slack Message
          • Send SMTP Email
          • Set Property
          • Solr Dynamic Field Name Mapping
          • Solr Indexer
          • Solr Partial Update Indexer
          • Tag Part-of-Speech
          • Update Experiment
          • Update Related Document
          • Write Log Message
          • XML Transformation
        • Query Pipeline Stages
          • Active Directory Security Trimming
          • Additional Query Parameters
          • Analytics Catalog
          • Apply Rules
          • Block Documents
          • Boost Documents
          • Boost with Signals
          • Experiment
          • Field Facet
          • Filter Stop Words
          • Highlight
          • JavaScript
          • JDBC Lookup
          • Landing Pages
          • Logging
          • Machine Learning
          • Machine Learning (Responses)
          • Managed JavaScript
          • Merge Async Results
          • Modify Response with Rules
          • NLP Annotator
          • Parameterized Boosting
          • Parameterized Faceting
          • Query Fields
          • Query RPC
          • Recommend Items for Item
          • Recommend Items for User
          • Recommend Similar Queries
          • Response Document Exclusion
          • Response Pairwise Swap
          • Response Shuffle
          • Result Document Field Sorting
          • Response Document Field Redaction
          • Retrieve Stored Parameters Stage
          • Return Query Parameters
          • Rollup Aggregation
          • Run Query
          • Security Trimming
          • Send Slack Message
          • Send SMTP Email
          • Solr MoreLikeThis
          • Solr Query
          • Solr Subquery
          • Text Tagger
          • Write Log Message
        • Pipeline Stage Overview
      • Query Operations
        • Custom JavaScript Stages Global Variables
        • Solr Query Language Cheat Sheet
      • Resources and Support
        • Language Support in Fusion
      • REST API
        • Authentication and Authorization
          • Realms API
          • Roles API
          • Sessions API
          • User API
        • Connectors
          • Connector Datasources API
          • Connector Jobs API
          • Connector Plugins API
          • Connector Plugins Repository API
        • Index
          • Index Pipelines API
          • Index Profiles API
          • Index Stages API
        • Query
          • Query Pipelines API
          • Query Profiles API
          • Query Rewrite API
          • Query Stages API
        • System Administration
          • Configurations API
          • History API
          • Nodes API
          • System API
        • Apps API
        • Blob Store API
        • Catalog API
        • Collection Features API
        • Collections API
        • Custom Rules API
        • Data Models API
        • Experiments API
        • Groups API
        • Jobs API
        • License API
        • Links API
        • Objects API
        • Parsers API
        • Recommendations API
        • Scheduler API
        • Search Cluster API
        • Signals API
        • Solr API
        • Solr Configuration API
        • SolrAdmin API
        • Spark Jobs API
        • Subscriptions API
        • Synonyms Editor API
        • Tasks API
        • Webapps API
        • ZooKeeper Import/Export API
      • Component Versions
      • Template Expressions
        • Index Pipeline Stage
        • Query pipeline Stage
      • Additional Resources
      • Directories, Files, and Ports
      • Microservices Reference
      • System Metrics
    • Release Notes
      • 5.3.2 Release Notes
      • 5.3.1 Release Notes
      • 5.3.0 Release Notes
      • 5.2.1 Release Notes
      • 5.2.0 Release Notes
      • 5.1.4 Release Notes
      • 5.1.3 Release Notes
      • 5.1.2 Release Notes
      • 5.1.1 Release Notes
      • 5.1.0 Release Notes
      • 5.0.2 Release Notes
      • 5.0.1 Release Notes
      • 5.0.0 Release Notes
      • 4.2.6 Release Notes
      • 4.2.5 Release Notes
      • 4.2.4 Release Notes
      • 4.2.3 Release Notes
      • 4.2.2 Release Notes
      • 4.2.1 Release Notes
      • 4.2.0 Release Notes
      • 4.1.3 Release Notes
      • 4.1.2 Release Notes
      • 4.1.1 Release Notes
      • 4.1.0 Release Notes
      • 4.0.2 Release Notes
      • 4.0.1 Release Notes
      • 4.0.0 Release Notes
      • Deprecations and Removals

    Querying Fusion SQL

    Fusion SQL provides a set of search and analytic capabilities designed for data exploration and visualization.

    • search

    • text analytics

      • Text Analysis and Analytics (analyze)

      • Significant Terms (significant_terms)

    • aggregation

    • time series

    • statistics

      • Sampling and descriptive statistics

      • Co-occurrence Matrices (co_matrix)

      • Correlation Matrices (corr_matrix)

      • Cumulative Probability (cumulative_probability)

      • Gaussfit (gaussfit)

      • Geo Clustering (geo_cluster)

      • Histogram (hist)

      • 2D K-Means Clustering (kmeans)

      • Knnfit (knnfit)

      • Regression and Residual Plot (linearfit)

      • Mann-Whitney (mann_whitney)

      • Percentiles (percentiles)

      • Polyfit (polyfit)

      • Probability (probability)

      • qqplot

      • Regression Diagnostics (regress)

      • ttest

    • miscellaneous

      • concat_text

      • timediff

      • weighted_sum

    Please turn off your adblocker to leave feedback.

    Was this page helpful?

    Thank you! Your feedback helps improve Lucidworks documentation.

    ©2021 Lucidworks All rights reserved. Lucidworks logo