Versions Compared

Old Version 9

changes.mady.by.user Vineet Garg

Saved on

compared with

New Version 10

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: minor edits

...

Currently HIVE doesn't support subqueries in SELECT statement e.g. , for example, the following query will not run on HIVE:

Code Block
languagesql
SELECT customer.customer_num,
	(SELECT SUM(ship_charge) 
		FROM orders
		WHERE customer.customer_num = orders.customer_num
	) AS total_ship_chg
FROM customer

...