Re: will hbase storage engine scan twice?

Yes, that's it. Waiting for your new release to solve it. 2016-08-09 23:26 GMT+08:00 Zelaine Fong : > It looks like you're encountering DRILL-4771. Note that the problem is not > specific to querying from HBase. > > -- Zelaine > > On Tue, Aug 9, 2016 at 3:09 AM, qiang li

Re: Suggestions for hangout topics for 08/09

Copy of Mehant's doc here: https://docs.google.com/document/d/1IsfU3JwW8VF8Zyra7FIRoGrvyDe87iFJHTXGLbpD36U/edit?usp=sharing On Tue, Aug 9, 2016 at 11:15 AM, Gautam Parai wrote: > Minutes from the hangout > > Attendees: Alok, Aman, Arina, Dave, Jason, Paul, Subbu,

Re: Suggestions for hangout topics for 08/09

Minutes from the hangout Attendees: Alok, Aman, Arina, Dave, Jason, Paul, Subbu, Vitalii, Zelaine, Padma, Jinfeng, Parth, Gautam 1. 1.8 RELEASE 4836 - Regression from 1.4 (February) Pull req open. Trying to fix in 1.8. Sudheesh will review it. 4766 - PR from Hakim. Is it a regression? If no,

Re: Apache Drill Use Case : JSON files

If you meant to create a copy with your changes (performed via CTAS). You can set the store format to JSON [1]. So if done at a session level, all CTAS statements executed in that session will create underlying files in JSON format. alter session set `store.format`='json'; [1]

Re: Query hangs on planning

Oscar, can you please report a JIRA with the required steps to reproduce the OOM error. That way someone from the Drill team will take a look and investigate. For others interested here is the stack trace. 2016-08-09 16:51:14,280 [285642de-ab37-de6e-a54c-378aaa4ce50e:foreman] ERROR

Re: Suggestions for hangout topics for 08/09

The hangout will start shortly. Here is the link: https://plus.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc On Mon, Aug 8, 2016 at 12:47 PM, Jason Altekruse wrote: > Yeah, I can join the hangout tomorrow to talk about the PR, thanks for the > heads up. > > Jason

Re: will hbase storage engine scan twice?

It looks like you're encountering DRILL-4771. Note that the problem is not specific to querying from HBase. -- Zelaine On Tue, Aug 9, 2016 at 3:09 AM, qiang li wrote: > I did some research and find out that the logic plan not good if contains > count(distinct ) clause. >

Re: Dockerized Drill with Bridged Network

You can try this image if you want to do a quick test: https://hub.docker.com/r/miradatv/apache-drill/ It has a few patches though. On Tue, Aug 09, 2016 at 05:36:56PM +0300, Oscar Morante wrote: Hi Suhas, I've been running a Drill cluster on Kubernetes just by patching this:

Re: Dockerized Drill with Bridged Network

Hi Suhas, I've been running a Drill cluster on Kubernetes just by patching this: https://github.com/miradatv/drill/commit/ef139a4d8645936a0ecbc8318546fad99ee9609b I think it should also work on Mesos. Cheers, On Mon, Aug 08, 2016 at 12:55:32PM -0700, Suhas Gaddam wrote: Hi, I am trying

Query hangs on planning

Hi there, I've been stuck with this for a while and I'm not sure if I'm running into a bug or I'm just doing something very wrong. I have this stripped-down version of my query: https://gist.github.com/spacepluk/9ab1e1a0cfec6f0efb298f023f4c805b The data is just a single file with one record

will hbase storage engine scan twice?

Hi We use drill to query hbase. Recently I check one of our query's plan: 0: jdbc:drill:drillbit=rfdc2> explain plan for SELECT '2016-07-27 00:00' as key, sum(convert_from(action.`v`.`c`,'INT_BE')) AS pv,COUNT(DISTINCT BYTE_SUBSTR(action.row_key,-8,8)) AS uv,