[DRILL-1320] Allow storage plugin to query formatted files with no extention

• Type: Improvement
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.7.0
• Component/s: Functions - Drill
• Assignee: DrillCommitter
• Reporter: Michael England
• Created: 21/Aug/14 16:20
• Updated: 07/Nov/14 16:30
• Resolved: 07/Nov/14 16:30

Description

I am pulling data in from a database into Hadoop using Sqoop. This creates .csv files that do not have any file extensions. I have looked at the Drill Wiki and tried to alter my storage plugin config by removing the "csv" format in the JSON and I have tried to leave empty quotes here too. I have found that whatever I try, Drill cannot find the 'table' (csv file) if there is no .csv file extension present. If I add this extension to the files, drill can find the table.

Would it be possible to add the ability to set an 'empty' extention so csv/other separated files with no file extension can be queried without having to change the file name?

If this is already possible, please close this ticket.

Thanks,
Mike

Issue Links

• duplicates: DRILL-1540 Provide a fallback data format in case Drill is unable to determine one