hive 限制需要输出的字段
- 建表语句
CREATE TABLE `adminuser`(
`id` int,
`adminname` string,
`adminpwd` string,
`creationtime` string,
`updatetime` string,
`role` int,
`name` string,
`tel` string,
`isdelete` int,
`type` string) row format delimited fields terminated by '\001'
- 表数据
1admind58f390af7f5a4e001589cf82c6e7ed42015-12-31 12:06:04.242015-12-31 12:06:04.241管理员187515155030null
2我是医生d58f390af7f5a4e001589cf82c6e7ed42016-02-29 00:51:16.572016-02-29 00:51:16.572华佗151524630090null
318112018599e10adc3949ba59abbe56e057f20f883e2017-05-05 20:43:56.0172017-05-05 20:43:56.0173工资管理员null0工资管理员
- 设置hive
set hive.support.quoted.identifiers=None;
SELECT `(role)?+.+` FROM adminuser
- 如图所示