Re: Apache Drill - Read Java Objects

2016-02-24 Thread Jacques Nadeau
Based on how I understand your questions, you have serialized java objects with a field you want to query. How are the java objects serialized? -- Jacques Nadeau CTO and Co-Founder, Dremio On Thu, Feb 18, 2016 at 6:48 PM, jorge gonzalez wrote: > Hello, > The company I currently work for stores

Re: Apache Drill - Read Java Objects

2016-02-24 Thread Andries Engelbrecht
I don't believe the current reader can take a text field in a JSON object and read it as TSV/CSV to get the columns. AS Neeraja mentioned, it will help you can provide more specific information and perhaps a sample of what you are trying to achieve. Are the text field with tab delimited fields e

Hangout notes from the last few meetings

2016-02-24 Thread Jason Altekruse
Hey guys, Sorry I haven't been sending these out, I keep meaning to go back to them and clean them up before sending them out and I don't get around to it. I will just post the raw notes after the meeting going forward and provide clarification on the thread if anyone has questions. Drill Hangou

Re: crash when querying mongo

2016-02-24 Thread Árpád Tamási
It works now, thanks. I just don’t understand why. The nested document is polymorph, but the column I selected always has the same type. Árpád Tamási | CTO +36 70 381 9620 | arpad.tam...@samebug.io |

Re: Apache Drill - Read Java Objects

2016-02-24 Thread Neeraja Rentachintala
Jorge can you give an example of what you are looking to accomplish here. Based on your description, it seems to me that you might be able to use the functions listed here. https://drill.apache.org/docs/supported-data-types/#data-types-for-convert_to-and-convert_from-functions On Wed, Feb 24, 20

Re: Apache Drill - Read Java Objects

2016-02-24 Thread jorge_...@yahoo.com.INVALID
Can you please reply to my question below? We need to know if it is possible.. The company I work for is probably MapR's largest customer and I would appreciate your help. Thanks, Jorge Sent from my iPhone > On Feb 18, 2016, at 9:48 PM, jorge gonzalez wrote: > > Hello, > > The company I cu

Re: crash when querying mongo

2016-02-24 Thread Jacques Nadeau
I don't believe the BSON reader (default as of 1.4) supports writing to union types yet. You'll need to also turn off the bson reader to take advantage of the union type support. ALTER SESSION/SYSTEM SET `store.mongo.bson.record.reader` = false; -- Jacques Nadeau CTO and Co-Founder, Dremio On W

Re: crash when querying mongo

2016-02-24 Thread Hanifi Gunes
I would not be surprised if your data has schema change from string to list. Ideally, we should log at which column we hit to this problem and display a better message suggesting use of union types. Can you try enabling union types? ALTER SESSION/SYSTEM SET `exec.enable_union_type` = true; -Han

JDBC connection failing when connecting through Zookeeper

2016-02-24 Thread James Norris
Hi, I'm getting an error when using Drill 1.5 JDBC drivers. I have 2 hosts: Host A running Zookeeper, host B running a Drillbit. If use a JDBC URL to connect directly to B, it works OK. If I try to connect to A via ZK, I get, the error below. Ports are open (2181,8047,31010 - 31012, ICMP), Hos