conversion

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
conversion [2016/03/10 16:43]
dmtolpeko [Data Types]
conversion [2016/04/13 14:12]
dmtolpeko [SQL SELECT Statement]
Line 51: Line 51:
 | **Source** || **Hive SQL** | | **Source** || **Hive SQL** |
 | "​identifier",​ [identifier] | Identifier | `identifier` |  | "​identifier",​ [identifier] | Identifier | `identifier` | 
 +| dbo, [dbo] | Schema name | Removed |
 | [[twopipes|expr || expr2 || ...]] | String concatenation | [[concat|CONCAT(expr,​ expr2, ...)]] | | [[twopipes|expr || expr2 || ...]] | String concatenation | [[concat|CONCAT(expr,​ expr2, ...)]] |
  
Line 69: 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 79: 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]] |