Re: Loading json files into hive table is giving NULL as output(data is in s3 bucket)

2013-02-18 Thread Dean Wampler
I don't know what changed. I didn't work on this SerDe myself. I'm glad it's working now for you, though! dean On Mon, Feb 18, 2013 at 9:31 AM, Chunky Gupta wrote: > Hi Dean, > > I was using *hive-json-serde-0.2.jar* earlier. Now I tried > *hive-json-serde-0.3.jar > *as you suggested and it is

Re: Loading json files into hive table is giving NULL as output(data is in s3 bucket)

2013-02-18 Thread Chunky Gupta
Hi Dean, I was using *hive-json-serde-0.2.jar* earlier. Now I tried *hive-json-serde-0.3.jar *as you suggested and it is working fine, I am getting the output as expected. Can you please tell me that what code change from 0.2 to 0.3 could have solved this problem ? Thanks, Chunky. On Mon, Feb

Re: Loading json files into hive table is giving NULL as output(data is in s3 bucket)

2013-02-18 Thread Chunky Gupta
Hi Dean, I tried with removing underscore too, and getting the same output which means problem is not with underscore. Yes, it was an example. Actual json file is like :- {"colnamec":"ColNametest","colnamets":"2013-01-14","colnameip":"10.10.10.10","colnameid":"10","colnameid2":"100","colnamep":0

Re: Loading json files into hive table is giving NULL as output(data is in s3 bucket)

2013-02-18 Thread Dean Wampler
The "uname="$._u" is the correct form. We also hacked on this SerDe at Think Big Analytics. I don't know if you'll see an improvement though. https://github.com/thinkbiganalytics/hive-json-serde I wonder if there's a problem handling the leading underscore? Also, I know it's just an example, but

Loading json files into hive table is giving NULL as output(data is in s3 bucket)

2013-02-18 Thread Chunky Gupta
Hi, I have data in s3 bucket, which is in json format and is a zip file. I have added this jar file in hive console :- http://code.google.com/p/hive-json-serde/downloads/detail?name=hive-json-serde-0.2.jar&can=2&q= I tried the following steps to create table and load data :- 1. CREATE EXTERNAL T