[ https://issues.apache.org/jira/browse/IMPALA-8434?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Quanlong Huang updated IMPALA-8434: ----------------------------------- Affects Version/s: Impala 3.1.0 Impala 3.2.0 > 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 > Affects Versions: Impala 3.1.0, Impala 3.2.0 > Reporter: Xiaomeng Zhang > Assignee: Quanlong Huang > 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.14#76016) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org