
impala
duncanboy
这个作者很懒,什么都没留下…
展开
-
Impala ODBC 安装笔记
Impala在线文档介绍了 Impala ODBC接口安装和配置http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/latest/Impala/Installing-and-Using-Impala/ciiu_impala_odbc.htmlImpala ODBC 驱动下载地址:http://www.cloud...原创 2015-05-13 10:44:17 · 376 阅读 · 0 评论 -
impala数据插入的方法详解
_snappy select * from raw_text_data;Inserted 1000000000 rows in 181.98s 2、CTAS [slave12:21000] > create table test_table STORED AS PARQUET as select * from table;Query: create table test_table STORED AS PARQUET as select * from table+---2015-11-19 10:38:47 · 1076 阅读 · 0 评论 -
impala和hive shell下退格键出现 ^H的解决方法
ng Impala Shell without Kerberos authenticationConnected to slave1:21000Server version: impalad version cdh5-1.3.0 RELEASE (build 40e1b62cf0b97f666d084d9509bf9639c575068c)Welcome to the Impala shell. Press TAB twice to see a list of available command2015-09-16 17:52:32 · 198 阅读 · 0 评论 -
impala jdbc方式连接报java.sql.SQLException: Error: Error: could not match input解决方法
e.jdbc.Utils.verifySuccess(Utils.java:159) at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:147) at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:182) at org.apache.hive.jdbc.HiveStatement.executeQue2015-09-14 15:56:56 · 1101 阅读 · 0 评论 -
Impala ODBC 安装笔记
ODBC 驱动下载地址:http://www.cloudera.com/content/support/en/downloads/connectors.html本文详细讲解了CentOS-6.5-x86_64环境下 Impala ODBC的安装和使用。 一、检查unixODBC是否安装:rpm -qa|grep unixODBC如果没有安装,使用下面的命令安装: yum install unixODBC yum install unixODBC-devel使用原创 2015-05-13 10:44:17 · 441 阅读 · 0 评论 -
ERROR: Couldn't open transport for host.impala:26000(connect() failed: Connectio
[size=large] 今天impala集群在执行:invalidate metadata;时,报ERROR: Couldn't open transport for host.impala:26000(connect() failed: Connection refused) 经过分析后,发现主节点的catalog服务已经停了,没启动,service impala-catalo...2017-05-01 20:32:52 · 3051 阅读 · 0 评论 -
impala数据插入的方法详解
impala是一种内存计算的数据库,查询性能相比于hive官网称是快100倍,其向表中插入数据的方法如下: 1、insert into[slave12:21000] > insert into parquet_snappy select * from raw_text_data;Inserted 1000000000 rows in 181.98s 2、CTAS...2015-11-19 10:38:47 · 8006 阅读 · 0 评论 -
impala和hive shell下退格键出现 ^H的解决方法
通过impala-shell 连接到impala shell命令下是,输入命令要删除字符时会出现 ^H字符,而不能真正删除,如下所示: [await]mqq@192.168.10.1:~$ impala-shellStarting Impala Shell without Kerberos authenticationConnected to slave1:21000Ser...2015-09-16 17:52:32 · 458 阅读 · 0 评论 -
impala jdbc方式连接报java.sql.SQLException: Error: Error: could not match input解决方法
今天写了个程序通过jdbc的方式去连接impala,访问库里的数据时遇到如下错误: java.sql.SQLException: Error: Error: could not match input at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:159) at org.apache.h...2015-09-14 15:56:56 · 1587 阅读 · 0 评论 -
ERROR: Couldn't open transport for host.impala:26000(connect() failed: Connectio
2017-05-01 20:32:52 · 500 阅读 · 0 评论