Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-6242

Passing custom cache and type names to CREATE TABLE

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • 2.1
    • 2.3
    • sql

    Description

      Once CREATE TABLE is executed Ignite:

      • will create an IgniteCache naming it SQL_PUBLIC_{TABLE}. So, if a Person table is created you’ll have SQL_PUBLIC_PERSON cache in the cluster.
      • will use autogenerated names for the key and value types. For instance, this is how the type name might look like SQL_PUBLIC_CITY_3f4e9fbf_3464_4598_8394_1307b86dc4e7_KEY.

      The goal of the ticket is to give a way to pass a custom cache name, key's type name, value's type name into WITH clause.

      Refer to this discussion for more details:
      http://apache-ignite-developers.2346864.n4.nabble.com/Key-value-access-to-caches-created-with-DDL-td21622.html
      http://apache-ignite-developers.2346864.n4.nabble.com/Override-cache-name-created-with-CREATE-TABLE-td21456.html

      Attachments

        Issue Links

          Activity

            People

              al.psc Alexander Paschenko
              dmagda Denis A. Magda
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: