[DRILL-6394] Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 17: Object '/tmp/file.dat' not found within 'dfs'

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.13.0
• Component/s: Server, Execution - Codegen, Metadata, Query Planning & Optimization, SQL Parser, Storage - Text & CSV

Environment

MapR 6.0

• Assignee: Unassigned
• Reporter: Hari Sekhon
• Created: 09/May/18 12:23
• Updated: 09/May/18 12:23

Description

Improvement request for the following error to be made more specific to mention that this is caused by the file extension (.dat) not being one of the expected ones, even though it was a CSV file (renaming it to .csv worked):

0: jdbc:drill:drillbit=<fqdn>> select * from dfs.`/tmp/file.dat`;
Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 17: Object '/tmp/file.dat' not found within 'dfs'

SQL Query null

[Error Id: e7c2863e-0feb-4b80-82b7-008056f0fcef on <fqdn>:31010] (state=,code=0)