Return-Path: 
 <issues-return-6242-apmail-drill-issues-archive=drill.apache.org@drill.incubator.apache.org>
X-Original-To: apmail-drill-issues-archive@minotaur.apache.org
Delivered-To: apmail-drill-issues-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 76D9B10C5C
	for <apmail-drill-issues-archive@minotaur.apache.org>;
 Wed, 19 Nov 2014 20:06:00 +0000 (UTC)
Received: (qmail 29051 invoked by uid 500); 19 Nov 2014 20:06:00 -0000
Delivered-To: apmail-drill-issues-archive@drill.apache.org
Received: (qmail 29025 invoked by uid 500); 19 Nov 2014 20:06:00 -0000
Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@drill.incubator.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@drill.incubator.apache.org>
List-Post: <mailto:issues@drill.incubator.apache.org>
List-Id: <issues.drill.incubator.apache.org>
Reply-To: dev@drill.incubator.apache.org
Delivered-To: mailing list issues@drill.incubator.apache.org
Received: (qmail 29016 invoked by uid 99); 19 Nov 2014 20:06:00 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Nov 2014 20:06:00 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED,T_RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3)
    by apache.org (qpsmtpd/0.29) with SMTP; Wed, 19 Nov 2014 20:05:59 +0000
Received: (qmail 27767 invoked by uid 99); 19 Nov 2014 20:05:34 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Nov 2014 20:05:34 +0000
Date: Wed, 19 Nov 2014 20:05:34 +0000 (UTC)
From: "Abhishek Girish (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12756521.1416427502000.538394.1416427534148@Atlassian.JIRA>
In-Reply-To: <JIRA.12756521.1416427502000@Atlassian.JIRA>
References: <JIRA.12756521.1416427502000@Atlassian.JIRA>
 <JIRA.12756521.1416427502296@arcas>
Subject: [jira] [Created] (DRILL-1751) Drill must indicate JSON All Text
 Mode needs to be turned on when such queries fail
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org

Abhishek Girish created DRILL-1751:
--------------------------------------

             Summary: Drill must indicate JSON All Text Mode needs to be turned on when such queries fail
                 Key: DRILL-1751
                 URL: https://issues.apache.org/jira/browse/DRILL-1751
             Project: Apache Drill
          Issue Type: Improvement
            Reporter: Abhishek Girish
            Assignee: Jacques Nadeau


Although JSON All Text Mode is a documented option, it may not be obvious to turn this option ON on encountering an error. 

Query:
> select * from dfs.`/data/json/lastfm/lastfm_test/A/A/A/TRAAAEA128F935A30D.json` limit 1;
Query failed: Failure while running fragment.[ 4331e9a7-c5b4-4e52-bece-214ffa5d06dd on abhi7.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query. (state=,code=0)

Resolution:

I tried setting JSON Text Mode and queries began to work. 

> alter system set `store.json.all_text_mode` = true;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | store.json.all_text_mode updated. |
+------------+------------+
1 row selected (0.136 seconds)
0: jdbc:drill:zk=10.10.103.34:5181> select * from dfs.`/data/json/lastfm/lastfm_test/A/A/A/TRAAAEA128F935A30D.json` limit 1;
+------------+------------+------------+------------+------------+
<results>
+------------+------------+------------+------------+------------+
1 row selected (0.169 seconds)

A clear message must be included in the logs and must be displayed on SQLline. 




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)