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
  
      • 

    
  
    • 
  
  • 

      
  
    • 
    Tutorials
    

        
  
      • 
    GSQL 101
    

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

        
  
        • 
  
      • 
    Pattern Matching Tutorial
    

          
  
        • 
    Get Set
  
          • 
  
        • 
    Define the Schema
  
          • 
  
        • 
    Load Data
  
          • 
  
        • 
    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
  
        • 

      
  
      • 

    
  
    • 
  
  • 

      
  
    • 
    Database definition & Loading
    

        
  
      • 
    System & Language Basics
  
        • 
  
      • 
    Defining a Graph Schema
  
        • 
  
      • 
    Modifying a Graph Schema
  
        • 
  
      • 
    Creating a Loading Job
    

          
  
        • 
    Add a User-defined Token Function
  
          • 

        
  
        • 
  
      • 
    Running a Loading Job
  
        • 
  
      • 
    Appendix
    

          
  
        • 
    DDL Keywords & Reserved Words
  
          • 
  
        • 
    GSQL Start-to-End Process and Data Flow
  
          • 

        
  
        • 

      
  
      • 

    
  
    • 
  
  • 

      
  
    • 
    Querying
    

        
  
      • 
    Introduction
  
        • 
  
      • 
    Queries
  
        • 
  
      • 
    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
  
          • 

        
  
        • 
  
      • 
    Declaration and Assignment Statements
  
        • 
  
      • 
    SELECT Statement
    

          
  
        • 
    SQL-like SELECT statement
  
          • 

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

          
  
        • 
    Common Errors and Problems
  
          • 
  
        • 
    Formal Grammar for Query Language
  
          • 
  
        • 
    Query Language Reserved Words
  
          • 
  
        • 
    Example Graphs
  
          • 
  
        • 
    Interpreted GSQL Limitations
  
          • 

        
  
        • 

      
  
      • 

    
  
    • 


  





    

      GSQL Language Reference
      3.2
    

  
    
    
  • 
      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
    • 
    
  • Tutorials
    • 
    
  • Pattern Matching Tutorial
    • 
  



  
Edit this Page

  

  





Pattern Matching Tutorial




    

  • 

    Get Set
    

    • 

  • 

    Load Data
    

    • 

  • 

    One-hop patterns
    

    • 

  • 

    Repeating a 1-Hop Pattern
    

    • 

  • 

    Multiple Hop Patterns and Accumulation
    

    • 

  • 

    Example - A Recommender
    

    • 

  • 

    Advanced Features
    

    • 

  • 

    Summary
    

    • 






  








  

    
 


    

      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
        
      • 
      
    
    
    •