sql—如何在向配置单元表中插入数据时转义html代码数据

qoefvg9y 于 2021-06-25 发布在 Hive

关注(0)|答案(1)|浏览(326)

我需要将数据插入到我的一个表列中，该列具有特殊字符，如<>-。。。。。所以我给出了\这是用作每个文本转义字符的
这是我要插入的“简介”一栏的数据。数据来自csv文件，其中所有数据都用双引号括起来

"<p><span style=""font-family: \'Calibri Light\': sans-serif\; font-size: xx-large\; color: #2184c2\;""><span style=""font-size: 28pt\;""><span style=""font-size: x-large\;""><span style=""font-size: 18pt\;""><strong>Help us improve by taking our short satisfaction survey.&nbsp\;</strong></span></span></span></span></p>"

当我试图插入这个数据，我得到下面的错误。

AnalysisException: Syntax error in line 1:\n...","","<p><span style="font-family: \\\\\'Calibri Light\\\\\'...\n                             ^\nEncountered: -\nExpected: CROSS, FROM, FULL, GROUP, HAVING, INNER, JOIN, LEFT, LIMIT, OFFSET, ON, ORDER, RIGHT, STRAIGHT_JOIN, TABLESAMPLE, UNION, USING, WHERE, COMMA\n\nCAUSED BY: Exception: Syntax error\n (110) (SQLExecDirectW)')

日志类型-信息日志
有人能帮我把这种数据插入表格吗

sql Hive impala

来源：https://stackoverflow.com/questions/59150553/how-to-escape-html-code-data-while-inserting-data-into-a-table-of-hive

1条答案

按热度按时间

gojuced71#

分号和单引号需要使用反斜杠转义：

create table test_str as select '<p><span style=""font-family: \'Calibri Light\', sans-serif\; font-size: xx-large\; color: #2184c2\;""><span style=""font-size: 28pt\;""><span style=""font-size: x-large\;""><span style=""font-size: 18pt\;""><strong>Help us improve by taking our short satisfaction survey&nbsp\;</strong></span></span></span></span></p>';

 select * from test_str;

结果：

<p><span style=""font-family: 'Calibri Light', sans-serif; font-size: xx-large; color: #2184c2;""><span style=""font-size: 28pt;""><span style=""font-size: x-large;""><span style=""font-size: 18pt;""><strong>Help us improve by taking our short satisfaction survey&nbsp;</strong></span></span></span></span></p>

赞(0）回复(0）举报 2021-06-26

我来回答

sql—如何在向配置单元表中插入数据时转义html代码数据

1条答案

相关问题

热门标签

最新问答