Versions Compared

Old Version 21

changes.mady.by.user Prasad Mujumdar

Saved on

compared with

New Version 22

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: mention CTEs in Insert section (HIVE-1180)

...

  • Multi Table Inserts minimize the number of data scans required. Hive can insert data into multiple tables by scanning the input data just once (and applying different query operators) to the input data.
  • Starting with Hive 0.13.0, the select statement can include one or more common table expressions (CTEs) as shown in the SELECT syntax. For an example, see Common Table Expression.
Dynamic Partition Inserts

...