select

Differences

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

Link to this comparison view

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]]