jSonar SonarW Documentation¶
- About SonarW
- SonarW Installation and Configuration
- SonarW Extensions
- String Processing Extensions
- Searching for Existing of Multiple Words within a String
- Ranking the Similarity of Matches in a Search
- Searching for Word Tuples in Strings (an OR of AND Containment)
- Finding unique heads and tails in a string
- Finding substrings in a repeating expression via regex
- Searching for Full Inclusion of a Set of Words
- Searching for Words in Strings (an OR of AND Containment) with Location Specificity
- Find by Network
- Additional Network Projection Expressions
- Cron Date matching and generation
- Fuzzy Search
- Searching for Inclusion of Sequences of Characters anywhere in Strings
- Removing (Trimming) Whitespaces
- Replace in String
- String Length
- Encrypting/Decrypting Strings
- Concatenation of a null value
- Search for text only within a named field
- Count Substrings
- Regular Expression Extensions
- Statistical Extensions
- Numerical Extensions
- Date Extensions
- Array and Object Extensions
- Arbitrary Expressions in Aggregation Stages
- Sorting the Contents of an Array and Removing Duplicates
- Creating a Hash that Identifies the Unique Contents of an Array
- Flattening Nested Arrays to a Single Array
- Flattening Nested Arrays to a Single Set (Array with no duplicates)
- Removing duplicates from an array
- Projecting a Subdocument by Name
- Applying an Expression to Each Element of an Array to Reduce an Array to a Single Value
- Projecting Documents
- regex case matching
- Network Query and manipulation functions
- Creating an array list of IP addresses corresponding to a hostname
- Operators that work on Arrays and Non-Arrays
- Producing Subdocuments in a Group Stage
- $objectElementAt - projection of a field within expression
- Indirect in Projection and Calculated Field Names
- Example for $indirect - Converting an array of name-value pairs (a-la ETL)
- Example - Using $indirect and $union to aggregate Steam gaming data
- Selecting documents in a range of internal IDs
- Projecting the Internal ID
- Projecting a new ObjectId
- Dereferencing a DBRef
- Determining if Two Documents are Different
- Comparing Documents:
- Casting Operators
- Privileges Extensions
- Additional Match Extensions
- Extensions Related to Delete
- Output Extensions
- Appending to an Existing Collection Using $out
- Updating an Existing Collection Using $out
- Outputting to a Collection in Another Database
- Outputting to a Collection Without an
_id
, Ingesting and Partitioning - Outputting to an Operating System File
- Outputting to Amazon AWS S3
- Outputting to Syslog
- Chunking the output to a file and compressing files
- Sort Extensions
- Grouping Extensions
- Specifying Filtering Criteria as Part of a Group
- Group by Regex
- Group Pivot Ranges
- Combining Multiple Documents into One
- $countDistinct function in $group
- $addToSetWithCount function in $group
- $flattenToSet operator in $group
- $extend operator in $group
- $extendSet operator in $group
- $top operator in $group
- $sort and $limit within $group
- Getting the document responsible for the min or max value of a field
- Unwind Extensions
- Aggregation Pipeline Control
- Subqueries
- Using an Aggregation Pipeline in a Subquery
- Union as an Aggregation Step
- lmrm__metadata as an Aggregation Step
- Database Links
- Schema and Metadata
- User Defined Functions (UDFs)
- Automatic Columns
- Miscellaneous Extensions
- Joins in SonarW
- Window Functions
- Notes Related to Insert
- SonarW-Specific Command Extensions
- serverStatus
- blockInfo
- PartsInfo
- PriorityStatus and Memory Pegging
- Cache Management
- Memory Stats
- Statistics
- debugQueries
- Stop Collection
- Start Collection
- Enabling GPU-Based Execution
- Union Command
- Get and Set Parameters
- Query Priorities
- Pipeline Optimizer
- Federated Query Inspection
- PID for the sonard Process
- Generate data for debug purposes
- Security Extensions in SonarW
- Views in SonarW
- Geospatial Extensions in SonarW
- Annex Collections
- SonarW Indexes
- Cloud Storage
- Purge and Recompress
- SonarW Encryption (Data at Rest)
- Backup and Restore on SonarW
- High Availability / Disaster Recovery in SonarW
- SonarW Trackers
- SonarW Oplog Tracker for MongoDB
- Unsupported Features
- SonarW configuration
- SonarW Warehouse Monitoring Service (WMS)
- SonarW Release Notes