This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
select [2016/03/23 07:12] dmtolpeko [SELECT Statement - PL/HQL] |
select [2016/04/20 07:48] dmtolpeko |
||
---|---|---|---|
Line 5: | Line 5: | ||
===== SELECT TOP n ===== | ===== SELECT TOP n ===== | ||
- | You can specify a SELECT statement with the TOP clause. PL/SQL automatically converts it to LIMIT clause for Hive. | + | You can specify a SELECT statement with the TOP clause. HPL/SQL automatically converts it to LIMIT clause for Hive. |
**Example**: | **Example**: | ||
Line 15: | Line 15: | ||
**Compatibility**: Microsoft SQL Server. | **Compatibility**: Microsoft SQL Server. | ||
- | **Version**: PL/HQL 0.3.7 | + | **Version**: HPL/SQL 0.3.7 |
===== SELECT Without FROM Clause ===== | ===== SELECT Without FROM Clause ===== | ||
- | You can specify a SELECT statement without FROM. PL/SQL automatically adds the FROM clause using the table name defined by the [[configuration#plhqldualtable|plhql.dual.table]] option. | + | You can specify a SELECT statement without FROM. HPL/SQL can automatically add the FROM clause using the table name defined by the [[configuration#hplsqldualtable|hplsql.dual.table]] option. |
- | By default, PL/HQL uses //default.dual// table name. Make sure such table exists in the database and contains exactly one row and one column only. | + | By default, HPL/SQL uses //default.dual// table name. Make sure such table exists in the database and contains exactly one row and one column only. |
**Example**: | **Example**: | ||
Line 31: | Line 31: | ||
**Compatibility**: Microsoft SQL Server, PostgreSQL, MySQL and Netezza. | **Compatibility**: Microsoft SQL Server, PostgreSQL, MySQL and Netezza. | ||
- | **Version**: PL/HQL 0.03 | + | **Version**: HPL/SQL 0.3 |
===== FROM TABLE (VALUES ... ) Clause ===== | ===== FROM TABLE (VALUES ... ) Clause ===== | ||
Line 67: | Line 67: | ||
</code> | </code> | ||
- | Note that PL/HQL transforms FROM (VALUES ...) clause to SELECT UNION ALL subquery before the execution in Hive: | + | Note that HPL/SQL transforms FROM (VALUES ...) clause to SELECT UNION ALL subquery before the execution in Hive: |
<code language=sql> | <code language=sql> | ||
Line 78: | Line 78: | ||
</code> | </code> | ||
- | You can specify the single row, single column dual table using [[configuration#plhqldualtable|plhql.dual.table]] option. | + | You can specify the single row, single column dual table using [[configuration#hplsqldualtable|hplsql.dual.table]] option. |
**Compatibility**: IBM DB2, Microsoft SQL Server | **Compatibility**: IBM DB2, Microsoft SQL Server | ||
- | **Version**: PL/HQL 0.03 | + | **Version**: HPL/SQL 0.3 |
See also: | See also: | ||
* [[select-into|SELECT INTO]] | * [[select-into|SELECT INTO]] |