Skip to content

Instantly share code, notes, and snippets.

@ashishb888
Created November 12, 2020 07:17
Show Gist options
  • Save ashishb888/d339652534631053cdc5fe93495702df to your computer and use it in GitHub Desktop.
Save ashishb888/d339652534631053cdc5fe93495702df to your computer and use it in GitHub Desktop.
Ignite sqlline connection parameters
// Find PID
[user@host ~]$ ps -ef | grep app-name
user 14276 184778 1 11:46 pts/3 00:00:28 /host/setups/jdk1.8.0_191/bin/java -jar app-name-0.0.1-SNAPSHOT.jar
-------------------------------
// Find the list of port used for the PID
[user@host ~]$ netstat -lnp | grep 14422
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:43500 0.0.0.0:* LISTEN 14422/java
tcp 0 0 0.0.0.0:11213 0.0.0.0:* LISTEN 14422/java
tcp 0 0 0.0.0.0:8082 0.0.0.0:* LISTEN 14422/java
tcp 0 0 0.0.0.0:10804 0.0.0.0:* LISTEN 14422/java
tcp 0 0 0.0.0.0:43101 0.0.0.0:* LISTEN 14422/java
-------------------------------
// Now use relevent port and connect to the cluster by using sqlline
[user@host ~]$ $IGNITE_HOME/bin/sqlline.sh --verbose=true -u jdbc:ignite:thin://localhost:10804?distributedJoins=true
issuing: !connect jdbc:ignite:thin://localhost:10804?distributedJoins=true '' '' org.apache.ignite.IgniteJdbcThinDriver
Connecting to jdbc:ignite:thin://localhost:10804?distributedJoins=true
Connected to: Apache Ignite (version 8.7.23#20200728-sha1:4e015639)
Driver: Apache Ignite Thin JDBC Driver (version 8.7.23#20200728-sha1:4e015639)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
sqlline version 1.3.0
0: jdbc:ignite:thin://localhost:10804> select count(*) from "SCHEMA_NAME".TABLE_NAME;
+--------------------------------+
| COUNT(*) |
+--------------------------------+
| 11111 |
+--------------------------------+
1 row selected (0.073 seconds)
0: jdbc:ignite:thin://localhost:10804>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment