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.

Create a mapping to a map called myMappingName.

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

Get the name of all mappings.

SHOW MAPPINGS;

You should see the name of the mapping.

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

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

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

Next Steps

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