Presto commonly used sentence collation

Source: Internet
Author: User

Inquire

Fetching data rows from 0 or more tables

...............] ][ LIMIT count ]

from_itemAs one of the following

......] ) ]
GROUP BY clause

The GROUP BY clause groups the output of the SELECT statement, and the data row that matches the value in the group. The Group by clause supports arbitrary expressions, including specifying column names or column ordinals (starting at 1).

HAVING clause

The HAVING clause is used in conjunction with the aggregate function and the GROUP BY clause to control the selection grouping. The HAVING clause removes the grouping that does not satisfy the condition. After the grouping and aggregation calculations are complete, you have to filter the groupings.

The following example queries the Customer table and groups the records that account balances are larger than the specified values:

SELECT count(*), mktsegment, nationkey, CAST(sum(acctbal) AS bigint) AS totalbalFROM customerGROUP BY mktsegment, nationkeyHAVING sum(acctbal) > 5700000ORDER BY totalbal DESC;
Union clause

The UNION clause is used to combine the results of multiple query statements into one result set:

queryUNION [ALLDISTINCTquery

The parameter all or DISTINCT controls which rows The final result set contains. If the parameter all is specified, all rows are included, even if the rows are identical. If the parameter DISTINCT is specified, the result set is merged and the result set has only unique rows that are not duplicates. If you do not specify a parameter, DISTINCT is used by default when executing.
Multiple unions are executed from left to right unless the order is explicitly specified in parentheses.

Insert

Inserts a row into the table.

INSERT INTO table_name query

The specified column name is not currently supported. Therefore, the columns in the query statement must exactly match the columns in the table that you want to insert. For example:

INSERT INTO orders SELECT * FROM new_orders;INSERT INTO cities VALUES (1, ‘San Francisco‘);NSERT INTO cities VALUES (2, ‘San Jose‘), (3, ‘Oakland‘);
Table Operations
function Statement Description
Modify Table ALTER TABLE name RENAME to New_name Change the definition of an existing table
Build table CREATE TABLE table_name as Query Create a new table that contains query query results
Build View CREATE [OR REPLACE] VIEW view_name as Query Creates a new view of a query query. A view is a logical table that can be used in future queries. The view does not contain any data. Query statements stored in the view are executed whenever the view is used by another query statement
View table Structure DESCRIBE table_name View a table structure that already exists
Delete Table DROP TABLE table_name Delete a table that already exists
Delete View DROP VIEW view_name Delete A view that already exists
Show
function Statement Description
Show Columns SHOW COLUMNS from table List columns and their data types and other properties in a table
Display functions SHOW FUNCTIONS List all functions that are available for querying
Show partitions SHOW partitions from table [WHERE ...] [ORDER by ...] [LIMIT ...] Lists the partitions in the table, which can be filtered using the WHERE clause, ordered by the ORDER BY clause, and restricted using the limit clause. These clauses work the same way they do in queries
Show Library SHOW SCHEMAS [from catalog] List the libraries in the catalog or current catalog
Show session SHOW SESSION List current session properties
Show Table SHOW TABLES [from schema] [like pattern] Lists the tables in the specified library or in the current library. You can control the table names listed by using the LIKE clause
Explain

Displays a logical or distributed execution scenario for a statement.

...] ) ] statementoption可以为以下之一:    FORMAT { TEXT | GRAPHVIZ }    TYPE { LOGICAL | DISTRIBUTED }

Presto commonly used sentence collation

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.