Hive Table Creation | Hive Tables | Hive View | Hive Tutorial | Big Data Tutorials for Beginners
Hive Tables in Hadoop | Hive View in Hadoop | Hive Tutorial | Big Data Tutorials for Beginners
https://acadgild.com/big-data/big-dat...
Welcome to Hadoop Hive tutorial conducted by Acadgild. In this Hadoop online tutorial, we will take you through an in-depth introduction to Hive Tables and Hive Views.
Check out the hands-on execution of creating hive tables in Hadoop.
• THE CREATE TABLE statement follows SQL conventions, but Hive’s version offers significant extensions to support a wide range of flexibility where the data files for tables are stored, the formats used, etc.
• DROP TABLE IF EXISTS emp_details:
• Most table properties can be altered with ALTER TABLE statements, which change metadata about the table but not the data itself
• Renaming Table
• Use this statement to rename the table emp_deatails to employee_details;
• Changing Columns
• You can rename a column, change its position, type or comment:
• ALTER TABLE emp_details
• CHANGE COLUMN emp_name emp_name STRING
• COMMENT ‘Employee Name’
• AFTER unit;
• You have to specify the old name, a new name, and the type, even if the name or type
• Is not changing
Kindly go through the complete video for an in-depth hive tutorial.
Please like and share the video and kindly give your feedbacks and subscribe the channel for more tutorial videos.
For more updates on courses and tips follow us on:
Facebook: / acadgild
Twitter: / acadgild
LinkedIn: / acadgild
Смотрите видео Hive Table Creation | Hive Tables | Hive View | Hive Tutorial | Big Data Tutorials for Beginners онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ACADGILD 23 Июль 2018, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,423 раз и оно понравилось 18 людям.