关于clickghouse数据库中的Array<T>类型的数据映射，in查询时，mybatis中xml的写法

1、sql示例  sql示例  sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例sql示例(凑字数用）

SELECT
	record.dossier_id,
	argMax(record.record_id,
	record.timestamp) AS record_id,
	argMax(record.camera_id,
	record.timestamp) AS camera_id
FROM
	xx.xx record
INNER JOIN xx.xx meta on
	record.dossier_id = meta.dossier_id
WHERE
	meta.source_repos IN([ 'xx' ],[ 'xx' ])
GROUP BY
	record.dossier_id

2、java代码中xml的展示

<select id="dossierQuery"  parameterType="xx.xx" resultMap="BaseResultMap">
        SELECT
            record.dossier_id AS dossier_id,
            argMax(record.record_id,record.timestamp) AS record_id,
            argMax(record.camera_id,record.timestamp) AS camera_id
        FROM
            xx.xx record
        INNER JOIN ${databaseName}.xx meta ON
            record.dossier_id = meta.dossier_id
        WHERE
            <if test="sourceRepos!=null">
                meta.source_repos IN (
                <foreach item="item" collection="sourceRepos" separator=",">
                    ['${item}']
                </foreach>
                )
            </if>
        GROUP BY
            record.dossier_id
    </select>