Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2958

MongoDB: Remove the need to have parent id in embedded table

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 8.7.1, 8.9
    • 8.7
    • Misc. Connectors

    Description

      Currently, it seems like ID needs to be appear in parent and child for nested documents. But it is unlikely a case for MongoDB customers. It would be nice if Teiid can flatten out data in one single table. Therefore, users would not need to insert parent id in the child document in order for Teiid to work.

      I am thinking the following case. For example I have a JSON object like this:

       
      Customer
      {
        _id: 1374932,
        FirstName: "John",
        LastName: "Doe",
        Address:  {
             _id: 43839430,
             customer_id: IDRef("Customer", 1374932)
              Street: "123 Lane",
              City: "New York",
              State: "NY",
              Zipcode: "12345"
           }
      }
      

      the Teiid should work with document such as

       
      Customer
      {
        _id: 1374932,
        FirstName: "John",
        LastName: "Doe",
        Address:  {
             _id: 43839430,
              Street: "123 Lane",
              City: "New York",
              State: "NY",
              Zipcode: "12345"
           }
      }
      

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-rareddy Ramesh Reddy
              mchantibco Ivan Chan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: