[root@dub-vcd-vms165 ~]# impala-shell
Starting Impala Shell without Kerberos authentication
Connected to XXXXXX
Server version: impalad version cdh5-1.3.0 RELEASE (build 40e1b62cf0b97f666d084d9509bf9639c575068c)
Welcome to the Impala shell. Press TAB twice to see a list of available commands.
Copyright (c) 2012 Cloudera, Inc. All rights reserved.
(Shell build version: Impala Shell vcdh5-1.3.0 (40e1b62) built on Tue Mar 25 13:46:44 PDT 2014)
[XXXXXX:21000] > select * from foo;
Query: select * from foo
+----+-----------+
| id | msg |
+----+-----------+
| 1 | message 1 |
+----+-----------+
Returned 3 row(s) in 0.62s
[XXXXXX:21000] >
1条答案
按热度按时间46scxncf1#
使用impalaservice.jar,您可以发送一条insert语句,例如:
然后,可以通过以下方式使用impalaservice.jar检查结果:
或者使用 Impala 壳:
注意:如果要插入多个数据,则可以将impalaservice.jar修改为更详细的解决方案,通过使用参数指定包含要插入的所有记录的数据源来执行多个insert语句。
参考文献1:https://github.com/pauldeschacht/impala-java-client
参考文献2:https://github.com/pauldeschacht/impala-java-client/blob/master/test/src/org/impalaconnecttest.java