followed the steps but getting all NULLS . I compiled the serde and copied the json-serde-1.3.8-SNAPSHOT.jar file to the $FLUME_HOME/lib folder. hive> CREATE EXTERNAL TABLE tweetdata3 (
> id string,
> person struct<email:string, first_name:string, last_name:string, location:struct<address:string, city:string, state:string, zipcode:string>, text:string, url:string>)
> ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
> LOCATION '/user/flume/tweets';
OK
Time taken: 0.197 seconds
hive> desc tweetdata3;
OK
id string from deserializer
person struct<email:string,first_name:string,last_name:string,location:struct<address:string,city:string,state:string,zipcode:string>,text:string,url:string> from deserializer
Time taken: 0.266 seconds, Fetched: 2 row(s)
hive>
> SELECT id, person.first_name, person.last_name, person.email,
> person.location.address, person.location.city, person.location.state,
> person.location.zipcode, person.text, person.url
> FROM tweetdata3 LIMIT 5;
OK
790657073453424645 NULL NULL NULL NULL NULL NULL NULL NULL NULL
790657073453424645 NULL NULL NULL NULL NULL NULL NULL NULL NULL
Time taken: 0.282 seconds, Fetched: 2 row(s)
hive> SELECT id, person.first_name, person.last_name, person.email,
> person.location.address, person.location.city, person.location.state,
> person.location.zipcode, person.text, person.url
> FROM tweetdata3 LIMIT 5;
OK
790657073453424645 NULL NULL NULL NULL NULL NULL NULL NULL NULL
790657073453424645 NULL NULL NULL NULL NULL NULL NULL NULL NULL
Time taken: 0.063 seconds, Fetched: 2 row(s)
... View more
