Skip to content

Instantly share code, notes, and snippets.

View milindjagre's full-sized avatar
💭
❤️ DATA ❤️

Milind Jagre milindjagre

💭
❤️ DATA ❤️
14 followers · 0 following
View GitHub Profile
@milindjagre
milindjagre / post39.sql
Created July 26, 2017 14:13
this SQL file is used for creating a hive table to load the data from the HDFS directory
create table post39 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as textfile;
@milindjagre
milindjagre / post39.csv
Created July 26, 2017 14:12
this file is used for loading the data into the hive table from HDFS directory
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
@milindjagre
milindjagre / post38.sql
Created July 25, 2017 18:03
this SQL file is used for loading data into the hive internal table from the local file system
create table post38 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as textfile;
@milindjagre
milindjagre / post38.csv
Created July 25, 2017 17:46
this file is used for loading the data into hive table from the local file system
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
@milindjagre
milindjagre / post37.sql
Created July 19, 2017 01:15
this SQL file is used for creating the Hive table for TAB delimited data
create external table post37 (
id int,
name string,
gender string
)
row format delimited
fields terminated by '\t'
stored as textfile
location '/hdpcd/input/post37/';
@milindjagre
milindjagre / post37.tsv
Created July 17, 2017 13:35
this file is used for loading into hive table with TAB delimited format
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
@milindjagre
milindjagre / post36.sql
Created July 15, 2017 18:14
this sql file is used for creating a hive table with SequenceFileInputFormat
create table post36 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as sequencefile;
@milindjagre
milindjagre / post34.sql
Created July 3, 2017 13:39
this SQL file is used for creating the hive internal table with ORC as the input format
create table post34 (
id int,
name string,
gender string
)
row format delimited
fields terminated by ','
stored as orc;
@milindjagre
milindjagre / twitter-bot.R
Last active July 1, 2017 00:03
this file is used for creating a Twitter bot using R
#######################################
# TWITTER BOT #
#######################################
#Twitter App Consumer Key
ConsumerKey="YOUR_TWITTER_APP_CONSUMER_KEY"
#Twitter App Consumer Secret
ConsumerSecret="YOUR_TWITTER_APP_CONSUMER_SECRET"
@milindjagre
milindjagre / post32.sql
Created June 26, 2017 11:50
this SQL file is used for creating hive bucketed table post32
create table post32 (
id int,
name string,
gender string
)
clustered by (id) into 4 buckets
row format delimited
fields terminated by ','
stored as textfile;