not recognize input near 'row' 'format' 'delimited' in select clause
来源:互联网 发布:mac安装ps软件教程 编辑:程序博客网 时间:2024/05/22 06:53
在使用hive出现如下的问题:
hive> insert overwrite local directory '/opt/data/traindata' row format delimited fields terminated by '\t' select * from dw_rcm_hitop_prepare2train_dm;
FAILED: Parse Error: line 1:55 cannot recognize input near 'row' 'format' 'delimited' in select clause
问题原因:
这里使用的是hive-0.9.0.tar,原来是该版本没有这个功能;
在Hive0.11.0 才有的新功能:当用户将hive查询结果输出到文件,用户可以指定列的分割,而在之前的版本是不能制动列之间的分隔符
阅读全文
0 0
- not recognize input near 'row' 'format' 'delimited' in select clause
- hive -e "show tables"提示cannot recognize input near 'show' '<EOF>' '<EOF>' in ddl statement
- hive -e "show tables"提示cannot recognize input near 'show' '<EOF>' '<EOF>' in ddl statement
- Input string was not in a correct format. 错误解析
- SELECT list is not in GROUP BY clause and contains nonaggregated column
- jdbc4.MySQLSyntaxErrorException:Expression #2 of SELECT list is not in GROUP BY clause and contains
- MySQL: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column '
- Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.
- hive FAILED: ParseException line 1:814 cannot recognize input near ‘;’ <EOF>’
- hive 建表报错:ParseException - cannot recognize input near 'end' 'string'
- aggregates not allowed in where clause
- #1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this i
- [mysql] Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lo
- MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”
- MySQL: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sss
- ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
- Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
- mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
- Faster R-CNN训练问题解决:py-faster-rcnn/lib/datasets/imdb.py问题
- 非监督特征学习与深度学习(十一)----优化方法:随机梯度下降
- C#回顾学习笔记三十一:抽象类与抽象方法
- ubuntu16.14安装中文教程
- Leetcode之Search a 2D Matrix 问题
- not recognize input near 'row' 'format' 'delimited' in select clause
- 5课:单片机延时程序分析
- 使用Rancher 安装K8S
- Reverse Nodes in k-Group
- CentOS7上TFTP服务器简单搭建
- 网站处于联机状态,但未对连接尝试做出响应解决方案
- 贝塞尔曲线收录: 五,镂空效果的View+蒙版
- windows 下wav采集音频
- Redis集群启动异常