This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
select [2015/09/23 20:27] 127.0.0.1 external edit |
select [2016/04/20 07:48] (current) dmtolpeko |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== SELECT Statement - PL/HQL ====== | + | ====== SELECT Statement ====== |
SELECT statement allows you to run queries. | SELECT statement allows you to run queries. | ||
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]] |