Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Sun, 13 Mar 2016 19:29:33 +0000 (UTC)
From: "Aman Sinha (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12949720.1457897030000.3062.1457897373477@Atlassian.JIRA>
In-Reply-To: <JIRA.12949720.1457897030000@Atlassian.JIRA>
References: <JIRA.12949720.1457897030000@Atlassian.JIRA>
 <JIRA.12949720.1457897030256@arcas>
Subject: [jira] [Updated] (DRILL-4503) Schema change exception even with
 all_text_mode enabled
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aman Sinha updated DRILL-4503:
------------------------------
    Attachment: mostlynulls_1.json

Attached file with 3 columns {a, b, c} where 'a' has non-null values, b and c have many null values. 

> 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: Aman Sinha
>              Labels: 1.7.0
>         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)