Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Won't Fix
-
None
-
None
-
None
Description
The first query failed, and the second succeeded. The only difference was that the field was referred to with the table name b (ie, b.hours.Friday vs. hours.Friday). Both should work.
0: jdbc:drill:zk=localhost:2181> SELECT name, hours.Friday FROM dfs.root.`Users/tshiran/Development/demo/data/yelp/business.json` b LIMIT 1; Query failed: Failure while running sql. Error: exception while executing query: Failure while executing query. (state=,code=0) 0: jdbc:drill:zk=localhost:2181> SELECT name, b.hours.Friday FROM dfs.root.`Users/tshiran/Development/demo/data/yelp/business.json` b LIMIT 1; +------------+------------+ | name | EXPR$1 | +------------+------------+ | Eric Goldberg, MD | {"close":"17:00","open":"08:00"} | +------------+------------+