2022-09-13 19:24:42,043 INFO [Query f242e7c8-a439-09dd-e359-bfcde0cc8721-31568] service.QueryService:454 : Using project: KPY_RANGER 2022-09-13 19:24:42,043 INFO [Query f242e7c8-a439-09dd-e359-bfcde0cc8721-31568] service.QueryService:455 : The original query: SELECT "自訂 SQL 查詢"."FAIL" AS "FAIL" FROM ( SELECT DT TEST_DATE,CATEGORY_KEY,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6) TEST_FLOOR,TEST_LINE,SYMPTOM_CODE,COLOR,CONFIG,REGION,LOCALLIZATION,FACTORY, SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 ) VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3) WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4) DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL , SUBSTRING(BANF FROM 1 for POSITION('*-' IN BANF from 1)-1 ) VENDERBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 5)+1 FOR 3) WEEKBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 6)+1 FOR 4) DATEBANF,SUBSTRING(BANF FROM POSITION('*-' IN BANF FROM 1)+7 FOR 4) EEEEBANF ,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 14)+1 FOR 1) CONFIGBANF, SUBSTRING(BCAM FROM 1 for POSITION('*-' IN BCAM from 1)-1 ) VENDERBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 5)+1 FOR 3) WEEKBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 6)+1 FOR 4) DATEBCAM,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 1)+7 FOR 4) EEEEBCAM ,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 2)+12 FOR 1) CONFIGBCAM, SUBSTRING(BGB FROM 1 for POSITION('*-' IN BGB from 1)-1 ) VENDERBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 5)+1 FOR 3) WEEKBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 6)+1 FOR 4) DATEBGB,SUBSTRING(BGB FROM POSITION('*-' IN BGB FROM 1)+7 FOR 4) EEEEBGB , SUBSTRING(BTY FROM 1 for POSITION('*-' IN BTY from 1)-1 ) VENDERBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 5)+1 FOR 3) WEEKBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 6)+1 FOR 4) DATEBTY,SUBSTRING(BTY FROM POSITION('*-' IN BTY FROM 1)+7 FOR 4) EEEEBTY , SUBSTRING(CAM FROM 1 for POSITION('*-' IN CAM from 1)-1 ) VENDERCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 5)+1 FOR 3) WEEKCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 6)+1 FOR 4) DATECAM,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 1)+7 FOR 4) EEEECAM ,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 2)+12 FOR 1) CONFIGCAM, SUBSTRING(CYF FROM 1 for POSITION('*-' IN CYF from 1)-1 ) VENDERCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 5)+1 FOR 3) WEEKCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 6)+1 FOR 4) DATECYF,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 1)+7 FOR 4) EEEECYF ,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 2)+12 FOR 2) CONFIGCYF, SUBSTRING(DKF FROM 1 for POSITION('*-' IN DKF from 1)-1 ) VENDERDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 5)+1 FOR 3) WEEKDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 6)+1 FOR 4) DATEDKF,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 1)+7 FOR 4) EEEEDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 2)+12 FOR 1) CONFIGDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 3)+14 FOR 1) CONFIG2DKF , SUBSTRING(FTH FROM 1 for POSITION('*-' IN FTH from 1)-1 ) VENDERFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 5)+1 FOR 3) WEEKFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 6)+1 FOR 4) DATEFTH,SUBSTRING(FTH FROM POSITION('*-' IN FTH FROM 1)+7 FOR 4) EEEEFTH , SUBSTRING(HSG FROM 1 for POSITION('*-' IN HSG from 1)-1 ) VENDERHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 5)+1 FOR 3) WEEKHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 6)+1 FOR 4) DATEHSG,SUBSTRING(HSG FROM POSITION('*-' IN HSG FROM 1)+7 FOR 4) EEEEHSG , SUBSTRING(JAF FROM 1 for POSITION('*-' IN JAF from 1)-1 ) VENDERJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 5)+1 FOR 3) WEEKJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 6)+1 FOR 4) DATEJAF,SUBSTRING(JAF FROM POSITION('*-' IN JAF FROM 1)+7 FOR 4) EEEEJAF , SUBSTRING(LCFM FROM 1 for POSITION('*-' IN LCFM from 1)-1 ) VENDERLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 5)+1 FOR 3) WEEKLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 6)+1 FOR 4) DATELCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 10)+1 FOR 4) EEEELCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 1)+12 FOR 3) CONFIGLCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 2)+16 FOR 3) CONFIGLCFM2 ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 3)+20 FOR 3) CONFIGLCFM3, SUBSTRING(LCG FROM 1 for POSITION('*-' IN LCG from 1)-1 ) VENDERLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 5)+1 FOR 3) WEEKLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 6)+1 FOR 4) DATELCG,SUBSTRING(LCG FROM POSITION('*-' IN LCG FROM 1)+7 FOR 4) EEEELCG , SUBSTRING(NAP FROM 1 for POSITION('*-' IN NAP from 1)-1 ) VENDERNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 5)+1 FOR 3) WEEKNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 6)+1 FOR 4) DATENAP,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 1)+7 FOR 4) EEEENAP ,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 2)+12 FOR 2) CONFIGNAP, SUBSTRING(RCAM FROM 1 for POSITION('*-' IN RCAM from 1)-1 ) VENDERRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 5)+1 FOR 3) WEEKRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 6)+1 FOR 4) DATERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 1)+7 FOR 4) EEEERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 2)+12 FOR 1) CONFIGRCAM , SUBSTRING(RCV FROM 1 for POSITION('*-' IN RCV from 1)-1 ) VENDERRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 5)+1 FOR 3) WEEKRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 6)+1 FOR 4) DATERCV,SUBSTRING(RCV FROM POSITION('*-' IN RCV FROM 1)+7 FOR 4) EEEERCV , SUBSTRING(SEK FROM 1 for POSITION('*-' IN SEK from 1)-1 ) VENDERSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 5)+1 FOR 3) WEEKSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 6)+1 FOR 4) DATESEK,SUBSTRING(SEK FROM POSITION('*-' IN SEK FROM 1)+7 FOR 4) EEEESEK , SUBSTRING(SEN FROM 1 for POSITION('*-' IN SEN from 1)-1 ) VENDERSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 5)+1 FOR 3) WEEKSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 6)+1 FOR 4) DATESEN,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 1)+7 FOR 4) EEEESEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 2)+12 FOR 1) CONFIGSEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 3)+14 FOR 1) CONFIG2SEN , SUBSTRING(SPR FROM 1 for POSITION('*-' IN SPR from 1)-1 ) VENDERSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 5)+1 FOR 3) WEEKSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 6)+1 FOR 4) DATESPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 10)+1 FOR 4) EEEESPR , SUBSTRING(STF FROM 1 for POSITION('*-' IN STF from 1)-1 ) VENDERSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 5)+1 FOR 3) WEEKSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 6)+1 FOR 4) DATESTF,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 1)+7 FOR 4) EEEESTF ,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 2)+12 FOR 2) CONFIGSTF, SUBSTRING(UAT FROM 1 for POSITION('*-' IN UAT from 1)-1 ) VENDERUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 5)+1 FOR 3) WEEKUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 6)+1 FOR 4) DATEUAT,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 1)+7 FOR 4) EEEEUAT ,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 2)+12 FOR 2) CONFIGUAT, SUBSTRING(UAT2 FROM 1 for POSITION('*-' IN UAT2 from 1)-1 ) VENDERUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 5)+1 FOR 3) WEEKUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 6)+1 FOR 4) DATEUAT2,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 1)+7 FOR 4) EEEEUAT2 ,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 2)+12 FOR 2) CONFIGUAT2, SUBSTRING(VGA FROM 1 for POSITION('*-' IN VGA from 1)-1 ) VENDERVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 5)+1 FOR 3) WEEKVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 6)+1 FOR 4) DATEVGA,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 1)+7 FOR 4) EEEEVGA ,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 2)+12 FOR 1) CONFIGVGA, INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA_D73 ) "自訂 SQL 查詢" 2022-09-13 19:24:42,043 ERROR [Query 33f416bb-c921-3afe-71fc-fb11cd0f1987-55] util.QueryUtil:227 : Failed to parse sql: SELECT COUNT("自訂 SQL 查詢"."VENDERLCG") AS "q__nlp_VENDERLCG_cnt", COUNT(DISTINCT "自訂 SQL 查詢"."VENDERLCG") AS "q__nlp_VENDERLCG_ctd" FROM ( SELECT DT TEST_DATE,CATEGORY_KEY,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6) TEST_FLOOR,TEST_LINE,SYMPTOM_CODE,COLOR,CONFIG,REGION,LOCALLIZATION,FACTORY, SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 ) VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3) WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4) DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL , SUBSTRING(BANF FROM 1 for POSITION('*-' IN BANF from 1)-1 ) VENDERBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 5)+1 FOR 3) WEEKBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 6)+1 FOR 4) DATEBANF,SUBSTRING(BANF FROM POSITION('*-' IN BANF FROM 1)+7 FOR 4) EEEEBANF ,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 14)+1 FOR 1) CONFIGBANF, SUBSTRING(BCAM FROM 1 for POSITION('*-' IN BCAM from 1)-1 ) VENDERBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 5)+1 FOR 3) WEEKBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 6)+1 FOR 4) DATEBCAM,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 1)+7 FOR 4) EEEEBCAM ,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 2)+12 FOR 1) CONFIGBCAM, SUBSTRING(BGB FROM 1 for POSITION('*-' IN BGB from 1)-1 ) VENDERBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 5)+1 FOR 3) WEEKBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 6)+1 FOR 4) DATEBGB,SUBSTRING(BGB FROM POSITION('*-' IN BGB FROM 1)+7 FOR 4) EEEEBGB , SUBSTRING(BTY FROM 1 for POSITION('*-' IN BTY from 1)-1 ) VENDERBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 5)+1 FOR 3) WEEKBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 6)+1 FOR 4) DATEBTY,SUBSTRING(BTY FROM POSITION('*-' IN BTY FROM 1)+7 FOR 4) EEEEBTY , SUBSTRING(CAM FROM 1 for POSITION('*-' IN CAM from 1)-1 ) VENDERCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 5)+1 FOR 3) WEEKCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 6)+1 FOR 4) DATECAM,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 1)+7 FOR 4) EEEECAM ,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 2)+12 FOR 1) CONFIGCAM, SUBSTRING(CYF FROM 1 for POSITION('*-' IN CYF from 1)-1 ) VENDERCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 5)+1 FOR 3) WEEKCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 6)+1 FOR 4) DATECYF,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 1)+7 FOR 4) EEEECYF ,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 2)+12 FOR 2) CONFIGCYF, SUBSTRING(DKF FROM 1 for POSITION('*-' IN DKF from 1)-1 ) VENDERDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 5)+1 FOR 3) WEEKDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 6)+1 FOR 4) DATEDKF,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 1)+7 FOR 4) EEEEDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 2)+12 FOR 1) CONFIGDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 3)+14 FOR 1) CONFIG2DKF , SUBSTRING(FTH FROM 1 for POSITION('*-' IN FTH from 1)-1 ) VENDERFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 5)+1 FOR 3) WEEKFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 6)+1 FOR 4) DATEFTH,SUBSTRING(FTH FROM POSITION('*-' IN FTH FROM 1)+7 FOR 4) EEEEFTH , SUBSTRING(HSG FROM 1 for POSITION('*-' IN HSG from 1)-1 ) VENDERHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 5)+1 FOR 3) WEEKHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 6)+1 FOR 4) DATEHSG,SUBSTRING(HSG FROM POSITION('*-' IN HSG FROM 1)+7 FOR 4) EEEEHSG , SUBSTRING(JAF FROM 1 for POSITION('*-' IN JAF from 1)-1 ) VENDERJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 5)+1 FOR 3) WEEKJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 6)+1 FOR 4) DATEJAF,SUBSTRING(JAF FROM POSITION('*-' IN JAF FROM 1)+7 FOR 4) EEEEJAF , SUBSTRING(LCFM FROM 1 for POSITION('*-' IN LCFM from 1)-1 ) VENDERLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 5)+1 FOR 3) WEEKLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 6)+1 FOR 4) DATELCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 10)+1 FOR 4) EEEELCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 1)+12 FOR 3) CONFIGLCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 2)+16 FOR 3) CONFIGLCFM2 ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 3)+20 FOR 3) CONFIGLCFM3, SUBSTRING(LCG FROM 1 for POSITION('*-' IN LCG from 1)-1 ) VENDERLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 5)+1 FOR 3) WEEKLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 6)+1 FOR 4) DATELCG,SUBSTRING(LCG FROM POSITION('*-' IN LCG FROM 1)+7 FOR 4) EEEELCG , SUBSTRING(NAP FROM 1 for POSITION('*-' IN NAP from 1)-1 ) VENDERNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 5)+1 FOR 3) WEEKNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 6)+1 FOR 4) DATENAP,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 1)+7 FOR 4) EEEENAP ,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 2)+12 FOR 2) CONFIGNAP, SUBSTRING(RCAM FROM 1 for POSITION('*-' IN RCAM from 1)-1 ) VENDERRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 5)+1 FOR 3) WEEKRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 6)+1 FOR 4) DATERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 1)+7 FOR 4) EEEERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 2)+12 FOR 1) CONFIGRCAM , SUBSTRING(RCV FROM 1 for POSITION('*-' IN RCV from 1)-1 ) VENDERRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 5)+1 FOR 3) WEEKRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 6)+1 FOR 4) DATERCV,SUBSTRING(RCV FROM POSITION('*-' IN RCV FROM 1)+7 FOR 4) EEEERCV , SUBSTRING(SEK FROM 1 for POSITION('*-' IN SEK from 1)-1 ) VENDERSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 5)+1 FOR 3) WEEKSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 6)+1 FOR 4) DATESEK,SUBSTRING(SEK FROM POSITION('*-' IN SEK FROM 1)+7 FOR 4) EEEESEK , SUBSTRING(SEN FROM 1 for POSITION('*-' IN SEN from 1)-1 ) VENDERSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 5)+1 FOR 3) WEEKSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 6)+1 FOR 4) DATESEN,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 1)+7 FOR 4) EEEESEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 2)+12 FOR 1) CONFIGSEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 3)+14 FOR 1) CONFIG2SEN , SUBSTRING(SPR FROM 1 for POSITION('*-' IN SPR from 1)-1 ) VENDERSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 5)+1 FOR 3) WEEKSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 6)+1 FOR 4) DATESPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 10)+1 FOR 4) EEEESPR , SUBSTRING(STF FROM 1 for POSITION('*-' IN STF from 1)-1 ) VENDERSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 5)+1 FOR 3) WEEKSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 6)+1 FOR 4) DATESTF,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 1)+7 FOR 4) EEEESTF ,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 2)+12 FOR 2) CONFIGSTF, SUBSTRING(UAT FROM 1 for POSITION('*-' IN UAT from 1)-1 ) VENDERUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 5)+1 FOR 3) WEEKUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 6)+1 FOR 4) DATEUAT,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 1)+7 FOR 4) EEEEUAT ,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 2)+12 FOR 2) CONFIGUAT, SUBSTRING(UAT2 FROM 1 for POSITION('*-' IN UAT2 from 1)-1 ) VENDERUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 5)+1 FOR 3) WEEKUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 6)+1 FOR 4) DATEUAT2,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 1)+7 FOR 4) EEEEUAT2 ,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 2)+12 FOR 2) CONFIGUAT2, SUBSTRING(VGA FROM 1 for POSITION('*-' IN VGA from 1)-1 ) VENDERVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 5)+1 FOR 3) WEEKVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 6)+1 FOR 4) DATEVGA,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 1)+7 FOR 4) EEEEVGA ,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 2)+12 FOR 1) CONFIGVGA, INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA_D73 ) "自訂 SQL 查詢" HAVING (COUNT(1) > 0) org.apache.kylin.query.util.ParseException: Encountered " "\'" "\' "" at line 1, column 7646. Was expecting: at org.apache.kylin.query.util.CommentParser.generateParseException(CommentParser.java:407) at org.apache.kylin.query.util.CommentParser.jj_consume_token(CommentParser.java:292) at org.apache.kylin.query.util.CommentParser.Input(CommentParser.java:44) at org.apache.kylin.query.util.QueryUtil.removeCommentInSql(QueryUtil.java:225) at org.apache.kylin.query.util.QueryUtil.massageSql(QueryUtil.java:81) at org.apache.kylin.query.util.QueryUtil.massageSql(QueryUtil.java:125) at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:698) at org.apache.kylin.rest.service.QueryService.query(QueryService.java:224) at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:525) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:480) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:416) at org.apache.kylin.rest.controller.QueryController.prepareQuery(QueryController.java:106) at sun.reflect.GeneratedMethodAccessor202.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:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1195) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:317) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) 2022-09-13 19:24:42,043 ERROR [Query f242e7c8-a439-09dd-e359-bfcde0cc8721-31568] util.QueryUtil:227 : Failed to parse sql: SELECT "自訂 SQL 查詢"."FAIL" AS "FAIL" FROM ( SELECT DT TEST_DATE,CATEGORY_KEY,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6) TEST_FLOOR,TEST_LINE,SYMPTOM_CODE,COLOR,CONFIG,REGION,LOCALLIZATION,FACTORY, SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 ) VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3) WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4) DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL , SUBSTRING(BANF FROM 1 for POSITION('*-' IN BANF from 1)-1 ) VENDERBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 5)+1 FOR 3) WEEKBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 6)+1 FOR 4) DATEBANF,SUBSTRING(BANF FROM POSITION('*-' IN BANF FROM 1)+7 FOR 4) EEEEBANF ,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 14)+1 FOR 1) CONFIGBANF, SUBSTRING(BCAM FROM 1 for POSITION('*-' IN BCAM from 1)-1 ) VENDERBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 5)+1 FOR 3) WEEKBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 6)+1 FOR 4) DATEBCAM,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 1)+7 FOR 4) EEEEBCAM ,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 2)+12 FOR 1) CONFIGBCAM, SUBSTRING(BGB FROM 1 for POSITION('*-' IN BGB from 1)-1 ) VENDERBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 5)+1 FOR 3) WEEKBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 6)+1 FOR 4) DATEBGB,SUBSTRING(BGB FROM POSITION('*-' IN BGB FROM 1)+7 FOR 4) EEEEBGB , SUBSTRING(BTY FROM 1 for POSITION('*-' IN BTY from 1)-1 ) VENDERBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 5)+1 FOR 3) WEEKBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 6)+1 FOR 4) DATEBTY,SUBSTRING(BTY FROM POSITION('*-' IN BTY FROM 1)+7 FOR 4) EEEEBTY , SUBSTRING(CAM FROM 1 for POSITION('*-' IN CAM from 1)-1 ) VENDERCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 5)+1 FOR 3) WEEKCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 6)+1 FOR 4) DATECAM,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 1)+7 FOR 4) EEEECAM ,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 2)+12 FOR 1) CONFIGCAM, SUBSTRING(CYF FROM 1 for POSITION('*-' IN CYF from 1)-1 ) VENDERCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 5)+1 FOR 3) WEEKCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 6)+1 FOR 4) DATECYF,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 1)+7 FOR 4) EEEECYF ,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 2)+12 FOR 2) CONFIGCYF, SUBSTRING(DKF FROM 1 for POSITION('*-' IN DKF from 1)-1 ) VENDERDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 5)+1 FOR 3) WEEKDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 6)+1 FOR 4) DATEDKF,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 1)+7 FOR 4) EEEEDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 2)+12 FOR 1) CONFIGDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 3)+14 FOR 1) CONFIG2DKF , SUBSTRING(FTH FROM 1 for POSITION('*-' IN FTH from 1)-1 ) VENDERFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 5)+1 FOR 3) WEEKFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 6)+1 FOR 4) DATEFTH,SUBSTRING(FTH FROM POSITION('*-' IN FTH FROM 1)+7 FOR 4) EEEEFTH , SUBSTRING(HSG FROM 1 for POSITION('*-' IN HSG from 1)-1 ) VENDERHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 5)+1 FOR 3) WEEKHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 6)+1 FOR 4) DATEHSG,SUBSTRING(HSG FROM POSITION('*-' IN HSG FROM 1)+7 FOR 4) EEEEHSG , SUBSTRING(JAF FROM 1 for POSITION('*-' IN JAF from 1)-1 ) VENDERJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 5)+1 FOR 3) WEEKJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 6)+1 FOR 4) DATEJAF,SUBSTRING(JAF FROM POSITION('*-' IN JAF FROM 1)+7 FOR 4) EEEEJAF , SUBSTRING(LCFM FROM 1 for POSITION('*-' IN LCFM from 1)-1 ) VENDERLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 5)+1 FOR 3) WEEKLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 6)+1 FOR 4) DATELCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 10)+1 FOR 4) EEEELCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 1)+12 FOR 3) CONFIGLCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 2)+16 FOR 3) CONFIGLCFM2 ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 3)+20 FOR 3) CONFIGLCFM3, SUBSTRING(LCG FROM 1 for POSITION('*-' IN LCG from 1)-1 ) VENDERLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 5)+1 FOR 3) WEEKLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 6)+1 FOR 4) DATELCG,SUBSTRING(LCG FROM POSITION('*-' IN LCG FROM 1)+7 FOR 4) EEEELCG , SUBSTRING(NAP FROM 1 for POSITION('*-' IN NAP from 1)-1 ) VENDERNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 5)+1 FOR 3) WEEKNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 6)+1 FOR 4) DATENAP,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 1)+7 FOR 4) EEEENAP ,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 2)+12 FOR 2) CONFIGNAP, SUBSTRING(RCAM FROM 1 for POSITION('*-' IN RCAM from 1)-1 ) VENDERRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 5)+1 FOR 3) WEEKRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 6)+1 FOR 4) DATERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 1)+7 FOR 4) EEEERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 2)+12 FOR 1) CONFIGRCAM , SUBSTRING(RCV FROM 1 for POSITION('*-' IN RCV from 1)-1 ) VENDERRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 5)+1 FOR 3) WEEKRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 6)+1 FOR 4) DATERCV,SUBSTRING(RCV FROM POSITION('*-' IN RCV FROM 1)+7 FOR 4) EEEERCV , SUBSTRING(SEK FROM 1 for POSITION('*-' IN SEK from 1)-1 ) VENDERSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 5)+1 FOR 3) WEEKSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 6)+1 FOR 4) DATESEK,SUBSTRING(SEK FROM POSITION('*-' IN SEK FROM 1)+7 FOR 4) EEEESEK , SUBSTRING(SEN FROM 1 for POSITION('*-' IN SEN from 1)-1 ) VENDERSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 5)+1 FOR 3) WEEKSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 6)+1 FOR 4) DATESEN,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 1)+7 FOR 4) EEEESEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 2)+12 FOR 1) CONFIGSEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 3)+14 FOR 1) CONFIG2SEN , SUBSTRING(SPR FROM 1 for POSITION('*-' IN SPR from 1)-1 ) VENDERSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 5)+1 FOR 3) WEEKSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 6)+1 FOR 4) DATESPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 10)+1 FOR 4) EEEESPR , SUBSTRING(STF FROM 1 for POSITION('*-' IN STF from 1)-1 ) VENDERSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 5)+1 FOR 3) WEEKSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 6)+1 FOR 4) DATESTF,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 1)+7 FOR 4) EEEESTF ,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 2)+12 FOR 2) CONFIGSTF, SUBSTRING(UAT FROM 1 for POSITION('*-' IN UAT from 1)-1 ) VENDERUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 5)+1 FOR 3) WEEKUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 6)+1 FOR 4) DATEUAT,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 1)+7 FOR 4) EEEEUAT ,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 2)+12 FOR 2) CONFIGUAT, SUBSTRING(UAT2 FROM 1 for POSITION('*-' IN UAT2 from 1)-1 ) VENDERUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 5)+1 FOR 3) WEEKUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 6)+1 FOR 4) DATEUAT2,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 1)+7 FOR 4) EEEEUAT2 ,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 2)+12 FOR 2) CONFIGUAT2, SUBSTRING(VGA FROM 1 for POSITION('*-' IN VGA from 1)-1 ) VENDERVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 5)+1 FOR 3) WEEKVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 6)+1 FOR 4) DATEVGA,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 1)+7 FOR 4) EEEEVGA ,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 2)+12 FOR 1) CONFIGVGA, INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA_D73 ) "自訂 SQL 查詢" org.apache.kylin.query.util.ParseException: Encountered " "\'" "\' "" at line 1, column 7549. Was expecting: at org.apache.kylin.query.util.CommentParser.generateParseException(CommentParser.java:407) at org.apache.kylin.query.util.CommentParser.jj_consume_token(CommentParser.java:292) at org.apache.kylin.query.util.CommentParser.Input(CommentParser.java:44) at org.apache.kylin.query.util.QueryUtil.removeCommentInSql(QueryUtil.java:225) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:457) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:416) at org.apache.kylin.rest.controller.QueryController.prepareQuery(QueryController.java:106) at sun.reflect.GeneratedMethodAccessor202.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:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1195) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:317) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) 2022-09-13 19:24:42,044 ERROR [Query f242e7c8-a439-09dd-e359-bfcde0cc8721-31568] util.QueryUtil:227 : Failed to parse sql: select "自訂 sql 查詢"."fail" as "fail" from ( select dt test_date,category_key,test_station_code,substring(test_line,1,6) test_floor,test_line,symptom_code,color,config,region,locallization,factory, substring(atl from 1 for position('*-' in atl from 1)-1 ) venderatl,substring(atl from position('-' in atl from 5)+1 for 3) weekatl,substring(atl from position('-' in atl from 6)+1 for 4) dateatl,substring(atl from position('*-' in atl from 1)+7 for 4) eeeeatl , substring(banf from 1 for position('*-' in banf from 1)-1 ) venderbanf,substring(banf from position('-' in banf from 5)+1 for 3) weekbanf,substring(banf from position('-' in banf from 6)+1 for 4) datebanf,substring(banf from position('*-' in banf from 1)+7 for 4) eeeebanf ,substring(banf from position('-' in banf from 14)+1 for 1) configbanf, substring(bcam from 1 for position('*-' in bcam from 1)-1 ) venderbcam,substring(bcam from position('-' in bcam from 5)+1 for 3) weekbcam,substring(bcam from position('-' in bcam from 6)+1 for 4) datebcam,substring(bcam from position('*-' in bcam from 1)+7 for 4) eeeebcam ,substring(bcam from position('*-' in bcam from 2)+12 for 1) configbcam, substring(bgb from 1 for position('*-' in bgb from 1)-1 ) venderbgb,substring(bgb from position('-' in bgb from 5)+1 for 3) weekbgb,substring(bgb from position('-' in bgb from 6)+1 for 4) datebgb,substring(bgb from position('*-' in bgb from 1)+7 for 4) eeeebgb , substring(bty from 1 for position('*-' in bty from 1)-1 ) venderbty,substring(bty from position('-' in bty from 5)+1 for 3) weekbty,substring(bty from position('-' in bty from 6)+1 for 4) datebty,substring(bty from position('*-' in bty from 1)+7 for 4) eeeebty , substring(cam from 1 for position('*-' in cam from 1)-1 ) vendercam,substring(cam from position('-' in cam from 5)+1 for 3) weekcam,substring(cam from position('-' in cam from 6)+1 for 4) datecam,substring(cam from position('*-' in cam from 1)+7 for 4) eeeecam ,substring(cam from position('*-' in cam from 2)+12 for 1) configcam, substring(cyf from 1 for position('*-' in cyf from 1)-1 ) vendercyf,substring(cyf from position('-' in cyf from 5)+1 for 3) weekcyf,substring(cyf from position('-' in cyf from 6)+1 for 4) datecyf,substring(cyf from position('*-' in cyf from 1)+7 for 4) eeeecyf ,substring(cyf from position('*-' in cyf from 2)+12 for 2) configcyf, substring(dkf from 1 for position('*-' in dkf from 1)-1 ) venderdkf,substring(dkf from position('-' in dkf from 5)+1 for 3) weekdkf,substring(dkf from position('-' in dkf from 6)+1 for 4) datedkf,substring(dkf from position('*-' in dkf from 1)+7 for 4) eeeedkf ,substring(dkf from position('*-' in dkf from 2)+12 for 1) configdkf ,substring(dkf from position('*-' in dkf from 3)+14 for 1) config2dkf , substring(fth from 1 for position('*-' in fth from 1)-1 ) venderfth,substring(fth from position('-' in fth from 5)+1 for 3) weekfth,substring(fth from position('-' in fth from 6)+1 for 4) datefth,substring(fth from position('*-' in fth from 1)+7 for 4) eeeefth , substring(hsg from 1 for position('*-' in hsg from 1)-1 ) venderhsg,substring(hsg from position('-' in hsg from 5)+1 for 3) weekhsg,substring(hsg from position('-' in hsg from 6)+1 for 4) datehsg,substring(hsg from position('*-' in hsg from 1)+7 for 4) eeeehsg , substring(jaf from 1 for position('*-' in jaf from 1)-1 ) venderjaf,substring(jaf from position('-' in jaf from 5)+1 for 3) weekjaf,substring(jaf from position('-' in jaf from 6)+1 for 4) datejaf,substring(jaf from position('*-' in jaf from 1)+7 for 4) eeeejaf , substring(lcfm from 1 for position('*-' in lcfm from 1)-1 ) venderlcfm,substring(lcfm from position('-' in lcfm from 5)+1 for 3) weeklcfm,substring(lcfm from position('-' in lcfm from 6)+1 for 4) datelcfm,substring(lcfm from position('-' in lcfm from 10)+1 for 4) eeeelcfm ,substring(lcfm from position('*-' in lcfm from 1)+12 for 3) configlcfm ,substring(lcfm from position('*-' in lcfm from 2)+16 for 3) configlcfm2 ,substring(lcfm from position('*-' in lcfm from 3)+20 for 3) configlcfm3, substring(lcg from 1 for position('*-' in lcg from 1)-1 ) venderlcg,substring(lcg from position('-' in lcg from 5)+1 for 3) weeklcg,substring(lcg from position('-' in lcg from 6)+1 for 4) datelcg,substring(lcg from position('*-' in lcg from 1)+7 for 4) eeeelcg , substring(nap from 1 for position('*-' in nap from 1)-1 ) vendernap,substring(nap from position('-' in nap from 5)+1 for 3) weeknap,substring(nap from position('-' in nap from 6)+1 for 4) datenap,substring(nap from position('*-' in nap from 1)+7 for 4) eeeenap ,substring(nap from position('*-' in nap from 2)+12 for 2) confignap, substring(rcam from 1 for position('*-' in rcam from 1)-1 ) venderrcam,substring(rcam from position('-' in rcam from 5)+1 for 3) weekrcam,substring(rcam from position('-' in rcam from 6)+1 for 4) datercam,substring(rcam from position('*-' in rcam from 1)+7 for 4) eeeercam,substring(rcam from position('*-' in rcam from 2)+12 for 1) configrcam , substring(rcv from 1 for position('*-' in rcv from 1)-1 ) venderrcv,substring(rcv from position('-' in rcv from 5)+1 for 3) weekrcv,substring(rcv from position('-' in rcv from 6)+1 for 4) datercv,substring(rcv from position('*-' in rcv from 1)+7 for 4) eeeercv , substring(sek from 1 for position('*-' in sek from 1)-1 ) vendersek,substring(sek from position('-' in sek from 5)+1 for 3) weeksek,substring(sek from position('-' in sek from 6)+1 for 4) datesek,substring(sek from position('*-' in sek from 1)+7 for 4) eeeesek , substring(sen from 1 for position('*-' in sen from 1)-1 ) vendersen,substring(sen from position('-' in sen from 5)+1 for 3) weeksen,substring(sen from position('-' in sen from 6)+1 for 4) datesen,substring(sen from position('*-' in sen from 1)+7 for 4) eeeesen ,substring(sen from position('*-' in sen from 2)+12 for 1) configsen ,substring(sen from position('*-' in sen from 3)+14 for 1) config2sen , substring(spr from 1 for position('*-' in spr from 1)-1 ) venderspr,substring(spr from position('-' in spr from 5)+1 for 3) weekspr,substring(spr from position('-' in spr from 6)+1 for 4) datespr,substring(spr from position('-' in spr from 10)+1 for 4) eeeespr , substring(stf from 1 for position('*-' in stf from 1)-1 ) venderstf,substring(stf from position('-' in stf from 5)+1 for 3) weekstf,substring(stf from position('-' in stf from 6)+1 for 4) datestf,substring(stf from position('*-' in stf from 1)+7 for 4) eeeestf ,substring(stf from position('*-' in stf from 2)+12 for 2) configstf, substring(uat from 1 for position('*-' in uat from 1)-1 ) venderuat,substring(uat from position('-' in uat from 5)+1 for 3) weekuat,substring(uat from position('-' in uat from 6)+1 for 4) dateuat,substring(uat from position('*-' in uat from 1)+7 for 4) eeeeuat ,substring(uat from position('*-' in uat from 2)+12 for 2) configuat, substring(uat2 from 1 for position('*-' in uat2 from 1)-1 ) venderuat2,substring(uat2 from position('-' in uat2 from 5)+1 for 3) weekuat2,substring(uat2 from position('-' in uat2 from 6)+1 for 4) dateuat2,substring(uat2 from position('*-' in uat2 from 1)+7 for 4) eeeeuat2 ,substring(uat2 from position('*-' in uat2 from 2)+12 for 2) configuat2, substring(vga from 1 for position('*-' in vga from 1)-1 ) vendervga,substring(vga from position('-' in vga from 5)+1 for 3) weekvga,substring(vga from position('-' in vga from 6)+1 for 4) datevga,substring(vga from position('*-' in vga from 1)+7 for 4) eeeevga ,substring(vga from position('*-' in vga from 2)+12 for 1) configvga, input,fail,retest from bi_dw.kpy_fact_sum_data_d73 ) "自訂 sql 查詢" org.apache.kylin.query.util.ParseException: Encountered " "\'" "\' "" at line 1, column 7549. Was expecting: at org.apache.kylin.query.util.CommentParser.generateParseException(CommentParser.java:407) at org.apache.kylin.query.util.CommentParser.jj_consume_token(CommentParser.java:292) at org.apache.kylin.query.util.CommentParser.Input(CommentParser.java:44) at org.apache.kylin.query.util.QueryUtil.removeCommentInSql(QueryUtil.java:225) at org.apache.kylin.query.util.QueryUtil.isSelectStatement(QueryUtil.java:214) at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:523) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:480) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:416) at org.apache.kylin.rest.controller.QueryController.prepareQuery(QueryController.java:106) at sun.reflect.GeneratedMethodAccessor202.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:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1195) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:317) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) 2022-09-13 19:24:42,045 INFO [Query eebcc80b-b430-9d92-5a4c-a7daa59bae51-59] service.QueryService:701 : The corrected query: SELECT COUNT("自訂 SQL 查詢"."VENDERLCFM") AS "q__nlp_VENDERLCFM_cnt", COUNT(DISTINCT "自訂 SQL 查詢"."VENDERLCFM") AS "q__nlp_VENDERLCFM_ctd" FROM ( SELECT DT TEST_DATE,CATEGORY_KEY,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6) TEST_FLOOR,TEST_LINE,SYMPTOM_CODE,COLOR,CONFIG,REGION,LOCALLIZATION,FACTORY, SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 ) VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3) WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4) DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL , SUBSTRING(BANF FROM 1 for POSITION('*-' IN BANF from 1)-1 ) VENDERBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 5)+1 FOR 3) WEEKBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 6)+1 FOR 4) DATEBANF,SUBSTRING(BANF FROM POSITION('*-' IN BANF FROM 1)+7 FOR 4) EEEEBANF ,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 14)+1 FOR 1) CONFIGBANF, SUBSTRING(BCAM FROM 1 for POSITION('*-' IN BCAM from 1)-1 ) VENDERBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 5)+1 FOR 3) WEEKBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 6)+1 FOR 4) DATEBCAM,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 1)+7 FOR 4) EEEEBCAM ,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 2)+12 FOR 1) CONFIGBCAM, SUBSTRING(BGB FROM 1 for POSITION('*-' IN BGB from 1)-1 ) VENDERBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 5)+1 FOR 3) WEEKBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 6)+1 FOR 4) DATEBGB,SUBSTRING(BGB FROM POSITION('*-' IN BGB FROM 1)+7 FOR 4) EEEEBGB , SUBSTRING(BTY FROM 1 for POSITION('*-' IN BTY from 1)-1 ) VENDERBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 5)+1 FOR 3) WEEKBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 6)+1 FOR 4) DATEBTY,SUBSTRING(BTY FROM POSITION('*-' IN BTY FROM 1)+7 FOR 4) EEEEBTY , SUBSTRING(CAM FROM 1 for POSITION('*-' IN CAM from 1)-1 ) VENDERCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 5)+1 FOR 3) WEEKCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 6)+1 FOR 4) DATECAM,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 1)+7 FOR 4) EEEECAM ,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 2)+12 FOR 1) CONFIGCAM, SUBSTRING(CYF FROM 1 for POSITION('*-' IN CYF from 1)-1 ) VENDERCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 5)+1 FOR 3) WEEKCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 6)+1 FOR 4) DATECYF,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 1)+7 FOR 4) EEEECYF ,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 2)+12 FOR 2) CONFIGCYF, SUBSTRING(DKF FROM 1 for POSITION('*-' IN DKF from 1)-1 ) VENDERDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 5)+1 FOR 3) WEEKDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 6)+1 FOR 4) DATEDKF,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 1)+7 FOR 4) EEEEDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 2)+12 FOR 1) CONFIGDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 3)+14 FOR 1) CONFIG2DKF , SUBSTRING(FTH FROM 1 for POSITION('*-' IN FTH from 1)-1 ) VENDERFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 5)+1 FOR 3) WEEKFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 6)+1 FOR 4) DATEFTH,SUBSTRING(FTH FROM POSITION('*-' IN FTH FROM 1)+7 FOR 4) EEEEFTH , SUBSTRING(HSG FROM 1 for POSITION('*-' IN HSG from 1)-1 ) VENDERHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 5)+1 FOR 3) WEEKHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 6)+1 FOR 4) DATEHSG,SUBSTRING(HSG FROM POSITION('*-' IN HSG FROM 1)+7 FOR 4) EEEEHSG , SUBSTRING(JAF FROM 1 for POSITION('*-' IN JAF from 1)-1 ) VENDERJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 5)+1 FOR 3) WEEKJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 6)+1 FOR 4) DATEJAF,SUBSTRING(JAF FROM POSITION('*-' IN JAF FROM 1)+7 FOR 4) EEEEJAF , SUBSTRING(LCFM FROM 1 for POSITION('*-' IN LCFM from 1)-1 ) VENDERLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 5)+1 FOR 3) WEEKLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 6)+1 FOR 4) DATELCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 10)+1 FOR 4) EEEELCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 1)+12 FOR 3) CONFIGLCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 2)+16 FOR 3) CONFIGLCFM2 ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 3)+20 FOR 3) CONFIGLCFM3, SUBSTRING(LCG FROM 1 for POSITION('*-' IN LCG from 1)-1 ) VENDERLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 5)+1 FOR 3) WEEKLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 6)+1 FOR 4) DATELCG,SUBSTRING(LCG FROM POSITION('*-' IN LCG FROM 1)+7 FOR 4) EEEELCG , SUBSTRING(NAP FROM 1 for POSITION('*-' IN NAP from 1)-1 ) VENDERNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 5)+1 FOR 3) WEEKNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 6)+1 FOR 4) DATENAP,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 1)+7 FOR 4) EEEENAP ,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 2)+12 FOR 2) CONFIGNAP, SUBSTRING(RCAM FROM 1 for POSITION('*-' IN RCAM from 1)-1 ) VENDERRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 5)+1 FOR 3) WEEKRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 6)+1 FOR 4) DATERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 1)+7 FOR 4) EEEERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 2)+12 FOR 1) CONFIGRCAM , SUBSTRING(RCV FROM 1 for POSITION('*-' IN RCV from 1)-1 ) VENDERRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 5)+1 FOR 3) WEEKRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 6)+1 FOR 4) DATERCV,SUBSTRING(RCV FROM POSITION('*-' IN RCV FROM 1)+7 FOR 4) EEEERCV , SUBSTRING(SEK FROM 1 for POSITION('*-' IN SEK from 1)-1 ) VENDERSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 5)+1 FOR 3) WEEKSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 6)+1 FOR 4) DATESEK,SUBSTRING(SEK FROM POSITION('*-' IN SEK FROM 1)+7 FOR 4) EEEESEK , SUBSTRING(SEN FROM 1 for POSITION('*-' IN SEN from 1)-1 ) VENDERSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 5)+1 FOR 3) WEEKSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 6)+1 FOR 4) DATESEN,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 1)+7 FOR 4) EEEESEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 2)+12 FOR 1) CONFIGSEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 3)+14 FOR 1) CONFIG2SEN , SUBSTRING(SPR FROM 1 for POSITION('*-' IN SPR from 1)-1 ) VENDERSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 5)+1 FOR 3) WEEKSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 6)+1 FOR 4) DATESPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 10)+1 FOR 4) EEEESPR , SUBSTRING(STF FROM 1 for POSITION('*-' IN STF from 1)-1 ) VENDERSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 5)+1 FOR 3) WEEKSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 6)+1 FOR 4) DATESTF,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 1)+7 FOR 4) EEEESTF ,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 2)+12 FOR 2) CONFIGSTF, SUBSTRING(UAT FROM 1 for POSITION('*-' IN UAT from 1)-1 ) VENDERUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 5)+1 FOR 3) WEEKUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 6)+1 FOR 4) DATEUAT,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 1)+7 FOR 4) EEEEUAT ,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 2)+12 FOR 2) CONFIGUAT, SUBSTRING(UAT2 FROM 1 for POSITION('*-' IN UAT2 from 1)-1 ) VENDERUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 5)+1 FOR 3) WEEKUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 6)+1 FOR 4) DATEUAT2,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 1)+7 FOR 4) EEEEUAT2 ,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 2)+12 FOR 2) CONFIGUAT2, SUBSTRING(VGA FROM 1 for POSITION('*-' IN VGA from 1)-1 ) VENDERVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 5)+1 FOR 3) WEEKVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 6)+1 FOR 4) DATEVGA,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 1)+7 FOR 4) EEEEVGA ,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 2)+12 FOR 1) CONFIGVGA, INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA_D73 ) "自訂 SQL 查詢" 2022-09-13 19:24:42,046 INFO [Query 33f416bb-c921-3afe-71fc-fb11cd0f1987-55] service.QueryService:701 : The corrected query: SELECT COUNT("自訂 SQL 查詢"."VENDERLCG") AS "q__nlp_VENDERLCG_cnt", COUNT(DISTINCT "自訂 SQL 查詢"."VENDERLCG") AS "q__nlp_VENDERLCG_ctd" FROM ( SELECT DT TEST_DATE,CATEGORY_KEY,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6) TEST_FLOOR,TEST_LINE,SYMPTOM_CODE,COLOR,CONFIG,REGION,LOCALLIZATION,FACTORY, SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 ) VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3) WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4) DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL , SUBSTRING(BANF FROM 1 for POSITION('*-' IN BANF from 1)-1 ) VENDERBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 5)+1 FOR 3) WEEKBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 6)+1 FOR 4) DATEBANF,SUBSTRING(BANF FROM POSITION('*-' IN BANF FROM 1)+7 FOR 4) EEEEBANF ,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 14)+1 FOR 1) CONFIGBANF, SUBSTRING(BCAM FROM 1 for POSITION('*-' IN BCAM from 1)-1 ) VENDERBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 5)+1 FOR 3) WEEKBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 6)+1 FOR 4) DATEBCAM,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 1)+7 FOR 4) EEEEBCAM ,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 2)+12 FOR 1) CONFIGBCAM, SUBSTRING(BGB FROM 1 for POSITION('*-' IN BGB from 1)-1 ) VENDERBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 5)+1 FOR 3) WEEKBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 6)+1 FOR 4) DATEBGB,SUBSTRING(BGB FROM POSITION('*-' IN BGB FROM 1)+7 FOR 4) EEEEBGB , SUBSTRING(BTY FROM 1 for POSITION('*-' IN BTY from 1)-1 ) VENDERBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 5)+1 FOR 3) WEEKBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 6)+1 FOR 4) DATEBTY,SUBSTRING(BTY FROM POSITION('*-' IN BTY FROM 1)+7 FOR 4) EEEEBTY , SUBSTRING(CAM FROM 1 for POSITION('*-' IN CAM from 1)-1 ) VENDERCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 5)+1 FOR 3) WEEKCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 6)+1 FOR 4) DATECAM,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 1)+7 FOR 4) EEEECAM ,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 2)+12 FOR 1) CONFIGCAM, SUBSTRING(CYF FROM 1 for POSITION('*-' IN CYF from 1)-1 ) VENDERCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 5)+1 FOR 3) WEEKCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 6)+1 FOR 4) DATECYF,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 1)+7 FOR 4) EEEECYF ,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 2)+12 FOR 2) CONFIGCYF, SUBSTRING(DKF FROM 1 for POSITION('*-' IN DKF from 1)-1 ) VENDERDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 5)+1 FOR 3) WEEKDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 6)+1 FOR 4) DATEDKF,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 1)+7 FOR 4) EEEEDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 2)+12 FOR 1) CONFIGDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 3)+14 FOR 1) CONFIG2DKF , SUBSTRING(FTH FROM 1 for POSITION('*-' IN FTH from 1)-1 ) VENDERFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 5)+1 FOR 3) WEEKFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 6)+1 FOR 4) DATEFTH,SUBSTRING(FTH FROM POSITION('*-' IN FTH FROM 1)+7 FOR 4) EEEEFTH , SUBSTRING(HSG FROM 1 for POSITION('*-' IN HSG from 1)-1 ) VENDERHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 5)+1 FOR 3) WEEKHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 6)+1 FOR 4) DATEHSG,SUBSTRING(HSG FROM POSITION('*-' IN HSG FROM 1)+7 FOR 4) EEEEHSG , SUBSTRING(JAF FROM 1 for POSITION('*-' IN JAF from 1)-1 ) VENDERJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 5)+1 FOR 3) WEEKJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 6)+1 FOR 4) DATEJAF,SUBSTRING(JAF FROM POSITION('*-' IN JAF FROM 1)+7 FOR 4) EEEEJAF , SUBSTRING(LCFM FROM 1 for POSITION('*-' IN LCFM from 1)-1 ) VENDERLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 5)+1 FOR 3) WEEKLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 6)+1 FOR 4) DATELCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 10)+1 FOR 4) EEEELCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 1)+12 FOR 3) CONFIGLCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 2)+16 FOR 3) CONFIGLCFM2 ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 3)+20 FOR 3) CONFIGLCFM3, SUBSTRING(LCG FROM 1 for POSITION('*-' IN LCG from 1)-1 ) VENDERLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 5)+1 FOR 3) WEEKLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 6)+1 FOR 4) DATELCG,SUBSTRING(LCG FROM POSITION('*-' IN LCG FROM 1)+7 FOR 4) EEEELCG , SUBSTRING(NAP FROM 1 for POSITION('*-' IN NAP from 1)-1 ) VENDERNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 5)+1 FOR 3) WEEKNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 6)+1 FOR 4) DATENAP,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 1)+7 FOR 4) EEEENAP ,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 2)+12 FOR 2) CONFIGNAP, SUBSTRING(RCAM FROM 1 for POSITION('*-' IN RCAM from 1)-1 ) VENDERRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 5)+1 FOR 3) WEEKRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 6)+1 FOR 4) DATERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 1)+7 FOR 4) EEEERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 2)+12 FOR 1) CONFIGRCAM , SUBSTRING(RCV FROM 1 for POSITION('*-' IN RCV from 1)-1 ) VENDERRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 5)+1 FOR 3) WEEKRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 6)+1 FOR 4) DATERCV,SUBSTRING(RCV FROM POSITION('*-' IN RCV FROM 1)+7 FOR 4) EEEERCV , SUBSTRING(SEK FROM 1 for POSITION('*-' IN SEK from 1)-1 ) VENDERSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 5)+1 FOR 3) WEEKSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 6)+1 FOR 4) DATESEK,SUBSTRING(SEK FROM POSITION('*-' IN SEK FROM 1)+7 FOR 4) EEEESEK , SUBSTRING(SEN FROM 1 for POSITION('*-' IN SEN from 1)-1 ) VENDERSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 5)+1 FOR 3) WEEKSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 6)+1 FOR 4) DATESEN,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 1)+7 FOR 4) EEEESEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 2)+12 FOR 1) CONFIGSEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 3)+14 FOR 1) CONFIG2SEN , SUBSTRING(SPR FROM 1 for POSITION('*-' IN SPR from 1)-1 ) VENDERSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 5)+1 FOR 3) WEEKSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 6)+1 FOR 4) DATESPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 10)+1 FOR 4) EEEESPR , SUBSTRING(STF FROM 1 for POSITION('*-' IN STF from 1)-1 ) VENDERSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 5)+1 FOR 3) WEEKSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 6)+1 FOR 4) DATESTF,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 1)+7 FOR 4) EEEESTF ,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 2)+12 FOR 2) CONFIGSTF, SUBSTRING(UAT FROM 1 for POSITION('*-' IN UAT from 1)-1 ) VENDERUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 5)+1 FOR 3) WEEKUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 6)+1 FOR 4) DATEUAT,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 1)+7 FOR 4) EEEEUAT ,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 2)+12 FOR 2) CONFIGUAT, SUBSTRING(UAT2 FROM 1 for POSITION('*-' IN UAT2 from 1)-1 ) VENDERUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 5)+1 FOR 3) WEEKUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 6)+1 FOR 4) DATEUAT2,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 1)+7 FOR 4) EEEEUAT2 ,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 2)+12 FOR 2) CONFIGUAT2, SUBSTRING(VGA FROM 1 for POSITION('*-' IN VGA from 1)-1 ) VENDERVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 5)+1 FOR 3) WEEKVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 6)+1 FOR 4) DATEVGA,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 1)+7 FOR 4) EEEEVGA ,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 2)+12 FOR 1) CONFIGVGA, INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA_D73 ) "自訂 SQL 查詢" 2022-09-13 19:24:42,047 ERROR [Query f242e7c8-a439-09dd-e359-bfcde0cc8721-31568] util.QueryUtil:227 : Failed to parse sql: SELECT "自訂 SQL 查詢"."FAIL" AS "FAIL" FROM ( SELECT DT TEST_DATE,CATEGORY_KEY,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6) TEST_FLOOR,TEST_LINE,SYMPTOM_CODE,COLOR,CONFIG,REGION,LOCALLIZATION,FACTORY, SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 ) VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3) WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4) DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL , SUBSTRING(BANF FROM 1 for POSITION('*-' IN BANF from 1)-1 ) VENDERBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 5)+1 FOR 3) WEEKBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 6)+1 FOR 4) DATEBANF,SUBSTRING(BANF FROM POSITION('*-' IN BANF FROM 1)+7 FOR 4) EEEEBANF ,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 14)+1 FOR 1) CONFIGBANF, SUBSTRING(BCAM FROM 1 for POSITION('*-' IN BCAM from 1)-1 ) VENDERBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 5)+1 FOR 3) WEEKBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 6)+1 FOR 4) DATEBCAM,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 1)+7 FOR 4) EEEEBCAM ,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 2)+12 FOR 1) CONFIGBCAM, SUBSTRING(BGB FROM 1 for POSITION('*-' IN BGB from 1)-1 ) VENDERBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 5)+1 FOR 3) WEEKBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 6)+1 FOR 4) DATEBGB,SUBSTRING(BGB FROM POSITION('*-' IN BGB FROM 1)+7 FOR 4) EEEEBGB , SUBSTRING(BTY FROM 1 for POSITION('*-' IN BTY from 1)-1 ) VENDERBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 5)+1 FOR 3) WEEKBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 6)+1 FOR 4) DATEBTY,SUBSTRING(BTY FROM POSITION('*-' IN BTY FROM 1)+7 FOR 4) EEEEBTY , SUBSTRING(CAM FROM 1 for POSITION('*-' IN CAM from 1)-1 ) VENDERCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 5)+1 FOR 3) WEEKCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 6)+1 FOR 4) DATECAM,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 1)+7 FOR 4) EEEECAM ,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 2)+12 FOR 1) CONFIGCAM, SUBSTRING(CYF FROM 1 for POSITION('*-' IN CYF from 1)-1 ) VENDERCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 5)+1 FOR 3) WEEKCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 6)+1 FOR 4) DATECYF,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 1)+7 FOR 4) EEEECYF ,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 2)+12 FOR 2) CONFIGCYF, SUBSTRING(DKF FROM 1 for POSITION('*-' IN DKF from 1)-1 ) VENDERDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 5)+1 FOR 3) WEEKDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 6)+1 FOR 4) DATEDKF,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 1)+7 FOR 4) EEEEDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 2)+12 FOR 1) CONFIGDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 3)+14 FOR 1) CONFIG2DKF , SUBSTRING(FTH FROM 1 for POSITION('*-' IN FTH from 1)-1 ) VENDERFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 5)+1 FOR 3) WEEKFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 6)+1 FOR 4) DATEFTH,SUBSTRING(FTH FROM POSITION('*-' IN FTH FROM 1)+7 FOR 4) EEEEFTH , SUBSTRING(HSG FROM 1 for POSITION('*-' IN HSG from 1)-1 ) VENDERHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 5)+1 FOR 3) WEEKHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 6)+1 FOR 4) DATEHSG,SUBSTRING(HSG FROM POSITION('*-' IN HSG FROM 1)+7 FOR 4) EEEEHSG , SUBSTRING(JAF FROM 1 for POSITION('*-' IN JAF from 1)-1 ) VENDERJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 5)+1 FOR 3) WEEKJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 6)+1 FOR 4) DATEJAF,SUBSTRING(JAF FROM POSITION('*-' IN JAF FROM 1)+7 FOR 4) EEEEJAF , SUBSTRING(LCFM FROM 1 for POSITION('*-' IN LCFM from 1)-1 ) VENDERLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 5)+1 FOR 3) WEEKLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 6)+1 FOR 4) DATELCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 10)+1 FOR 4) EEEELCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 1)+12 FOR 3) CONFIGLCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 2)+16 FOR 3) CONFIGLCFM2 ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 3)+20 FOR 3) CONFIGLCFM3, SUBSTRING(LCG FROM 1 for POSITION('*-' IN LCG from 1)-1 ) VENDERLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 5)+1 FOR 3) WEEKLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 6)+1 FOR 4) DATELCG,SUBSTRING(LCG FROM POSITION('*-' IN LCG FROM 1)+7 FOR 4) EEEELCG , SUBSTRING(NAP FROM 1 for POSITION('*-' IN NAP from 1)-1 ) VENDERNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 5)+1 FOR 3) WEEKNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 6)+1 FOR 4) DATENAP,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 1)+7 FOR 4) EEEENAP ,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 2)+12 FOR 2) CONFIGNAP, SUBSTRING(RCAM FROM 1 for POSITION('*-' IN RCAM from 1)-1 ) VENDERRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 5)+1 FOR 3) WEEKRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 6)+1 FOR 4) DATERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 1)+7 FOR 4) EEEERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 2)+12 FOR 1) CONFIGRCAM , SUBSTRING(RCV FROM 1 for POSITION('*-' IN RCV from 1)-1 ) VENDERRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 5)+1 FOR 3) WEEKRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 6)+1 FOR 4) DATERCV,SUBSTRING(RCV FROM POSITION('*-' IN RCV FROM 1)+7 FOR 4) EEEERCV , SUBSTRING(SEK FROM 1 for POSITION('*-' IN SEK from 1)-1 ) VENDERSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 5)+1 FOR 3) WEEKSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 6)+1 FOR 4) DATESEK,SUBSTRING(SEK FROM POSITION('*-' IN SEK FROM 1)+7 FOR 4) EEEESEK , SUBSTRING(SEN FROM 1 for POSITION('*-' IN SEN from 1)-1 ) VENDERSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 5)+1 FOR 3) WEEKSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 6)+1 FOR 4) DATESEN,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 1)+7 FOR 4) EEEESEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 2)+12 FOR 1) CONFIGSEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 3)+14 FOR 1) CONFIG2SEN , SUBSTRING(SPR FROM 1 for POSITION('*-' IN SPR from 1)-1 ) VENDERSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 5)+1 FOR 3) WEEKSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 6)+1 FOR 4) DATESPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 10)+1 FOR 4) EEEESPR , SUBSTRING(STF FROM 1 for POSITION('*-' IN STF from 1)-1 ) VENDERSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 5)+1 FOR 3) WEEKSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 6)+1 FOR 4) DATESTF,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 1)+7 FOR 4) EEEESTF ,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 2)+12 FOR 2) CONFIGSTF, SUBSTRING(UAT FROM 1 for POSITION('*-' IN UAT from 1)-1 ) VENDERUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 5)+1 FOR 3) WEEKUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 6)+1 FOR 4) DATEUAT,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 1)+7 FOR 4) EEEEUAT ,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 2)+12 FOR 2) CONFIGUAT, SUBSTRING(UAT2 FROM 1 for POSITION('*-' IN UAT2 from 1)-1 ) VENDERUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 5)+1 FOR 3) WEEKUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 6)+1 FOR 4) DATEUAT2,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 1)+7 FOR 4) EEEEUAT2 ,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 2)+12 FOR 2) CONFIGUAT2, SUBSTRING(VGA FROM 1 for POSITION('*-' IN VGA from 1)-1 ) VENDERVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 5)+1 FOR 3) WEEKVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 6)+1 FOR 4) DATEVGA,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 1)+7 FOR 4) EEEEVGA ,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 2)+12 FOR 1) CONFIGVGA, INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA_D73 ) "自訂 SQL 查詢" org.apache.kylin.query.util.ParseException: Encountered " "\'" "\' "" at line 1, column 7549. Was expecting: at org.apache.kylin.query.util.CommentParser.generateParseException(CommentParser.java:407) at org.apache.kylin.query.util.CommentParser.jj_consume_token(CommentParser.java:292) at org.apache.kylin.query.util.CommentParser.Input(CommentParser.java:44) at org.apache.kylin.query.util.QueryUtil.removeCommentInSql(QueryUtil.java:225) at org.apache.kylin.query.util.QueryUtil.massageSql(QueryUtil.java:81) at org.apache.kylin.query.util.QueryUtil.massageSql(QueryUtil.java:125) at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:698) at org.apache.kylin.rest.service.QueryService.query(QueryService.java:224) at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:525) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:480) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:416) at org.apache.kylin.rest.controller.QueryController.prepareQuery(QueryController.java:106) at sun.reflect.GeneratedMethodAccessor202.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:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1195) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:317) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) 2022-09-13 19:24:42,059 INFO [Query f242e7c8-a439-09dd-e359-bfcde0cc8721-31568] service.QueryService:402 : ==========================[QUERY]=============================== Query Id: f242e7c8-a439-09dd-e359-bfcde0cc8721 SQL: SELECT "自訂 SQL 查詢"."FAIL" AS "FAIL" FROM ( SELECT DT TEST_DATE,CATEGORY_KEY,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6) TEST_FLOOR,TEST_LINE,SYMPTOM_CODE,COLOR,CONFIG,REGION,LOCALLIZATION,FACTORY, SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 ) VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3) WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4) DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL , SUBSTRING(BANF FROM 1 for POSITION('*-' IN BANF from 1)-1 ) VENDERBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 5)+1 FOR 3) WEEKBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 6)+1 FOR 4) DATEBANF,SUBSTRING(BANF FROM POSITION('*-' IN BANF FROM 1)+7 FOR 4) EEEEBANF ,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 14)+1 FOR 1) CONFIGBANF, SUBSTRING(BCAM FROM 1 for POSITION('*-' IN BCAM from 1)-1 ) VENDERBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 5)+1 FOR 3) WEEKBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 6)+1 FOR 4) DATEBCAM,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 1)+7 FOR 4) EEEEBCAM ,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 2)+12 FOR 1) CONFIGBCAM, SUBSTRING(BGB FROM 1 for POSITION('*-' IN BGB from 1)-1 ) VENDERBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 5)+1 FOR 3) WEEKBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 6)+1 FOR 4) DATEBGB,SUBSTRING(BGB FROM POSITION('*-' IN BGB FROM 1)+7 FOR 4) EEEEBGB , SUBSTRING(BTY FROM 1 for POSITION('*-' IN BTY from 1)-1 ) VENDERBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 5)+1 FOR 3) WEEKBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 6)+1 FOR 4) DATEBTY,SUBSTRING(BTY FROM POSITION('*-' IN BTY FROM 1)+7 FOR 4) EEEEBTY , SUBSTRING(CAM FROM 1 for POSITION('*-' IN CAM from 1)-1 ) VENDERCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 5)+1 FOR 3) WEEKCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 6)+1 FOR 4) DATECAM,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 1)+7 FOR 4) EEEECAM ,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 2)+12 FOR 1) CONFIGCAM, SUBSTRING(CYF FROM 1 for POSITION('*-' IN CYF from 1)-1 ) VENDERCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 5)+1 FOR 3) WEEKCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 6)+1 FOR 4) DATECYF,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 1)+7 FOR 4) EEEECYF ,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 2)+12 FOR 2) CONFIGCYF, SUBSTRING(DKF FROM 1 for POSITION('*-' IN DKF from 1)-1 ) VENDERDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 5)+1 FOR 3) WEEKDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 6)+1 FOR 4) DATEDKF,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 1)+7 FOR 4) EEEEDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 2)+12 FOR 1) CONFIGDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 3)+14 FOR 1) CONFIG2DKF , SUBSTRING(FTH FROM 1 for POSITION('*-' IN FTH from 1)-1 ) VENDERFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 5)+1 FOR 3) WEEKFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 6)+1 FOR 4) DATEFTH,SUBSTRING(FTH FROM POSITION('*-' IN FTH FROM 1)+7 FOR 4) EEEEFTH , SUBSTRING(HSG FROM 1 for POSITION('*-' IN HSG from 1)-1 ) VENDERHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 5)+1 FOR 3) WEEKHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 6)+1 FOR 4) DATEHSG,SUBSTRING(HSG FROM POSITION('*-' IN HSG FROM 1)+7 FOR 4) EEEEHSG , SUBSTRING(JAF FROM 1 for POSITION('*-' IN JAF from 1)-1 ) VENDERJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 5)+1 FOR 3) WEEKJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 6)+1 FOR 4) DATEJAF,SUBSTRING(JAF FROM POSITION('*-' IN JAF FROM 1)+7 FOR 4) EEEEJAF , SUBSTRING(LCFM FROM 1 for POSITION('*-' IN LCFM from 1)-1 ) VENDERLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 5)+1 FOR 3) WEEKLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 6)+1 FOR 4) DATELCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 10)+1 FOR 4) EEEELCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 1)+12 FOR 3) CONFIGLCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 2)+16 FOR 3) CONFIGLCFM2 ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 3)+20 FOR 3) CONFIGLCFM3, SUBSTRING(LCG FROM 1 for POSITION('*-' IN LCG from 1)-1 ) VENDERLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 5)+1 FOR 3) WEEKLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 6)+1 FOR 4) DATELCG,SUBSTRING(LCG FROM POSITION('*-' IN LCG FROM 1)+7 FOR 4) EEEELCG , SUBSTRING(NAP FROM 1 for POSITION('*-' IN NAP from 1)-1 ) VENDERNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 5)+1 FOR 3) WEEKNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 6)+1 FOR 4) DATENAP,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 1)+7 FOR 4) EEEENAP ,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 2)+12 FOR 2) CONFIGNAP, SUBSTRING(RCAM FROM 1 for POSITION('*-' IN RCAM from 1)-1 ) VENDERRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 5)+1 FOR 3) WEEKRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 6)+1 FOR 4) DATERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 1)+7 FOR 4) EEEERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 2)+12 FOR 1) CONFIGRCAM , SUBSTRING(RCV FROM 1 for POSITION('*-' IN RCV from 1)-1 ) VENDERRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 5)+1 FOR 3) WEEKRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 6)+1 FOR 4) DATERCV,SUBSTRING(RCV FROM POSITION('*-' IN RCV FROM 1)+7 FOR 4) EEEERCV , SUBSTRING(SEK FROM 1 for POSITION('*-' IN SEK from 1)-1 ) VENDERSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 5)+1 FOR 3) WEEKSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 6)+1 FOR 4) DATESEK,SUBSTRING(SEK FROM POSITION('*-' IN SEK FROM 1)+7 FOR 4) EEEESEK , SUBSTRING(SEN FROM 1 for POSITION('*-' IN SEN from 1)-1 ) VENDERSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 5)+1 FOR 3) WEEKSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 6)+1 FOR 4) DATESEN,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 1)+7 FOR 4) EEEESEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 2)+12 FOR 1) CONFIGSEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 3)+14 FOR 1) CONFIG2SEN , SUBSTRING(SPR FROM 1 for POSITION('*-' IN SPR from 1)-1 ) VENDERSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 5)+1 FOR 3) WEEKSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 6)+1 FOR 4) DATESPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 10)+1 FOR 4) EEEESPR , SUBSTRING(STF FROM 1 for POSITION('*-' IN STF from 1)-1 ) VENDERSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 5)+1 FOR 3) WEEKSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 6)+1 FOR 4) DATESTF,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 1)+7 FOR 4) EEEESTF ,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 2)+12 FOR 2) CONFIGSTF, SUBSTRING(UAT FROM 1 for POSITION('*-' IN UAT from 1)-1 ) VENDERUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 5)+1 FOR 3) WEEKUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 6)+1 FOR 4) DATEUAT,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 1)+7 FOR 4) EEEEUAT ,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 2)+12 FOR 2) CONFIGUAT, SUBSTRING(UAT2 FROM 1 for POSITION('*-' IN UAT2 from 1)-1 ) VENDERUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 5)+1 FOR 3) WEEKUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 6)+1 FOR 4) DATEUAT2,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 1)+7 FOR 4) EEEEUAT2 ,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 2)+12 FOR 2) CONFIGUAT2, SUBSTRING(VGA FROM 1 for POSITION('*-' IN VGA from 1)-1 ) VENDERVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 5)+1 FOR 3) WEEKVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 6)+1 FOR 4) DATEVGA,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 1)+7 FOR 4) EEEEVGA ,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 2)+12 FOR 1) CONFIGVGA, INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA_D73 ) "自訂 SQL 查詢" User: h2606712 Success: true Duration: 0.015 Project: KPY_RANGER Realization Names: [] Cuboid Ids: [] Is Exactly Matched: [] Total scan count: 0 Total scan files: 0 Total metadata time: 0ms Total spark scan time: 0ms Total scan bytes: -1 Result row count: 0 Storage cache used: false Is Query Push-Down: false Is Prepare: true Used Spark pool: null Trace URL: null Message: null Time consuming for each query stage: ----------------- SQL_TRANSFORMATION : -1ms Time consuming for each query stage: ----------------- 2022-09-13 20:37:42,338 INFO [Query cf0bfde7-5976-e7d4-5d18-565aa5cc9546-55] service.QueryService:1234 : Processed rows for each storageContext: 0 2022-09-13 20:37:42,339 INFO [Query cf0bfde7-5976-e7d4-5d18-565aa5cc9546-55] service.QueryService:402 : ==========================[QUERY]=============================== Query Id: cf0bfde7-5976-e7d4-5d18-565aa5cc9546 SQL: SELECT "自訂 SQL 查詢"."FAIL" AS "FAIL" FROM ( SELECT DT TEST_DATE,CATEGORY_KEY,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6) TEST_FLOOR,TEST_LINE,SYMPTOM_CODE,COLOR,CONFIG,REGION,LOCALLIZATION,FACTORY, SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 ) VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3) WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4) DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL , SUBSTRING(BANF FROM 1 for POSITION('*-' IN BANF from 1)-1 ) VENDERBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 5)+1 FOR 3) WEEKBANF,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 6)+1 FOR 4) DATEBANF,SUBSTRING(BANF FROM POSITION('*-' IN BANF FROM 1)+7 FOR 4) EEEEBANF ,SUBSTRING(BANF FROM POSITION('-' IN BANF FROM 14)+1 FOR 1) CONFIGBANF, SUBSTRING(BCAM FROM 1 for POSITION('*-' IN BCAM from 1)-1 ) VENDERBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 5)+1 FOR 3) WEEKBCAM,SUBSTRING(BCAM FROM POSITION('-' IN BCAM FROM 6)+1 FOR 4) DATEBCAM,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 1)+7 FOR 4) EEEEBCAM ,SUBSTRING(BCAM FROM POSITION('*-' IN BCAM FROM 2)+12 FOR 1) CONFIGBCAM, SUBSTRING(BGB FROM 1 for POSITION('*-' IN BGB from 1)-1 ) VENDERBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 5)+1 FOR 3) WEEKBGB,SUBSTRING(BGB FROM POSITION('-' IN BGB FROM 6)+1 FOR 4) DATEBGB,SUBSTRING(BGB FROM POSITION('*-' IN BGB FROM 1)+7 FOR 4) EEEEBGB , SUBSTRING(BTY FROM 1 for POSITION('*-' IN BTY from 1)-1 ) VENDERBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 5)+1 FOR 3) WEEKBTY,SUBSTRING(BTY FROM POSITION('-' IN BTY FROM 6)+1 FOR 4) DATEBTY,SUBSTRING(BTY FROM POSITION('*-' IN BTY FROM 1)+7 FOR 4) EEEEBTY , SUBSTRING(CAM FROM 1 for POSITION('*-' IN CAM from 1)-1 ) VENDERCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 5)+1 FOR 3) WEEKCAM,SUBSTRING(CAM FROM POSITION('-' IN CAM FROM 6)+1 FOR 4) DATECAM,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 1)+7 FOR 4) EEEECAM ,SUBSTRING(CAM FROM POSITION('*-' IN CAM FROM 2)+12 FOR 1) CONFIGCAM, SUBSTRING(CYF FROM 1 for POSITION('*-' IN CYF from 1)-1 ) VENDERCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 5)+1 FOR 3) WEEKCYF,SUBSTRING(CYF FROM POSITION('-' IN CYF FROM 6)+1 FOR 4) DATECYF,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 1)+7 FOR 4) EEEECYF ,SUBSTRING(CYF FROM POSITION('*-' IN CYF FROM 2)+12 FOR 2) CONFIGCYF, SUBSTRING(DKF FROM 1 for POSITION('*-' IN DKF from 1)-1 ) VENDERDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 5)+1 FOR 3) WEEKDKF,SUBSTRING(DKF FROM POSITION('-' IN DKF FROM 6)+1 FOR 4) DATEDKF,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 1)+7 FOR 4) EEEEDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 2)+12 FOR 1) CONFIGDKF ,SUBSTRING(DKF FROM POSITION('*-' IN DKF FROM 3)+14 FOR 1) CONFIG2DKF , SUBSTRING(FTH FROM 1 for POSITION('*-' IN FTH from 1)-1 ) VENDERFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 5)+1 FOR 3) WEEKFTH,SUBSTRING(FTH FROM POSITION('-' IN FTH FROM 6)+1 FOR 4) DATEFTH,SUBSTRING(FTH FROM POSITION('*-' IN FTH FROM 1)+7 FOR 4) EEEEFTH , SUBSTRING(HSG FROM 1 for POSITION('*-' IN HSG from 1)-1 ) VENDERHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 5)+1 FOR 3) WEEKHSG,SUBSTRING(HSG FROM POSITION('-' IN HSG FROM 6)+1 FOR 4) DATEHSG,SUBSTRING(HSG FROM POSITION('*-' IN HSG FROM 1)+7 FOR 4) EEEEHSG , SUBSTRING(JAF FROM 1 for POSITION('*-' IN JAF from 1)-1 ) VENDERJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 5)+1 FOR 3) WEEKJAF,SUBSTRING(JAF FROM POSITION('-' IN JAF FROM 6)+1 FOR 4) DATEJAF,SUBSTRING(JAF FROM POSITION('*-' IN JAF FROM 1)+7 FOR 4) EEEEJAF , SUBSTRING(LCFM FROM 1 for POSITION('*-' IN LCFM from 1)-1 ) VENDERLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 5)+1 FOR 3) WEEKLCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 6)+1 FOR 4) DATELCFM,SUBSTRING(LCFM FROM POSITION('-' IN LCFM FROM 10)+1 FOR 4) EEEELCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 1)+12 FOR 3) CONFIGLCFM ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 2)+16 FOR 3) CONFIGLCFM2 ,SUBSTRING(LCFM FROM POSITION('*-' IN LCFM FROM 3)+20 FOR 3) CONFIGLCFM3, SUBSTRING(LCG FROM 1 for POSITION('*-' IN LCG from 1)-1 ) VENDERLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 5)+1 FOR 3) WEEKLCG,SUBSTRING(LCG FROM POSITION('-' IN LCG FROM 6)+1 FOR 4) DATELCG,SUBSTRING(LCG FROM POSITION('*-' IN LCG FROM 1)+7 FOR 4) EEEELCG , SUBSTRING(NAP FROM 1 for POSITION('*-' IN NAP from 1)-1 ) VENDERNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 5)+1 FOR 3) WEEKNAP,SUBSTRING(NAP FROM POSITION('-' IN NAP FROM 6)+1 FOR 4) DATENAP,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 1)+7 FOR 4) EEEENAP ,SUBSTRING(NAP FROM POSITION('*-' IN NAP FROM 2)+12 FOR 2) CONFIGNAP, SUBSTRING(RCAM FROM 1 for POSITION('*-' IN RCAM from 1)-1 ) VENDERRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 5)+1 FOR 3) WEEKRCAM,SUBSTRING(RCAM FROM POSITION('-' IN RCAM FROM 6)+1 FOR 4) DATERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 1)+7 FOR 4) EEEERCAM,SUBSTRING(RCAM FROM POSITION('*-' IN RCAM FROM 2)+12 FOR 1) CONFIGRCAM , SUBSTRING(RCV FROM 1 for POSITION('*-' IN RCV from 1)-1 ) VENDERRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 5)+1 FOR 3) WEEKRCV,SUBSTRING(RCV FROM POSITION('-' IN RCV FROM 6)+1 FOR 4) DATERCV,SUBSTRING(RCV FROM POSITION('*-' IN RCV FROM 1)+7 FOR 4) EEEERCV , SUBSTRING(SEK FROM 1 for POSITION('*-' IN SEK from 1)-1 ) VENDERSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 5)+1 FOR 3) WEEKSEK,SUBSTRING(SEK FROM POSITION('-' IN SEK FROM 6)+1 FOR 4) DATESEK,SUBSTRING(SEK FROM POSITION('*-' IN SEK FROM 1)+7 FOR 4) EEEESEK , SUBSTRING(SEN FROM 1 for POSITION('*-' IN SEN from 1)-1 ) VENDERSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 5)+1 FOR 3) WEEKSEN,SUBSTRING(SEN FROM POSITION('-' IN SEN FROM 6)+1 FOR 4) DATESEN,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 1)+7 FOR 4) EEEESEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 2)+12 FOR 1) CONFIGSEN ,SUBSTRING(SEN FROM POSITION('*-' IN SEN FROM 3)+14 FOR 1) CONFIG2SEN , SUBSTRING(SPR FROM 1 for POSITION('*-' IN SPR from 1)-1 ) VENDERSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 5)+1 FOR 3) WEEKSPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 6)+1 FOR 4) DATESPR,SUBSTRING(SPR FROM POSITION('-' IN SPR FROM 10)+1 FOR 4) EEEESPR , SUBSTRING(STF FROM 1 for POSITION('*-' IN STF from 1)-1 ) VENDERSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 5)+1 FOR 3) WEEKSTF,SUBSTRING(STF FROM POSITION('-' IN STF FROM 6)+1 FOR 4) DATESTF,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 1)+7 FOR 4) EEEESTF ,SUBSTRING(STF FROM POSITION('*-' IN STF FROM 2)+12 FOR 2) CONFIGSTF, SUBSTRING(UAT FROM 1 for POSITION('*-' IN UAT from 1)-1 ) VENDERUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 5)+1 FOR 3) WEEKUAT,SUBSTRING(UAT FROM POSITION('-' IN UAT FROM 6)+1 FOR 4) DATEUAT,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 1)+7 FOR 4) EEEEUAT ,SUBSTRING(UAT FROM POSITION('*-' IN UAT FROM 2)+12 FOR 2) CONFIGUAT, SUBSTRING(UAT2 FROM 1 for POSITION('*-' IN UAT2 from 1)-1 ) VENDERUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 5)+1 FOR 3) WEEKUAT2,SUBSTRING(UAT2 FROM POSITION('-' IN UAT2 FROM 6)+1 FOR 4) DATEUAT2,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 1)+7 FOR 4) EEEEUAT2 ,SUBSTRING(UAT2 FROM POSITION('*-' IN UAT2 FROM 2)+12 FOR 2) CONFIGUAT2, SUBSTRING(VGA FROM 1 for POSITION('*-' IN VGA from 1)-1 ) VENDERVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 5)+1 FOR 3) WEEKVGA,SUBSTRING(VGA FROM POSITION('-' IN VGA FROM 6)+1 FOR 4) DATEVGA,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 1)+7 FOR 4) EEEEVGA ,SUBSTRING(VGA FROM POSITION('*-' IN VGA FROM 2)+12 FOR 1) CONFIGVGA, INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA_D73 ) "自訂 SQL 查詢" User: h2606712 Success: false Duration: 4380.261 Project: KPY_RANGER Realization Names: [CUBE[name=KPY_Ranger_Cube]] Cuboid Ids: [34359738367] Is Exactly Matched: [false] Total scan count: 0 Total scan files: 0 Total metadata time: 0ms Total spark scan time: 0ms Total scan bytes: 5170309007 Result row count: 0 Storage cache used: false Is Query Push-Down: false Is Prepare: false Used Spark pool: lightweight_tasks Trace URL: null Message: Java heap space