hive show locks 哪个query

、导本文件系统

1
　　
2
hive> insert overwrite local directory '/home/wyp/wyp'
3
> select * from wyp;
　　条HQL执行需要启用Mapreduce完运行完条语句本文件系统/home/wyp/wyp目录文件文件Reduce产结（文件名000000_0）我看看文件内容：

1
[wyp@master ~/wyp]$ vim 000000_0
2
5^Awyp1^A23^A131212121212
3
6^Awyp2^A24^A134535353535
4
7^Awyp3^A25^A132453535353
5
8^Awyp4^A26^A154243434355
6
1^Awyp^A25^A13188888888888
7
2^Atest^A30^A13888888888888
8
3^Azs^A34^A899314121
看wyp表所数据数据列与列间隔符^A(ascii码\00001)

　　导入数据Hive能用insert into数据导：
查看源代码打印帮助
01
　　
02
hive> insert into local directory '/home/wyp/wyp'
03
> select * from wyp;
04
NoViableAltException(79@[])
05
at org.apache.hadoop.hive.ql.parse.HiveParser_SelectClauseParser.selectClause(HiveParser_SelectClauseParser.java:683)
06
at org.apache.hadoop.hive.ql.parse.HiveParser.selectClause(HiveParser.java:30667)
07
at org.apache.hadoop.hive.ql.parse.HiveParser.regular_body(HiveParser.java:28421)
08
at org.apache.hadoop.hive.ql.parse.HiveParser.queryStatement(HiveParser.java:28306)
09
at org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpression(HiveParser.java:28100)
10
at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1213)
11
at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:928)
12
at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:190)
13
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:418)
14
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:337)
15
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:902)
16
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
17
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
18
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
19
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:756)
20
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
21
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
22
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
23
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
24
at java.lang.reflect.Method.invoke(Method.java:597)
25
at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
26
FAILED: ParseException line 1:12 missing TABLE at 'local' near 'local' in select clause
27
line 1:18 cannot recognize input near 'directory' ''/home/wyp/wyp''

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/f2yx3rvf7x2272ffxe.html