[Hindi] Hive Basic Important command for Hadoop

Enroll to the Oracle DBA real time interview Question
====================================================
https://learnomate.org/courses/oracle-dba-interview-question/

WhatsApp me for Training - https://wa.link/gi7fv2

Starting new Oracle DBA batch in next week.
Please connect with me if you are interested.
Batch will start from next week
Time - 9am ist (11:30 PM EST)
Duration - 45 days
Daily one hour
Contact - +91 9960262955
Email - [email protected]
Fees - 15k (300$)

Two installments can be available

Syllabus -

https://www.learnomate.org/syllabus

Review -

https://www.learnomate.org/reviews

YouTube Channel

https://youtu.be/cFHMTPEtUG0

Registration

https:www.learnomate.org/register

WhatsApp me
https://wa.link/usfz52

Facebook Page
https://www.facebook.com/learnomate/

LinkedIn
https://www.linkedin.com/in/ankushthavali/ DDL Commands on Databases in Hive
=======================================
Usage of Create Database Command in Hive

create database if not exists firstDB comment "This is my first demo" location '/user/hive/warehouse/newdb' with DBPROPERTIES ('createdby'='Ankush','createdfor'='orcldata');

Drop Database in Hive
===========================
drop database if exists firstDB CASCADE;


Describe Database Command in Hive (This command is used to check any associated metadata for the databases.)
=================================================
describe database extended firstDB;



Usage of Show Database Command
==============================
show databases



Usage of Use Database Command in Hive
=====================================
use database;



DDL Commands on Tables in Hive
Create Table Command in Hive
=======================================
How to create a table in hive by copying an existing table schema?

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name Like [db_name].existing_table [LOCATION hdfs_path]


DROP Table Command in Hive
================================
DROP TABLE [IF EXISTS] table_name [PURGE];


TRUNCATE Table Command in Hive
===================================
TRUNCATE TABLE [db_name].table_name


ALTER Table Command in Hive
==================================
ALTER TABLE [db_name].old_table_name RENAME TO [db_name].new_table_name;

ALTER TABLE firstDB.internal_table rename to firstDB.internal_table1;

DESCRIBE Table Command in Hive
===================================
DESCRIBE [EXTENDED|FORMATTED] [db_name.] table_name[.col_name ( [.field_name]


Show Table Command in Hive
===============================
show tables


DML Commands in Hive
==============================
=================================

Data can be loaded into Hive tables using –

LOAD command
Insert command



LOAD DATA [LOCAL] INPATH 'hdfsfilepath/localfilepath' [OVERWRITE] INTO TABLE existing_table_name


hive= select * from students;
hive= select * from students limit 5;
hive= select count(*) from table_name;
hive= select state ,COUNT(*) from students group by state ;


hive commands list

hive commands pdf

hive -f command example

hive commands tutorial

hive sql commands

hive commands cheat sheet

hive dml commands

hive commands cheat sheet pdf

#hive
#bigdata
#analytics