Milind Jagre milindjagre

## post41.csv

          
            1
            tina
            F

            
              2
              jerry
              M

            
              3
              tom
              M

            
              4
              wonder woman
              F

            
              5
              scoobydoo
              M

            
              6
              donald duck
              M

            
              7
              pink panther
              F

            
              8
              oggy
              M

            
              9
              shinchan
              M

## post40.sql
create table post40 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as textfile;

## post39.sql
create table post39 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as textfile;

## post39.csv

          
            2
            jerry
            M

            
              3
              tom
              M

            
              4
              wonder woman
              F

            
              5
              scoobydoo
              M

            
              6
              donald duck
              M

            
              7
              pink panther
              F

            
              8
              oggy
              M

            
              9
              shinchan
              M

## post38.sql
create table post38 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as textfile;

## post38.csv

          
            2
            jerry
            M

            
              3
              tom
              M

            
              4
              wonder woman
              F

            
              5
              scoobydoo
              M

            
              6
              donald duck
              M

            
              7
              pink panther
              F

            
              8
              oggy
              M

            
              9
              shinchan
              M

## post37.sql
create external table post37 (
id int,
name string,
gender string
)
row format delimited
fields terminated by '\t'
stored as textfile
location '/hdpcd/input/post37/';

## post37.tsv

          
            1
            tina
            F

            
              2
              jerry
              M

            
              3
              tom
              M

            
              4
              wonder woman
              F

            
              5
              scoobydoo
              M

            
              6
              donald duck
              M

            
              7
              pink panther
              F

            
              9
              shinchan
              M

            
              8
              oggy
              M

## post36.sql
create table post36 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as sequencefile;

## post34.sql
create table post34 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as orc;
1	tina	F
2	jerry	M
3	tom	M
4	wonder woman	F
5	scoobydoo	M
6	donald duck	M
7	pink panther	F
8	oggy	M
9	shinchan	M
	create table post40 (
	id int,
	name string,
	gender string
	)
	row format delimited
	fields terminated by ','
	stored as textfile;
	create table post39 (
	id int,
	name string,
	gender string
	)
	row format delimited
	fields terminated by ','
	stored as textfile;
	create table post38 (
	id int,
	name string,
	gender string
	)
	row format delimited
	fields terminated by ','
	stored as textfile;
	create external table post37 (
	id int,
	name string,
	gender string
	)
	row format delimited
	fields terminated by '\t'
	stored as textfile
	location '/hdpcd/input/post37/';
	create table post36 (
	id int,
	name string,
	gender string
	)
	row format delimited
	fields terminated by ','
	stored as sequencefile;
	create table post34 (
	id int,
	name string,
	gender string
	)
	row format delimited
	fields terminated by ','
	stored as orc;