[
https://issues.apache.org/jira/browse/IMPALA-9763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17366397#comment-17366397
]
liuyao edited comment on IMPALA-9763 at 7/5/21, 2:44 AM:
---------------------------------------------------------
create table join_aa(id int);
create table join_bb(id int);
create table join_cc(id int);
create view testfun2 as select coalesce(a.id,2) from join_aa a,join_bb,join_cc
limit 10;
create view testfun3 as select * from testfun2 limit 10;
My test script：
#/bin/bash
for((i=1;i<=10000000;i++));
do
for i in \{1..3}
do
{ impala-shell.sh -i localhost:21000 -d default -q "select * from
rawdata.testfun3;" }
&
done
{ impala-shell.sh -i localhost:21001 -d rawdata -q "invalidate metadata;" }
&
sleep 2
done
was (Author: liuyao):
create table join_aa(id int);
create table join_bb(id int);
create table join_cc(id int);
create view testfun2 as select coalesce(a.id,2) from join_aa a,join_bb,join_cc
limit 10;
create view testfun3 as select * from testfun2 limit 10;
My test script：
#/bin/bash
for((i=1;i<=10000000;i++));
do
for i in \{1..3}
do
{ impala-shell.sh -i localhost:21000 -d default -q "select * from
rawdata.testfun3;" }
&
done
{ impala-shell.sh -i localhost:21001 -d rawdata -q "invalidate metadata;" }
&
# done
sleep 2
done
> impala查询偶尔报错 -- Impala queries occasionally report errors
> ---------------------------------------------------------
>
> Key: IMPALA-9763
> URL: https://issues.apache.org/jira/browse/IMPALA-9763
> Project: IMPALA
> Issue Type: Bug
> Components: Catalog
> Affects Versions: Impala 3.2.0
> Reporter: liqinglong
> Assignee: liuyao
> Priority: Major
> Labels: bug
> Fix For: Impala 4.0
>
> Attachments: 1.png, 2.png, 3.png, long_text_2020-05-19-17-00-29.txt
>
>
> 用 superset 链接impala
> 视图查询，打开看板偶尔会报如图3的的错，都是在解析SQL时找不到内置函数的错，但是强制刷新看板重新查询又不再报错，连续多次查询都会报，但是过一会再强制刷新查询又会报错，前后查询SQL语句一致，见图1和图2，日志见附件文档，能不能帮忙提一下意见是哪方面bug
>
> Adding the Google-translated English version (laszlog):
> Use the superset to link the impala view query. When you open the kanban
> board, you will occasionally report the error as shown in Figure 3. It is the
> error that you cannot find the built-in function when parsing the SQL.
> However, after a while, you will be forced to refresh the query again and you
> will get an error. The query SQL statement is consistent before and after,
> see Figure 1 and Figure 2, the log is in the attached document, can you help
> to mention what is the bug?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
