Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive view in HDP3

Solved Go to solution
Highlighted

Hive view in HDP3

Rising Star

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

Accepted Solutions

Re: Hive view in HDP3

Mentor

@Sanaz Janbakhsh

According to numerous official posts, unfortunately, Ambari views have been dropped but there is a new tool in the pipeline to replace Ambari views and HUE nevertheless you can have a standalone HUE server :-)
The nearest you can get it using the

HDFS-->NameNodeUI-->Utilities-->Browse the file system

And from there you can upload and browse but unfortunately not execute any queries or view tables :-)

HTH

5 REPLIES 5

Re: Hive view in HDP3

Mentor

@Sanaz Janbakhsh

According to numerous official posts, unfortunately, Ambari views have been dropped but there is a new tool in the pipeline to replace Ambari views and HUE nevertheless you can have a standalone HUE server :-)
The nearest you can get it using the

HDFS-->NameNodeUI-->Utilities-->Browse the file system

And from there you can upload and browse but unfortunately not execute any queries or view tables :-)

HTH

Re: Hive view in HDP3

Rising Star

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

Re: Hive view in HDP3

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.

Re: Hive view in HDP3

@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.

Re: Hive view in HDP3

Rising Star

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

Don't have an account?
Coming from Hortonworks? Activate your account here