[
https://issues.apache.org/jira/browse/IMPALA-8434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16821522#comment-16821522
]
Xiaomeng Zhang commented on IMPALA-8434:
----------------------------------------
More findings. It looks like after alter db, not only lose functions, tables
under that db also get lost.
{code:java}
[localhost:21000] xm> show tables;
Query: show tables
+------+
| name |
+------+
| xm |
| xms |
| xmt |
+------+
Fetched 3 row(s) in 0.01s
[localhost:21000] xm> alter database xm set owner user impala258;
Query: alter database xm set owner user impala258
+-------------------+
| summary |
+-------------------+
| Updated database. |
+-------------------+
Fetched 1 row(s) in 0.51s
[localhost:21000] xm> show tables;
Query: show tables
Fetched 0 row(s) in 0.01s
[localhost:21000] xm> invalidate metadata;
Query: invalidate metadata
Query submitted at: 2019-04-18 15:00:40 (Coordinator:
http://xiaomeng-OptiPlex-9020:25000)
Query progress can be monitored at:
http://xiaomeng-OptiPlex-9020:25000/query_plan?query_id=404c09dd94296d20:b994e9fa00000000
Fetched 0 row(s) in 3.71s
[localhost:21000] xm> show tables;
Query: show tables
+------+
| name |
+------+
| xm |
| xms |
| xmt |
+------+
Fetched 3 row(s) in 0.01s
{code}
> 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
> Priority: Critical
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
