You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Xiaomeng Zhang (JIRA)" <ji...@apache.org> on 2019/04/18 21:35:00 UTC
[jira] [Created] (IMPALA-8434) Alter Db leads to functions missing
unless run "refresh functions"
Xiaomeng Zhang created IMPALA-8434:
--------------------------------------
Summary: Alter Db leads to functions missing unless run "refresh functions"
Key: IMPALA-8434
URL: https://issues.apache.org/jira/browse/IMPALA-8434
Project: IMPALA
Issue Type: Bug
Reporter: Xiaomeng Zhang
Assignee: Xiaomeng Zhang
I was testing on master branch. In a database with java and native functions. Run queries below, all functions are missing after alter db until run "refresh functions" in db.
{code:java}
[localhost:21000] xm> show functions;
Query: show functions
+-------------+------------------------+-------------+---------------+
| return type | signature | binary type | is persistent |
+-------------+------------------------+-------------+---------------+
| STRING | add10impala(STRING) | JAVA | true |
| STRING | add10udf(STRING) | JAVA | true |
| INT | add2(INT, INT) | NATIVE | true |
| INT | add2xm(INT, INT) | NATIVE | true |
| INT | addtwomaster(INT, INT) | NATIVE | true |
+-------------+------------------------+-------------+---------------+
Fetched 5 row(s) in 0.01s
[localhost:21000] xm> alter database xm set owner user impala218;
Query: alter database xm set owner user impala218
+-------------------+
| summary |
+-------------------+
| Updated database. |
+-------------------+
Fetched 1 row(s) in 0.59s
[localhost:21000] xm> show functions;
Query: show functions
Fetched 0 row(s) in 0.01s
[localhost:21000] xm> refresh functions xm;
Query: refresh functions xm
Query submitted at: 2019-04-18 14:19:00 (Coordinator: http://xiaomeng-OptiPlex-9020:25000)
Query progress can be monitored at: http://xiaomeng-OptiPlex-9020:25000/query_plan?query_id=fa40cdffde223550:df2a6cc000000000
Fetched 0 row(s) in 0.08s
[localhost:21000] xm> show functions;
Query: show functions
+-------------+------------------------+-------------+---------------+
| return type | signature | binary type | is persistent |
+-------------+------------------------+-------------+---------------+
| STRING | add10impala(STRING) | JAVA | true |
| STRING | add10udf(STRING) | JAVA | true |
| INT | add2(INT, INT) | NATIVE | true |
| INT | add2xm(INT, INT) | NATIVE | true |
| INT | addtwomaster(INT, INT) | NATIVE | true |
+-------------+------------------------+-------------+---------------+
Fetched 5 row(s) in 0.00s
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)