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

aggregation function on complex type should give appropriate error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 0.8.0
    • Future
    • Functions - Drill
    • None

    Description

      #Fri Mar 06 16:51:10 EST 2015
      git.commit.id.abbrev=fb293ba

      Apply aggregation function on complex data should error out with appropriate error message instead of returning null.

      0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select t.soa[1] from `complex.json` t limit 1;
      +------------+
      |   EXPR$0   |
      +------------+
      | {"in":1,"fl":1.12345} |
      +------------+
      1 row selected (0.169 seconds)
      0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select avg(t.soa[1]) from `complex.json` t;
      +--+
      |  |
      +--+
      +--+
      No rows selected (0.164 seconds)
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              cchang@maprtech.com Chun Chang
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: