[ 
https://issues.apache.org/jira/browse/HIVE-3488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14983997#comment-14983997
 ] 

Dinesh commented on HIVE-3488:
------------------------------

Hi, 

I was getting similar exception trace. And quick solution to that is to not use 
default warehouse location for table i.e; "/user/hive/warehouse". 

Alter table to set location to some other directory like 
'hdfs://localhost:8888/user/youruser/hive/test'. 

This might help you. Please let me know if it works.

Thanks

> Issue trying to use the thick client (embedded) from windows.
> -------------------------------------------------------------
>
>                 Key: HIVE-3488
>                 URL: https://issues.apache.org/jira/browse/HIVE-3488
>             Project: Hive
>          Issue Type: Bug
>          Components: Windows
>    Affects Versions: 0.8.1
>            Reporter: Rémy DUBOIS
>            Priority: Critical
>
> 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:
> {code:java}
> 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)
> {code}
> 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?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to