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
Watch video Hive Table Creation | Hive Tables | Hive View | Hive Tutorial | Big Data Tutorials for Beginners online without registration, duration hours minute second in high quality. This video was added by user ACADGILD 23 July 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,423 once and liked it 18 people.