$ gsql --version
$ gadmin version
gsqlcommand 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.
$ gadmin status
gsqlfrom an operating system prompt). Then type the
QUERYcommands. For example,
gadminadministration tool also has a help menu and a manual page:
$ gadmin help
userare 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.
ENDkeywords to mark off a multi-line block of text that should not be executed until
lscommand 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
lswill show only item which have global scope. To see graph-specific items (including loading jobs and queries), you must define an active graph.
DROP GRAPH g1
CLEAR GRAPH STORE
uidcolumn is int type,
nameis string type,
avg_scoreis float type, and
is_memberis 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 .
\t. To specify any ASCII character, use
nnis the character's ASCII code, in decimal. For example, to specify ASCII 30, the Record Separator (RS):
QUOTE="double"are set, then when the following data are read,
"\nn"for ASCII decimal code nn
'a string'or double quotation marks:
"\n"(system-defined newline character or character sequence)
$0, the next one is
$1, and so on.
nameis one of the header column names.
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 -HARDcommand. 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_idmust be used. Note that that query does not use the id name
date_timeare user-defined optional attributes.
RUN JOB [-DRYRUN] [-n [
-DRYRUNoption will read input files and process data as instructed by the job, but it does not store data in the graph store.
-noption 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 50means read lines 1 to 50.
-n 10,50means 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, you will be given all the file paths of the most commonly used log files.