Re: "Already had POJO for id" Error In SQL - Join B/W Redshift and HDFS

Is this trivial, or big? Thanks, Rohit On Thu, Jan 7, 2016 at 11:29 PM, Boris Chmiel < boris.chm...@yahoo.com.invalid> wrote: > Hi everyone,I do also have this error trying to join MSSQL data source > with dfs parquet files. Here the stack : >

problem with drill

Hi I am a beginner about Drill. According the document offered by offsite, I connect to drill programmatically. But encountering the following problem, I do not know how to fix it. I hope you can help me to solve this problem. Thanks. Here is the example document referred.The environment is

Re: problem with drill

The user mailing list tool doesn't support images. Please use text or post images somewhere and provide a link. Thanks. Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn skype:krishahn On Wed, Jan 13, 2016 at 12:06 AM, 伍晋博 wrote: > Hi > I am a beginner about

Re: problem with drill

Hi, Looks like you're using drill in distributed mode (not embedded). Change 'zk' in your connection url with 'drillbit' as described in this thread: http://mail-archives.apache.org/mod_mbox/drill-user/201511.mbox/%3c897ab939-abc1-4eb1-81e9-a8e08ec30...@maprtech.com%3E Karol Potocki On Wed,

Re: JSON File, Total numbers Record: 1

The apache mailing lists don't support image attachments, it would be better to attach text anyway since it's searchable. Chris Matta cma...@mapr.com 215-701-3146 On Wed, Jan 13, 2016 at 9:55 AM, Paolo Spanevello wrote: > Hi, > > thanks again Jason for your support. > >

Re: JSON File, Total numbers Record: 1

Wasn't thinking about that, I was seeing the images because I was included directly in the recipients lists. +1 on text for searchability. Can you please rerun the queries and post the errors here as text? On Wed, Jan 13, 2016 at 11:20 AM, Christopher Matta wrote: > The

Re: JSON File, Total numbers Record: 1

The issue you have now is that you are passing an array into KVGEN, which only works on maps. You can just flatten it again instead. Looking more closely at your dataset, I don't think you have any maps that would require KVGEN to analyze them, they all have keys that appear in all records, KVGEN

Re: Community Drill UDFs

Hi, This is my playgrund https://github.com/activitystream/asdrill Please feel free to do with it what you will. I'd be more than happy to participate in a community driven UDF project. Regards, Stefán On Wed, Jan 13, 2016 at 10:28 PM, Ted Dunning wrote: > There is

RE: JDBC Ignores URL ?

Hi, Did you try connect to drillbit URL directly? see as: https://drill.apache.org/docs/using-the-jdbc-driver/#using-the-jdbc-url-format-for-a-direct-drillbit-connection or https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/#entering-the-connection-url -- Miura, Masahide

RE: Drill query does not return all results from HBase

I opened the bug on this. The drill is returning the correct rows when the hbase contains 5 or less columns, but not 6 or more columns. https://issues.apache.org/jira/browse/DRILL-4271 Thanks Kumiko -Original Message- From: Kumiko Yada [mailto:kumiko.y...@ds-iq.com] Sent: Wednesday,

JDBC Ignores URL ?

Hi, I know this sounds crazy, but here is how I got the problem. -I downloaded Drill 1.4.0 and dropped it in a Centos VM (Virtualbox) -Configured Zookeep, Started Drill service (daemon) -Tested using SQLLine, all good. -Picked the drill-jdbc-all-1.4.0.jar from

Re: Drill query does not return all results from HBase

Thanks for filing the issue. I haven't worked much with HBase, but this is a critical wrong results issues, so I will be taking a look at this soon if no one else raises their hand. On Wed, Jan 13, 2016 at 6:20 PM, Kumiko Yada wrote: > I opened the bug on this. The drill

Re: "Already had POJO for id" Error In SQL - Join B/W Redshift and HDFS

Thanks a bunch Jacques! Sent from my iPhone > On 14-Jan-2016, at 12:48 AM, Jacques Nadeau wrote: > > I think it is most likely probably trivial but unfortunately haven't had > the time to look at it yet. It looks like, for some reason, we're having a > failure when

Re: Community Drill UDFs

Thanks Ted and Stefán these are pointing me in the right direction. My question was twofold. One, I have some large blobs of text in an Hbase/mapr db store, and wanted to start processing it. Coming from hive, there were some nice functions and non sql compliant tricks like field rlike 'pattern'

Re: JSON File, Total numbers Record: 1

Hi, thanks again Jason for your support. I'm trying as u suggest, to apply the kvgen function. Below you can find the query and the error. *select tt.flat_intervals from (select flatten(kvgen(t.flat_rides.INTERVALS)) as flat_intervals from (select flatten(rides) as flat_rides from

Re: problem with drill

The approval messages sent to list managers actually don't filter out images, it happens before it is sent out to the actual list. I threw them onto imgur for others to see. http://imgur.com/a/L7ksG The jdbc-all jar should contain everything needed to connect to drill. I can't think of a reason