Created
November 12, 2020 07:17
-
-
Save ashishb888/d339652534631053cdc5fe93495702df to your computer and use it in GitHub Desktop.
Ignite sqlline connection parameters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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