question Re: How to get Hive Upload Table option ? in Support Questions

How to get Hive Upload Table option ?

ajit_bajwa — Sun, 18 Sep 2016 09:39:18 GMT

This tutorial talks about Upload Table tab in Hive view of Ambari. But I don't see such an option. How can I get this option to show ?

Re: How to get Hive Upload Table option ?

gkeys — Sun, 18 Sep 2016 10:19:35 GMT

@Ajit Bajwa

Please confirm that your issue is identical to https://community.hortonworks.com/storage/attachments/7739-ambari-issue-1.jpg which is described in greater detail in https://community.hortonworks.com/questions/56938/sandbox-hello-udp-lab-test-2-issue.html#comment-57056

Which hosting envt is your sandbox in (VirtualBox or Azure) and any other details.

Re: How to get Hive Upload Table option ?

djangone_armel — Sun, 18 Sep 2016 14:12:06 GMT

Hello,

This is Armel. Yes, I am getting the same issue Ajit Bajwa described.. I am using Sandbox with HDP 2.4 on a VM.

Can anyone please help with this?

Thanks

Armel.

Re: How to get Hive Upload Table option ?

gkeys — Sun, 18 Sep 2016 20:27:06 GMT

@Armel Djangone

Could you identify the browser and version you are using.

Re: How to get Hive Upload Table option ?

gkeys — Sun, 18 Sep 2016 20:27:43 GMT

@Ajit Bajwa

Could you identify the browser and version you are using

Re: How to get Hive Upload Table option ?

ajit_bajwa — Sun, 18 Sep 2016 21:25:56 GMT

@gkeys This is NOT the same issue as mentioned in https://community.hortonworks.com/storage/attachments/7739-ambari-issue-1.jpg.

In my case, 'Upload Table' tab ( or option ) is not there at all.

Also, please note i am using Oracle VM VirtualBox. And my browser is Google Chrome Version 53.0.2785.116 m.

Also, i tried using IE Version 11, same issue.

Re: How to get Hive Upload Table option ?

gkeys — Mon, 19 Sep 2016 02:55:08 GMT

One more thing ... a new version of the sandbox was released on Friday. (It is 2.5 GA, not the previous 2.5 TP). If you downloaded your sandbox before Friday, please download the new one and try again. Otherwise, please let me know that you have the recent GA version.

Re: How to get Hive Upload Table option ?

djangone_armel — Mon, 19 Sep 2016 07:55:55 GMT

I selected the Upload Table of the Ambari Hive View, but I do not have the options to "Upload from Local" or " Upload from HDFS". The below screenshot shows the issue I am currently facing:

http://127.0.0.1:8080/#/main/views/HIVE/1.0.0/AUTO_HIVE_INSTANCE

I have tried with IE11 and Google Chrome as well, but still same issue. I am using Sandbox with HDP 2.4 on Oracle VM VirtualBox.

Any help?

Re: How to get Hive Upload Table option ?

TimothySpann — Mon, 19 Sep 2016 07:59:14 GMT

can you post a screen shot?

Perhaps it's security permissions

make sure your user dir is created and has permissions

https://community.hortonworks.com/questions/33396/users-can-upload-and-create-directories-using-file.html

http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/

Re: How to get Hive Upload Table option ?

djangone_armel — Mon, 19 Sep 2016 08:06:15 GMT

Here is a screenshot

lab2-issue.png

Re: How to get Hive Upload Table option ?

Former Member — Tue, 20 Sep 2016 01:34:53 GMT

Can you please provide the Sandbox version?

http://hortonworks.com/hadoop-tutorial/learning-the-ropes-of-the-hortonworks-sandbox/#learn-sandbox-version

If you are using the HDP 2.4 SB then you need to use the corresponding tutorial:

https://github.com/hortonworks/tutorials/tree/hdp-2.4/tutorials/hortonworks/hello-hdp-an-introduction-to-hadoop

which doesn't include the Hive upload table option.

Re: How to get Hive Upload Table option ?

gkeys — Tue, 20 Sep 2016 23:03:08 GMT

Do you have your pop-up blocker turned off on your browser?

Re: How to get Hive Upload Table option ?

ajit_bajwa — Sun, 18 Aug 2019 12:14:01 GMT

I created the user 'asb' in 'Manage Ambari' page, but could not give it admin permissions. Also, '/user/asb' dir is created and 'chown' to asb as well. But still unable to 'su - asb'. Although i can login to Ambari but with virtually no permissions.

[root@sandbox ~]# hdfs dfs -ls /user

/user/ambari-qa drwxr-xr-x - asb hdfs 0 2016-09-25 02:16 /user/asb

Re: How to get Hive Upload Table option ?

mohamedgougam — Sun, 25 Sep 2016 14:56:35 GMT

Hello Greg. Yes I had it on but the problem is still persisting even after switching it to off. I tried on Firefox as well.

I thought maybe I should log in as admin and when I tried the credentials used in the documentations admin/admin it says "Unable to sign in. Invalid username/password combination.", it is important to note that with maria_dev account sandbox doesn't allow you to change in the Configs of HDFS service.

I downloaded Sandbox 2.5 but I am downloading it again I think the download dint happen properly so it is giving me an error while importing. However I don't think it's an issue with the sandbox version.

Please help with this.

Thanks in advance

Re: How to get Hive Upload Table option ?

raghu1bobby — Sun, 18 Aug 2019 12:13:53 GMT

I am also facing the same issue. What is the workaround for this? I have setup the HDP cluster on EC2.

I am also facing the same issue. What is the work around for this.