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