impala使用
来源:互联网 发布:java.lang.object 编辑:程序博客网 时间:2024/05/21 18:53
1.登陆
impala-shell -i cslave1
2.refresh
refresh table_name:当有文件更新时
INVALIDATE METADATA;当有刚创建的表
3.中文code不支持问题
impala-shell -i cslave1
[cslave1:21000] >select count(1) from s_trade where receiver_name = '李丹';
Unknown Exception : 'ascii' codec can't encode characters in position: ordinal not in range
官方issue https://issues.cloudera.org/browse/IMPALA-607
解决:
vim /usr/lib/impala-shell/impala_shell.py
def do_select(self, args):
"""Executes a SELECT... query, fetching all rows"""
return self.__execute_query(self.__create_beeswax_query("select %s" % args))
修改成:
def do_select(self, args):
"""Executes a SELECT... query, fetching all rows"""
return self.__execute_query(self.__create_beeswax_query("select %s" %(args.encode('utf-8'),)))
修改后:
[cslave1:21000] > select count(1) from s_trade where receiver_name = '李丹';
Query: select count(1) from s_trade where receiver_name = '李丹'
+----------+
| count(1) |
+----------+
| 822 |
+----------+
Returned 1 row(s) in 1.62s
impala-shell -i cslave1
2.refresh
refresh table_name:当有文件更新时
INVALIDATE METADATA;当有刚创建的表
3.中文code不支持问题
impala-shell -i cslave1
[cslave1:21000] >select count(1) from s_trade where receiver_name = '李丹';
Unknown Exception : 'ascii' codec can't encode characters in position: ordinal not in range
官方issue https://issues.cloudera.org/browse/IMPALA-607
解决:
vim /usr/lib/impala-shell/impala_shell.py
def do_select(self, args):
"""Executes a SELECT... query, fetching all rows"""
return self.__execute_query(self.__create_beeswax_query("select %s" % args))
修改成:
def do_select(self, args):
"""Executes a SELECT... query, fetching all rows"""
return self.__execute_query(self.__create_beeswax_query("select %s" %(args.encode('utf-8'),)))
修改后:
[cslave1:21000] > select count(1) from s_trade where receiver_name = '李丹';
Query: select count(1) from s_trade where receiver_name = '李丹'
+----------+
| count(1) |
+----------+
| 822 |
+----------+
Returned 1 row(s) in 1.62s
0 0
- impala使用
- 什么是impala,如何安装使用Impala
- Impala实践之十五:Impala使用文档
- 今天开始使用impala
- Impala 使用的端口
- impala简单使用
- Impala原理、使用
- Impala Shell使用
- impala
- IMPALA
- impala
- Impala
- Impala
- Impala
- impala
- Impala
- Impala
- Impala 表使用 Parquet 文件格式
- eclipse debug cannot connect to VM
- hive hive.optimize.ppd=false导致map数量很大
- C语言基础
- 【Web前端】HTML常用标签及其全称
- leetcode: 单链表之Add Two Numbers
- impala使用
- Linux lspci查看硬件设备
- MongoDB性能篇之索引分析
- Linux下添加新硬盘,分区及挂载
- hive执行时找不到文件
- 小白被绊倒了,小白不哭,站起来撸
- Nanopi2 GPIO学习心得
- 根据分页的当前页和页数得到开始条数和结尾条数
- java.lang.OutOfMemoryError: unable to create new native thread