I don't think you can for now. There is an ongoing effort to add select with options but I don't know the current progress on that
On Thu, Dec 3, 2015 at 11:51 AM, John Omernik <[email protected]> wrote: > I can't reproduce, so I must have done something wrong the first time, > thank you for replying. > > Is there away to select from a csv directory with extract header for only > that query or table? (Options?) > > > > On Wed, Dec 2, 2015 at 11:56 AM, Abdel Hakim Deneche < > [email protected]> > wrote: > > > Hey John, > > > > What do you get when you run "select * from sys.version" ? > > > > extractHeader is false by default, so you need to explicitly set it to > > true. > > > > can you post your storage plugin configuration ? > > > > Thanks > > > > On Tue, Dec 1, 2015 at 6:04 AM, John Omernik <[email protected]> wrote: > > > > > Hey all, > > > > > > Per my comment on https://issues.apache.org/jira/browse/DRILL-4145, I > > am > > > curious on why a CSV query (I am assuming with a default configuration, > > but > > > I have asked the question) in S3 would interpret differently than a CSV > > > query in MaprFS. > > > > > > Per the other user, they are using Drill 1.3, and I am as well (per the > > > MapR folks, I am using a Dev release version from MapR that has the > > Office > > > 1.3 release code base) > > > > > > Basically, The query from the JIRA author showed the CSV file being > > > interpreted, i.e. the "FIELD_1", "FIELD_2" etc were the headers and the > > > results broken out into columns. When I did this on the same data, I > got > > > one results, columns and an array of data. > > > > > > I tried setting extractHeader: true (what is the default on this > setting) > > > and that had no effect. (After I update a storage plugin, what do I > need > > to > > > do to ensure I see the effect in my SQL line session? DO I need to > > > reconnect? Basically I set the storage plugin, got the "success" then > > > changed to a difference schema and then back to my original schema and > > saw > > > no effect... should I reconnect or is that not needed?) > > > > > > Just curious on why we'd see different ways to read CSV files, the S3 > vs. > > > MapRFS shouldn't be different... or am I missing something? > > > > > > Thanks! > > > > > > John > > > > > > > > > > > -- > > > > Abdelhakim Deneche > > > > Software Engineer > > > > <http://www.mapr.com/> > > > > > > Now Available - Free Hadoop On-Demand Training > > < > > > http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available > > > > > > -- Abdelhakim Deneche Software Engineer <http://www.mapr.com/> Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
