Drill's Hangout topics for tomorrow (10am-11am 8/23/2016 PDT)

2016-08-22 Thread Chunhui Shi
The topics I think we should cover are: 1, Updates on 1.8.0 release. 2, Recently there are some thoughts on how to improve and shorten unit tests. Would like to get some more inputs on this topic. If there is any topic you feel that we should discuss, please feel free to bring them up here or at

Re: about the way to load customized data

2016-08-22 Thread Krystal Nguyen
The fix from DRILL-3149 and its related fixes only address multi-bytes for line delimiters but not for field delimiters. DRILL-4660 was opened to track the support for multi-byte field delimiters. On Mon, Aug 22, 2016 at 10:32 AM, Parth Chandra wrote: > DRILL-3149 (and the related DRILL-4746) f

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

2016-08-22 Thread Bridget Bevens
Hi Robin, Thank you for passing this along. I've added a task for myself to get this article posted. I will post it as soon as I get some time to work on it. Thanks, Bridget On Mon, Aug 22, 2016 at 9:22 AM, Neeraja Rentachintala < nrentachint...@maprtech.com> wrote: > Hi Robin > This is great.

Re: [Drill-Issues] Drill-1.6.0: CTAS - No table found in case select returns empty set.

2016-08-22 Thread Parth Chandra
Not that I know of. See https://issues.apache.org/jira/browse/DRILL-2223 - There may be issues with creating an empty Parquet file with no data. We haven't investigated that in too much detail though. On Mon, Aug 22, 2016 at 5:48 AM, Shankar Mane wrote: > Is there any configuration to do, To

Re: about the way to load customized data

2016-08-22 Thread Parth Chandra
DRILL-3149 (and the related DRILL-4746) fix issues with reading multi-byte delimiters. You can maybe build from master or wait for the 1.8 release (due out soon as we are in the release process). HTH. On Mon, Aug 22, 2016 at 12:32 AM, wrote: > Hi, > > I'd like to try drill in my project. But

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

2016-08-22 Thread Neeraja Rentachintala
Hi Robin This is 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> wrote: > Hi, > I've written an article on how to use Apache Drill

[Drill-Issues] Drill-1.6.0: CTAS - No table found in case select returns empty set.

2016-08-22 Thread Shankar Mane
Is there any configuration to do, To force create table even when SELECT statement return empty data ? 0: jdbc:drill:> create table glv_abcookie_min_newsid as . . . . . . . > select . . . . . . . > app_sessionid, . . . . . . . > new_sessionid, . . . . . . . > min(serverTime) as min_serverTime . .

about the way to load customized data

2016-08-22 Thread shawn.liu
Hi, I'd like to try drill in my project. But the source data has quite strange format which delimited by "|^|" and has line end "|!|". the example likes below. Aaa|^|bbb|^|ccc|!| So what's the best way to accomplish the data loading? Shall I extend the storage plugin. Thanks & Kind regards Sh

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

2016-08-22 Thread Robin Moffatt
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 M