报错：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'NaN' in 'field list'_: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerror-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_36836847/article/details/103426729

在计算留存率代码中添加条件后遇到报错：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException，原因可能是数仓事实表时间范围过短。重新生成一个月的数据并执行任务后，错误消失。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

今天只是在计算留存率的代码中添加了一个条件，结果报错如下：

Log Type: stderr
Log Upload Time: 6-Dec-2019 13:18:45
Log Length: 12549
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/data6/yarn/nm-local-dir/usercache/spark/filecache/0/3565450/__spark_libs__8210665535340896795.zip/slf4j-log4j12-1.7.16.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/app/hadoop-2.6.2/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
[Stage 0:>                                                        (0 + 0) / 847]
[Stage 0:>                                                        (0 + 8) / 847]
[Stage 0:>                                                       (1 + 11) / 847]
[Stage 0:=>                                                      (27 + 8) / 847]
[Stage 0:=====>                                                  (80 + 8) / 847]
[Stage 0:=========>                                             (152 + 8) / 847]
[Stage 0:=============>                                         (212 + 8) / 847]
[Stage 0:==================>                                    (280 + 9) / 847]
[Stage 0:========================>                              (378 + 8) / 847]
[Stage 0:=============================>                         (457 + 8) / 847]
[Stage 0:==================================>                    (528 + 8) / 847]
[Stage 0:=======================================>              (623 + 10) / 847]
[Stage 0:===============================================>       (735 + 8) / 847]
[Stage 0:=====================================================> (817 + 8) / 847]
                                                                                
[Stage 1:>                                                        (0 + 0) / 822]
[Stage 1:>                                                        (0 + 8) / 822]
[Stage 1:>                                                       (0 + 20) / 822]
[Stage 1:>                                                       (4 + 18) / 822]
[Stage 1:>                                                       (6 + 16) / 822]
[Stage 1:>                                                       (6 + 20) / 822]
[Stage 1:>                                                       (9 + 24) / 822]
[Stage 1:>                                                       (9 + 25) / 822]
[Stage 1:>                                                      (13 + 24) / 822]
[Stage 1:=>                                                     (17 + 24) / 822]
[Stage 1:=>                                                     (20 + 24) / 822]
[Stage 1:=>                                                     (23 + 24) / 822]
[Stage 1:=>                                                     (27 + 24) / 822]
[Stage 1:==>                                                    (31 + 24) / 822]
[Stage 1:==>                                                    (36 + 24) / 822]
[Stage 1:&#