[DRILL-2186] select * is not working with flatten

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: Functions - Drill
• Assignee: Daniel Barclay
• Reporter: Rahul Kumar Challapalli
• Created: 09/Feb/15 05:15
• Updated: 21/Apr/15 18:11
• Resolved: 10/Feb/15 17:17

Description

git.commit.id.abbrev=c54bd6a

Data Set :

{
  "id" : 1,
  "lst" : [1,2,3]
}

The below queries incorrectly return null

0: jdbc:drill:schema=dfs> select *, flatten(lst) from `temp.json`;
+------------+------------+
|     *      |   EXPR$1   |
+------------+------------+
| null       | 1          |
| null       | 2          |
| null       | 3          |
+------------+------------+

0: jdbc:drill:schema=dfs> select * from `temp.json` order by flatten(lst);
+------------+
|     *      |
+------------+
| null       |
| null       |
| null       |
+------------+

Issue Links

• duplicates: DRILL-2180 Star is not expanded when being used with flatten