drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject problem with missing values
Date Mon, 27 Jun 2016 03:56:50 GMT
In DRILL-4754, I reported that where a field is missing, it is sometimes
replaced with an empty list. This seems very wrong.

The data:


*{'a':3, 'b':[3,2], 'c':'xyz'}{'a':7, 'c':'wxy'}*
*{"a":7, "b":[]}*

Note the missing 'b' value in the second record.

The query:

0: jdbc:drill:> select * from maprfs.ted.`bug.json`;

The result:

0: jdbc:drill:> select * from maprfs.ted.`bug.json`;






*+----+--------+-------+| a  |   b    |   c   |+----+--------+-------+| 3
 | [3,2]  | xyz   || 7  | []     | wxy   || 7  | []     | null
 |+----+--------+-------+*

Note the way that 'b' has a non-null value in the second record. Note the
way that 'c' does have a null value in the third record.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message