[DRILL-1181] make sqlline error messages more user friendly

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Client - JDBC, Execution - RPC
• Assignee: DrillCommitter
• Reporter: Hanifi Gunes
• Created: 23/Jul/14 21:18
• Updated: 05/Aug/14 21:32
• Resolved: 27/Jul/14 18:50

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 ]"
]

Issue Links

• duplicates: DRILL-347 Improve user messages from CLI