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) >
