[DRILL-453] Query on a directory throws exception

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Flow
• Assignee: Unassigned
• Reporter: Neeraja
• Created: 26/Mar/14 15:21
• Updated: 24/Apr/15 17:59
• Resolved: 29/May/14 17:47

Description

Following exception is thrown when issuing query against a directory.
The directory contained 2 files of similar schema. Queries against each single file works but query against doesn't work.
0: jdbc:drill:> select * from dfs.`/home/mapr/apache-drill-1.0.0-m2-incubating-SNAPSHOT/sample-data/fb`;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "3dc30404-99b7-4ba1-ba38-c8afb7006fb0"
endpoint {
address: "ubuntu"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line 1, column 87 ] < EigenbaseContextException:[ From line 1, column 15 to line 1, column 87 ] < SqlValidatorException:[ Table \'dfs./home/mapr/apache-drill-1.0.0-m2-incubating-SNAPSHOT/sample-data/fb\' not found ]"
]Error: exception while executing query (state=,code=0)

Issue Links

• duplicates: DRILL-405 Not able to query directory containing json files