drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4503) Schema change exception even with all_text_mode enabled
Date Sun, 13 Mar 2016 19:24:33 GMT
Aman Sinha created DRILL-4503:
---------------------------------

             Summary: 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


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)

Mime
View raw message