异常行1:143不匹配的输入“/”,在表位置规范的“location”附近需要stringliteral

vqlkdk9b  于 2021-05-29  发布在  Hadoop
关注(0)|答案(0)|浏览(627)

我正在创建一个用于存储查询结果的外部表。下面是查询和错误消息。

  1. hive> create external table result_teamquery1(teamname string,count int) row
  2. format delimited fields terminated by '\t' stored as textfile location
  3. '/home/biadmin/location/result_teamquery1’;
  4. MismatchedTokenException(15!=286)
  5. at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617)
  6. FAILED: ParseException line 1:143 mismatched input '/' expecting StringLiteral near 'location' in table location specification

我尝试了许多现有的解决方案,如“hive create table query上的mismatchedtokenexception”,但都不起作用。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题