Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1751

Drill must indicate JSON All Text Mode needs to be turned on when such queries fail

    XMLWordPrintableJSON

Details

    Description

      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.

      Attachments

        1. drillbit.log
          11 kB
          Abhishek Girish

        Issue Links

          Activity

            People

              jaltekruse Jason Altekruse
              agirish Abhishek Girish
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: