conversion

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
conversion [2016/04/13 14:11]
dmtolpeko [SQL Statements]
conversion [2016/04/13 14:12]
dmtolpeko [SQL SELECT Statement]
Line 70: Line 70:
 | **Source** || **Hive SQL** | | **Source** || **Hive SQL** |
 | SELECT TOP n ... FROM ... | Row limit | SELECT ... FROM ... LIMIT n | | SELECT TOP n ... FROM ... | Row limit | SELECT ... FROM ... LIMIT n |
-| SELECT without FROM || FROM [[configuration#​hplsqldualtable|hplsql.dual.table]] added for Hive 0.13 and earlier | 
 | FROM TABLE (VALUES ... ) clause | Row constructor | SELECT UNION ALL subquery | | FROM TABLE (VALUES ... ) clause | Row constructor | SELECT UNION ALL subquery |