4:56 AM

Hive Partition Tables

...

Learn more »

1:31 AM

Hive Data types and Merging tables , table to table copy

Lab Practice: [training@localhost ~]$ cat > tmpr.txt xxxxx1950xxx23xx xxxxx1950xxx25xx xxxxx1950xxx24xx xxxxx1951xxx21xx xxxxx1951xxx20xx [training@localhost ~]$ hive> create table raw(line string); OK...

Learn more »

12:33 AM

Hive : Loading data into hive tables

Lab Practice: [training@localhost ~]$ cat > samp1 100,200,300 200,500,500 12,345,567 hive> use practice; OK Time taken: 0.037 seconds hive> show...

Learn more »

4:04 AM

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...

Learn more »

4:28 AM

Example9:(number of employees in the organization)

Example9:   Emp9.java ___________________________________________________________________________________________________ [training@localhost ~]$ hadoop fs -cat mr/emp 101,ravi,10000,hyd,m,11 102,rani,12000,pune,f,12 103,ravina,13000,hyd,f,13 104,rana,14000,hyd,m,11 105,roopa,15000,pune,f,12 106,razeena,16000,pune,f,12 107,susma,14000,hyd,f,12 108,sampurnesh,20000,delhi,m,13 109,samantha,18000,pune,f,12 110,kamal,19000,delhi,m,11...

Learn more »

4:27 AM

Example8:(Minimum salary of the organization)

Example 8:    Emp8.java _____________________________________________________________________________________ [training@localhost ~]$ hadoop fs -cat mr/emp 101,ravi,10000,hyd,m,11 102,rani,12000,pune,f,12 103,ravina,13000,hyd,f,13 104,rana,14000,hyd,m,11 105,roopa,15000,pune,f,12 106,razeena,16000,pune,f,12 107,susma,14000,hyd,f,12 108,sampurnesh,20000,delhi,m,13 109,samantha,18000,pune,f,12...

Learn more »

4:25 AM

Example7:(Maximum salary of the organization)

Example 7:    Emp7.java _______________________________________________________________________________________________ [training@localhost ~]$ hadoop fs -cat mr/emp 101,ravi,10000,hyd,m,11 102,rani,12000,pune,f,12 103,ravina,13000,hyd,f,13 104,rana,14000,hyd,m,11 105,roopa,15000,pune,f,12 106,razeena,16000,pune,f,12 107,susma,14000,hyd,f,12 108,sampurnesh,20000,delhi,m,13 109,samantha,18000,pune,f,12...

Learn more »