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

Accumulo does not return null values

    Details

    • Steps to Reproduce:
      Hide

      1. Query a nullable column with some null entries
      2. Check that the null values wasn't returned

      Show
      1. Query a nullable column with some null entries 2. Check that the null values wasn't returned

      Description

      Accumulo doesn't return null values when a whole 'column' is being selected.
      For a command in accumulo shell like:

      Unable to find source-code formatter for language: plain. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      scan -c name:BYTENUM
      

      Accumulo returns only non-empty values, this is expected behaviour.

      Equivalent query in Teiid would be:

      SELECT ByteNum FROM SmallA
      

      Which returns the same results as Accumulo does. That means, no NULL values, if there are rowids without specified column families/qualifiers missing. But when a user has his schema defined in a vdb, he probably expects, that he will get as many rows as there are in the table.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rareddy Ramesh Reddy
                Reporter:
                jstastny Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: