[jira] [Comment Edited] (DRILL-1320) Allow storage plugin to query formatted files with no extention

["Hanifi Gunes (JIRA)" <ji...@apache.org>]

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

Hanifi Gunes edited comment on DRILL-1320 at 10/16/14 2:50 AM:
---------------------------------------------------------------

Drill matches extensions to determine the data format. DRILL-1540 introduces a fallback data format per workspace in case data source has no extension. Please take a look at the DRILL-1540.


was (Author: hgunes):
Drill matches extensions to determine the data format. DRILL-1540 introduces a fallback data format per workspace in case data source has no extension. Please take a look at the DRILL-1504.

> Allow storage plugin to query formatted files with no extention
> ---------------------------------------------------------------
>
>                 Key: DRILL-1320
>                 URL: https://issues.apache.org/jira/browse/DRILL-1320
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Functions - Drill
>    Affects Versions: 0.4.0
>            Reporter: Michael England
>            Assignee: Hanifi Gunes
>            Priority: Critical
>             Fix For: 0.7.0
>
>
> 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



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