Details
-
Bug
-
Status: Reviewable
-
Major
-
Resolution: Unresolved
-
1.6.0
-
None
Description
Both HashAggregate and StreamingAggregate encounter schema change error whey querying a JSON file with non-null values for column 'a' and many null values for column 'c'.
This occurs even when all_text_mode is enabled, which seems counterintuitive since once all_text_mode is enabled, everything (including nulls) should be treated as varchar and one would expect no schema change errors.
Here are some example queries that encounter this error:
0: jdbc:drill:zk=local> select a, c from dfs.`mostlynulls_1.json` group by a, c; Error: UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema changes 0: jdbc:drill:zk=local> alter session set `store.json.all_text_mode` = true; +-------+------------------------------------+ | ok | summary | +-------+------------------------------------+ | true | store.json.all_text_mode updated. | +-------+------------------------------------+ 1 row selected (0.15 seconds) 0: jdbc:drill:zk=local> select a, c from dfs.`mostlynulls_1.json` group by a, c; Error: UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema changes 0: jdbc:drill:zk=local> select min(a), min(c) from dfs.`mostlynulls_1.json`; Error: UNSUPPORTED_OPERATION ERROR: Streaming aggregate does not support schema changes
Attachments
Attachments
Issue Links
- relates to
-
DRILL-4538 Turn on Union type by default
- Open