Impala Public Jenkins has submitted this change and it was merged. ( 
http://gerrit.cloudera.org:8080/12014 )

Change subject: IMPALA-7907: Fix ScalarFunction.toSql()
......................................................................

IMPALA-7907: Fix ScalarFunction.toSql()

Each AST statement node has a toSql() implementation. The code for
ScalarFunction and ToSqlUtils has a number of issues:

* If Location or Symbol are not set, they are shown as 'null'. Better to
  omit these clauses if the items are not available. This is mostly an
  issue during testing.
* The generated SQL does not follow the CREATE TABLE syntax.  For
  example, the signature and return value are provided for Java
  functions, but should not be.
* Unlike other statements, this one is generated with a trailing newline.
* ToSql.getCreateFunctionSql() fails to separate functions with the
  semi-colon statement separator.

These are all minor issues, but we might as well fix the code to work as
intended.

Testing:
* Added a new unit tests to verify the behavior (no tested existed
  previously.)
* Re-ran all FE tests.

Change-Id: Id34d6df97760a11c299092dff8edbdb7033bce1c
Reviewed-on: http://gerrit.cloudera.org:8080/12014
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
---
M fe/src/main/java/org/apache/impala/analysis/ToSqlUtils.java
M fe/src/main/java/org/apache/impala/catalog/AggregateFunction.java
M fe/src/main/java/org/apache/impala/catalog/Function.java
M fe/src/main/java/org/apache/impala/catalog/ScalarFunction.java
M fe/src/test/java/org/apache/impala/analysis/ToSqlUtilsTest.java
M testdata/workloads/functional-query/queries/QueryTest/functions-ddl.test
M testdata/workloads/functional-query/queries/QueryTest/grant_revoke.test
M tests/common/test_result_verifier.py
M tests/metadata/test_ddl.py
9 files changed, 224 insertions(+), 41 deletions(-)

Approvals:
  Impala Public Jenkins: Looks good to me, approved; Verified

--
To view, visit http://gerrit.cloudera.org:8080/12014
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings

Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: merged
Gerrit-Change-Id: Id34d6df97760a11c299092dff8edbdb7033bce1c
Gerrit-Change-Number: 12014
Gerrit-PatchSet: 7
Gerrit-Owner: Paul Rogers <[email protected]>
Gerrit-Reviewer: Impala Public Jenkins <[email protected]>
Gerrit-Reviewer: Paul Rogers <[email protected]>
Gerrit-Reviewer: Tim Armstrong <[email protected]>

Reply via email to