Hive No partition predicate found for Alias xxx 解决方案
来源:互联网 发布:猴王竞猜网站源码 编辑:程序博客网 时间:2024/05/17 07:04
No partition predicate found for Alias "b" Table "user_browse_region"
在Hive中联表查询,数据量比较大,对一个表指定了分区字段,而另一个是放到联表查询的条件,导致报错。
出错的sql:
select count(a.user_id), count(distinct a.user_id) from ugc_action_raw a join user b on a.user_id=b.id join user_browse_region c on a.user_id=c.id and a.log_date=c.log_date where a.ugc_type=0 and b.gender='男生' and b.stage='20' and c.region='北京' and a.log_date='2012-09-11';
原因分析:没有对c表指定分区字段。
解决方案:联表查询的条件中去掉a.log_date=c.log_date,在后面的where语句中加上c.log_date='2012-09-11';
正确的sql:
select count(a.user_id), count(distinct a.user_id) from ugc_action_raw a join user b on a.user_id=b.id join user_browse_region c on a.user_id=c.id where a.ugc_type=0 and b.gender='男生' and b.stage='20' and c.region='北京' and a.log_date='2012-09-11' and c.log_date='2012-09-11';
- Hive No partition predicate found for Alias xxx 解决方案
- No suitable driver found for jdbc:XXX
- No typehandler found for property XXX
- No outbound converter found for XXX
- No property sql found for type xxx.xxx.entity.UserdefinedGroup
- No tab content FrameLayout found for id xxx
- No resource identifier found for attribute 'showAsAction' in package 'XXX'
- No mapping found for HTTP request with URI [XXX]
- hive 权限:Authorization failed:No privilege 'Create' found for outputs
- 自定义View XML文件出现No resource identifier found for attribute 'xxx' in package 'xxx.xxx.xxx'错误
- No manual entry for xxx 错误的解决方案
- No configuration found for the specified action: 'xxx/xxx.action' in namespace: ''. Form action def
- Android自定义View:No resource identifier found for attribute ‘XXX’ in package ‘XXX‘
- android自定义View时报 error: No resource identifier found for attribute ‘XXX’ in package 'XXX'
- No qualifying bean of type [XXX.XXX] found for dependency 解决方法
- android自定义View时报 error: No resource identifier found for attribute ‘XXX’ in package 'XXX'
- log4j:WARN No appenders could be found for logger 解决方案
- log4j:WARN No appenders could be found for logger 解决方案
- 雁过也,月满西楼
- 【小技巧】ORA-12638: 身份证明检索失败解决方法
- 分享使用Box2D和Cocos2D制作弹球游戏的方法
- Domino控制台命令大全
- Webkit for Android分析
- Hive No partition predicate found for Alias xxx 解决方案
- 5个最好用的GIF制作软件
- DSP开发入门学习
- Android Spiner 添加与删除数据
- 写正确函数需要注意的地方:奇偶数分开,左边偶数,右边奇数。
- shell 调用函数 case
- dz 论坛x2.5爆路径 利用
- ld.so.1: test: fatal: libstdc++.so.6: open failed: No such file or directory.
- 静静的在心里承受所有的伤痛和不快乐