hadoop - pig FILTER ERROR 1000: Error during parsing. Encountered
问题描述
This script working fine
data1 = LOAD '/user/maria_dev/ml-100k/test/u3.data' AS (usesrID:int, movieID:int, rating:int, ratingTime:int);
DUMP data1;
When i used FILTER then PIG through error
data1 = LOAD '/user/maria_dev/ml-100k/test/u3.data' AS (usesrID:int, movieID:int, rating:int, ratingTime:int);
filterRowData1=filter data1 by (int)movieID == 556;
DUMP filterRowData1;
Error screen-shot Error Detail:
2018-10-20 23:20:24,653 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1000: Error during parsing. Encountered " "filterRowData1=filter "" at line 2, column 1.
I have also tried
data1 = LOAD '/user/maria_dev/ml-100k/test/u3.data' AS (usesrID:int, movieID:int, rating:int, ratingTime:int);
filterRowData1=filter data1 by movieID == 556; (i have tried: '556'; but no luck)
DUMP filterRowData1;
解决方案
filterRowData1 = filter data1 by movieID == 556;
you should space between alias name and query.
推荐阅读
- c++ - MSVC 下运算符 new 上的未知 C++ 异常
- user-interface - 如何在 Flutter 的 NestedScrollView 中设置 SliverAppBar 的最小高度
- python - 当主线程调用 sys.exit() 时,守护线程是否被杀死?
- maven - 为什么我需要在 jar 文件中查找未包含在 maven pom.xml 文件中的类?
- php - Cron 命令在给定的 url 上运行控制器功能?
- javascript - 如何确保命令序列按顺序运行(jQuery 中的超时问题 - Qualtrics)
- java - 如何在 webssoprofileoption 中将 forceAuthn 设置为 true?
- c# - 如何使用 IEqualityComparer 加快多个字段的比较?
- webpack - 带有popper的引导工具提示无法通过webpack工作
- macos - 无法启动为 App Store 提交上传的 MAC 应用程序