Member since
05-19-2016
4
Posts
0
Kudos Received
0
Solutions
05-30-2016
08:08 PM
That is great. Now I know not to use user. Thank you for the reply!
... View more
05-29-2016
04:45 PM
That worked Grant. Thank you. I'm reading through the link you sent as well, however I'm very curious. Why would the word user not work and c3 would? I tried this: CREATE EXTERNAL TABLE twitter_sample ( tweetmessage string, createdate date, user struct< screenname:string, userlocation:string >)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'; and it failed. Then I changed user --> c3 and then it executed properly.
... View more
05-28-2016
05:09 AM
I am trying to process a sample Json file. It's a very basic file of twitter data. I found that I should use a JsonSerDe. I did not know what this was so I looked it up. I know what a SerDe is now (I'm a newbie if you can't tell). How can I tell if a SerDe is installed on the HDP 2.4 sandbox? The SerDe I want to use is org.apache.hcatalog.data.JsonSerDe but when I execute the following, I get errors saying "cannot recognize input near ':' 'string' ',' in column type" Here's what I'm trying to execute: CREATE EXTERNAL
TABLE twitter_sample ( tweetmessage:string, createdate:date, 'user' struct< screenname:string, userlocation:string>)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' location '/user/root/twitter_txt_results';
Like I said, I'm a newbie, not only to Hive but also to Linux. I tried searching for anything that had the wording JsonSerDe in it but the search came back blank (it could be I didn't do the search correctly). I have a feeling however that the serde isn't installed. Can anyone help?
... View more
Labels:
05-20-2016
12:07 AM
Thank you for posting this. I am having this issue as well (I'm a newbie too). However when I look in the contents of the redhat.repo file, it's only full of comments and there are no mentions of any rhel-6.... or enabled=0 lines whatsoever. There's a comment in the line that says "If this file is empty and this system is subscribed consider a "yum repolist" to refresh available repos". I'm not subscribed though. Any advice on this? Thanks!
... View more