@Yair Ogen, I did a find for hive-jdbc jars and got the below result. Check if any of the paths exist in your setup /usr/hdp/2.6.2.0-205/spark2/jars/hive-jdbc-1.21.2.2.6.2.0-205.jar /usr/hdp/2.6.2.0-205/hive/lib/hive-jdbc.jar /usr/hdp/2.6.2.0-205/hive/lib/hive-jdbc-1.2.1000.2.6.2.0-205.jar /usr/hdp/2.6.2.0-205/hive/jdbc/hive-jdbc-1.2.1000.2.6.2.0-205-standalone.jar /usr/hdp/2.6.2.0-205/hive2/lib/hive-jdbc-2.1.0.2.6.2.0-205.jar /usr/hdp/2.6.2.0-205/hive2/lib/hive-jdbc.jar /usr/hdp/2.6.2.0-205/hive2/jdbc/hive-jdbc-2.1.0.2.6.2.0-205-standalone.jar /usr/hdp/2.6.2.0-205/oozie/share/lib/hive2/hive-jdbc-1.2.1000.2.6.2.0-205.jar /usr/hdp/2.6.2.0-205/oozie/libserver/hive-jdbc-1.2.1000.2.6.2.0-205.jar /usr/hdp/2.6.2.0-205/oozie/libtools/hive-jdbc-1.2.1000.2.6.2.0-205.jar /usr/hdp/2.6.2.0-205/zeppelin/interpreter/jdbc/hive-jdbc-1.2.1000.2.6.2.0-205.jar Thanks, Aditya ... View more

@Neha G You can use the basic hdfs commands to achieve this. hdfs dfs -copyFromLocal <local file system path> <hdfs path> - to copy files from local to hdfs hdfs dfs -copyToLocal <hdfs path> <local fs path> - copy from hdfs to local hdfs dfs -put <local file system path> <hdfs path> - to copy files from local to hdfs hdfs dfs -get <hdfs path> <local fs path> - copy from hdfs to local hdfs dfs -ls <path> - list the files. Check this link for more commands. https://hadoop.apache.org/docs/current/hadoop-project-dist/hadoop-common/FileSystemShell.html Make sure to run kinit with hdfs keytab before running the above commands as it is a secure enviroment ( kinit -kt /etc/security/keytabs/hdfs.headless.keytab <principal>) If you don't know the value of principal , you can run the below command and get it [root@xxxxx ~]# klist -kte /etc/security/keytabs/hdfs.headless.keytab Keytab name: FILE:/etc/security/keytabs/hdfs.headless.keytab KVNO Timestamp Principal ---- ----------------- -------------------------------------------------------- 1 09/10/17 14:06:14 hdfs@EXAMPLE.COM (aes128-cts-hmac-sha1-96) 1 09/10/17 14:06:14 hdfs@EXAMPLE.COM (arcfour-hmac) 1 09/10/17 14:06:14 hdfs@EXAMPLE.COM (des-cbc-md5) 1 09/10/17 14:06:14 hdfs@EXAMPLE.COM (des3-cbc-sha1) 1 09/10/17 14:06:14 hdfs@EXAMPLE.COM (aes256-cts-hmac-sha1-96) In the above output hdfs@EXAMPLE.COM is the principal, so your kinit command would be kinit -kt /etc/security/keytabs/hdfs.headless.keytab hdfs@EXAMPLE.COM Note : You can also use ambari files view to do these operations. GUI would be easy. Thanks, Aditya ... View more

@Neha G, Is your hostname exactly "nhknox-Virtual-Machine.mad.lab" or "nhknox-virtual-machine.mad.lab". We have seen issues where hostname in Mixed case has caused issues. If that is the case for you, change the hostname to all small letters and restart ambari server and then try restarting the namenode. If your hostname has all small letters, can you please paste your namenode logs under (/var/log/hadoop-hdfs/hdfs) Thanks, Aditya ... View more

@Ivan Majnaric, Did you try running sqlline.py. It will create the tables for you. (/usr/hdp/current/phoenix-client/bin/sqlline.py) Thanks, Aditya ... View more