Using Avro unions with HIVE

2013-05-26 Thread Ran Silberman
Hi, We started to work with Avro in CDH4 and to query the Avro files using Hive. This does work fine for us, except for unions. We do not understand how to query the data inside a union using Hive. For example, let's look at the following schema: { "type":"record", "name":"event", "namespac

Re: Sqoop Oracle Import to Hive Table - Error in metadata: InvalidObjectException

2013-05-26 Thread Edward Capriolo
I think the problem is that hive is trying to import into a database named ds12 validObjectException( message:There is no database named ds12) try this: hive > create database ds12; Also be careful you just send the entire internet your oracle PW and username, On Sun, May 26, 2013 at 12:19 AM,

Hive Map Join Memory Limit

2013-05-26 Thread Peter Chu
Hi, I ran into memory problem while using Map Join. Errors below, how do I increase the map join memory size and if there are other solutions? PeterExecution log at: /tmp/hadoop/hadoop_20130525231414_3cc50fdd-7e7a-4bcf-baab-b465804c6e49.log 2013-05-25 11:14:41 Starting to launch local task

Re: Issue with Json tuple lateral view

2013-05-26 Thread Sai Sai
* Here is the json-data that i load: * { "blogID" : "FJY26J1333", "date" : "2012-04-01", "name" : "vpxnksu", "comment" : "good stuff", "contact" : { "email" : "vpxn...@gmail.com", "website" : "vpxnksu.wordpress.com" } } { "blogID" : "VSAUMDFGSD"

Re: Issue with Json tuple lateral view

2013-05-26 Thread Navis류승우
Removing last ',' in second row would make result as you expected. I can't tell it's bug or not. 2013/5/27 Sai Sai : > > * > Here is the json-data that i load: > * > > { "blogID" : "FJY26J1333", "date" : "2012-04-01", "name" : "vpxnksu", > "comment"