@rich ... View more

@Kibrom GebreHiwot Perhaps your /etc/hosts is wrong... What's in your /etc/hosts? Is 10.0.225.60 there? What is the eth0 ip address when you do a ifconfig? Perhaps your ambari-server really did not start. What is your ambari-server status after executing > ambari-server status If it is not running do > ambari-server stop > rm -f /var/run/ambari-server/ambari-server.pid > ambari-server start Do you see an ambari-server process after executing ps -ef | grep ambari-server? If not what is in the log file /var/log/ambari-server/ambari-server.log? If you don't see any errors follow the steps here: https://community.hortonworks.com/articles/6227/sandbox-1270018080-not-accessible.html If NAT does not work try Bridged and get the ipaddress using ifconfig, restart Ambari-server and use that ip address when you do a http://:8080>:8080 Finally check the firewalls on your host. ... View more

I assume this is a completely different question right as you are able to view the hive table since you used the --hive-import Sqoop option, and you are now able to see the ORC table you created subsequently and query the data after accomplishing an "INSERT OVERWRITE TABLE" right? If you are just asking how can I import an existing HDFS file/ folder into a Hive Table, then @Artem Ervits is correct. Just do for example create external table employee2 LOCATION '/tmp/task/employees' and query using Hive view. For syntax see https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL ... View more

@keerthana gajarajakumar Let's see if I can make it clear. You asked how can I sqoop data into HDP/ Hive and then create an ORC table from it. I suggested the following: INSTEAD of Sqoop Data into a table and THEN creating an ORC table you can simply create the ORC table directly with Sqoop - hence the following options in the Sqoop call --hcatalog-database default --hcatalog-table my_table_orc --create-hcatalog-table --hcatalog-storage-stanza "stored as orcfile" OR, you can use normal Sqoop without the ORC options, create a normal table as you have done and then create an OrcEmployees table. ... View more

You can also review the docs here: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_dataintegration/content/moving_data_from_hdfs_to_hive_external_table_method.html ... View more

I just realized you had a comment under your original question. I will edit it so that it is the actual question. I was suggesting you can use Sqoop to DIRECTLY create an ORC Table. Try this also: INSERT OVERWRITE TABLE orcemployees SELECT * FROM employees; What is your output after you have done so? ... View more

@keerthana gajarajakumar You have two options: Use Sqoop to save directly as ORC file $ sqoop import --connect jdbc:mysql://localhost/employees --username hive --password hive --table departments --hcatalog-database default --hcatalog-table my_table_orc --create-hcatalog-table --hcatalog-storage-stanza "stored as orcfile" Since you already created the Employee Table then create the ORC table first (employee_orc) and then select from your employee hive table and insert into employee_orc create table employee_orc stored as orc as select * from employee_hive; ... View more

@keerthana gajarajakumar Try this grant all privileges on *.* to ‘username’@’%’ identified by ‘userpassword’; ... View more