[
https://issues.apache.org/jira/browse/IMPALA-12126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yx91490 updated IMPALA-12126:
-----------------------------
Description:
There is a keywords and builtin function names conflict introduced by
IMPALA-3916
, I can reproduce it by:
{code:java}
create view v1 as select 1 as `ilike`;
show create view v1; {code}
it will report error: "Failed to parse view-definition statement of view:
default.v1".
the exception stacktrace in impalad is :
{code:java}
I0509 17:03:43.819247 91698 jni-util.cc:286] 134f64cbdaecfa83:58b80d1700000000]
org.apache.impala.common.AnalysisException:
org.apache.impala.catalog.TableLoadingException: Failed to parse
view-definition statement of view: default.v1
at org.apache.impala.analysis.Analyzer.getTable(Analyzer.java:3452)
at
org.apache.impala.analysis.ShowCreateTableStmt.analyze(ShowCreateTableStmt.java:63)
at
org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:545)
at
org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:465)
at
org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:2035)
at
org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:2001)
at
org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1971)
at
org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:237)
Caused by: org.apache.impala.catalog.TableLoadingException: Failed to parse
view-definition statement of view: default.v1
at
org.apache.impala.catalog.IncompleteTable.loadFromThrift(IncompleteTable.java:123)
at org.apache.impala.catalog.Table.fromThrift(Table.java:485)
at
org.apache.impala.catalog.ImpaladCatalog.addTable(ImpaladCatalog.java:471)
at
org.apache.impala.catalog.ImpaladCatalog.addCatalogObject(ImpaladCatalog.java:326)
at
org.apache.impala.catalog.ImpaladCatalog.updateCatalog(ImpaladCatalog.java:255)
at
org.apache.impala.service.FeCatalogManager$CatalogdImpl.updateCatalogCache(FeCatalogManager.java:114)
at
org.apache.impala.service.Frontend.updateCatalogCache(Frontend.java:560)
at
org.apache.impala.service.JniFrontend.updateCatalogCache(JniFrontend.java:258)
at ========.<Remote stack trace on catalogd>:
org.apache.impala.catalog.TableLoadingException: Failed to parse
view-definition statement of view: default.v1
at org.apache.impala.catalog.View.parseViewDef(View.java:146)
at org.apache.impala.catalog.View.load(View.java:102)
at org.apache.impala.catalog.TableLoader.load(TableLoader.java:86)
at
org.apache.impala.catalog.TableLoadingMgr$2.call(TableLoadingMgr.java:244)
at
org.apache.impala.catalog.TableLoadingMgr$2.call(TableLoadingMgr.java:241)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750){code}
in this case, 'ilike' is both a function name and a keyword,
was:
There is a keywords and builtin function names conflict introduced by
IMPALA-3916
, I can reproduce it by:
{code:java}
create view v1 as select 1 as `ilike`;
show create view v1; {code}
will report error: "Failed to parse view-definition statement of view:
default.v1".
the exception stacktrace in impalad is :
{code:java}
I0509 17:03:43.819247 91698 jni-util.cc:286] 134f64cbdaecfa83:58b80d1700000000]
org.apache.impala.common.AnalysisException:
org.apache.impala.catalog.TableLoadingException: Failed to parse
view-definition statement of view: default.v1
at org.apache.impala.analysis.Analyzer.getTable(Analyzer.java:3452)
at
org.apache.impala.analysis.ShowCreateTableStmt.analyze(ShowCreateTableStmt.java:63)
at
org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:545)
at
org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:465)
at
org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:2035)
at
org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:2001)
at
org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1971)
at
org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:237)
Caused by: org.apache.impala.catalog.TableLoadingException: Failed to parse
view-definition statement of view: default.v1
at
org.apache.impala.catalog.IncompleteTable.loadFromThrift(IncompleteTable.java:123)
at org.apache.impala.catalog.Table.fromThrift(Table.java:485)
at
org.apache.impala.catalog.ImpaladCatalog.addTable(ImpaladCatalog.java:471)
at
org.apache.impala.catalog.ImpaladCatalog.addCatalogObject(ImpaladCatalog.java:326)
at
org.apache.impala.catalog.ImpaladCatalog.updateCatalog(ImpaladCatalog.java:255)
at
org.apache.impala.service.FeCatalogManager$CatalogdImpl.updateCatalogCache(FeCatalogManager.java:114)
at
org.apache.impala.service.Frontend.updateCatalogCache(Frontend.java:560)
at
org.apache.impala.service.JniFrontend.updateCatalogCache(JniFrontend.java:258)
at ========.<Remote stack trace on catalogd>:
org.apache.impala.catalog.TableLoadingException: Failed to parse
view-definition statement of view: default.v1
at org.apache.impala.catalog.View.parseViewDef(View.java:146)
at org.apache.impala.catalog.View.load(View.java:102)
at org.apache.impala.catalog.TableLoader.load(TableLoader.java:86)
at
org.apache.impala.catalog.TableLoadingMgr$2.call(TableLoadingMgr.java:244)
at
org.apache.impala.catalog.TableLoadingMgr$2.call(TableLoadingMgr.java:241)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750){code}
> Keywords and builtin function names conflict
> --------------------------------------------
>
> Key: IMPALA-12126
> URL: https://issues.apache.org/jira/browse/IMPALA-12126
> Project: IMPALA
> Issue Type: Bug
> Affects Versions: Impala 4.0.0
> Reporter: yx91490
> Assignee: yx91490
> Priority: Major
>
> There is a keywords and builtin function names conflict introduced by
> IMPALA-3916
> , I can reproduce it by:
> {code:java}
> create view v1 as select 1 as `ilike`;
> show create view v1; {code}
> it will report error: "Failed to parse view-definition statement of view:
> default.v1".
> the exception stacktrace in impalad is :
> {code:java}
> I0509 17:03:43.819247 91698 jni-util.cc:286]
> 134f64cbdaecfa83:58b80d1700000000]
> org.apache.impala.common.AnalysisException:
> org.apache.impala.catalog.TableLoadingException: Failed to parse
> view-definition statement of view: default.v1
> at org.apache.impala.analysis.Analyzer.getTable(Analyzer.java:3452)
> at
> org.apache.impala.analysis.ShowCreateTableStmt.analyze(ShowCreateTableStmt.java:63)
> at
> org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:545)
> at
> org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:465)
> at
> org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:2035)
> at
> org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:2001)
> at
> org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1971)
> at
> org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:237)
> Caused by: org.apache.impala.catalog.TableLoadingException: Failed to parse
> view-definition statement of view: default.v1
> at
> org.apache.impala.catalog.IncompleteTable.loadFromThrift(IncompleteTable.java:123)
> at org.apache.impala.catalog.Table.fromThrift(Table.java:485)
> at
> org.apache.impala.catalog.ImpaladCatalog.addTable(ImpaladCatalog.java:471)
> at
> org.apache.impala.catalog.ImpaladCatalog.addCatalogObject(ImpaladCatalog.java:326)
> at
> org.apache.impala.catalog.ImpaladCatalog.updateCatalog(ImpaladCatalog.java:255)
> at
> org.apache.impala.service.FeCatalogManager$CatalogdImpl.updateCatalogCache(FeCatalogManager.java:114)
> at
> org.apache.impala.service.Frontend.updateCatalogCache(Frontend.java:560)
> at
> org.apache.impala.service.JniFrontend.updateCatalogCache(JniFrontend.java:258)
> at ========.<Remote stack trace on catalogd>:
> org.apache.impala.catalog.TableLoadingException: Failed to parse
> view-definition statement of view: default.v1
> at org.apache.impala.catalog.View.parseViewDef(View.java:146)
> at org.apache.impala.catalog.View.load(View.java:102)
> at org.apache.impala.catalog.TableLoader.load(TableLoader.java:86)
> at
> org.apache.impala.catalog.TableLoadingMgr$2.call(TableLoadingMgr.java:244)
> at
> org.apache.impala.catalog.TableLoadingMgr$2.call(TableLoadingMgr.java:241)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:750){code}
> in this case, 'ilike' is both a function name and a keyword,
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
