Hello!
Are you sure the cache was not created? Did you check it in Visor?
After running this DML I can see the following:
visor> cache -a
Time of the snapshot: 2019-10-03 18:09:13
+=====================================================================================================================================================================+
| Name(@) | Mode | Nodes | Total entries (Heap /
Off-heap) | Primary entries (Heap / Off-heap) | Hits | Misses |
Reads | Writes |
+=====================================================================================================================================================================+
| foo_1234_test_test(@c0) | PARTITIONED | 1 | 0 (0 / 0)
| min: 0 (0 / 0) | min: 0 | min: 0 | min: 0
| min: 0 |
Regards,
--
Ilya Kasnacheev
чт, 3 окт. 2019 г. в 00:07, Stephen Danauskas <sdanaus...@factset.com>:
> I’m attempting to create a table and I’m setting the cache name according
> to the examples in the documentation.
>
>
>
> CREATE TABLE IF NOT EXISTS batch_test (x varchar(10), y int, z float,
> PRIMARY KEY (y)) WITH "CACHE_NAME=foo_1234_test_test";
>
>
>
> I’ve run this query through sqlline and a C++ executable using the ODBC
> driver. I’m using Ignite 2.7.6. In both cases I’m not seeing the cache
> being created
>
>
>
>
> +--------------------------------+--------------------------------+--------------------------------+--------------------------------+--------------------------------+-+
>
> | TABLE_CAT | TABLE_SCHEM
> | TABLE_NAME | TABLE_TYPE |
> REMARKS | |
>
>
> +--------------------------------+--------------------------------+--------------------------------+--------------------------------+--------------------------------+-+
>
> | |
> PUBLIC | BATCH_TEST |
> TABLE |
> | |
>
>
> +--------------------------------+--------------------------------+--------------------------------+--------------------------------+--------------------------------+-+
>
>
>
>
>
> Any help is appreciated.
>
>
>
