运行Spark SQL报错

1.Spark SQL报错处理

Exception in thread "main" org.apache.spark.sql.catalyst.parser.ParseException: 
mismatched input '(' expecting {<EOF>, ',', 'WHERE', 'GROUP', 'ORDER', 'HAVING', 'LIMIT', 'JOIN', 'CROSS', 'INNER', 'LEFT', 'RIGHT', 'FULL', 'NATURAL', 'LATERAL', 'WINDOW', 'UNION', 'EXCEPT', 'MINUS', 'INTERSECT', 'SORT', 'CLUSTER', 'DISTRIBUTE', 'ANTI'}(line 6, pos 5)

更换下pom.xml中

<spark.version>2.1.1</spark.version>

改为
<spark.version>2.4.4</spark.version>
即可。