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

make sqlline error messages more user friendly

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Labels:
      None

      Description

      Current sqlline messages are not quite end user friendly. Say, running a simple query [select * from NOT_HERE;] produces the output below. We should prettify the error messages shown to end user.

      0: jdbc:drill:zk> select * from NOT_HERE;
      select * from NOT_HERE;
      Query failed: Remote failure while running query.[error_id: "af7f4b8d-b556-49d0-a6c2-a8f27d4d8b1f"
      Error: exception while executing query (state=,code=0)
      endpoint {
      address: "192.168.168.122"
      user_port: 31010
      control_port: 31011
      data_port: 31012
      }
      error_type: 0
      message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line 1, column 22 ] < EigenbaseContextException:[ From line 1, column 15 to line 1, column 22 ] < SqlValidatorException:[ Table 'NOT_HERE' not found ]"
      ]

        Attachments

        1. DRILL-1181.1.patch.txt
          17 kB
          Hanifi Gunes
        2. DRILL-1181.2.patch.txt
          17 kB
          Hanifi Gunes

          Issue Links

            Activity

              People

              • Assignee:
                DrillCommitter DrillCommitter
                Reporter:
                hgunes Hanifi Gunes
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: