1 hive sql 是以;作为语句分割的
select split("a;b;c","\;");该语句进行语法解析时,会识别为select split("a; 这样就会导致sql不完整,报以下错误:
FAILED: ParseException line 1:15 cannot recognize input near 'a' '<EOF>' '<EOF>' in select expression
2 解决方案,保持语句的完整性:
select split("a\;b\;c","\;");
结果:["a","b","c"]