Hello Quanlong Huang, lipeng...@sensorsdata.cn, Csaba Ringhofer, Impala Public
Jenkins,
I'd like you to reexamine a change. Please visit
http://gerrit.cloudera.org:8080/19252
to look at the new patch set (#12).
Change subject: IMPALA-11728: Set fallback database for functions
......................................................................
IMPALA-11728: Set fallback database for functions
Currently the create function statement only works on specified
database. When using the function in another database, it will throw an
AnalysisException because the function is unknown in the current
database.
Add query option FALLBACK_DB_FOR_FUNCTIONS. When setting fallback
database query option, function names do not need to be fully
qualified.
The exact precedence of the functions:
1. _impala_builtins
2. fallback db specified in query option FALLBACK_DB_FOR_FUNCTIONS
3. function in current db
An example of how to use this feature is listed below. Assuming we
connected to the default database and then execute the statements. The
query executed successfully after setting FALLBACK_DB_FOR_FUNCTIONS.
CREATE FUNCTION util_db.fn() returns int LOCATION '/libTestUdfs.so'
symbol='NoArgs';
set FALLBACK_DB_FOR_FUNCTIONS=util_db;
SELECT fn() from functional.alltypes limit 1;
Testing:
- Add test_set_fallback_db_for_functions in test_udfs.py.
Change-Id: I37b7e126718fea1c50723cacbaed898b20bb55e5
---
M be/src/service/query-options.cc
M be/src/service/query-options.h
M common/thrift/ImpalaService.thrift
M common/thrift/Query.thrift
M fe/src/main/java/org/apache/impala/analysis/Analyzer.java
M fe/src/main/java/org/apache/impala/analysis/FunctionName.java
M tests/query_test/test_udfs.py
7 files changed, 65 insertions(+), 3 deletions(-)
git pull ssh://gerrit.cloudera.org:29418/Impala-ASF refs/changes/52/19252/12
--
To view, visit http://gerrit.cloudera.org:8080/19252
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings
Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: newpatchset
Gerrit-Change-Id: I37b7e126718fea1c50723cacbaed898b20bb55e5
Gerrit-Change-Number: 19252
Gerrit-PatchSet: 12
Gerrit-Owner: Xiaoqing Gao <gaoxq...@gmail.com>
Gerrit-Reviewer: Anonymous Coward <lipeng...@sensorsdata.cn>
Gerrit-Reviewer: Csaba Ringhofer <csringho...@cloudera.com>
Gerrit-Reviewer: Impala Public Jenkins <impala-public-jenk...@cloudera.com>
Gerrit-Reviewer: Quanlong Huang <huangquanl...@gmail.com>
Gerrit-Reviewer: Xiaoqing Gao <gaoxq...@gmail.com>
