[HIVE-3488] Issue trying to use the thick client (embedded) from windows.

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 0.8.1
• Component/s: Windows
• Assignee: Unassigned
• Reporter: Rémy DUBOIS
• Created: 19/Sep/12 15:20
• Updated: 31/Oct/15 13:46

Description

I'm trying to execute a very simple SELECT query against my remote hive server.

If I'm doing a SELECT * from table, everything works well. If I'm trying to execute a SELECT name from table, this error appears:

Job Submission failed with exception 'java.io.IOException(cannot find dir = /user/hive/warehouse/test/city=paris/out.csv in pathToPartitionInfo: [hdfs://cdh-four:8020/user/hive/warehouse/test/city=paris])'
12/09/19 17:18:44 ERROR exec.Task: Job Submission failed with exception 'java.io.IOException(cannot find dir = /user/hive/warehouse/test/city=paris/out.csv in pathToPartitionInfo: [hdfs://cdh-four:8020/user/hive/warehouse/test/city=paris])'
java.io.IOException: cannot find dir = /user/hive/warehouse/test/city=paris/out.csv in pathToPartitionInfo: [hdfs://cdh-four:8020/user/hive/warehouse/test/city=paris]
	at org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.getPartitionDescFromPathRecursively(HiveFileFormatUtils.java:290)
	at org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.getPartitionDescFromPathRecursively(HiveFileFormatUtils.java:257)
	at org.apache.hadoop.hive.ql.io.CombineHiveInputFormat$CombineHiveInputSplit.<init>(CombineHiveInputFormat.java:104)
	at org.apache.hadoop.hive.ql.io.CombineHiveInputFormat.getSplits(CombineHiveInputFormat.java:407)
	at org.apache.hadoop.mapred.JobClient.writeOldSplits(JobClient.java:989)
	at org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:981)
	at org.apache.hadoop.mapred.JobClient.access$500(JobClient.java:170)
	at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:891)
	at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:844)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Unknown Source)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1232)
	at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:844)
	at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:818)
	at org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:452)
	at org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:136)
	at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:133)
	at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
	at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1332)
	at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1123)
	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:931)
	at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:191)
	at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187)

Indeed, this "dir" (/user/hive/warehouse/test/city=paris/out.csv) can't be found since it deals with my data file, and not a directory.

Could you please help me?