1. Load data from another table
insert overwrite table batting
SELECT
regexp_extract(col_value,'^(?:([^,]*)\,?){1}',1) player_id,
regexp_extract(col_value,'^(?:([^,]*)\,?){2}',1) year,
regexp_extract(col_value,'^(?:([^,]*)\,?){9}',1) run
FROM temp_batting;
2. Load data from File
LOAD DATA INPATH '/user/hue/Batting.csv' OVERWRITE INTO TABLE temp_batting
Search This Blog
May 26, 2015
May 25, 2015
HIVE: Create Table
CREATE TABLE TABLE_NAME (COL1 STRING, COL2 INT);
create table Batting
(PlayerId STRING, Year INT,Runs INT);
create table Batting
(PlayerId STRING, Year INT,Runs INT);
May 24, 2015
Hive: Select Statements
1. SELECT * FROM Table_Name;
2. SELECT * FROM Table_Name WHERE Column_Name =’’;
3. SELECT COUNT(*) FROM TABLE_Name;
4. SELECT COL_1, MAX(COL_2) FROM Table_Name
GROUP BY COL_1
5. SELECT a.* from Table_Name a
Join (select * from table_name ) b
On (a.col_1 = b.col_1)
2. SELECT * FROM Table_Name WHERE Column_Name =’’;
3. SELECT COUNT(*) FROM TABLE_Name;
4. SELECT COL_1, MAX(COL_2) FROM Table_Name
GROUP BY COL_1
5. SELECT a.* from Table_Name a
Join (select * from table_name ) b
On (a.col_1 = b.col_1)
May 23, 2015
Hive: Hive Commands
How to invoke Hive
hive
How to exit from Hive
quit;
List all databases present in Hive
show databases;
Execute commands in a database
use database_name;
List all tables present in a database
show tables
How to view table structure
describe table_name;
hive
How to exit from Hive
quit;
List all databases present in Hive
show databases;
Execute commands in a database
use database_name;
List all tables present in a database
show tables
How to view table structure
describe table_name;
May 22, 2015
SQOOP: Jobs
How to get help of SQOOP JOB command
sqoop help job
How to view saved SQOOP jobs
sqoop job --list
How to view content of saved SQOOP job
sqoop job --show job_name
How to delete a saved SQOOP Job
sqoop job --delete job_name
sqoop help job
How to view saved SQOOP jobs
sqoop job --list
How to view content of saved SQOOP job
sqoop job --show job_name
How to delete a saved SQOOP Job
sqoop job --delete job_name
Subscribe to:
Posts (Atom)