Thanks Raj ... View more

table is created...but data is not loaded from EMP1(DIRECT0RY)...In this directory there is emp.txt file ... View more

will it load data without loading from specified location? ... View more

Last login: Sat Dec 3 07:58:20 2016 from 192.168.203.1 [cloudera@quickstart ~]$ hdfs dfs -ls /user/cloudera Found 5 items -rwxrwxrwx 1 cloudera cloudera 28 2016-12-03 05:41 /user/cloudera/emp.txt drwxr-xr-x - cloudera cloudera 0 2016-12-03 08:08 /user/cloudera/emp1 -rw-r--r-- 1 cloudera cloudera 67 2016-12-03 01:35 /user/cloudera/file3.txt -rw-r--r-- 1 cloudera cloudera 0 2016-12-03 02:36 /user/cloudera/merge.txt drwxr-xr-x - cloudera cloudera 0 2016-12-03 02:21 /user/cloudera/ram ... View more

Hi Raj, create external table emp1(eno int, ename string, sal string) row format delimited fields terminate by '~' location '/user/cloudera/hadoop_practise/emp1/emp.txt'; ... View more