Details
-
Bug
-
Resolution: Done
-
Major
-
8.12.3
-
None
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.