Logship Documentation
Open Logship
  • Prerequisites
  • Single Node Deployment
  • Push Your First Event
  • Query
  • Advanced
  • Next Steps
  • Logship Database
  • Install
  • Database Configuration
  • Blob storage durability
  • Identity providers and SSO
  • Indexed file V5 encodings
  • Table declarations and blob references
  • Logship Agent
  • Getting Started
  • Install
  • Config
  • Platform Guides
    • Agent installation on openwrt
  • Overview
  • Install logsh
  • Terminal UI (logsht)
  • Overview
  • Install
  • Frontend Configuration
  • System Settings
  • Account Settings
  • Grafana Datasource Plugin
  • Dashboards
  • Public query embeds
  • Operations
  • Administration Account
  • Incident Management
  • Group Management
  • Security
    • Firewall & Network Hardening
    • Token revocation
  • Basics
  • Language
    • Functions
      • Aggregate Functions
        • Agg Avg
        • Agg Expavg
        • Agg Max
        • Agg Min
        • Argmax
        • Argmin
        • Avg
        • Count
        • Dcount
        • First
        • Join
        • Make List
        • Make Set
        • Percentile
        • percentiles
        • Stdev
        • Sum
        • Variance
      • Scalar Functions
        • Abs
        • Acos
        • Acos2
        • Ago
        • Asin
        • Asin2
        • Atan
        • Atan2
        • Bin
        • Case
        • Ceil
        • Coalesce
        • Concat
        • Cos
        • Countof
        • Datetime Add
        • Datetime Diff
        • Datetime Part
        • Datetime Utc To Local
        • Degrees
        • Exp
        • Extract
        • Floor
        • Format Datetime
        • Hash
        • Iff
        • Indexof
        • Isempty
        • Isnotempty
        • Isnull
        • Json
        • Log
        • Log10
        • Log2
        • Math
        • Max
        • Min
        • Newid
        • Now
        • Parse Json
        • Pi
        • Pow
        • Prev
        • Radians
        • Rand
        • Round
        • Sign
        • Sin
        • Split
        • Sqrt
        • Str
        • String Transform
        • Strlen
        • Substring
        • Tan
        • Todouble
        • Toguid
        • Toint
        • Toreal
        • Tostring
        • Trim
        • Trim End
        • Trim Start
        • Type Conversion
    • Management Commands
      • .create table
      • .create-merge table
      • .drop column
      • .drop table
      • .show table
      • .show tables
      • .truncate table
      • Table retention policy
    • Tabular Operators
      • Count
      • Datatable
      • Distinct
      • Extend
      • Join
      • Limit
      • Make-Streams
      • multi-project
      • Parse
      • Project
      • Range
      • Render
      • Sort
      • Summarize
      • Table
      • Take
      • Time-Bound
      • Union
      • Where Filter
    • Chart settings reference
    • Expressions
    • Types
  • Multiple query results
  • Query

Tabular Operators

Tabular operators transform a stream of rows and are combined with the pipe character. Use them to select columns, filter events, join datasets, aggregate values, and choose how results are rendered. Each reference page describes the operator's syntax and includes an example.

Pages

Count

Datatable

Distinct

Extend

Join

Limit

Make-Streams

multi-project

Parse

Project

Range

Render

Sort

Summarize

Table

Take

Time-Bound

Union

Where Filter