TigerGraph Logo Docs 

            
            
          
Page 1PrevNext
Search by Algolia

        


        
        

          Products
          

            
TigerGraph Server

            

              TigerGraph DB
            


            
TigerGraph Suite

            

              GraphStudio and Admin Portal
              Insights
              GSQL Web Shell
            


            
GSQL

            

              GSQL Language Reference
            


            
TigerGraph Cloud

            

              TigerGraph Cloud
              TigerGraph Cloud 4.0
                New
              
            


            
Graph Data Science

            

              TigerGraph Graph Data Science Library
              TigerGraph ML Workbench
              TigerGraph CoPilot
            


            
Connectors and APIs

            

              pyTigerGraph
              TigerGraph GraphQL Service
              JDBC Driver
            


            
Legacy Documentation

            

               Legacy Documentation 
            

          

        


        

          Resources
          

            Developer Site
            Community Forum
            Knowledge Base
          

        




        

          
            Download
          
        

        

          
             TG Cloud
          
        

      

    

  





    




  

    



  

    
GSQL Language Reference


    
  
  • 

      
  
    • 
    Overview
  
      • 
  
    • 
    What sets GSQL apart
  
      • 

    
  
    • 
  
  • 

      
  
    • 
    Tutorials
    

        
  
      • 
    GSQL 101
    

          
  
        • 
    Define a Schema
  
          • 
  
        • 
    Load Data
  
          • 
  
        • 
    Run Built-in Queries
  
          • 
  
        • 
    Parameterized Queries
  
          • 
  
        • 
    Review
  
          • 

        
  
        • 
  
      • 
    Pattern Matching Tutorial
    

          
  
        • 
    Prepare your Environment
  
          • 
  
        • 
    One-hop patterns
  
          • 
  
        • 
    Repeating a 1-Hop Pattern
  
          • 
  
        • 
    Multiple Hop Patterns and Accumulation
  
          • 
  
        • 
    Example - A Recommender
  
          • 
  
        • 
    Advanced Features
    

            
  
          • 
    Per Clause (Beta)
  
            • 
  
          • 
    Conjunctive Pattern Matching (Beta)
  
            • 
  
          • 
    Data Modification
  
            • 

          
  
          • 
  
        • 
    Summary
  
          • 

        
  
        • 
  
      • 
    Accumulators Tutorial
  
        • 

      
  
      • 

    
  
    • 
  
  • 

      
  
    • 
    System & Language Basics
  
      • 

    
  
    • 
  
  • 

      
  
    • 
    Attribute Data Types
  
      • 
  
    • 
    Schema Definition
    

        
  
      • 
    Define a Graph Schema
  
        • 
  
      • 
    Modify a Graph Schema
  
        • 

      
  
      • 
  
    • 
    Loading Jobs
    

        
  
      • 
    Create a Loading Job
    

          
  
        • 
    Functions
    

            
  
          • 
    Token Functions
    

              
  
            • 
    flatten()
  
              • 
  
            • 
    flatten_json_array()
  
              • 
  
            • 
    gsql_concat()
  
              • 
  
            • 
    gsql_current_time_epoch()
  
              • 
  
            • 
    gsql_day()
  
              • 
  
            • 
    gsql_day_epoch()
  
              • 
  
            • 
    gsql_find()
  
              • 
  
            • 
    gsql_length()
  
              • 
  
            • 
    gsql_lower()
  
              • 
  
            • 
    gsql_ltrim()
  
              • 
  
            • 
    gsql_month()
  
              • 
  
            • 
    gsql_month_epoch()
  
              • 
  
            • 
    gsql_regex_match()
  
              • 
  
            • 
    gsql_regex_replace()
  
              • 
  
            • 
    gsql_reverse()
  
              • 
  
            • 
    gsql_rtrim()
  
              • 
  
            • 
    gsql_substring()
  
              • 
  
            • 
    gsql_to_bool()
  
              • 
  
            • 
    gsql_to_int()
  
              • 
  
            • 
    gsql_to_uint()
  
              • 
  
            • 
    gsql_trim()
  
              • 
  
            • 
    gsql_ts_to_epoch_seconds()
  
              • 
  
            • 
    gsql_upper()
  
              • 
  
            • 
    gsql_uuid_v4()
  
              • 
  
            • 
    gsql_year()
  
              • 
  
            • 
    gsql_year_epoch()
  
              • 
  
            • 
    split()
  
              • 

            
  
            • 
  
          • 
    Token Functions in WHERE Clause
    

              
  
            • 
    concat()
  
              • 
  
            • 
    gsql_is_false()
  
              • 
  
            • 
    gsql_is_not_empty()
  
              • 
  
            • 
    gsql_is_true()
  
              • 
  
            • 
    gsql_token_equal()
  
              • 
  
            • 
    gsql_token_ignore_case_equal()
  
              • 
  
            • 
    to_float()
  
              • 
  
            • 
    to_int()
  
              • 
  
            • 
    token_len()
  
              • 

            
  
            • 
  
          • 
    Reducer functions
    

              
  
            • 
    add()
  
              • 
  
            • 
    and()
  
              • 
  
            • 
    ignore_if_exists()
  
              • 
  
            • 
    max()
  
              • 
  
            • 
    min()
  
              • 
  
            • 
    or()
  
              • 

            
  
            • 

          
  
          • 
  
        • 
    Add a User-defined Token Function
  
          • 

        
  
        • 
  
      • 
    Run a Loading Job
  
        • 
  
      • 
    Manage Loading Jobs
  
        • 

      
  
      • 

    
  
    • 
  
  • 

      
  
    • 
    Querying
    

        
  
      • 
    Query Language Syntax Versions
  
        • 
  
      • 
    Queries
  
        • 
  
      • 
    Query Optimizer (Preview Feature)
    

          
  
        • 
    Enabling Cost-Based Optimization (Preview Feature)
  
          • 
  
        • 
    Statistics REST APIs (Preview Feature)
  
          • 

        
  
        • 
  
      • 
    Distributed Query Mode
  
        • 
  
      • 
    Data Types
  
        • 
  
      • 
    Accumulators
  
        • 
  
      • 
    Operators and Expressions
  
        • 
  
      • 
    Functions
    

          
  
        • 
    Aggregation Functions
  
          • 
  
        • 
    Datetime Functions
  
          • 
  
        • 
    Edge Methods
  
          • 
  
        • 
    JSON Object Methods
  
          • 
  
        • 
    JSON Array Methods
  
          • 
  
        • 
    Mathematical Functions
  
          • 
  
        • 
    Miscellaneous Functions
  
          • 
  
        • 
    Query User-Defined Functions
  
          • 
  
        • 
    String Functions
  
          • 
  
        • 
    Type Conversion Functions
  
          • 
  
        • 
    Vertex Functions
  
          • 
  
        • 
    Context Functions
  
          • 

        
  
        • 
  
      • 
    Declaration and Assignment Statements
  
        • 
  
      • 
    SELECT Statement
    

          
  
        • 
    SELECT Statement (Syntax V1)
  
          • 
  
        • 
    SQL-like SELECT statement
  
          • 

        
  
        • 
  
      • 
    Control Flow Statements
  
        • 
  
      • 
    Data Modification Statements
  
        • 
  
      • 
    Output Statements and FILE Objects
  
        • 
  
      • 
    Exception Statements
  
        • 
  
      • 
    Comments
  
        • 

      
  
      • 

    
  
    • 
  
  • 

      
  
    • 
    openCypher
    

        
  
      • 
    openCypher in GSQL
  
        • 
  
      • 
    Writing and Running openCypher in GSQL Shell
  
        • 
  
      • 
    openCypher Pattern Support in GSQL
  
        • 

      
  
      • 

    
  
    • 
  
  • 

      
  
    • 
    Appendix
    

        
  
      • 
    GSQL Style Guide
  
        • 
  
      • 
    DDL Keywords & Reserved Words
  
        • 
  
      • 
    Query Language Keywords & Reserved Words
  
        • 
  
      • 
    Formal Grammar for Query Language
  
        • 
  
      • 
    Interpreted GSQL Limitations
  
        • 
  
      • 
    GSQL Start-to-End Process and Data Flow
  
        • 
  
      • 
    Example Graphs
  
        • 
  
      • 
    Common Errors and Problems
  
        • 
  
      • 
    GSQL Cheat Sheets
  
        • 
  
      • 
    Documentation Notations
  
        • 

      
  
      • 
  
    • 
    Legacy Version Documentation
  
      • 

    
  
    • 


  





    

      GSQL Language Reference
      4.1 Pre
    

  
    
    
  • 
      TigerGraph Cloud
    
    • 
    
  • 
      TigerGraph Cloud 4.0
    
    • 
    
  • 
      TigerGraph DB
        
      
            
    • 
              4.1 Pre
            
      • 
            
    • 
              3.10
            
      • 
            
    • 
              3.9
            
      • 
            
    • 
              3.8
            
      • 
            
    • 
              3.7
            
      • 
            
    • 
              3.6
            
      • 
            
    • 
              3.5
            
      • 
            
    • 
              3.4
            
      • 
            
    • 
              3.3
            
      • 
            
    • 
              3.2
            
      • 
        
    
    
    • 
    
  • 
      GSQL Language Reference
        
      
            
    • 
              4.1 Pre
            
      • 
            
    • 
              3.10
            
      • 
            
    • 
              3.9
            
      • 
            
    • 
              3.8
            
      • 
            
    • 
              3.7
            
      • 
            
    • 
              3.6
            
      • 
            
    • 
              3.5
            
      • 
            
    • 
              3.4
            
      • 
            
    • 
              3.3
            
      • 
            
    • 
              3.2
            
      • 
        
    
    
    • 
    
  • 
      GraphStudio and Admin Portal
        
      
            
    • 
              4.1 Pre
            
      • 
            
    • 
              3.10
            
      • 
            
    • 
              3.9
            
      • 
            
    • 
              3.8
            
      • 
            
    • 
              3.7
            
      • 
            
    • 
              3.6
            
      • 
            
    • 
              3.5
            
      • 
            
    • 
              3.4
            
      • 
            
    • 
              3.3
            
      • 
            
    • 
              3.2
            
      • 
        
    
    
    • 
    
  • 
      Insights
        
      
            
    • 
              4.1 Pre
            
      • 
            
    • 
              3.10
            
      • 
            
    • 
              3.9
            
      • 
            
    • 
              3.8
            
      • 
            
    • 
              3.7
            
      • 
        
    
    
    • 
    
  • 
      TigerGraph Graph Data Science Library
        
      
            
    • 
              3.9 LTS
            
      • 
            
    • 
              3.8
            
      • 
            
    • 
              3.7
            
      • 
        
    
    
    • 
    
  • 
      pyTigerGraph
        
      
            
    • 
              1.6
            
      • 
            
    • 
              1.5
            
      • 
            
    • 
              1.4
            
      • 
            
    • 
              1.3
            
      • 
            
    • 
              1.2
            
      • 
            
    • 
              1.1
            
      • 
            
    • 
              1.0
            
      • 
        
    
    
    • 
    
  • 
      TigerGraph ML Workbench
        
      
            
    • 
              1.4
            
      • 
            
    • 
              1.3
            
      • 
            
    • 
              1.2
            
      • 
            
    • 
              1.1
            
      • 
        
    
    
    • 
    
  • 
      TigerGraph GraphQL Service
        
      
            
    • 
              3.9
            
      • 
            
    • 
              3.8
            
      • 
            
    • 
              3.7
            
      • 
        
    
    
    • 
    
  • 
      TigerGraph CoPilot
        
      
            
    • 
              main
            
      • 
        
    
    
    • 
  



    

  








  


  
    
    
  • GSQL Language Reference
    • 
    
  • Legacy Version Documentation
    • 
  



  
