This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
conversion [2016/03/09 12:20] dmtolpeko [SQL SELECT Statement] |
conversion [2016/03/09 12:21] dmtolpeko |
||
---|---|---|---|
Line 68: | Line 68: | ||
| **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 clause || FROM [[configuration#plhqldualtable|plhql.dual.table]] added for Hive 0.13 and earlier | | + | | 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 | | ||