Meta-information about Mappings

You can find more information about existing mappings such as the column names and their SQL data types using the information_schema tables.

1. Create a mapping to a map called myMappingName.

   sql

   CREATE MAPPING myMappingName
   TYPE IMap
   OPTIONS ('keyFormat'='varchar','valueFormat'='int');

2. Get the name of all mappings.

   sql

   SHOW MAPPINGS;

   You should see the name of the mapping.

   +--------------------+
   |name                |
   +--------------------+
   |myMappingName       |
   +--------------------+

3. Get more information about the mapping.

   sql

   SELECT * FROM information_schema.mappings
   WHERE table_name = 'myMappingName';

   The name of the mapping is stored in the table_name column. Currently, all mappings are part of the public schema in the hazelcast table catalog.

4. Get information about the column names and the columns' SQL data types.

   sql

   SELECT * FROM information_schema.columns
   WHERE table_name = 'myMappingName';

Next Steps

See the SQL statements that you can use to manage your mappings.