gsql-users

1–30 of 222

/************************************************************************************************

* NEW COMMUNITY FORUM https://community.tigergraph.com IN NOW LIVE!

* This gsql_users is set to Read-Only

* Further Q&A will need to be posted on the new community site.

************************************************************************************************/

Avoid the hassles of installation, get your free TigerGraph cloud instance here with pre-installed data and schema (HOT)
GSQL Query Examples: Schema, IS, IC, and BI workloads based on LDBC benchmark
Installation on linux
Download our latest docker image for your laptop
GSQL 101 webinar, GSQL 102 webinar, Accumulator 101
Document
Cheat sheet
Online office hour every Thursday
FAQ and examples (see HOW TO FAQs section at the bottom)
Take the GSQL Online Lecture on Youtube. 🆕

0 selected

Doug2

4/12/20

Order of boolean conditions matters?

Never mind.... I overlooked the part in the documentation that discusses the nuances of how edge

unread,

Order of boolean conditions matters?

Never mind.... I overlooked the part in the documentation that discusses the nuances of how edge

4/12/20

Khan, … Doug15

4/12/20

Compiling token bank fails with error

For anyone having trouble compiling TokenBank.cpp and/or the testing code for UDFs (in tigergraph/dev

unread,

Compiling token bank fails with error

For anyone having trouble compiling TokenBank.cpp and/or the testing code for UDFs (in tigergraph/dev

4/12/20

Meghana Ponnuru, Xinyu Chang3

4/9/20

Unable to load data

Hello Xinyu, I have not entered the license key while sudo ./install.sh . Is that the mistake? On

unread,

Unable to load data

Hello Xinyu, I have not entered the license key while sudo ./install.sh . Is that the mistake? On

4/9/20

Daniel Solow, Adil Ainihaer5

4/9/20

How to pattern match edges in reverse?

Thank you! This has been driving me crazy On Wednesday, April 8, 2020 at 9:32:13 PM UTC-4, Adil

unread,

How to pattern match edges in reverse?

Thank you! This has been driving me crazy On Wednesday, April 8, 2020 at 9:32:13 PM UTC-4, Adil

4/9/20

Brett Renshaw, Xinyu Chang2

4/8/20

How To Continuously Feed Off Of Multiple Topics

Hi Brett, There is a Kafka config for concurrent Kafka loader numbers. 1. gadmin --config kafka 2.

unread,

How To Continuously Feed Off Of Multiple Topics

Hi Brett, There is a Kafka config for concurrent Kafka loader numbers. 1. gadmin --config kafka 2.

4/8/20

Mark Megerian, … Rik4

4/8/20

Fun with Dates and Times

OK. To truncate to days, divide by 86400 first. As it is an integer divide, the hours/seconds etc are

unread,

Fun with Dates and Times

OK. To truncate to days, divide by 86400 first. As it is an integer divide, the hours/seconds etc are

4/8/20

Kim Payne

4/7/20

Error: unknown function/tuple constructor

Hi, I'm working writing a query (query_main) calling a sub query ( query_main_sub(SET<VERTEX

unread,

Error: unknown function/tuple constructor

Hi, I'm working writing a query (query_main) calling a sub query ( query_main_sub(SET<VERTEX

4/7/20

Doug2

4/7/20

Trying to use INPUT_LINE_FILTER

Ok, I figured it out. My filter was actually using gsql_substring($"field1",0,10) != $

unread,

Trying to use INPUT_LINE_FILTER

Ok, I figured it out. My filter was actually using gsql_substring($"field1",0,10) != $

4/7/20

Anders Lauri, Xinyu Chang2

4/2/20

Returning a global accumulator

After the query execution, the memory of the runtime data structures will be automatically released.

unread,

Returning a global accumulator

After the query execution, the memory of the runtime data structures will be automatically released.

4/2/20

Anders Lauri, … Anders Lauri3

3/31/20

GSQL Batch Query

Ah ok, That's fine. Thanks. Get Outlook for iOS From: Xinyu Chang <xi...@tigergraph.com>

unread,

GSQL Batch Query

Ah ok, That's fine. Thanks. Get Outlook for iOS From: Xinyu Chang <xi...@tigergraph.com>

3/31/20

Brett Renshaw, … Szilard Barany4

3/30/20

Dynamically Build TigerGraph Queries Using Schema

Hi Brett, I would like to know more about your solution, sounds very interesting. I would appreciate

unread,

Dynamically Build TigerGraph Queries Using Schema

Hi Brett, I would like to know more about your solution, sounds very interesting. I would appreciate

3/30/20

Brett Renshaw2

3/30/20

Dropped Vertex Attribute But Disk Usage Is The Same

Still looking for an answer, this is on an enterprise instance, not the dev docker container. Any

unread,

Dropped Vertex Attribute But Disk Usage Is The Same

Still looking for an answer, this is on an enterprise instance, not the dev docker container. Any

3/30/20

Meghana Ponnuru, Xinyu Chang2

3/30/20

Regarding UDF Queries

You can run queries and call C++ UDFs without having any data in your graph. Could you please provide

unread,

Regarding UDF Queries

You can run queries and call C++ UDFs without having any data in your graph. Could you please provide

3/30/20

术士, Xinyu Chang2

3/30/20

time function datetime_format get error

In GSQL, it is required to clearly separate the definition of data structure and running logics.

unread,

time function datetime_format get error

In GSQL, it is required to clearly separate the definition of data structure and running logics.

3/30/20

术士, Xinyu Chang2

3/30/20

How to returns a ListAccum<tuple>

In order to return a list of tuple, please define your tuple from your schema instead of inside the

unread,

How to returns a ListAccum<tuple>

In order to return a list of tuple, please define your tuple from your schema instead of inside the

3/30/20

He Chaojie, … Xinyu Chang3

3/30/20

How to use vertex as parameter in restpp /gsqlserver/interpreted_query?

v=id1 should be the right way, could you confirm this vertex is in your graph? Also, it would be

unread,

How to use vertex as parameter in restpp /gsqlserver/interpreted_query?

v=id1 should be the right way, could you confirm this vertex is in your graph? Also, it would be

3/30/20

Meghana Ponnuru

3/28/20

K not ready error

Hi, May I know if anyone in this group faced same issue? Cannot read nodes from service GPE , node

unread,

K not ready error

Hi, May I know if anyone in this group faced same issue? Cannot read nodes from service GPE , node

3/28/20

Martyn Bowis, … Szilard Barany5

3/27/20

Q&A

Case Insensitive SELECT

Hey Szilard, Thanks for taking a look at this for me :-) I tried running it again just now and yes,

unread,

Q&A

Case Insensitive SELECT

Hey Szilard, Thanks for taking a look at this for me :-) I tried running it again just now and yes,

