在hive中出现;例如以下的错误:
Error while compiling statement: FAILED: SemanticException 19:9 In strict mode, if ORDER BY is specified, LIMIT must also be specified. Error encountered near token 'id'
主要是通过在使用ORDER BY之前添加以下设置
set hive.mapred.mode=nonstrict;
在hive中出现;例如以下的错误:
Error while compiling statement: FAILED: SemanticException 19:9 In strict mode, if ORDER BY is specified, LIMIT must also be specified. Error encountered near token 'id'
主要是通过在使用ORDER BY之前添加以下设置
set hive.mapred.mode=nonstrict;