Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1771

Doing a flatten along with selecting a column from a subquery which does a flatten over kvgen results in a planning error

    XMLWordPrintableJSON

Details

    Description

      git.commit.id.abbrev=108d29f

      Dataset :

      {"map":{"rm": [ {"rptd": [{ "a": "foo"}]}]}}
      

      Query :

      select sub.fk.key, flatten(sub.fk.`value`) from (select flatten(kvgen(map)) fk from `json_kvgenflatten/nested3.json` limit 1) sub;
      Query failed: Failure while setting up Foreman.
      
      Error: exception while executing query: Failure while executing query. (state=,code=0)
      

      I attached the error log. Let me know if you need anything more

      Attachments

        1. error.log
          4 kB
          Rahul Kumar Challapalli

        Activity

          People

            dsbos Daniel Barclay
            rkins Rahul Kumar Challapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: