You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/07/03 16:35:06 UTC

[jira] [Resolved] (DRILL-3457) Query extensionless file in csv format

     [ https://issues.apache.org/jira/browse/DRILL-3457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau resolved DRILL-3457.
-----------------------------------
    Resolution: Not A Problem

You can use a default input format to solve this problem.  See here: 

https://drill.apache.org/docs/drill-default-input-format/

> Query extensionless file in csv format
> --------------------------------------
>
>                 Key: DRILL-3457
>                 URL: https://issues.apache.org/jira/browse/DRILL-3457
>             Project: Apache Drill
>          Issue Type: Improvement
>    Affects Versions: 1.0.0
>            Reporter: Harsh Choudhary
>            Priority: Minor
>
> I imported data in Hadoop using Sqoop 1.4.6. Sqoop imports and saves the data in HDFS in an extensionless file but in csv format. I used Apache Drill to query the data from this file but got Table not found error. In Storage Plugin configuration, I even put null, blank (""), space (" ") in extensions but was not able to query the file. Even I was able to query the file when I changed the filename with an extension. Putting any extension in the configuration file works other than null extension. I could query the file saved in csv format but with extension 'mat' or anything.
> We should be able to query the data from the extensionless file, not by default may be, but at least when specified in the configuration file.



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