conversion
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
conversion [2016/03/09 12:20] dmtolpeko [SQL SELECT Statement] |
conversion [2016/03/11 14:49] dmtolpeko [Language Elements and Operators] |
||
|---|---|---|---|
| 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 68: | 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 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 | | ||
Page Tools
