[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zelaine Fong reassigned DRILL-4503: ----------------------------------- Assignee: Padma Penumarthy (was: Aman Sinha) Assigning to [~ppenumarthy] for code review. > Schema change exception even with all_text_mode enabled > ------------------------------------------------------- > > Key: DRILL-4503 > URL: https://issues.apache.org/jira/browse/DRILL-4503 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JSON > Affects Versions: 1.6.0 > Reporter: Aman Sinha > Assignee: Padma Penumarthy > Fix For: Future > > Attachments: mostlynulls_1.json > > > 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: > {noformat} > 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 > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)