$ gsql --version
$ gadmin version
gsql
command from an operating system prompt. If this command has never worked, then probably the installation was not successful. If it works but you are not sure what to do next, please see the GSQL Demo Examples guide.gsql
and gadmin
commands are now recognized), then please contact [email protected] and summarize your issue in the email subject.$ gadmin status
gsql
from an operating system prompt). Then type the help
command, e.g., HELP
BASIC
, QUERY
commands. For example,HELP QUERY
gadmin
administration tool also has a help menu and a manual page:$ gadmin help
User
and user
are different. The GSQL language keywords (e.g., CREATE, LOAD, VERTEX) are not case-sensitive, but in our documentation examples, we generally show keywords in ALL CAPS to make them easy to distinguish.BEGIN
and END
keywords to mark off a multi-line block of text that should not be executed until END
is encountered.ls
command lists the catalog : the vertex type, edge type, and graph type definitions, job definitions, query definitions, and some system configuration settings. If you have not set your active graph, then ls
will show only item which have global scope. To see graph-specific items (including loading jobs and queries), you must define an active graph.GSQL>
DROP ALL
GSQL>
DROP GRAPH g1
GSQL>
CLEAR GRAPH STORE
uid
column is int type, name
is string type, avg_score
is float type, and is_member
is boolean type. See simple examples in Real-Life Data Loading and Querying Examples and a complete specification in the section "Creating a Loading Job" in GSQL Language Reference, Part 1: Defining Graphs and Loading Data . ​USING SEPARATOR=";"
\t
. To specify any ASCII character, use \nn
where nn
is the character's ASCII code, in decimal. For example, to specify ASCII 30, the Record Separator (RS):
USING SEPARATOR="\30"
USING QUOTE="single"
or
USING QUOTE="double"
SEPARATOR=","
and QUOTE="double"
are set, then when the following data are read,QUOTE="single"
or QUOTE="double"
."\t"
for tab
"\nn"
for ASCII decimal code nn'a string'
or double quotation marks: "a string"
"single", "double"
"\n"
(system-defined newline character or character sequence)$0
, the next one is $1
, and so on.quot;name"
, where name
is one of the header column names.abc,def,ghi
$2
or quot;ghi"
.flatten($2, ",",1)
. Using the example of data file , TEMP_TABLE t1 will then contain the following:"Fiction"
appears twice. Seven book_genre edges will be generated, one for each row in the TEMP_TABLE.CLEAR GRAPH STORE -HARD
command. Be very careful using this command; deleted data cannot be restored (except from a Backup). Note that clearing the data does not erase the catalog definitions of vertex, edge, and graph types. See also " How do I delete my entire graph schema? "primary_id
must be used. Note that that query does not use the id name pid
.rating
and date_time
are user-defined optional attributes.RUN JOB [-DRYRUN] [-n [
first_line_num
,]
last_line_num
]
job_name
-DRYRUN
option will read input files and process data as instructed by the job, but it does not store data in the graph store.-n
option limits the loading job to processing only a range of lines of each input data file. The selected data will be stored in the graph store, so the user can check the results. The -n flag accepts one or two arguments. For example,-n 50
means read lines 1 to 50.
-n 10,50
means read lines 10 to 50.
The special symbol $ is interpreted as "last line", so -n 10,$
means reads from line 10 to the end.<TigerGraph_rootdir>/app/<VERSION_NUM>/dev/gdk/gsql/output
. The filename load_output.log is a link to the most recent log file. This file contains summary statistics on the number of lines read, the vertices created, and various types of errors encountered. Or, you can type a shell command to find log paths "gadmin log
".gadmin log
, you will be given all the file paths of the most commonly used log files.