Impala批量插入数据出现空格问题

常用语句记录

impala insert values 批量插入出现空格

出现空格(password的两个值长度不一样 导致666666那个会出现空格)

UPSERT
into user ( name, password )
VALUES ('admin','666666'),('xiaobu','88888888')

正常

UPSERT
UPSERT
into user ( name, password )
VALUES ("admin","666666"),("xiaobu","88888888")

解决方法：

<insert id="upsertList">
        upsert into user (
        <include refid="Base_Column_List"/>
        )
        values
        <foreach collection="list" item="item" index="index" separator=",">
            (
            "${item.name}",
            "${item.password}"
            <!-- 
#{item.name,jdbcType=VARCHAR},
#{item.password,jdbcType=VARCHAR}-->
)
</
foreach
>
</
insert
>