hive执行遇到报错
SQLStateSQLExceptionTranslator#doTranslate()_96 | Extracted SQL state class '42' from value '42000'
如果你不小心使用了下面关键词,会报错
关键词参考下面:
https://blog.csdn.net/weixin_34221036/article/details/92581323
Extracted SQL state class '42' from value '42000' ,这个错误是 with tmp as() 后面加了;
解决方法:删除掉后面的; 就可