Re: Stop Drill querying .tmp files

mura by any mistransmission of this e-mail. Any reference to "Nomura" is a reference to any entity in the Nomura Holdings, Inc. group. Please read our Electronic Communications Legal Notice which forms part of this e-mail: http://www.Nomura.com/email_disclaimer.htm -- Chris Matta cma...@mapr.com <mailto:cma...@mapr.com> 215-701-3146 -- Daniel Barclay MapR Technologies

Re: Convert from Array to String

, it was working fine, I just didn't see it because SQL Squirrel kept returning " instead of the results of the function. Hmmm. 2002 is the value for java.sql.Types.STRUCT. ... Daniel-- Daniel Barclay MapR Technologies

Re: Using Drill JDBC V1.2 with V1.1 release

Dhruv Gohil wrote: I think the JDBC driver didn't have any "known" issues in 1.1 > DRILL-3632 seems to be a blocker on 1.1.0 . That is fixed now in master (for Drill 1.2) (via DRILL-3566). Daniel On Thursday 01 October 2015 11:06 AM, Daniel Barclay wrote: Hakim, Abdel

Re: Using Drill JDBC V1.2 with V1.1 release

think that it happens to work, but it's definitely not known to work, so you'll have to check. (I think I tried that combination incidentally as part of doing something else, so it wasn't a solid test, just connecting and a few basic queries). Daniel -- Daniel Barclay MapR Technologies

Re: Using Drill JDBC V1.2 with V1.1 release

y-conflict problems, reported against it. See some of DRILL-3589's linked JIRA reports (i.e., DRILL-3502, DRILL-3581, and DRILL-3784.) Daniel Thanks On Wed, Sep 30, 2015 at 12:02 PM, Daniel Barclay <dbarc...@maprtech.com> wrote: Nikunj Thakkar wrote: ... I'm using drill v1.1.0 in

Re: Querying local filesystem directory: How do I access the filename?

": "file", "enabled": true, "connection": "file:///", "workspaces": { "scimmia": { "location": "/home/scimmia", "writable": false, "defaultInputFormat": null } }, "formats": { "json": { "type": "json" } } } -- Daniel Barclay MapR Technologies

Re: Drill WITH clause syntax

cification in WITH clause works fine. -Neeraja -- Daniel Barclay MapR Technologies

Re: SQuirrel Quote Qualifiers

: DRILL.dfs.tmp.My_viewschemaName: dfs.tmpsimpleName : My_view Does anybody knows how to configure SQuirrel in order to implement the right SQL syntax, allowing to use GUI functionnalities ? ThxBoris -- Daniel Barclay MapR Technologies

Re: Recursive CTE Support in Drill

http://www.mapr.com/ Now Available - Free Hadoop On-Demand Training http://www.mapr.com/training?utm_source=Emailutm_medium=Signatureutm_campaign=Free%20available -- Daniel Barclay MapR Technologies

Re: Hangout happening in 30mins! (at 10:00am Pacific)

about Drill, want to know more or just want to listen in. Link: https://plus.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc -- Daniel Barclay MapR Technologies

Re: Adding an interval column to a date

this? Chris mattacma...@mapr.com 215-701-3146 ​ -- Daniel Barclay MapR Technologies

Re: VALUES operator in FROM clause

| ++--+-+---+--+---+---+ -- Daniel Barclay MapR Technologies

default to waiting for net/full schema? [was: Re: Desired Behavior when a table has both files and folders?]

: 2} This is what drill returns : +++ |dir0|col2| +++ | folder1 | 2 | | null | null | +++ Looks like drill ignored the columns from the first file. - Rahul -- Daniel Barclay

Re: subsequent CTAS statements getting cancelled

(...), hold on to the ResultSet, and call method next() on it until next() returns false. That should consume the results on the client side enough for the server to finish executing its side. Daniel -- Daniel Barclay MapR Technologies

FYI: NoSchema Revolution event with Hive Big Data Think Tank Meetup Group tonight

For whomever is interested, the Hive Big Data Think Tank Meetup Group is having a NoSchema Revolution event tonight. See http://www.meetup.com/SF-Bay-Areas-Big-Data-Think-Tank/events/219395393/ Daniel -- Daniel Barclay MapR Technologies