上周新做了一份报告,发现制作报告、查看报告都打不开,清除系统缓存也没用,9.0版本
附后台一段日志:
from newbi.s_reportdaily_text a:JDBCConn: 11,jdbc:hive2://10.70.2.7:10000,io.transwarp.jdbc.InceptorDriver,30,true,newbi,false,_mi00210044003300510038,,-1,,,null,true,,,,BI/客户服务中心/每日一览表邮件/每日一览表-正文;赔付率环比00;QCI:<2,,_MAX_ROWS_:5000000>]赔付率环比00[GDimCol<赔付率环比,0,g5.meta.BCol<赔付率环比>>], where=null][2023-12-26 09:57:33.999] |-[INFO] |-[2eeadde66dc44de3a020f2dadd841f3b] |-[admin] |-[g5.qry.sql.ARSExecutor.load(ARSExecutor.java:262)] |-[g5.qry.sql.impl.SparkHiveExecutor@69f39053 loaded 10000 rows, time occupied: 1003][2023-12-26 09:57:33.999] |-[INFO] |-[a52e0c9b2db649e7b68c690545223603] |-[admin] |-[g5.qry.sql.ARSExecutor.load(ARSExecutor.java:267)] |-[g5.qry.sql.impl.SparkHiveExecutor@6619452c load data finished, grid: g5.grid.impl.QGrid@3d9a5f0f<[QColumn[赔付率环比]<r-1,type-DynamicStringSeg@1520871178<false,0>[0]>]>, time occupied: 11, load rows: 1, cancel:false][2023-12-26 09:57:33.999] |-[INFO] |-[a52e0c9b2db649e7b68c690545223603] |-[admin] |-[g5.grid.impl.DynamicStringSeg.convert(DynamicStringSeg.java:137)] |-[Slow DefStringSeg is used!][2023-12-26 09:57:33.999] |-[INFO] |-[a52e0c9b2db649e7b68c690545223603] |-[admin] |-[g5.gqry.GQuery.getGrid(GQuery.java:1134)] |-[Execute one query 'g5.gqry.SQLGQuery@363eea49', result 'g5.grid.impl.QGrid@3d9a5f0f<[QColumn[赔付率环比]<r-2,type-DefStringSeg@1924137802<false,0>[0]>]>', occupied 5161ms. Related Dashboard: '每日一览表(正文)20231226095512-915' Run user: 'admin' SQL statement: 'SELECT a.mpr_mom as long_col_0FROM newbi.s_reportdaily_text aGROUP BY a.mpr_momORDER BY long_col_0 ASCLIMIT 5000000']
|