Let’s Connect, Analyze, and Learn from Data.!
TigerGraph is the world’s fastest graph analytics platform designed to unleash the power of interconnected data for deeper insights and better outcomes. The company supports applications such as IoT, AI, and machine learning to make sense of ever-changing big data.
TigerGraph’s massively parallel processing (MPP) architecture combined with an efficient query processing engine allow for analyzing entities and their relationships at scale. TigerGraph is fully ACID compliant, giving the ability to perform both transactional and analytic workloads on the same platform. As with data lakes, TigerGraph’s scalability and flexible schema allow the joining of diverse data sets.
This is my first time using and install the Tiger Graph. Prerequisites, my local setup:
-macOS Catalina 10.15.7
-Docker Desktop 3.6.0 on Mac
–TigerGraph Enterprise Edition docker image
Step 1: Install Docker on Mac follow this link.
Step 2: Open Terminal on your Mac and follow these steps:
-Prepare a Shared Folder on Host OS to be shared with Docker Container:
henrygultom@MacBook-Pro ~ % mkdir tigergraph
henrygultom@MacBook-Pro ~ % cd tigergraph
henrygultom@MacBook-Pro tigergraph % mkdir data
henrygultom@MacBook-Pro tigergraph % chmod 777 data
henrygultom@MacBook-Pro tigergraph % ls
data
-Run TigerGraph Docker image as a daemon:
henrygultom@MacBook-Pro tigergraph % docker run -d -p 14022:22 -p 9000:9000 -p 14240:14240 –name tigergraph –ulimit nofile=1000000:1000000 -v ~/tigergraph/data:/home/tigergraph/mydata -t docker.tigergraph.com/tigergraph:latest
Unable to find image ‘docker.tigergraph.com/tigergraph:latest’ locally
latest: Pulling from tigergraph
528184910841: Pull complete
8a9df81d603d: Pull complete
636d9303bf66: Pull complete
672b5bdcef61: Pull complete
5d1235f9b296: Pull complete
819f1e6e507e: Pull complete
Digest: sha256:4f16402f6cece37de98911ff286d4b6c996e7a7dab0cab996f36a77ede304010
Status: Downloaded newer image for docker.tigergraph.com/tigergraph:latest
b3f33c6f7d7591b8c0a5a2fe13e94f37d48a55eb643171002357110ae1c40332
henrygultom@MacBook-Pro tigergraph %
henrygultom@MacBook-Pro tigergraph % docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
b3f33c6f7d75 docker.tigergraph.com/tigergraph:latest “/bin/sh -c ‘/usr/sb…” 48 minutes ago Up 48 minutes 0.0.0.0:9000->9000/tcp, :::9000->9000/tcp, 0.0.0.0:14240->14240/tcp, :::14240->14240/tcp, 0.0.0.0:14022->22/tcp, :::14022->22/tcp tigergraph
henrygultom@MacBook-Pro tigergraph %
henrygultom@MacBook-Pro tigergraph % uname -a
Darwin MacBook-Pro.local 19.6.0 Darwin Kernel Version 19.6.0: Tue Jun 22 19:49:55 PDT 2021; root:xnu-6153.141.35~1/RELEASE_X86_64 x86_64
henrygultom@MacBook-Pro tigergraph %
-Use SSH to connect to your container:
henrygultom@MacBook-Pro tigergraph % ssh -p 14022 tigergraph@localhost
The authenticity of host ‘[localhost]:14022 ([::1]:14022)’ can’t be established.
ECDSA key fingerprint is SHA256:yxJX13+vAPeEMuhhUE6Ni0qVMGzeUzci29Buv7qvZ6U.
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning: Permanently added ‘[localhost]:14022’ (ECDSA) to the list of known hosts.
tigergraph@localhost’s password:
Connection closed by ::1 port 14022
henrygultom@MacBook-Pro tigergraph %
henrygultom@MacBook-Pro tigergraph % ssh -p 14022 tigergraph@localhost
tigergraph@localhost’s password:
Welcome to Ubuntu 16.04.7 LTS (GNU/Linux 5.10.47-linuxkit x86_64)
* Documentation: https://help.ubuntu.com
* Management: https://landscape.canonical.com
* Support: https://ubuntu.com/advantage
tigergraph@b3f33c6f7d75:~$
-Start TigerGraph:
tigergraph@b3f33c6f7d75:~$ gadmin start
[ Info] If no serviceID is specified, it only starts services excluding the infrastructure. Use ‘gadmin start all’ to start all services.
[ Info] Starting ZK ETCD DICT KAFKA ADMIN GSE NGINX GPE RESTPP KAFKASTRM-LL KAFKACONN TS3SERV GSQL TS3 GUI
[ Error] ConnectionClosed (Unable to talk to ctrl, are all infrastructure services up? You can start them by ‘gadmin start infra’)
tigergraph@b3f33c6f7d75:~$
tigergraph@b3f33c6f7d75:~$ gadmin start all
[ Info] Starting EXE
[ Info] Starting CTRL
[ Info] Starting ZK ETCD DICT KAFKA ADMIN GSE NGINX GPE RESTPP KAFKASTRM-LL KAFKACONN TS3SERV GSQL TS3 IFM GUI
tigergraph@b3f33c6f7d75:~$
tigergraph@b3f33c6f7d75:~$
tigergraph@b3f33c6f7d75:~$ gsql
Welcome to TigerGraph.
GSQL > show v
vertex values var
GSQL > alter
alter
GSQL > alter
alter
GSQL > ls
—- Global vertices, edges, and all graphs
Vertex Types:
Edge Types:
Graphs:
Jobs:
JSON API version: v2
Syntax version: v1
GSQL > quit
tigergraph@b3f33c6f7d75:~$
tigergraph@b3f33c6f7d75:~$ ls
gsql-graph-algorithms mydata tigergraph tutorial
tigergraph@b3f33c6f7d75:~$ cd tutorial
tigergraph@b3f33c6f7d75:~/tutorial$ ls
2.x 3.x
tigergraph@b3f33c6f7d75:~/tutorial$
tigergraph@b3f33c6f7d75:~/tutorial$ cd 2.x/
tigergraph@b3f33c6f7d75:~/tutorial/2.x$ ls
gsql101 gsql102
tigergraph@b3f33c6f7d75:~/tutorial/2.x$ cd gsql101
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$ ls
friendship.csv gsql101.gsql person.csv README.md
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$ vim README.md
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$ gsql gsql101.gsql
Dropping all, about 1 minute …
Abort all active loading jobs
Resetting GPE…
Successfully reset GPE
Stopping GPE GSE
Successfully stopped GPE GSE in 0.495 seconds
Clearing graph store…
Successfully cleared graph store
Starting GPE GSE RESTPP
Successfully started GPE GSE RESTPP in 0.075 seconds
Everything is dropped.
The vertex type person is created.
The edge type friendship is created.
Stopping GPE GSE RESTPP
Successfully stopped GPE GSE RESTPP in 17.650 seconds
Starting GPE GSE RESTPP
Successfully started GPE GSE RESTPP in 0.071 seconds
The graph social is created.
Semantic Check Fails: File or directory ‘$HOME/tutorial/gsql101/person.csv’ does not exist!
Semantic Check Fails: The FILENAME = ‘m1:/home/tigergraph/tutorial/gsql101/person.csv’ is not in a valid path format.
The job load_social could not be created!
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$ gsql version
GSQL version: 3.1
GSQL commit number: 06c9098c895d88a30daf3ee307a428ee38f0a7b4
GSQL commit date: 2021-07-19 09:18:25 -0700
Copyright (c) 2014-2021 TigerGraph. All rights reserved.
This product is protected by U.S. and international copyright and intellectual property laws.
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$
Continue – next tutorial: https://docs.tigergraph.com/start/gsql-101/parameterized-gsql-query