Getting FileNotFoundException while querying individual column from HIVE table for S3 data

Question

I have created a table in HIVE by using below statement. My input data is located in `S3(s3n://test/hiveTest/01/)`. ``` CREATE external TABLE tests3(firstName STRING, lastName STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '	' STORED AS TEXTFILE location 's3n://test/hiveTest/01/'; ``` I can see result data when i issue below command . hive> select * from tests3; OK first second third fourth Time taken: 1.647 seconds But when i do select specific column from a table gives below error hive> select firstName from tests3; 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: File does not exist: /tests3/hiveTest/01/abc.txt at org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:736) at org.apache.hadoop.mapred.lib.CombineFileInputFormat$OneFileInfo.(CombineFileInputFormat.java:462) at org.apache.hadoop.mapred.lib.CombineFileInputFormat.getMoreSplits(CombineFi…

Accepted Answer

Pleas try to set bellow parameter before query run:

```
SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
```

Getting FileNotFoundException while querying individual column from HIVE table for S3 data

Solution

Problem