Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save derms/346609a04f3849d9125e045464e0fbc1 to your computer and use it in GitHub Desktop.
Save derms/346609a04f3849d9125e045464e0fbc1 to your computer and use it in GitHub Desktop.
BEGIN
CREATE LOADING JOB load_job_bi_data FOR GRAPH dataops {
DEFINE FILENAME MyDataSource = "/home/tigergraph/tigergraph/data/gui/loading_data/bi_data.csv";
LOAD MyDataSource
TO VERTEX object VALUES(gsql_concat($0, ":", $1, ":", $3), $0, $1, $3, _, _)
, TO VERTEX object VALUES(gsql_concat($0, ":", $4, ":", $5), $0, $4, $5, _, _) WHERE $4 != "Logical Table"
, TO EDGE relates_to VALUES(gsql_concat($0, ":", $1, ":", $3), gsql_concat($0, ":", $4, ":", $5)) WHERE $4 != "Logical Table"
USING SEPARATOR = ","
, HEADER = "true"
, EOL = "\n";
}
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment