question Re: Hive view in HDP3 in Archives of Support Questions (Read Only)

Hive view in HDP3

Sanaz_janbakhsh — Sun, 29 Jul 2018 01:26:45 GMT

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

Re: Hive view in HDP3

Shelton — Sun, 29 Jul 2018 03:08:24 GMT

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

Sanaz_janbakhsh — Sun, 29 Jul 2018 03:17:45 GMT

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_line_query_locally.html

Thanks,

Re: Hive view in HDP3

Shelton — Sun, 29 Jul 2018 04:16:53 GMT

@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

SQLShaw — Mon, 30 Jul 2018 19:28:50 GMT

@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

Sanaz_janbakhsh — Tue, 31 Jul 2018 05:59:33 GMT

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?