conversion
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
conversion [2016/03/11 14:49] dmtolpeko [Language Elements and Operators] |
conversion [2016/04/13 14:12] (current) 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 | | ||
| Line 80: | Line 79: | ||
| | **Source** || **Hive SQL** | | | **Source** || **Hive SQL** | | ||
| + | | DELETE FROM //table// ALL || TRUNCATE TABLE //table// | | ||
| | [[set-session#current-schema|SET CURRENT SCHEMA = name]] || [[use|USE name]] | | | [[set-session#current-schema|SET CURRENT SCHEMA = name]] || [[use|USE name]] | | ||
Page Tools
