我正在创建一个用于存储查询结果的外部表。下面是查询和错误消息。
hive> create external table result_teamquery1(teamname string,count int) row
format delimited fields terminated by '\t' stored as textfile location
'/home/biadmin/location/result_teamquery1’;
MismatchedTokenException(15!=286)
at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617)
FAILED: ParseException line 1:143 mismatched input '/' expecting StringLiteral near 'location' in table location specification
我尝试了许多现有的解决方案,如“hive create table query上的mismatchedtokenexception”,但都不起作用。
暂无答案!
目前还没有任何答案,快来回答吧!