Edit this Page

  

  



  
Contents
  • LTS Versions
  • Other Versions






Legacy Version Documentation


Contents
  • LTS Versions
  • Other Versions






This page lists all LTS (Long-Term Support) and previous versions of GSQL.










LTS Versions






    

  • 

    3.9
    

    • 

  • 

    3.6
    

    • 











Other Versions






    

  • 

    3.8
    

    • 

  • 

    3.7
    

    • 

  • 

    3.5
    

    • 

  • 

    3.4
    

    • 

  • 

    3.3
    

    • 

  • 

    3.2
    

    • 










  








  

    
 


    

      3 Twin Dolphin Drive, Ste 225

      Redwood City, CA 94065

    

    

      
Copyright © 2024 TigerGraph

    

  


  
    

    
  • 
      
    Resources
    

      
      
        
    • 
          Support
        
      • 

        
    • 
          Community
        
      • 

        
    • 
          Developer Site
        
      • 

        
    • 
          Test Drive
        
      • 
      
    
    
    • 

    
  • 
      
    Social
    

      
      
        
    • 
          Linkedin
        
      • 

        
    • 
          Facebook
        
      • 

        
    • 
          Twitter
        
      • 
      
    
    
    • 

    
  • 
      
    Legal
    

      
      
        
    • 
          Privacy Policy
        
      • 

        
    • 
          Terms of Use
        
      • 

        
    • 
          Sitemap
        
      • 
      
    
    
    •