This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
conversion [2016/03/09 12:21] dmtolpeko |
conversion [2016/04/13 14:11] dmtolpeko [SQL Statements] |
||
---|---|---|---|
Line 44: | Line 44: | ||
| NUMBER | DECIMAL | | | NUMBER | DECIMAL | | ||
+ | For more details, see [[/data-types#data_type_conversion|Data Type Conversion]]. | ||
===== Language Elements and Operators ===== | ===== Language Elements and Operators ===== | ||
Line 50: | 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 78: | Line 80: | ||
| **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]] | | ||