当前使用版本(必填,否则不予处理)

com.baomidou mybatis-plus-boot-starter 3.4.3.4

该问题是如何引起的？(确定最新版也有问题再提!!!)

Phoenix 插入是 unset 但是当我用mybatisplus 的插入时出现以下错误 ERROR 601 (42P00): Syntax error. Encountered "INSERT" at line 1, column 1. 官网说的是支持Phoenix

重现步骤(如果有就写完整)

List phoenixDbDataList = new ArrayList<>(); for (Map dto : result.getMappedResults()) { System.out.println(JSON.toJSONString(dto)); TruckTrack phoenixDbData = JSON.parseObject(JSON.toJSONString(dto), TruckTrack.class); phoenixDbDataList.add(phoenixDbData); } truckTrackService.saveOrUpdateBatch(phoenixDbDataList);

报错信息

Error updating database. Cause: org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered "INSERT" at line 1, column 1.

The error may exist in com/hxql/collectdata/mapper/TruckTrackMapper.java (best guess)

The error may involve com.hxql.collectdata.mapper.TruckTrackMapper.insert

The error occurred while executing an update

SQL: INSERT INTO HXQL_CAR_TRACK1 ( vcl_n, latd, lond, spd, mlg, hgt, agl, g_iso_tm_stamp ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? )

Cause: org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered "INSERT" at line 1, column 1.

; bad SQL grammar []; nested exception is org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered "INSERT" at line 1, column 1.

Comment From: miemieYaho

默认注入的sql只支持标准语法,各种数据库的支持只是在分页上