Flinksql关于日期截取字段报错SQL parse failed. Encountered “, DAY“

最新推荐文章于 2024-04-02 08:43:20 发布

思凡04

最新推荐文章于 2024-04-02 08:43:20 发布

阅读量2k

点赞数

分类专栏：大数据总结文章标签： sql java flink 大数据

本文链接：https://blog.csdn.net/qq_44042428/article/details/125890314

版权

大数据总结专栏收录该内容

1 篇文章 0 订阅

订阅专栏

"这篇博客记录了一个在使用Flink时遇到的SQL解析异常，错误信息为`SQLparsefailed.Encountered",DAY"atline18,column23.`。问题在于使用了不被解析器接受的`DAY`关键字。解决方法是改用`dayofmonth`函数来获取日期的天数。该文章详细描述了异常的堆栈跟踪，并提供了具体的解决步骤。"

摘要由CSDN通过智能技术生成

org.apache.flink.table.api.SqlParserException: SQL parse failed. Encountered ", DAY" at line 18, column 23.
Was expecting one of:
	at org.apache.flink.table.planner.parse.CalciteParser.parse(CalciteParser.java:56)
	at org.apache.flink.table.planner.delegation.ParserImpl.parse(ParserImpl.java:96)
	at org.apache.flink.table.api.internal.TableEnvironmentImpl.explainSql(TableEnvironmentImpl.java:670)
	at com.dlink.executor.Executor.explainSql(Executor.java:230)
	at com.dlink.explainer.Explainer.explainSql(Explainer.java:215)
	at com.dlink.job.JobManager.explainSql(JobManager.java:464)
	at com.dlink.service.impl.StudioServiceImpl.explainFlinkSql(StudioServiceImpl.java:167)
	at com.dlink.service.impl.StudioServiceImpl.explainSql(StudioServiceImpl.java:154)
	at com.dlink.controller.StudioController.explainSql(StudioController.java:51)
	at sun.reflect.GeneratedMethodAccessor520.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)