hadoop 中hive查询表时出现无法使用mayreduce job任务 错误
来源:互联网 发布:2014年上证指数数据 编辑:程序博客网 时间:2024/04/28 03:08
hadoop中使用hive+mysql 对表进行查询时,只能全表查询,不能对查询显示部分列。希望大虾们能给出解决办法,具体如下:
1 使用 select * from student; 正常
hive> select * from student;
OK
1 lisi computer 034
2 zhangsan computer 034
3 wangwu computer 034
4 zhaoliu computer 034
5 wangli computer 034
6 wangliying computer 034
7 wp physics 034
8 zxm physics 034
9 ljz physics 034
10 cds physics 034
11 mac physics 034
12 android physics 034
13 symbian physics 034
14 wp physics 034
Time taken: 0.749 seconds
2 使用hive> select id,name from student; 异常
报错如下:
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
java.io.FileNotFoundException: File1 file:/home/GuoYunling-Andy/hadoop/hive/hive-0.9.0/lib/hbase-0.92.0.jar does not exist.
at org.apache.hadoop.fs.RawLocalFileSystem.getFileStatus(RawLocalFileSystem.java:407)
at org.apache.hadoop.fs.FilterFileSystem.getFileStatus(FilterFileSystem.java:251)
at org.apache.hadoop.fs.FileUtil.copy(FileUtil.java:213)
at org.apache.hadoop.fs.FileUtil.copy(FileUtil.java:163)
at org.apache.hadoop.mapred.JobClient.copyRemoteFiles(JobClient.java:627)
at org.apache.hadoop.mapred.JobClient.copyAndConfigureFiles(JobClient.java:730)
at org.apache.hadoop.mapred.JobClient.copyAndConfigureFiles(JobClient.java:655)
at org.apache.hadoop.mapred.JobClient.access$300(JobClient.java:174)
at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:865)
at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:850)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1093)
at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:850)
at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:824)
at org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:435)
at org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:137)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1326)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1118)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
Job Submission failed with exception 'java.io.FileNotFoundException(File1 file:/home/GuoYunling-Andy/hadoop/hive/hive-0.9.0/lib/hbase-0.92.0.jar does not exist. )'
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask
希望大虾们能帮忙解决下!
- hadoop 中hive查询表时出现无法使用mayreduce job任务 错误
- hadoop运行job任务出现异常
- hadoop调度程序时出现“Error opening job jar”错误
- hive错误 show tables 无法使用 : Unable to instantiate rg.apache.hadoop.hive.metastore.HiveMetaStoreClient
- hive中出现rg.apache.hadoop.hive.ql.exec.mr.MapRedTask错误
- Hadoop集群中使用Hive查询报错
- 在使用windows调用Hadoop 错误 /bin/bash: line 0: fg: no job control一般解决方法[将windows中的任务提交到linux中出错]
- Hadoop Job在集群上运行出现“Error initializing”错误
- 关于使用hive删除表时出现的return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException
- Hadoop中作业(job)、任务(task)和task attempt
- 如何使用 Hadoop 提升 Hive 查询性能
- windows Hadoop在Eclipse中使用出现的错误
- 使用eclipse远程hive时出现的错误大汇总
- 执行job时出现错误ORA-08102
- hadoop namenode 修改host后 hive无法查询
- Mongo Hadoop Connector使用过程中,hive查询where不可以使用等号"="
- hadoop在运行job过程中出现了僵尸进程
- MSys中使用configure出现无法找到pr错误解决方案
- 第七周任务-用星号图体验循环结构程序设计
- Struts2文件上传(二) 深入FileUploadInterceptor
- 最简单的 Spring2.0 实例
- mfc中dialog中嵌入view
- Solaris Unix 常用命令
- hadoop 中hive查询表时出现无法使用mayreduce job任务 错误
- Excel作为数据源
- ConcurrentLinkedQueue 详解
- Extjs3 PagingToolbar下拉框分页插件
- VC操作Excel文件编程相关内容
- Android获取屏幕分辨率及DisplayMetrics简介
- 黑马程序员——交通灯管理系统代码
- .net中PNRP编程实现
- 2012网易笔试题