3/27/20

Martyn Bowis, Rik3

3/24/20

Q&A

How to purge all vertices and edges from a tigergraph database?

OK, there is this: https://docs.tigergraph.com/dev/restpp-api/built-in-endpoints#delete-graph-

unread,

Q&A

How to purge all vertices and edges from a tigergraph database?

OK, there is this: https://docs.tigergraph.com/dev/restpp-api/built-in-endpoints#delete-graph-

3/24/20

Meghana Ponnuru2

3/20/20

Executable file

The coredump file is not being generated in /home/tigergraph/tigergraph/logs/coredump when I run the

unread,

Executable file

The coredump file is not being generated in /home/tigergraph/tigergraph/logs/coredump when I run the

3/20/20

Danielle Tsai, kevin.cai2

3/19/20

graph studio

Hey Danielle, 'Import' will wipe all graphs and then import the solution. Thanks, Kevin

unread,

graph studio

Hey Danielle, 'Import' will wipe all graphs and then import the solution. Thanks, Kevin

3/19/20

Nicholas Kapinos, Xinyu Chang9

3/19/20

v2.5.3 - restpp Down

Thank you. i tried running that, got an error message that our disk was full. I cleaned up a bunch of

unread,

v2.5.3 - restpp Down

Thank you. i tried running that, got an error message that our disk was full. I cleaned up a bunch of

3/19/20

Meghana Ponnuru, kevin.cai2

3/17/20

Arrays : no viable alternative error

Hi Meghana, There are a few things you can change in the query. Start={Person.*} missing semicolon at

unread,

Arrays : no viable alternative error

Hi Meghana, There are a few things you can change in the query. Start={Person.*} missing semicolon at

3/17/20

Felix P., Rik5

3/12/20

Overlap between two sets out of one map.

Good news! Good luck, and of course we are here to help, so if anything else comes up, let us know.

unread,

Overlap between two sets out of one map.

Good news! Good luck, and of course we are here to help, so if anything else comes up, let us know.

3/12/20

Ernesto Carlo Valencia Vivando

3/10/20

GADMIN START - ERROR

Hi Everyone Next error appear when i try to start Tigergraph services: ('Failed to get Status(gpe

unread,

GADMIN START - ERROR

Hi Everyone Next error appear when i try to start Tigergraph services: ('Failed to get Status(gpe

3/10/20

Danielle Tsai, … Mingxi Wu3

3/7/20

GSQL source in file

do you mean you have a file containing multiple lines of drop token xxx1 drop token xx2 .. and you

unread,

GSQL source in file

do you mean you have a file containing multiple lines of drop token xxx1 drop token xx2 .. and you

3/7/20

Meghana Ponnuru, Xinyu Chang5

3/6/20

DYNAMIC ARRAYS

Sure, Thank you. I wasn't sure if it was dynamic earlier. Thanks for clearing my doubt. On Friday

unread,

DYNAMIC ARRAYS

Sure, Thank you. I wasn't sure if it was dynamic earlier. Thanks for clearing my doubt. On Friday

3/6/20

Carl Boudreau, Jonathan Herke3

2/28/20

Any examples of a 3 hop gsql query? <EOM>

CREATE QUERY khop(VERTEX<MyNode> start_node, INT depth) for graph GraphName { OrAccum @visited

unread,

Any examples of a 3 hop gsql query? <EOM>

CREATE QUERY khop(VERTEX<MyNode> start_node, INT depth) for graph GraphName { OrAccum @visited

2/28/20

Meghana Ponnuru, Chengbiao2

2/26/20

GCC VERSION

Hi Meghana, TigerGraph is currently compiled with gcc 4.8.4. It will not be able to run on an higher

unread,

GCC VERSION

Hi Meghana, TigerGraph is currently compiled with gcc 4.8.4. It will not be able to run on an higher

2/26/20

Martyn Bowis, … Jonathan Herke5

2/26/20

Connect to TigerGraph using JQuery to Create, Read, Update and Delete Nodes and Relationships

STEPS (Open your cloud instance) 1. Click "Admin" (top right) 2. Click "User

unread,

Connect to TigerGraph using JQuery to Create, Read, Update and Delete Nodes and Relationships

STEPS (Open your cloud instance) 1. Click "Admin" (top right) 2. Click "User

2/26/20