[main]- ERROR 1037 Operands of Regex can be CharArray only :(Name: Regex Type: null Uid: null)

最新推荐文章于 2024-10-01 18:52:18 发布

叫我三少爷

最新推荐文章于 2024-10-01 18:52:18 发布

阅读量602

点赞数

分类专栏： pig 文章标签： hadoop pig

本文链接：https://blog.csdn.net/charKim/article/details/77844931

版权

pig 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

以下是pig命令操作

grunt> sztdata_sub_orignal = LOAD '/datum/szt/subway/20160601' USING PigStorage(',') AS (num:chararray,id:chararray,subid:chararray,type:long,time:chararray,sub_station_line:chararray,sub_station_name:chararray,sub_num:chararray);

grunt> sztdata_sub = FILTER sztdata_sub_orignal BY type MATCHES '21';
2017-09-04 23:45:39,369 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1037:
<line 2, column 49> Operands of Regex can be CharArray only :(Name: Regex Type: null Uid: null)
Details at logfile: /state/partition1/home/wangsheng/pig_1504539913472.log
grunt> sztdata_sub_orignal = LOAD '/datum/szt/subway/20160601' USING PigStorage(',') AS (num:chararray,id:chararray,subid:chararray,type:chararray,time:chararray,sub_station_line:chararray,sub_station_name:chararray,sub_num:chararray);

grunt> sztdata_sub = FILTER sztdata_sub_orignal BY type MATCHES '21';

这是因为filter过滤函数作用的值只能是char类型的（Operands of Regex can be CharArray only ），type是long类型的

所以需要把type改成char类型的

修改之后，成功