custom locations for inner and external tables

hive> use practice;

OK

Time taken: 0.037 seconds

hive> create table  sample1(line string)

    >  location '/user/mypath';

OK

Time taken: 0.081 seconds

hive> load data local inpath 'file1' into table sample1;

Copying data from file:/home/training/file1

Copying file: file:/home/training/file1

Loading data to table practice.sample1

OK

Time taken: 0.138 seconds

hive> create external table sample2(line string)

    >  location '/user/urpath';

OK

Time taken: 0.05 seconds

hive> load data local inpath 'file2' into table sample2;

Copying data from file:/home/training/file2

Copying file: file:/home/training/file2

Loading data to table practice.sample2

OK

Time taken: 0.192 seconds

hive> select * from sample2;

OK

bbbbbbbbbb

bbbbbbbbbb

Time taken: 0.111 seconds

hive> 

[training@localhost ~]$ hadoop fs -ls /user/mypath

Found 1 items

-rw-r--r--   1 training supergroup         16 2015-04-19 00:20 /user/mypath/file1

[training@localhost ~]$ hadoop fs -ls /user/urpath

Found 1 items

-rw-r--r--   1 training supergroup         22 2015-04-19 00:22 /user/urpath/file2

_________________________________-

[training@localhost ~]$ hadoop fs -mkdir /user/d1/p1

[training@localhost ~]$ hadoop fs -copyFromLocal file3 /user/d1/p1

[training@localhost ~]$ 

hive> create table sample3(line string)

    > location '/user/d1/p1';

OK

Time taken: 0.059 seconds

hive> select * from sample3;

OK

cvxccccccccccc

cccccccccccccc

cccccccccccccc

Time taken: 0.11 seconds

hive> 

__________________________________________________

hive> create table ramp1(line string)

    > location  '/user/myramp';

OK

Time taken: 0.04 seconds

hive> create external  table ramp2(line string)

    >  location '/user/myramp';

OK

Time taken: 0.043 seconds

hive> load data local inpath 'file1' into table ramp1;

Copying data from file:/home/training/file1

Copying file: file:/home/training/file1

Loading data to table practice.ramp1

OK

Time taken: 0.173 seconds

hive> select * from ramp2;

OK

aaaaa

aaaaaaaaa

Time taken: 0.074 seconds

hive> load data local inpath 'file2' into table ramp2;

Copying data from file:/home/training/file2

Copying file: file:/home/training/file2

Loading data to table practice.ramp2

OK

Time taken: 0.147 seconds

hive> select * from ramp1;

OK

aaaaa

aaaaaaaaa

bbbbbbbbbb

bbbbbbbbbb

Time taken: 0.112 seconds

hive> drop table ramp1;

OK

Time taken: 0.11 seconds

hive> select * from ramp2;

OK

Time taken: 0.051 seconds

hive> 

__________________