报表查看时报错 - 永洪社区

上传

点击文件名下载附件 2022-11-10 09:39:16.892] |-[WARN] |-[e73f9152a31c45daa310562818ce6429] |-[SYSTEM] |-[g5.qry.database.AbsDBFileSystem.lastModified(AbsDBFileSystem.java:1394)] |-[ERROR: [ErrCode: 0] Table 'admin.FILESYSTEM_TABLE' doesn't exist]java.sql.SQLSyntaxErrorException: Table 'admin.FILESYSTEM_TABLE' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.21.jar:8.0.21] at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql-connector-java-8.0.21.jar:8.0.21] at g5.qry.database.AbsDBFileSystem.lastModified(AbsDBFileSystem.java:1376) [product.jar:?] at g5.io.FSFileTracker.modified(FSFileTracker.java:50) [product.jar:?] at g5.io.FileTracker.heartbeat(FileTracker.java:194) [product.jar:?] at g5.io.FileTracker$FileTrackerRunnable.run(FileTracker.java:313) [product.jar:?] at g5.thread.ThreadPoolWithChecker$GThread.run0(ThreadPoolWithChecker.java:214) [product.jar:?] at g5.thread.AbsThreadPool$PThread.run(AbsThreadPool.java:319) [product.jar:?][2022-11-10 09:39:16.951] |-[INFO] |-[8e779fb41b444eb69eb4632cae0fecaa] |-[admin] |-[g5.sv.defense.DefenseManager.reg(DefenseManager.java:34)] |-[DASHBOARD: [1、投放效果20221110093911-873<柳汽/01_投放效果全景看板/1、投放效果.db>] Add defense for id: 1、投放效果20221110093911-873, defense: DBPropReq@1793782072{id=1、投放效果20221110093911-873,timeout=2400000}][2022-11-10 09:39:16.951] |-[INFO] |-[8e779fb41b444eb69eb4632cae0fecaa] |-[admin] |-[g5.AbsSetting.getBoolean(AbsSetting.java:382)] |-[DASHBOARD: [1、投放效果20221110093911-873<柳汽/01_投放效果全景看板/1、投放效果.db>] boolean value does not exist: front.transfer.session][2022-11-10 09:39:21.039] |-[INFO] |-[48f44a3098be4318bf3cb48aeb3bcdd8] |-[admin] |-[g5.sv.defense.DefenseManager.reg(DefenseManager.java:34)] |-[DASHBOARD: [1、投放效果20221110093911-873<柳汽/01_投放效果全景看板/1、投放效果.db>] Add defense for id: 1、投放效果20221110093911-873, defense: DBPropReq@696344086{id=1、投放效果20221110093911-873,timeout=2400000}][2022-11-10 09:39:21.040] |-[INFO] |-[48f44a3098be4318bf3cb48aeb3bcdd8] |-[admin] |-[g5.AbsSetting.getBoolean(AbsSetting.java:382)] |-[DASHBOARD: [1、投放效果20221110093911-873<柳汽/01_投放效果全景看板/1、投放效果.db>] boolean value does not exist: front.transfer.session][2022-11-10 09:39:21.376] |-[INFO] |-[7c761704e64b407c936f5fc1ba48a6ab] |-[admin] |-[g5.sv.defense.DefenseManager.reg(DefenseManager.java:34)] |-[DASHBOARD: [1、投放效果20221110093911-873<柳汽/01_投放效果全景看板/1、投放效果.db>] Add defense for id: 1、投放效果20221110093911-873, defense: HandleBindReq@6907687{id=1、投放效果20221110093911-873,timeout=2400000}][2022-11-10 09:39:21.377] |-[INFO] |-[7c761704e64b407c936f5fc1ba48a6ab] |-[admin] |-[g5.AbsSetting.getBoolean(AbsSetting.java:382)] |-[DASHBOARD: [1、投放效果20221110093911-873<柳汽/01_投放效果全景看板/1、投放效果.db>] boolean value does not exist: front.transfer.session][2022-11-10 09:39:23.281] |-[INFO] |-[97ea4b0a77484cd0a42d6b0bcbc0941b] |-[SYSTEM] |-[g5.sv.defense.DefenseManager.doCheckDefense(DefenseManager.java:81)] |-[OTHER: Start to check defense.][2022-11-10 09:39:23.281] |-[INFO] |-[e809316ac7764972aa9fb01d06ebbe20] |-[SYSTEM] |-[g5.sv.defense.DefenseManager.doCheckDefense(DefenseManager.java:109)] |-[OTHER: End check defense.][2022-11-10 09:39:23.679] |-[INFO] |-[96771f6e416542f6b30f06c9c16e81fb] |-[SYSTEM] |-[g5.mem.LinkMgr.adjustMem(LinkMgr.java:185)] |-[OTHER: Not need adjust mem, free: 4807471320, total: 27246198784][2022-11-10 09:39:23.814] |-[INFO] |-[e544f62d73bc4ac88b61e637c9a7b399] |-[admin] |-[g5.sv.defense.DefenseManager.reg(DefenseManager.java:34)] |-[DASHBOARD: Add defense for id: __EMPTY_ID__, defense: PreviewDBReq@1794143187{id=__EMPTY_ID__,timeout=2400000}][2022-11-10 09:39:23.816] |-[INFO] |-[e544f62d73bc4ac88b61e637c9a7b399] |-[admin] |-[g5.sv.db.DBReq.auditActions(DBReq.java:548)] |-[DASHBOARD: [1、投放效果20221110093911-873 cloned<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>] admin,预览报告"柳汽/01_投放效果全景看板/1、投放效果.db"。][2022-11-10 09:39:23.821] |-[INFO] |-[e544f62d73bc4ac88b61e637c9a7b399] |-[admin] |-[g5.AbsSetting.getBoolean(AbsSetting.java:382)] |-[DASHBOARD: [1、投放效果20221110093911-873 cloned<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>] boolean value does not exist: front.transfer.session][2022-11-10 09:39:23.855] |-[INFO] |-[e86c20364d3f4595a50a9efe9bcd6053] |-[admin] |-[g5.AbsSetting.getBoolean(AbsSetting.java:382)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>] boolean value does not exist: front.transfer.session][2022-11-10 09:39:23.899] |-[INFO] |-[f459af9e0b5a4d0680eb795a6d92d4ce] |-[admin] |-[g5.sv.defense.DefenseManager.reg(DefenseManager.java:34)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>] Add defense for id: 预览: 1、投放效果20221110093923-495, defense: OpenDBReq2@1724508645{id=预览: 1、投放效果20221110093923-495,timeout=2400000}][2022-11-10 09:39:23.905] |-[WARN] |-[f459af9e0b5a4d0680eb795a6d92d4ce] |-[admin] |-[g5.gqry.exec.AExecutor.analyze(AExecutor.java:105)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>][下拉参数1] Filter requires to be post processed: [DimCol[日期, sinfo=SortInfo<Column=null, sort=2, rank=, user=>]]][2022-11-10 09:39:23.906] |-[WARN] |-[f459af9e0b5a4d0680eb795a6d92d4ce] |-[admin] |-[g5.aqry.AQuery.<init>(AQuery.java:214)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>][下拉参数1] Performance tuning required for slow query: [GDimCol<日期,2,g5.meta.UserCol<日期,日期>, exp=parseDate(col['数据日期'],'yyyy-MM-dd'), type=32, aggregated=false>]][2022-11-10 09:39:23.909] |-[INFO] |-[f459af9e0b5a4d0680eb795a6d92d4ce] |-[admin] |-[g5.qry.queryPool.QueryPool.add(QueryPool.java:73)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>][下拉参数1] executor QueryExecutor17514[g5.qry.sql.impl.ImpalaExecutor@5e80e81d] has been added into pool with grpCost: [0] and qryCost: [0].][2022-11-10 09:39:23.917] |-[INFO] |-[e3668ccf40ca4a27bf9b48b8fe418750] |-[SYSTEM] |-[g5.thread.ThreadMeta.reg(ThreadMeta.java:184)] |-[OTHER: Thread is cancelled when registering cancellable: MSGConsumer[2d254026]][2022-11-10 09:39:23.917] |-[INFO] |-[f459af9e0b5a4d0680eb795a6d92d4ce] |-[admin] |-[g5.qry.jdbc.JDBCExecutor.init(JDBCExecutor.java:110)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>][下拉参数1] g5.qry.sql.impl.ImpalaExecutor@5e80e81d[child-g5.qry.sql.impl.ImpalaExecutor@5b9dd92] start to init, with params: {_MAX_ROWS_=0, 下拉列表参数2=[是, 否], _SEL_STRATEGY_=0, 下拉列表参数1=[是, 否], _Running_GQuery_Already_Added_=true, 下拉列表参数4=[是, 否], 下拉列表参数3=[是, 否], _REFRESH_=true, startdate=2022-10-17T00:00:00.000+0800, _isMobile_=false, _CONN_TIME_OFFSET_=0, __DATA_CACHE_KEY__=QRY[`dws`.`t_dws_hive_ms_exposure_click`:JDBCConn: 19,jdbc:impala://192.168.0.52:21050/impala;auth=noSasl,com.cloudera.impala.jdbc4.Driver,30,true,true,bdp_dev,false,_mi,,,-1961,null,,,,柳汽/统计实际曝光点击;data_date0数据日期0;QCI:<4,,_MAX_ROWS_:0>], fromVooltdbJoinNode=false, _DISCARDED_GRID_=false, enddate=2022-11-01T00:00:00.000+0800, 下拉参数2=2022-11-03T00:00:00.000+0800, 媒体类型=null, 下拉参数1=2022-11-01T00:00:00.000+0800, _MAX_PERMIT_ROWS_=5000000, startdate2=2022-10-19T00:00:00.000+0800, enddate2=2022-11-03T00:00:00.000+0800}, by g5.qry.jdbc.JDBCExecutor$SQLRunnable@5489403e [ts=1668044363917, report=null, wts=0, cost=0, qryCost=0, grpCost=0, group=UNKNOWN, query=UNKNOWN, ready=true]][2022-11-10 09:39:23.921] |-[INFO] |-[f459af9e0b5a4d0680eb795a6d92d4ce] |-[admin] |-[g5.qry.jdbc.JDBCExecutor.init0(JDBCExecutor.java:976)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>][下拉参数1] g5.qry.sql.impl.ImpalaExecutor@5e80e81d[child-g5.qry.sql.impl.ImpalaExecutor@5b9dd92] start to get connection][2022-11-10 09:39:23.962] |-[INFO] |-[bf9a0f3b3f9d4dcca941f3aac39e142f] |-[SYSTEM] |-[g5.qry.driver.ConnectionProvider.getConn(ConnectionProvider.java:105)] |-[OTHER: Succeed to get connection, classloader: YH_ClassLoader_2.][2022-11-10 09:39:23.963] |-[INFO] |-[f459af9e0b5a4d0680eb795a6d92d4ce] |-[admin] |-[g5.qry.jdbc.JDBCExecutor.init0(JDBCExecutor.java:984)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>][下拉参数1] g5.qry.sql.impl.ImpalaExecutor@5e80e81d[child-g5.qry.sql.impl.ImpalaExecutor@5b9dd92] success get connection: g5.qry.sql.impl.GConn@43c33cf8][2022-11-10 09:39:23.963] |-[INFO] |-[f459af9e0b5a4d0680eb795a6d92d4ce] |-[admin] |-[g5.qry.jdbc.JDBCExecutor.init0(JDBCExecutor.java:999)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>][下拉参数1] g5.qry.sql.impl.ImpalaExecutor@5e80e81d[child-g5.qry.sql.impl.ImpalaExecutor@5b9dd92] prepare SQL statement][2022-11-10 09:39:23.963] |-[INFO] |-[f459af9e0b5a4d0680eb795a6d92d4ce] |-[admin] |-[g5.qry.jdbc.JDBCExecutor.getRS(JDBCExecutor.java:1414)] |-[DASHBOARD: [预览: 1、投放效果20221110093923-495<柳汽/01_投放效果全景看板/预览: 1、投放效果.db>][下拉参数1] g5.qry.sql.impl.ImpalaExecutor@5e80e81d[child-g5.qry.sql.impl.ImpalaExecutor@5b9dd92] start to execute SQL:____________SELECT `data_date` as `long_col_0`FROM `dws`.`t_dws_hive_ms_exposure_click`]

作者: yhdata_yzm 时间: 2022-11-10 09:56
数据加载超时了，你发一下完整的日志呢

作者: yhdata_ISrmYmdV 时间: 2022-11-10 10:10
找到原因了,是日期过滤:日期字段没有下推到数据库导致.这个怎么解决.数据源提供的日期是字符串,需要转换成日期类型.
但是在数据源直接设置为日期类型就报错了,字符串日期里面有null值

作者: yhdata_yzm 时间: 2022-11-10 10:23

yhdata_ISrmYmdV 发表于 2022-11-10 10:10
找到原因了,是日期过滤:日期字段没有下推到数据库导致.这个怎么解决.数据源提供的日期是字符串,需要转换成 ...

你的日期列里有空值？

作者: yhdata_ISrmYmdV 时间: 2022-11-10 10:32
对数据源提供过来 '日期' 类型是字符串有空值,无法在数据源转换为日期列

作者: yhdata_yzm 时间: 2022-11-10 13:32

yhdata_ISrmYmdV 发表于 2022-11-10 10:32
对数据源提供过来 '日期' 类型是字符串有空值,无法在数据源转换为日期列

你看看能不能把空值替换一下，替换一个特定的字符串，再转日期

欢迎光临永洪社区 (http://club.yonghongtech.com/)