Hive tutorial - create table, create table like, stored as textfile, stored as parquet

Опубликовано: 29 Сентябрь 2024
на канале: AI and beyond
631
3

Hive tutorial - create table, create table like, stored as textfile, stored as parquet


In this video it is shown how to create a table in Hive by specifying column names, types and comments if needed

It is shown how to prevent Hive from failure if a table with such name already exists

Discussed how to create a new table with the same structure as already existing table, without writting a long create table statement

It is shown how to specify a store format for Hive - in which format data will be stored in HDFS. Discussed textfile and parquet formats, what are the differences between them

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