Hi

AM using Ignite 2.3, 

I have created 2 caches thru Java API and could see the same thru
igniteVisor, but I dont see anything SQLLINE when I execute !tables, what
could be the reason.

I ahev shared the config xml, and DataLoad.java used for loading the data

visor> cache -e
Time of the snapshot: 12/21/17, 15:39:49
+===================================================================================================================+
|    Name(@)    |    Mode     | Nodes |  Entries (Heap / Off-heap)  |   Hits   
|  Misses   |   Reads   |  Writes   |
+===================================================================================================================+
| Account(@c0)  | PARTITIONED | 3     | min: 273 (0 / 273)          | min: 0   
| min: 0    | min: 0    | min: 0    |
|               |             |       | avg: 333.00 (0.00 / 333.00) | avg:
0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 |
|               |             |       | max: 382 (0 / 382)          | max: 0   
| max: 0    | max: 0    | max: 0    |
+---------------+-------------+-------+-----------------------------+-----------+-----------+-----------+-----------+
| Customer(@c1) | PARTITIONED | 3     | min: 273 (0 / 273)          | min: 0   
| min: 0    | min: 0    | min: 0    |
|               |             |       | avg: 333.00 (0.00 / 333.00) | avg:
0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 |
|               |             |       | max: 393 (0 / 393)          | max: 0   
| max: 0    | max: 0    | max: 0    |
+-------------------------------------------------------------------------------------------------------------------+

[tibusr@JMNGD1BAQ10V04 bin]$ ./sqlline.sh --color=true --verbose=true -u
jdbc:ignite:thin://127.0.0.1
[tibusr@JMNGD1BAQ10V04 bin]$ ip r
default via 10.144.114.1 dev eno16780032  proto static  metric 100
10.144.114.0/23 dev eno16780032  proto kernel  scope link  src
10.144.114.114  metric 100
[tibusr@JMNGD1BAQ10V04 bin]$ ./sqlline.sh --color=true --verbose=true -u
jdbc:ignite:thin://127.0.0.1
issuing: !connect jdbc:ignite:thin://127.0.0.1 '' ''
org.apache.ignite.IgniteJdbcThinDriver
Connecting to jdbc:ignite:thin://127.0.0.1
Connected to: Apache Ignite (version 2.3.0#20171028-sha1:8add7fd5)
Driver: Apache Ignite Thin JDBC Driver (version
2.3.0#20171028-sha1:8add7fd5)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
sqlline version 1.3.0
0: jdbc:ignite:thin://127.0.0.1> !tables
+--------------------------------+--------------------------------+--------------------------------+--------------------------------+-------------------------------+
|           TABLE_CAT            |          TABLE_SCHEM           |          
TABLE_NAME           |           TABLE_TYPE           |            REMARKS      
     
|
+--------------------------------+--------------------------------+--------------------------------+---------------

However when I add table thru SQLLLINE, i could see the same thre
igniteVisor



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Reply via email to