Azure databricks : Create table using ..

Question

If in Azure databricks , I create table using

Create table <tablename> using delta location ......

is it a hive table format table ? and its schema / definition is stored at the azure databricks metastore ?

what's the difference between hive and delta table ?

hive table can be stored at Azure blob storage ?

Answer 1

Hello @sakuraime ,
Thanks for the ask and using Microsoft Q&A platform .
When you create a table in ADB .

CREATE TABLE students_HIVE (name VARCHAR(64), address VARCHAR(64), student_id INT)
USING HIVE PARTITIONED BY (student_id);

INSERT INTO students_HIVE VALUES
('Amy Smith', '123 Park Ave, San Jose', 111111);

The schema can be viwed at data -> Table name

Delta table are used when you want to persisit the transaction .When you store data as delta table by default data is stored as parquet file in your cloud storage. ... Delta files are sequentially increasing named JSON files and together make up the log of all changes that have occurred to a table.

Thanks
Himanshu

-------------------------------------------------------------------------------------------------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators