Create New Table | Hive Tutorial Part-4 | How to create new table? | Data Types
Course Materials
https://github.com/venkatareddykonasa...
To keep up with the latest updates, join our WhatsApp community: https://chat.whatsapp.com/GidY7xFaFtk...
In this video, we delve into the process of creating a new table in SQL from scratch. We'll explore the SQL query required, step-by-step, along with the necessary schema for the new table.
Starting with the SQL command ""CREATE TABLE,"" we specify the table name and its schema. For instance, in our example, we create a table named "stackoverflow_tags" with columns such as ID, title, body, tag1, tag2, tag3, and tag4.
This schema mirrors the structure of our dataset, which, in this case, is the StackOverflow data. This dataset, typically stored as a text file with columns for ID, title, body, and tags, serves as the blueprint for our new table.
Using the SQL code provided, we generate an empty table with the defined columns. Upon running the ""SHOW TABLES"" command, you'll see our newly created table alongside any existing ones.
However, initially, the table will be empty, as confirmed by running ""SELECT COUNT(*)"" on our new table, resulting in zero rows.
To illustrate further, we also demonstrate running the same command on an existing table, "student_data," which reveals its row count to be seven.
Next steps involve populating our new "stackoverflow_tags" table. Before that, we need to ensure our data is on HDFS (Hadoop Distributed File System). If the data isn't already on HDFS, it must be moved there.
This tutorial offers a clear, concise walkthrough of the process, making it ideal for beginners and those looking to refresh their SQL skills.
Don't forget to like, share, and subscribe for more SQL tutorials!
#SQLTutorial #CreateTableSQL #DatabaseManagement #dataanalysis
#SQLCommands #hive #hivetutorial #bigdata