You can query to remove the quotes, but DRILL-1440 addresses this issue as well.
On Fri, Nov 14, 2014 at 5:56 AM, mufy <[email protected]> wrote: > Hello Hari, > > Did you get a chance to try the query mentioned here to remove quotes? > > > https://cwiki.apache.org/confluence/display/DRILL/Lesson+2%3A+Run+Queries+with+ANSI+SQL > > > --- > Mufeed Usman > My LinkedIn <http://www.linkedin.com/pub/mufeed-usman/28/254/400> | My > Social Cause <http://www.vision2016.org.in/> | My Blogs : LiveJournal > <http://mufeed.livejournal.com> > > > > > On Fri, Nov 14, 2014 at 5:10 PM, Hari Sekhon (JIRA) <[email protected]> > wrote: > > > Hari Sekhon created DRILL-1712: > > ---------------------------------- > > > > Summary: Quoted CSV parsing > > Key: DRILL-1712 > > URL: https://issues.apache.org/jira/browse/DRILL-1712 > > Project: Apache Drill > > Issue Type: Improvement > > Affects Versions: 0.6.0 > > Environment: MapR 4.0.1 M5 > > Reporter: Hari Sekhon > > > > > > When querying CSV files Drill doesn't handle quoted CSV files properly > and > > includes the quotes in the data. The directory /tmp/hari in MapR-FS has > two > > simple CSV files, one quoted, one not quoted so you can see the > difference. > > {code} > > 0: jdbc:drill:> select * from dfs.`/tmp/hari` limit 10; > > +------------+ > > | columns | > > +------------+ > > | ["1","2","3"] | > > | ["4","5","6"] | > > | ["7","8","9"] | > > | ["\"1\"","\"2\"","\"3\""] | > > | ["\"4\"","\"5\"","\"6\""] | > > | ["\"7\"","\"8\"","\"9\""] | > > +------------+ > > 6 rows selected (0.238 seconds) > > > > cat hari/hari.csv > > 1,2,3 > > 4,5,6 > > 7,8,9 > > cat hari/hari2.csv > > "1","2","3" > > "4","5","6" > > "7","8","9" > > {code} > > It shouldn't be including the quotes as data, they're just containers to > > the data. > > > > > > > > -- > > This message was sent by Atlassian JIRA > > (v6.3.4#6332) > > > -- *Jim Scott* Director, Enterprise Strategy & Architecture +1 (347) 746-9281 <http://www.mapr.com/> [image: MapR Technologies] <http://www.mapr.com>
