drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aditya Kishore (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-664) Improve Rpc error message display
Date Sat, 10 May 2014 22:10:31 GMT

    [ https://issues.apache.org/jira/browse/DRILL-664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13992805#comment-13992805
] 

Aditya Kishore commented on DRILL-664:
--------------------------------------

With the fix
{noformat}
org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "6642cc2d-d57d-4c42-8176-62fd6e82ccaf"
endpoint {
  address: "10.250.0.230"
  user_port: 31010
  control_port: 31011
  data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < SqlParseException:[ Encountered "." at line 2, column
24.
Was expecting one of:
    "FROM" ...
    "," ...
    "AS" ...
    <IDENTIFIER> ...
    <QUOTED_IDENTIFIER> ...
    <BACK_QUOTED_IDENTIFIER> ...
    <BRACKET_QUOTED_IDENTIFIER> ...
    <UNICODE_QUOTED_IDENTIFIER> ...
    "NOT" ...
    "IN" ...
    "BETWEEN" ...
    "LIKE" ...
    "SIMILAR" ...
    "=" ...
    ">" ...
    "<" ...
    "<=" ...
    ">=" ...
    "<>" ...
    "+" ...
    "-" ...
    "*" ...
    "/" ...
    "||" ...
    "AND" ...
    "OR" ...
    "IS" ...
    "MEMBER" ...
    "SUBMULTISET" ...
    "MULTISET" ...
    "[" ...
     ]"
]
	at org.apache.drill.exec.rpc.user.QueryResultHandler.batchArrived(QueryResultHandler.java:72)
	at org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:80)
{noformat}

> Improve Rpc error message display
> ---------------------------------
>
>                 Key: DRILL-664
>                 URL: https://issues.apache.org/jira/browse/DRILL-664
>             Project: Apache Drill
>          Issue Type: Improvement
>            Reporter: Aditya Kishore
>            Assignee: Aditya Kishore
>            Priority: Minor
>             Fix For: 1.0.0-rc1
>
>         Attachments: DRILL-664-Improve-Rpc-error-message-display.patch
>
>
> At present, a query failure results in illegibly formatted error message (due to escaped
protobuf string encoding). This results in error message like the following.
> {noformat}
> org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id:
"5041d4c5-0d60-47c2-a350-27c1a07e54f9"
> endpoint {
>   address: "10.250.0.230"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < SqlParseException:[ Encountered \".\" at line
2, column 24.\r\nWas expecting one of:\r\n    \"FROM\" ...\r\n    \",\" ...\r\n    \"AS\"
...\r\n    <IDENTIFIER> ...\r\n    <QUOTED_IDENTIFIER> ...\r\n    <BACK_QUOTED_IDENTIFIER>
...\r\n    <BRACKET_QUOTED_IDENTIFIER> ...\r\n    <UNICODE_QUOTED_IDENTIFIER>
...\r\n    \"NOT\" ...\r\n    \"IN\" ...\r\n    \"BETWEEN\" ...\r\n    \"LIKE\" ...\r\n  
 \"SIMILAR\" ...\r\n    \"=\" ...\r\n    \">\" ...\r\n    \"<\" ...\r\n    \"<=\"
...\r\n    \">=\" ...\r\n    \"<>\" ...\r\n    \"+\" ...\r\n    \"-\" ...\r\n   
\"*\" ...\r\n    \"/\" ...\r\n    \"||\" ...\r\n    \"AND\" ...\r\n    \"OR\" ...\r\n    \"IS\"
...\r\n    \"MEMBER\" ...\r\n    \"SUBMULTISET\" ...\r\n    \"MULTISET\" ...\r\n    \"[\"
...\r\n     ] < ParseException:[ Encountered \".\" at line 2, column 24.\r\nWas expecting
one of:\r\n    \"FROM\" ...\r\n    \",\" ...\r\n    \"AS\" ...\r\n    <IDENTIFIER> ...\r\n
   <QUOTED_IDENTIFIER> ...\r\n    <BACK_QUOTED_IDENTIFIER> ...\r\n    <BRACKET_QUOTED_IDENTIFIER>
...\r\n    <UNICODE_QUOTED_IDENTIFIER> ...\r\n    \"NOT\" ...\r\n    \"IN\" ...\r\n
   \"BETWEEN\" ...\r\n    \"LIKE\" ...\r\n    \"SIMILAR\" ...\r\n    \"=\" ...\r\n    \">\"
...\r\n    \"<\" ...\r\n    \"<=\" ...\r\n    \">=\" ...\r\n    \"<>\" ...\r\n
   \"+\" ...\r\n    \"-\" ...\r\n    \"*\" ...\r\n    \"/\" ...\r\n    \"||\" ...\r\n    \"AND\"
...\r\n    \"OR\" ...\r\n    \"IS\" ...\r\n    \"MEMBER\" ...\r\n    \"SUBMULTISET\" ...\r\n
   \"MULTISET\" ...\r\n    \"[\" ...\r\n     ]"
> ]
> 	at org.apache.drill.exec.rpc.user.QueryResultHandler.batchArrived(QueryResultHandler.java:72)
> 	at org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:80)
> 	at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:52)
> 	at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:34)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message