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

Query bug: null values in result of a conditioned query

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.9.0
    • Fix Version/s: 1.14.0
    • Labels:
      None

      Description

      I have a table with 300 columns.
      When I select a query , some null columns are also returned.
      This is the query that I used.
      "select a,b from dfs.root.`/2016/1/17` where a=1"

      For example in this query some columns are returned that "a" value is null.

      I think null values are problems. Because when I add a condition to it like
      "select a,b from dfs.root.`/2016/1/17` where a=1 and a IS NOT NULL"
      there is not any change and still NULL values are returned.

        Attachments

          Activity

            People

            • Assignee:
              jni Jinfeng Ni
              Reporter:
              mehran mehran
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: