[ https://issues.apache.org/jira/browse/DRILL-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jason Altekruse updated DRILL-1751: ----------------------------------- Fix Version/s: (was: Future) 0.9.0 > 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: Jason Altekruse > Labels: error_message_must_fix > Fix For: 0.9.0 > > Attachments: drillbit.log > > > 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)