Re: IndexR, a new storage plugin for Drill

Hi Flow Wei, This looks pretty interesting. Any comments on comparison of indexR with Apache Kudu? thanks, Robin. On 4 January 2017 at 11:20, WeiWan wrote: > Hi Nicolas, > > > 1)Does both drill and hive support predicat pushdown with indexR ? I mean > > using the indexes

Re: INTERVAL date arithmetic

000Z" ​thanks ​ On 10 November 2016 at 16:50, rahul challapalli <challapallira...@gmail.com> wrote: > Can you try the below query? > > select extract(day from cast(p.post.published_at as interval day)) > from dfs.data.ghost_posts_rm > p; > > - Rahul > > On Thu, N

INTERVAL date arithmetic

Hi, I have a date in a table, that I want to calculate how many days it is between then and current date. I have read the docs on date time formats, including intervals ( http://drill.apache.org/docs/date-time-and-timestamp/), as well as date time functions (

Excluding HDFS .tmp file from multi-file query?

Hi, I have a stream of data from Flume landing in HDFS in files of a set size. I can query these files individually just fine, and across multiple ones too - except if the wildcard encompasses the *currently open HDFS file that Flume is writing to*. When this happens, Drill understandably barfs.

Re: Apache Drill Error

Thanks, that fixed the problem for me on Mac with Drill 1.8. I had the same error as OP (Unable to locate an executable at "/System/Library/Frameworks/JavaVM.framework/Versions/A/bin/java" (-1)) $ diff drill-config.sh drill-config.sh.bak 395c395 < #export JAVA_HOME --- > export JAVA_HOME On 21

Re: Querying Delimited Sequence file

as well. But it should be similar to how other databases > implement this function. > > Also as you have observed, split does not support delimiters with more than > one character. You can raise a jira and mark it as documentation related. > > Rahul > > > > On Tue,

Re: Querying Delimited Sequence file

| > +-+ > 2 rows selected (0.319 seconds) > > Is that what you had in mind? > > -- Zelaine > > On Tue, Aug 30, 2016 at 7:17 AM, Robin Moffatt < > robin.moff...@rittmanmead.com> wrote: > > > Hi, > > > > I'm trying to rea

Re: Article on how to use Apache Drill with Oracle's BI tool, OBIEE

great. thanks for putting it together. > > Bridget Bevens takes care of the docs and can help publishing this on the > > site. > > > > thanks > > Neeraja > > > > On Mon, Aug 22, 2016 at 4:08 AM, Robin Moffatt < > > robin.moff...@rittmanmead.com>

Article on how to use Apache Drill with Oracle's BI tool, OBIEE

Hi, I've written an article on how to use Apache Drill with Oracle's BI tool, OBIEE: http://www.rittmanmead.com/blog/2016/08/using-apache-drill-with-obiee-12c/ Is there a way to get this added to the documentation list here? https://drill.apache.org/docs/using-drill-with-bi-tools/ thanks, Robin

"No current connection"

Hi, First attempt with Apache Drill, and failing spectacularly to get off the ground with it... Downloaded and unpacked apache-drill-1.6.0.tar.gz on my Oracle Linux 6 VM. Followed the "Drill in 10 Minutes" ( https://drill.apache.org/docs/drill-in-10-minutes/) tutorial. But, I'm stuck at "No