You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2019/05/29 15:34:00 UTC
[jira] [Commented] (IMPALA-7106) Log the original and rewritten SQL
when SQL rewrite fails
[ https://issues.apache.org/jira/browse/IMPALA-7106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16850974#comment-16850974 ]
ASF subversion and git services commented on IMPALA-7106:
---------------------------------------------------------
Commit 1ee17ee89a579e65c2fbc55a613ac368d01161a0 in impala's branch refs/heads/2.x from Fredy Wijaya
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=1ee17ee ]
IMPALA-7106: Log the original and rewritten SQL when SQL rewrite fails
toSql() method is used to print SQL string that is close to the original
SQL string when errors arise or as the result of "SHOW CREATE". When
debugging issues related to SQL rewrites, it can be very useful to be
able to get the SQL string that is being rewritten. This patch adds a
new method toSql(boolean rewritten) to get the rewritten SQL string. This
patch also logs the original and rewritten SQL when SQL rewrite fails.
Testing:
- Added FE test for the rewritten SQL string
- Ran all FE tests
Change-Id: Iab58b0cc865135d261dd4a7f72be130f2e7bde53
Reviewed-on: http://gerrit.cloudera.org:8080/10571
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
> Log the original and rewritten SQL when SQL rewrite fails
> ---------------------------------------------------------
>
> Key: IMPALA-7106
> URL: https://issues.apache.org/jira/browse/IMPALA-7106
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 3.0, Impala 2.12.0
> Reporter: Fredy Wijaya
> Assignee: Fredy Wijaya
> Priority: Major
> Fix For: Impala 2.13.0, Impala 3.1.0
>
>
> The toSql() prints the the SQL that is close to the original SQL string which makes sense for the users. However when debugging, i.e. log level set to TRACE, it is useful to have the rewritten SQL printed out correctly.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org