I have Generated the twitter schema
the following schema which is correct with my knowledge but fails while creation with following error
CREATE TABLE y (
created_at string,
favorite_count int,
id int,
retweet_count int,
retweeted_status struct<created_at:string,
entities:struct<urls:array<struct>>,
favorite_count:int,
retweet_count:int,
text:string,
user:struct<favourites_count:int,
followers_count:int,
friends_count:int,
location:string,
screen_name:string,
statuses_count:int,
time_zone:string>>,
source string,
text string,
user struct<favourites_count:int,
followers_count:int,
friends_count:int,
location:string,
name:string,
screen_name:string,
statuses_count:int,
time_zone:string>
)ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe';
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Could not initialize class org.openx.data.jsonserde.objectinspector.JsonObjectInspectorFactory
hive>
I have Generated the twitter schema the following schema which is correct with my knowledge but fails while creation with following error
CREATE TABLE y ( created_at string, favorite_count int, id int, retweet_count int, retweeted_status struct<created_at:string, entities:struct<urls:array<struct>>,
favorite_count:int,
retweet_count:int,
text:string,
user:struct<favourites_count:int,
followers_count:int,
friends_count:int,
location:string,
screen_name:string,
statuses_count:int,
time_zone:string>>,
source string,
text string,
user struct<favourites_count:int,
followers_count:int,
friends_count:int,
location:string,
name:string,
screen_name:string,
statuses_count:int,
time_zone:string>
)ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe';
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Could not initialize class org.openx.data.jsonserde.objectinspector.JsonObjectInspectorFactory hive>
Please provide me the solution ..