spark配置log4j问题

最新推荐文章于 2023-11-23 21:23:37 发布

皓月青风

最新推荐文章于 2023-11-23 21:23:37 发布

阅读量708

点赞数

分类专栏： Mysql数据库

本文链接：https://blog.csdn.net/YueQingFeng445/article/details/83831959

版权

Mysql数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

报错：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'javax.inject.Inject' annotation found and supported for autowiring','')' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'javax.inject.Inject' annotation found and supported for autowiring','')' at line 1

先安装apt-get install tcpdump

然后抓取数据库的包：tcpdump -A -i eth0 host 10.66.163.189 and tcp port 3306

查找原因发现问题

INSERT INTO spark_logs(project_name,create_date,level,category,file_name,thread_name,line,all_category,message,ip)values('mesReachStat','2018-11-07 21:00:29','INFO','org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor','AutowiredAnnotationBeanPostProcessor.java','main','155','org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.<init>(AutowiredAnnotationBeanPostProcessor.java:155)','JSR-330 ''javax.inject.Inject'' annotation found and supported for autowiring','');

解决：

1，裸写SQL,如果都写单引号会出现本错

INSERT spark_logs(project_name,create_date,level,category,file_name,thread_name,line,all_category,message)values('mesReachStat','%d{yyyy-MM-dd HH:mm:ss}','%p','%c','%F','%t','%L','%l','%m')

2，需要把一些单引号的用双引号括起来（正确写法）

INSERT INTO spark_logs(project_name,create_date,level,category,file_name,thread_name,line,all_category,message,ip)values('mesReachStat','%d{yyyy-MM-dd HH:mm:ss}','%p','%c',"%F","%t","%L","%l","%m",'%X{ip}');