[jira] [Created] (DRILL-3010) Convert bad command error messages into UserExceptions in SqlHandlers

["Venki Korukanti (JIRA)" <ji...@apache.org>]

Venki Korukanti created DRILL-3010:
--------------------------------------

             Summary: Convert bad command error messages into UserExceptions in SqlHandlers
                 Key: DRILL-3010
                 URL: https://issues.apache.org/jira/browse/DRILL-3010
             Project: Apache Drill
          Issue Type: Bug
          Components: Metadata
    Affects Versions: 0.8.0
            Reporter: Venki Korukanti
            Assignee: Venki Korukanti
             Fix For: 1.0.0


Currently SqlHandlers such as CreateTable or ViewHandler send the error messages as bad command records.  Instead we should throw a UserException.

{code}
0: jdbc:drill:zk=local> create table t1 as select * from cp.`region.json`;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| false      | Unable to create table. Schema [dfs.default] is immutable.  |
+------------+------------+
1 row selected (0.103 seconds)
{code}

Instead it should be like:

{code}
0: jdbc:drill:zk=10.10.30.143:5181> create table t1 as select * from cp.`region.json`;
Error: PARSE ERROR: Unable to create or drop tables/views. Schema [dfs.default] is immutable.


[Error Id: 3a92d026-3df7-4e8b-8988-2300463fa00b on centos64-30146.qa.lab:31010] (state=,code=0)
{code}



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