永洪社区
标题:
下推数据库报错
[打印本页]
作者:
yhdata_i9Mc00d4
时间:
2023-2-28 15:09
标题:
下推数据库报错
这个脚本点击sql表达式后就报错
(, 下载次数: 56)
上传
点击文件名下载附件 报错原因如下:
执行SQL失败:“Error while executing SQL "SELECT PERIOD_WID AS "考核日期", PERIOD_DATE AS "数据日期", PERIOD_YEAR AS "年", PERIOD_QUARTER AS "季度", PERIOD_MONTH AS "月" , PERIOD_WEEK AS "周", SOURCE_CODE AS "事业部编码", BUSINESS_DIVISION AS "事业部名称", REGION_CODE_NEW AS "战区CODE", REGION_NAME_NEW AS "战区名称" , PROVINCE_CODE AS "省份CODE", PROVINCE_NAME AS "省份名称", CITY_CODE AS "城市CODE", CITY_NAME AS "城市名称", SERIES_CODE AS "车系CODE" , SERIES_NAME AS "车系名称", MODEL_CODE AS "车型CODE", MODEL_NAME AS "车型名称", COL_CODE AS "颜色CODE", COL_NAME AS "颜色名称" , DEPLOY_CODE AS "配置CODE", DEPLOY_NAME AS "配置名称", CLUE_SORT AS "线索类型", CLUE_SOURCE_1_NAME AS "一级线索来源", CLUE_SOURCE_2_NAME AS "二级线索来源" , DATA_TYPE AS "数据类型(指标类型)", DAY_SUM AS "日数据", WEEK_SUM AS "周数据", MON_SUM AS "月数据", YEAR_SUM AS "年数据" , DAY30_SUM AS "滚动30天数据", MON_START_SAL_DAY30_SUM AS "近30天月初数据", MOM_WEEK_SUM AS "周环期", MOM_MON_SUM AS "月环期", MON_TARGET AS "月目标" , MON_START_SUM AS "月初值", ANNUAL_ACCUMULAT AS "累计值", QCZJ_RANK AS "汽车之家排名", YC_RANK AS "易车排名", DAYS_OF_MON AS "当月天数" , DAYS_OF_LAS_MON AS "上月天数", PART_DT AS "分区时间", if(DATA_TYPE == '订单' & PERIOD_DATE==date '2023-02-28'){MON_TARGET}else{0} AS "当月订单目标"FROM (select COL_NAME, YC_RANK, DEPLOY_CODE, PERIOD_QUARTER, PROVINCE_CODE, DAY_SUM, PERIOD_WID, SOURCE_CODE, PART_DT, MON_TARGET, YEAR_SUM, ANNUAL_ACCUMULAT, MOM_MON_SUM, DAYS_OF_MON, DATA_TYPE, MON_SUM, MON_START_SAL_DAY30_SUM, REGION_NAME_NEW, CITY_CODE, MODEL_NAME, DAYS_OF_LAS_MON, PERIOD_YEAR, QCZJ_RANK, SERIES_CODE, COL_CODE, MOM_WEEK_SUM, BUSINESS_DIVISION, PROVINCE_NAME, CLUE_SOURCE_2_NAME, PERIOD_WEEK, CLUE_SORT, MON_START_SUM, SERIES_NAME, DEPLOY_NAME, CLUE_SOURCE_1_NAME, PERIOD_MONTH, CITY_NAME, PERIOD_DATE, DAY30_SUM, REGION_CODE_NEW, MODEL_CODE, WEEK_SUM from DMR.DMR_SAL_QXC_DAILY_PAPER_DLY ) SUB_QRYWHERE SERIES_NAME = '长安览拓者' LIMIT 5000": java.sql.SQLException: java.io.IOException: Encountered "= =" at line 9, column 63.Was expecting one of: ")" ... "ORDER" ... "LIMIT" ... "OFFSET" ... "FETCH" ... "," ... "=>" ... "." ... "NOT" ... "IN" ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "UNION" ... "INTERSECT" ... "EXCEPT" ... "MINUS" ... "=" "SOME" ... "=" "ANY" ... "=" "ALL" ... "BETWEEN" ... "LIKE" ... "SIMILAR" ... "=" "+" ... "=" "-" ... "=" "NOT" ... "=" "EXISTS" ... "="
... "=" ... "=" ... "=" ... "=" ... "=" ... "=" ... "=" "TRUE" ... "=" "FALSE" ... "=" "UNKNOWN" ... "=" "NULL" ... "=" ... "=" ... "=" ... "=" "DATE" ... "=" "TIME" ... "=" "TIMESTAMP" ... "=" "INTERVAL" ... "=" "?" ... "=" "CAST" ... "=" "EXTRACT" ... "=" "POSITION" ... "=" "CONVERT" ... "=" "TRANSLATE" ... "=" "OVERLAY" ... "=" "FLOOR" ... "=" "CEIL" ... "=" "CEILING" ... "=" "SUBSTRING" ... "=" "TRIM" ... "=" "CLASSIFIER" ... "=" "MATCH_NUMBER" ... "=" "RUNNING" ... "=" "PREV" ... "=" "NEXT" ... "=" ... "=" "MULTISET" ... "=" "ARRAY" ... "=" "PERIOD" ... "=" "SPECIFIC" ... "=" ... "=" ... "=" ... "="
... "=" ... "=" "ABS" ... "=" "AVG" ... "=" "CARDINALITY" ... "=" "CHAR" ... "=" "CHAR_LENGTH" ... "=" "CHARACTER_LENGTH" ... "=" "COALESCE" ... "=" "COLLECT" ... "=" "COVAR_POP" ... "=" "COVAR_SAMP" ... "=" "CUME_DIST" ... "=" "COUNT" ... "=" "CURRENT_DATE" ... "=" "CURRENT_TIME" ... "=" "CURRENT_TIMESTAMP" ... "=" "DENSE_RANK" ... "=" "ELEMENT" ... "=" "EXP" ... "=" "FIRST_VALUE" ... "=" "FUSION" ... "=" "GROUPING" ... "=" "HOUR" ... "=" "LAG" ... "=" "LEAD" ... "=" "LEFT" ... "=" "LAST_VALUE" ... "=" "LN" ... "=" "LOCALTIME" ... "=" "LOCALTIMESTAMP" ... "=" "LOWER" ... "=" "MAX" ... "=" "MIN" ... "=" "MINUTE" ... "=" "MOD" ... "=" "MONTH" ... "=" "NTILE" ... "=" "NULLIF" ... "=" "OCTET_LENGTH" ... "=" "PERCENT_RANK" ... "=" "POWER" ... "=" "RANK" ... "=" "REGR_SXX" ... "=" "REGR_SYY" ... "=" "RIGHT" ... "=" "ROW_NUMBER" ... "=" "SECOND" ... "=" "SQRT" ... "=" "STDDEV_POP" ... "=" "STDDEV_SAMP" ... "=" "SUM" ... "=" "UPPER" ... "=" "TRUNCATE" ... "=" "USER" ... "=" "VAR_POP" ... "=" "VAR_SAMP" ... "=" "YEAR" ... "=" "CURRENT_CATALOG" ... "=" "CURRENT_DEFAULT_TRANSFORM_GROUP" ... "=" "CURRENT_PATH" ... "=" "CURRENT_ROLE" ... "=" "CURRENT_SCHEMA" ... "=" "CURRENT_USER" ... "=" "SESSION_USER" ... "=" "SYSTEM_USER" ... "=" "NEW" ... "=" "CASE" ... "=" "CURRENT" ... "=" "CURSOR" ... "=" "ROW" ... "=" "(" ... "[" ... "IS" ... "(" ...”
作者:
yhdata_ruby
时间:
2023-2-28 15:19
使用的什么版本,是数据集写的还是制作报告界面啊
欢迎光临 永洪社区 (https://club.yonghongtech.com/)
Powered by Discuz! X3.4