insert into and insert overwrite

 

  • INSERT INTO to append data to a table.
  • INSERT OVERWRITE to replace the data in a table; each new set of inserted rows replaces any existing data in the table.

 

# from a table with the same definition 
insert into table text_table select * from default.tab1;


# The VALUES clause is a general-purpose way to specify all the columns of a row or multiple rows
insert into val_example values (1,true,100.0);

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s