Hive QL vs SQL

No "IN" Clause Zero-based indexing "AS" aliasing for columns only SQL	HIVE QL
ORDER BY SELECT * FROM t WHERE id in (...)	SORT BY (ORDER BY is partial sort) SELECT * FROM t LEFT SEMI JOIN t2 ON ...
SELECT f[1] FROM t	SELECT f[0] FROM t

SELECT * FROM t AS tt	SELECT * FROM t tt