Hive tutorial - create database, describe database, use database, drop database, current database

Опубликовано: 05 Октябрь 2024
на канале: AI and beyond
116
2

Hive tutorial - create database, comment database, location database, describe database, use database, drop database, current database


In this video it is show in details how we work with a particular Hive database

It is shown how we can specify additional parameters while creating a new database, like comment which would be seen to other users as well as location where data will be stored on HDFS if for some reasons we do not like default location

It is shown how to prevent Hive script from failure if a database with a particular name already exists

It is shown how to delete / drop a database from Hive. By default it is not allowed to delete a database if it contains at least one table. Video shown how we can delete a database even if it contains one or multiple tables

It is shown how it could be checked which database we are currently working with

In the next video we will discuss multiple options we can use while creating a new table in the existing database

Do not forget to visit our blog available at http://blog.dataguru.guide , where you will find a lot of posts and articles relate to BigData topics. Stay turned!



Twitter -   / f_dmitrijs  
Instagram -   / dmitrijs.f  
Linkedin -   / dmitrijs-finaskins-a69598a5  
Facebook -   / dmitry.finashkin