Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive view in HDP3

avatar
Expert Contributor

Hi,

I am wondering how we can create Hive view in HDP3. It used to be in HDP2.6 but in the new version i cannot find it.

Please advise.
Thanks

1 ACCEPTED SOLUTION

avatar
Master Mentor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
5 REPLIES 5

avatar
Master Mentor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Expert Contributor

Thanks alot.

So that means everything in hive will be done via command line?

During the upgrade i exported all the ddl scripts for hive. should i run them from the command line? following the below post?

https://docs.hortonworks.com/HDPDocuments/HDP3/HDP-3.0.0/starting-hive/content/hive_start_a_command_l...

Thanks,

SJ

avatar
Master Mentor

@Sanaz Janbakhsh

Yes that should bring back the SQL guru in you 🙂 The is also new Zeppelin 0.8.0 which has new futures I haven't explored.

avatar

@Sanaz Janbakhsh Hive CLI is deprecated. We suggest using beeline. There is work being done on a more robust SQL IDE that provides significantly more functionality than the Hive view.

avatar
Expert Contributor

Thanks,

Since by default Tez replaces Mapreduces in this version as the default hive execution engine, I am wondering how we can convert the current hive scripts?

Would you please advise me on that?

SJ