Change Password

Please enter the password.
Please enter the password. Between 8-64 characters. Not identical to your email address. Contain at least 3 of: uppercase, lowercase, numbers, and special characters.
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

Apply New License

License Detail

Please complete this required field.

  • Ultipa Graph V4

Standalone

Please complete this required field.

Please complete this required field.

The MAC address of the server you want to deploy.

Please complete this required field.

Please complete this required field.

Cancel
Apply
ID
Product
Status
Cores
Applied Validity Period(days)
Effective Date
Excpired Date
Mac Address
Apply Comment
Review Comment
Close
Profile
  • Full Name:
  • Phone:
  • Company:
  • Company Email:
  • Country:
  • Language:
Change Password
Apply

You have no license application record.

Apply
Certificate Issued at Valid until Serial No. File
Serial No. Valid until File

Not having one? Apply now! >>>

Product Created On ID Amount (USD) Invoice
Product Created On ID Amount (USD) Invoice

No Invoice

v5.0
Search
    English
    v5.0

      Values and Types

      In GQL, various values and types can be used to represent information within the graph database. Understanding these values and types is essential for effective query construction and data manipulation.

      Graph Element Types

      Graph element types consist of node types and edge types, which are the data types of nodes and edges respectively.

      Graph Element Type
      Description
      NODE Represents the node type, which includes a label and a property type set associated with that label.

      E.g., NODE User (:User {name string, gender string}) specifies a node type named User with a label :User and properties name and gender.
      EDGE Represents the edge type, which includes a label and a property type set associated with that label.

      E.g., EDGE WorkIn ()-[:WorkIn {startOn datetime}]->() specifies an edge type named WorkIn with the label :WorkIn and a property startOn.

      Property Types

      A property type is a pair comprising a name and a value type. GQL supports the following property value types:

      Property Value Type
      Description
      int32 32-bit signed integer with a range from -2,147,483,648 to 2,147,483,647.
      uint32 32-bit unsigned integer with a range 0 to 4,294,967,295.
      int64 64-bit signed integer with a range from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
      uint64 64-bit unsigned integer with a range from 0 to 18,446,744,073,709,551,615.
      float 32-bit single-precision floating-point number with 6 to 7 significant digits (integer and fractional parts, excl. the decimal point).
      double 64-bit double-precision floating-point number with 15 to 16 significant digits (integer and fractional parts, excl. the decimal point).
      string A sequence of characters with a maximum length of 60,000 bytes. This is the default value type when creating a property.
      text A sequence of characters with no length limitation.
      datetime Date and time value with a range from 1000-01-01 00:00:00.000000 to 9999-12-31 23:59:59.499999, stored as uint64.
      timestamp A specific point in time, measured in seconds since 1970-01-01 00:00:00 UTC, stored as uint32.

      Note: If a value is assigned in date and time format, it is converted to a timestamp based on the local timezone or the timezone set via the SDK's RequestConfig. Similarly, when a timestamp is displayed in date and time format, it is also converted based on the local timezone or the timezone set via the SDK's RequestConfig.
      point A two-dimensional geographical coordinate that indicate a specific position; the two values are stored as double.
      list An ordered homogenous collection of elements. Supports the following types: int32[], uint32[], int64[], uint64[], float[], double[], string[], text[], datetime[] and timestamp[].

      Constructed Value Types

      A constructed value type is a data type comprising composite elements. GQL defines the following constructed value types:

      Constructed Value Type
      Description
      PATH Represents the path value type. A path value encapsulates nodes and edges that form a path element list[1]. A path value whose path element list comprises a single node is called the single-node path value.
      LIST Represents the list value type. A list value is an ordered homogenous or heterogeneous collection of elements.

      A list value is either a group list value or a regular list value. A group list value originates from a quantified path pattern. A regular list value is a list value that is not a group list value.
      RECORD Represents the record type. A record is a set of fields, each such field has a name and a value. The record with zero fields is called the unit record.

      [1] If the ordered sequence of nodes and edges in a path element list forms a path, then the sequence is said to identify a path.

      Result Types

      A result type refers to the data type of the values returned by a query. GQL defines the following result types.

      RESULT_TYPE_NODE

      This query returns all nodes labeled Paper bound to the variable n:

      MATCH (n:Paper) RETURN n
      

      Data structure of n:

      {
        "data": [
          {
            "id": "P2",
            "uuid": "8718971077612535835",
            "schema": "Paper",
            "values": {
              "title": "Optimizing Queries",
              "score": 9
            }
          },
          {
            "id": "P1",
            "uuid": "8791028671650463770",
            "schema": "Paper",
            "values": {
              "title": "Efficient Graph Search",
              "score": 6
            }
          }
        ],
        "alias": "n",
        "type": 2,
        "type_desc": "RESULT_TYPE_NODE"
      }
      

      RESULT_TYPE_EDGE

      This query returns all outgoing edges labeled Cites bound to the variable e:

      MATCH ()-[e:Cites]->() RETURN e
      

      Data structure of e:

      {
        "data": [
          {
            "from": "P1",
            "to": "P2",
            "uuid": "1",
            "from_uuid": "8791028671650463770",
            "to_uuid": "8718971077612535835",
            "schema": "Cites",
            "values": {
              "weight": 2
            }
          }
        ],
        "alias": "e",
        "type": 3,
        "type_desc": "RESULT_TYPE_EDGE"
      }
      

      RESULT_TYPE_PATH

      This query returns all outgoing 1-step paths bound to the variable p:

      MATCH p = ()-[]->() RETURN p
      

      Data structure of p:

      {
        "data": [
          {
            "nodes": [
              {
                "id": "P1",
                "uuid": "8791028671650463770",
                "schema": "Paper",
                "values": {
                  "title": "Efficient Graph Search",
                  "score": 6
                }
              },
              {
                "id": "P2",
                "uuid": "8718971077612535835",
                "schema": "Paper",
                "values": {
                  "title": "Optimizing Queries",
                  "score": 9
                }
              }
            ],
            "edges": [
              {
                "from": "P1",
                "to": "P2",
                "uuid": "1",
                "from_uuid": "8791028671650463770",
                "to_uuid": "8718971077612535835",
                "schema": "Cites",
                "values": {
                  "weight": 2
                }
              }
            ],
            "length": 1
          }
        ],
        "alias": "p",
        "type": 1,
        "type_desc": "RESULT_TYPE_PATH"
      }
      

      RESULT_TYPE_ATTR

      This query returns the title property of nodes labeled Paper:

      MATCH (n:Paper) RETURN n.title
      

      Data structure of n.title:

      {
        "data": {
          "alias": "n.title",
          "type": 4,
          "type_desc": "RESULT_TYPE_ATTR",
          "values": [
            "Optimizing Queries",
            "Efficient Graph Search"
          ]
        },
        "alias": "n.title",
        "type": 4,
        "type_desc": "RESULT_TYPE_ATTR"
      }
      

      RESULT_TYPE_TABLE

      This query returns a table bound to the variable table:

      MATCH (n:Paper) RETURN table(n.title, n.score) AS table
      

      Data structure of table:

      {
        "data": {
          "name": "table",
          "alias": "table",
          "headers": [
            "n.title",
            "n.score"
          ],
          "rows": [
            [
              "Optimizing Queries",
              "9"
            ],
            [
              "Efficient Graph Search",
              "6"
            ]
          ]
        },
        "alias": "table",
        "type": 5,
        "type_desc": "RESULT_TYPE_TABLE"
      }
      

      Null Value

      The null value is a special value available in all nullable types. Any non-null value is a material value.

      Null Scenarios

      The null values can arise in various contexts, including:

      • Default Assignment: When nodes or edges are inserted, nullable properties that lack specified values automatically receive null.
      • Explicit Null Specification: During node or edge insertion, nullable properties can be intentionally set to null.
      • Value Removal: Removing a property’s value replaces it with null.
      • New Property Assignment: When adding a new property to a label, any existing nodes or edges with that label are assigned null for the new property by default.
      • Nonexistent Property References: Referencing a property that does not exist returns null.
      • Optional Matching: When the OPTIONAL keyword is used with the MATCH statement, if no result is found for the pattern, MATCH yields null instead of empty return.
      • NULLIF Expression: The NULLIF expression returns null if the two compared values are equal.

      Null in Comparisons

      The null value is not comparable to any other value due to its inherently unknown nature. Consequently, comparisons involving null using normal operators such as = or <> do not typically yield true or false but rather an unknown result, also represented by null.

      Example
      Result
      RETURN null = null null
      RETURN null > 3 null
      RETURN [1,null,2] <> [1,null,2] null
      RETURN 3 IN [1,null,2] null
      RETURN null IN [1,2] null
      RETURN null IN [] 0

      Comparisons involving null require special handling with null predicates (IS NULL and IS NOT NULL).

      Example
      Result
      RETURN null IS NULL 1
      RETURN null IS NOT NULL 0

      Null Treatments

      The null values receive special treatment in some contexts. For instance:

      • Aggregate functions typically ignore null values.
      • The GROUP BY clause groups all null values together.
      • The ORDER BY statement allows for null ordering using the NULLS FIRST and NULL LAST keywords.
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写