Re: Question - Nested JSON using Hive

2012-04-02 Thread Ashwanth Kumar
ot;:"105540216147364","name":"Phoenix, > Arizona"},"position":{"id":"144703015548786","name":"Pharmacy > Tech"},"start_date":"2001-02","end_date":"2005-10"}],"sports":

RE: Question - Nested JSON using Hive

2012-04-02 Thread Anurag Gulati
ot;Philadelphia Flyers"},{"id":"93625750491","name":"Philadelphia Phillies"},{"id":"45898408995","name":"Phoenix Suns"},{"id":"120163518021430","name":"Philadelphia Eagles"}],"favo

Re: Question - Nested JSON using Hive

2012-04-01 Thread Ashwanth Kumar
You get that error because "location" is a keyword in Hive. Try to encapsulate it in ` char and try. On Mon, Apr 2, 2012 at 7:07 AM, Anurag Gulati wrote: > I’ve been trying to figure this out for a couple days now and I haven’t > gotten very far. > > Looking for your guidance on the matter.*

Question - Nested JSON using Hive

2012-04-01 Thread Anurag Gulati
I've been trying to figure this out for a couple days now and I haven't gotten very far. Looking for your guidance on the matter. As a test, I'm trying to import Facebook Open Graph API data into Hive but am having a problem with the syntax. Here is a line of sample data I'm trying to import (m