You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by GitBox <gi...@apache.org> on 2020/06/02 12:01:55 UTC

[GitHub] [flink] lirui-apache opened a new pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

lirui-apache opened a new pull request #12439:
URL: https://github.com/apache/flink/pull/12439


   <!--
   *Thank you very much for contributing to Apache Flink - we are happy that you want to help us improve Flink. To help the community review your contribution in the best possible way, please go through the checklist below, which will get the contribution into a shape in which it can be best reviewed.*
   
   *Please understand that we do not do this to make contributions to Flink a hassle. In order to uphold a high standard of quality for code contributions, while at the same time managing a large number of contributions, we need contributors to prepare the contributions well, and give reviewers enough contextual information for the review. Please also understand that contributions that do not follow this guide will take longer to review and thus typically be picked up with lower priority by the community.*
   
   ## Contribution Checklist
   
     - Make sure that the pull request corresponds to a [JIRA issue](https://issues.apache.org/jira/projects/FLINK/issues). Exceptions are made for typos in JavaDoc or documentation files, which need no JIRA issue.
     
     - Name the pull request in the form "[FLINK-XXXX] [component] Title of the pull request", where *FLINK-XXXX* should be replaced by the actual issue number. Skip *component* if you are unsure about which is the best component.
     Typo fixes that have no associated JIRA issue should be named following this pattern: `[hotfix] [docs] Fix typo in event time introduction` or `[hotfix] [javadocs] Expand JavaDoc for PuncuatedWatermarkGenerator`.
   
     - Fill out the template below to describe the changes contributed by the pull request. That will give reviewers the context they need to do the review.
     
     - Make sure that the change passes the automated tests, i.e., `mvn clean verify` passes. You can set up Azure Pipelines CI to do that following [this guide](https://cwiki.apache.org/confluence/display/FLINK/Azure+Pipelines#AzurePipelines-Tutorial:SettingupAzurePipelinesforaforkoftheFlinkrepository).
   
     - Each pull request should address only one issue, not mix up code from multiple issues.
     
     - Each commit in the pull request has a meaningful commit message (including the JIRA id)
   
     - Once all items of the checklist are addressed, remove the above text and this checklist, leaving only the filled out template below.
   
   
   **(The sections below can be removed for hotfixes of typos)**
   -->
   
   ## What is the purpose of the change
   
   Add doc for Hive dialect.
   
   
   ## Brief change log
   
     - Add a new page for Hive dialect
   
   
   ## Verifying this change
   
   Manually built the page and everything looks fine.
   
   ## Does this pull request potentially affect one of the following parts:
   
   NA
   
   ## Documentation
   
   NA
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] lirui-apache commented on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
lirui-apache commented on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-639306502


   @danny0405 Thanks for the comments. PR updated accordingly.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     }, {
       "hash" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "status" : "SUCCESS",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565",
       "triggerID" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "triggerType" : "PUSH"
     }, {
       "hash" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   * 723262421f8fbf9a4b86639ef8be6d6651f26bba Azure: [SUCCESS](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565) 
   * d7de89b8333fd9e073f6a329e2ba641a2d71f26e UNKNOWN
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] lirui-apache commented on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
lirui-apache commented on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637500275


   @JingsongLi Please take a look. Thanks.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     }, {
       "hash" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "status" : "SUCCESS",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565",
       "triggerID" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   * 723262421f8fbf9a4b86639ef8be6d6651f26bba Azure: [SUCCESS](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565) 
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] lirui-apache commented on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
lirui-apache commented on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637499989


   ![screenshot](https://user-images.githubusercontent.com/5210788/83518517-1bee9580-a50d-11ea-9e1d-f5fd36790a1d.png)
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] lirui-apache commented on a change in pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
lirui-apache commented on a change in pull request #12439:
URL: https://github.com/apache/flink/pull/12439#discussion_r435861584



##########
File path: docs/dev/table/hive/hive_dialect.md
##########
@@ -0,0 +1,347 @@
+---
+title: "Hive Dialect"
+nav-parent_id: hive_tableapi
+nav-pos: 1
+---
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements.  See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership.  The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License.  You may obtain a copy of the License at
+
+  http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied.  See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+Starting from 1.11.0, Flink allows users to write SQL statements in Hive syntax when Hive dialect
+is used. By providing compatibility with Hive syntax, we aim to improve the interoperability with
+Hive and reduce the scenarios when users need to switch between Flink and Hive in order to execute
+different statements.
+
+* This will be replaced by the TOC
+{:toc}
+
+## Use Hive Dialect
+
+Flink currently supports two SQL dialects: `default` and `hive`. You need to switch to Hive dialect
+before you can write in Hive syntax. The following describes how to set dialect with
+SQL Client and Table API. Also notice that you can dynamically switch dialect for each
+statement you execute. There's no need to restart a session to use a different dialect.
+
+### SQL Client
+
+SQL dialect can be specified via the `table.sql-dialect` property. Therefore you can set the initial dialect to use in
+the `configuration` section of the yaml file for your SQL Client.
+
+{% highlight yaml %}
+
+execution:
+  planner: blink
+  type: batch
+  result-mode: table
+
+configuration:
+  table.sql-dialect: hive
+  
+{% endhighlight %}
+
+You can also set the dialect after the SQL Client has launched.
+
+{% highlight bash %}
+
+Flink SQL> set table.sql-dialect=hive; -- to use hive dialect
+[INFO] Session property has been set.
+
+Flink SQL> set table.sql-dialect=default; -- to use default dialect
+[INFO] Session property has been set.
+
+{% endhighlight %}
+
+### Table API
+
+You can set dialect for your TableEnvironment with Table API.
+
+{% highlight java %}
+
+EnvironmentSettings settings = EnvironmentSettings.newInstance().useBlinkPlanner()...build();
+TableEnvironment tableEnv = TableEnvironment.create(settings);
+// to use hive dialect
+tableEnv.getConfig().setSqlDialect(SqlDialect.HIVE);
+// to use default dialect
+tableEnv.getConfig().setSqlDialect(SqlDialect.DEFAULT);
+
+{% endhighlight %}
+
+## DDL
+
+This section lists the supported DDLs with the Hive dialect. We'll mainly focus on the syntax
+here. You can refer to [Hive doc](https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL)
+for the semantics of each DDL statement.
+
+### DATABASE
+
+#### Show
+
+{% highlight sql %}
+SHOW DATABASES;
+{% endhighlight %}
+
+#### Create
+
+{% highlight sql %}
+CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
+  [COMMENT database_comment]
+  [LOCATION fs_path]
+  [WITH DBPROPERTIES (property_name=property_value, ...)];
+{% endhighlight %}
+
+#### Alter
+
+##### Update Properties
+
+{% highlight sql %}
+ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...);
+{% endhighlight %}
+
+##### Update Owner
+
+{% highlight sql %}
+ALTER (DATABASE|SCHEMA) database_name SET OWNER [USER|ROLE] user_or_role;
+{% endhighlight %}
+
+##### Update Location
+
+{% highlight sql %}
+ALTER (DATABASE|SCHEMA) database_name SET LOCATION fs_path;
+{% endhighlight %}
+
+#### Drop
+
+{% highlight sql %}
+DROP (DATABASE|SCHEMA) [IF EXISTS] database_name [RESTRICT|CASCADE];
+{% endhighlight %}
+
+#### Use
+
+{% highlight sql %}
+USE database_name;
+{% endhighlight %}
+
+### TABLE
+
+#### Show
+
+{% highlight sql %}
+SHOW TABLES;
+{% endhighlight %}
+
+#### Create
+
+{% highlight sql %}
+CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name
+  [(col_name data_type [column_constraint] [COMMENT col_comment], ... [table_constraint])]
+  [COMMENT table_comment]
+  [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
+  [
+    [ROW FORMAT row_format]
+    [STORED AS file_format]
+  ]
+  [LOCATION fs_path]
+  [TBLPROPERTIES (property_name=property_value, ...)]
+  
+row_format:
+  : DELIMITED [FIELDS TERMINATED BY char [ESCAPED BY char]] [COLLECTION ITEMS TERMINATED BY char]
+      [MAP KEYS TERMINATED BY char] [LINES TERMINATED BY char]
+      [NULL DEFINED AS char]
+  | SERDE serde_name [WITH SERDEPROPERTIES (property_name=property_value, ...)]
+  
+file_format:
+  : SEQUENCEFILE
+  | TEXTFILE
+  | RCFILE
+  | ORC
+  | PARQUET
+  | AVRO
+  | INPUTFORMAT input_format_classname OUTPUTFORMAT output_format_classname
+  
+column_constraint:
+  : NOT NULL [[ENABLE|DISABLE] [VALIDATE|NOVALIDATE] [RELY|NORELY]]
+  
+table_constraint:
+  : [CONSTRAINT constraint_name] PRIMARY KEY (col_name, ...) [[ENABLE|DISABLE] [VALIDATE|NOVALIDATE] [RELY|NORELY]]

Review comment:
       We'll need a lot of examples to cover all the use cases. Besides, since we follow Hive syntax, the examples we add will just be duplicates of what's already in Hive's own doc. So I'd prefer to only list the supported syntax here. Users can always refer to Hive docs for semantics and examples.




----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     }, {
       "hash" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   * 723262421f8fbf9a4b86639ef8be6d6651f26bba UNKNOWN
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] danny0405 commented on a change in pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
danny0405 commented on a change in pull request #12439:
URL: https://github.com/apache/flink/pull/12439#discussion_r435755828



##########
File path: docs/dev/table/hive/hive_dialect.md
##########
@@ -0,0 +1,347 @@
+---
+title: "Hive Dialect"
+nav-parent_id: hive_tableapi
+nav-pos: 1
+---
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements.  See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership.  The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License.  You may obtain a copy of the License at
+
+  http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied.  See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+Starting from 1.11.0, Flink allows users to write SQL statements in Hive syntax when Hive dialect
+is used. By providing compatibility with Hive syntax, we aim to improve the interoperability with
+Hive and reduce the scenarios when users need to switch between Flink and Hive in order to execute
+different statements.
+
+* This will be replaced by the TOC
+{:toc}
+
+## Use Hive Dialect
+
+Flink currently supports two SQL dialects: `default` and `hive`. You need to switch to Hive dialect
+before you can write in Hive syntax. The following describes how to set dialect with
+SQL Client and Table API. Also notice that you can dynamically switch dialect for each
+statement you execute. There's no need to restart a session to use a different dialect.
+
+### SQL Client
+
+SQL dialect can be specified via the `table.sql-dialect` property. Therefore you can set the initial dialect to use in
+the `configuration` section of the yaml file for your SQL Client.
+
+{% highlight yaml %}
+
+execution:
+  planner: blink
+  type: batch
+  result-mode: table
+
+configuration:
+  table.sql-dialect: hive
+  
+{% endhighlight %}
+
+You can also set the dialect after the SQL Client has launched.
+
+{% highlight bash %}
+
+Flink SQL> set table.sql-dialect=hive; -- to use hive dialect
+[INFO] Session property has been set.
+
+Flink SQL> set table.sql-dialect=default; -- to use default dialect
+[INFO] Session property has been set.
+
+{% endhighlight %}
+
+### Table API
+
+You can set dialect for your TableEnvironment with Table API.
+
+{% highlight java %}
+
+EnvironmentSettings settings = EnvironmentSettings.newInstance().useBlinkPlanner()...build();
+TableEnvironment tableEnv = TableEnvironment.create(settings);
+// to use hive dialect
+tableEnv.getConfig().setSqlDialect(SqlDialect.HIVE);
+// to use default dialect
+tableEnv.getConfig().setSqlDialect(SqlDialect.DEFAULT);
+
+{% endhighlight %}
+
+## DDL
+
+This section lists the supported DDLs with the Hive dialect. We'll mainly focus on the syntax
+here. You can refer to [Hive doc](https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL)
+for the semantics of each DDL statement.
+
+### DATABASE
+
+#### Show
+
+{% highlight sql %}
+SHOW DATABASES;
+{% endhighlight %}
+
+#### Create
+
+{% highlight sql %}
+CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
+  [COMMENT database_comment]
+  [LOCATION fs_path]
+  [WITH DBPROPERTIES (property_name=property_value, ...)];
+{% endhighlight %}
+
+#### Alter
+
+##### Update Properties
+
+{% highlight sql %}
+ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...);
+{% endhighlight %}
+
+##### Update Owner
+
+{% highlight sql %}
+ALTER (DATABASE|SCHEMA) database_name SET OWNER [USER|ROLE] user_or_role;
+{% endhighlight %}
+
+##### Update Location
+
+{% highlight sql %}
+ALTER (DATABASE|SCHEMA) database_name SET LOCATION fs_path;
+{% endhighlight %}
+
+#### Drop
+
+{% highlight sql %}
+DROP (DATABASE|SCHEMA) [IF EXISTS] database_name [RESTRICT|CASCADE];
+{% endhighlight %}
+
+#### Use
+
+{% highlight sql %}
+USE database_name;
+{% endhighlight %}
+
+### TABLE
+
+#### Show
+
+{% highlight sql %}
+SHOW TABLES;
+{% endhighlight %}
+
+#### Create
+
+{% highlight sql %}
+CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name
+  [(col_name data_type [column_constraint] [COMMENT col_comment], ... [table_constraint])]
+  [COMMENT table_comment]
+  [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
+  [
+    [ROW FORMAT row_format]
+    [STORED AS file_format]
+  ]
+  [LOCATION fs_path]
+  [TBLPROPERTIES (property_name=property_value, ...)]
+  
+row_format:
+  : DELIMITED [FIELDS TERMINATED BY char [ESCAPED BY char]] [COLLECTION ITEMS TERMINATED BY char]
+      [MAP KEYS TERMINATED BY char] [LINES TERMINATED BY char]
+      [NULL DEFINED AS char]
+  | SERDE serde_name [WITH SERDEPROPERTIES (property_name=property_value, ...)]
+  
+file_format:
+  : SEQUENCEFILE
+  | TEXTFILE
+  | RCFILE
+  | ORC
+  | PARQUET
+  | AVRO
+  | INPUTFORMAT input_format_classname OUTPUTFORMAT output_format_classname
+  
+column_constraint:
+  : NOT NULL [[ENABLE|DISABLE] [VALIDATE|NOVALIDATE] [RELY|NORELY]]
+  
+table_constraint:
+  : [CONSTRAINT constraint_name] PRIMARY KEY (col_name, ...) [[ENABLE|DISABLE] [VALIDATE|NOVALIDATE] [RELY|NORELY]]

Review comment:
       Can we also give an example for Hive `create table` ? The syntax template is too complex to understand.




----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     }, {
       "hash" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "status" : "PENDING",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565",
       "triggerID" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   * 723262421f8fbf9a4b86639ef8be6d6651f26bba Azure: [PENDING](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565) 
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     }, {
       "hash" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "status" : "DELETED",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565",
       "triggerID" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "triggerType" : "PUSH"
     }, {
       "hash" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "status" : "SUCCESS",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2794",
       "triggerID" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "triggerType" : "PUSH"
     }, {
       "hash" : "31b991e463168e16cc3400c1df3e06cb28a8a917",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "31b991e463168e16cc3400c1df3e06cb28a8a917",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   * d7de89b8333fd9e073f6a329e2ba641a2d71f26e Azure: [SUCCESS](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2794) 
   * 31b991e463168e16cc3400c1df3e06cb28a8a917 UNKNOWN
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] lirui-apache commented on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
lirui-apache commented on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-640373403


   @JingsongLi The zh file has been added


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot commented on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot commented on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637496929


   Thanks a lot for your contribution to the Apache Flink project. I'm the @flinkbot. I help the community
   to review your pull request. We will use this comment to track the progress of the review.
   
   
   ## Automated Checks
   Last check on commit a8e8962ad90eaaaa67b78240a2a9023e15dec1df (Tue Jun 02 12:05:08 UTC 2020)
   
   **Warnings:**
    * Documentation files were touched, but no `.zh.md` files: Update Chinese documentation or file Jira ticket.
   
   
   <sub>Mention the bot in a comment to re-run the automated checks.</sub>
   ## Review Progress
   
   * ❓ 1. The [description] looks good.
   * ❓ 2. There is [consensus] that the contribution should go into to Flink.
   * ❓ 3. Needs [attention] from.
   * ❓ 4. The change fits into the overall [architecture].
   * ❓ 5. Overall code [quality] is good.
   
   Please see the [Pull Request Review Guide](https://flink.apache.org/contributing/reviewing-prs.html) for a full explanation of the review process.<details>
    The Bot is tracking the review progress through labels. Labels are applied according to the order of the review items. For consensus, approval by a Flink committer of PMC member is required <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot approve description` to approve one or more aspects (aspects: `description`, `consensus`, `architecture` and `quality`)
    - `@flinkbot approve all` to approve all aspects
    - `@flinkbot approve-until architecture` to approve everything until `architecture`
    - `@flinkbot attention @username1 [@username2 ..]` to require somebody's attention
    - `@flinkbot disapprove architecture` to remove an approval you gave earlier
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] danny0405 commented on a change in pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
danny0405 commented on a change in pull request #12439:
URL: https://github.com/apache/flink/pull/12439#discussion_r435723057



##########
File path: docs/dev/table/hive/hive_dialect.md
##########
@@ -0,0 +1,347 @@
+---
+title: "Hive Dialect"
+nav-parent_id: hive_tableapi
+nav-pos: 1
+---
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements.  See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership.  The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License.  You may obtain a copy of the License at
+
+  http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied.  See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+Starting from 1.11.0, Flink allows users to write SQL statements in Hive syntax when Hive dialect
+is used. By providing compatibility with Hive syntax, we aim to improve the interoperability with
+Hive and reduce the scenarios when users need to switch between Flink and Hive in order to execute
+different statements.
+
+* This will be replaced by the TOC
+{:toc}
+
+## Use Hive Dialect
+
+Flink currently supports two SQL dialects: `default` and `hive`. You have to choose to use Hive
+dialect before you can write in Hive syntax. The following describes how to set dialect with
+SQL Client and Table API. Please also be noted that you can dynamically switch dialect for each
+statement you execute. There's no need to restart a session to use a different dialect.
+
+### SQL Client
+
+SQL dialect can be specified via the `table.sql-dialect` property. Therefore you can set the initial dialect to use in
+the `configuration` section of the yaml file for your SQL Client.
+
+{% highlight yaml %}
+
+execution:
+  planner: blink
+  type: batch
+  result-mode: table
+
+configuration:
+  table.sql-dialect: hive
+  
+{% endhighlight %}
+
+You can also set the dialect after the SQL Client has launched.
+
+{% highlight bash %}
+
+Flink SQL> set table.sql-dialect=hive; -- to use hive dialect
+[INFO] Session property has been set.
+
+Flink SQL> set table.sql-dialect=default; -- to use default dialect
+[INFO] Session property has been set.
+
+{% endhighlight %}
+
+### Table API
+
+With Table API, you can set dialect for you TableEnvironment.
+

Review comment:
       You can set dialect for you TableEnvironment with Table API.

##########
File path: docs/dev/table/hive/hive_dialect.md
##########
@@ -0,0 +1,347 @@
+---
+title: "Hive Dialect"
+nav-parent_id: hive_tableapi
+nav-pos: 1
+---
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements.  See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership.  The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License.  You may obtain a copy of the License at
+
+  http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied.  See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+Starting from 1.11.0, Flink allows users to write SQL statements in Hive syntax when Hive dialect
+is used. By providing compatibility with Hive syntax, we aim to improve the interoperability with
+Hive and reduce the scenarios when users need to switch between Flink and Hive in order to execute
+different statements.
+
+* This will be replaced by the TOC
+{:toc}
+
+## Use Hive Dialect
+
+Flink currently supports two SQL dialects: `default` and `hive`. You have to choose to use Hive
+dialect before you can write in Hive syntax. The following describes how to set dialect with
+SQL Client and Table API. Please also be noted that you can dynamically switch dialect for each

Review comment:
       `You have to choose to use Hive` -> `You need to switch to Hive dialect`

##########
File path: docs/dev/table/hive/hive_dialect.md
##########
@@ -0,0 +1,347 @@
+---
+title: "Hive Dialect"
+nav-parent_id: hive_tableapi
+nav-pos: 1
+---
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements.  See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership.  The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License.  You may obtain a copy of the License at
+
+  http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied.  See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+Starting from 1.11.0, Flink allows users to write SQL statements in Hive syntax when Hive dialect
+is used. By providing compatibility with Hive syntax, we aim to improve the interoperability with
+Hive and reduce the scenarios when users need to switch between Flink and Hive in order to execute
+different statements.
+
+* This will be replaced by the TOC
+{:toc}
+
+## Use Hive Dialect
+
+Flink currently supports two SQL dialects: `default` and `hive`. You have to choose to use Hive
+dialect before you can write in Hive syntax. The following describes how to set dialect with
+SQL Client and Table API. Please also be noted that you can dynamically switch dialect for each

Review comment:
       `Please also be noted that` -> `Also notice that`

##########
File path: docs/dev/table/hive/hive_dialect.md
##########
@@ -0,0 +1,347 @@
+---
+title: "Hive Dialect"
+nav-parent_id: hive_tableapi
+nav-pos: 1
+---
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements.  See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership.  The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License.  You may obtain a copy of the License at
+
+  http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied.  See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+Starting from 1.11.0, Flink allows users to write SQL statements in Hive syntax when Hive dialect
+is used. By providing compatibility with Hive syntax, we aim to improve the interoperability with
+Hive and reduce the scenarios when users need to switch between Flink and Hive in order to execute
+different statements.
+
+* This will be replaced by the TOC
+{:toc}
+
+## Use Hive Dialect
+
+Flink currently supports two SQL dialects: `default` and `hive`. You have to choose to use Hive
+dialect before you can write in Hive syntax. The following describes how to set dialect with
+SQL Client and Table API. Please also be noted that you can dynamically switch dialect for each
+statement you execute. There's no need to restart a session to use a different dialect.
+
+### SQL Client
+
+SQL dialect can be specified via the `table.sql-dialect` property. Therefore you can set the initial dialect to use in
+the `configuration` section of the yaml file for your SQL Client.
+
+{% highlight yaml %}
+
+execution:
+  planner: blink
+  type: batch
+  result-mode: table
+
+configuration:
+  table.sql-dialect: hive
+  
+{% endhighlight %}
+
+You can also set the dialect after the SQL Client has launched.
+
+{% highlight bash %}
+
+Flink SQL> set table.sql-dialect=hive; -- to use hive dialect
+[INFO] Session property has been set.
+
+Flink SQL> set table.sql-dialect=default; -- to use default dialect
+[INFO] Session property has been set.
+
+{% endhighlight %}
+
+### Table API
+
+With Table API, you can set dialect for you TableEnvironment.
+
+{% highlight java %}
+
+EnvironmentSettings settings = EnvironmentSettings.newInstance().useBlinkPlanner()...build();
+TableEnvironment tableEnv = TableEnvironment.create(settings);
+// to use hive dialect
+tableEnv.getConfig().setSqlDialect(SqlDialect.HIVE);
+// to use default dialect
+tableEnv.getConfig().setSqlDialect(SqlDialect.DEFAULT);
+
+{% endhighlight %}
+
+## DDL
+
+This section lists the supported DDLs with the Hive dialect. We'll mainly focus on the syntax
+here. You can refer to [Hive doc](https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL)
+for the semantics of each DDL statement.
+
+### DATABASE
+
+#### Show
+
+{% highlight sql %}
+SHOW DATABASES;
+{% endhighlight %}
+
+#### Create
+
+{% highlight sql %}
+CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
+  [COMMENT database_comment]
+  [LOCATION fs_path]
+  [WITH DBPROPERTIES (property_name=property_value, ...)];
+{% endhighlight %}
+
+#### Alter
+
+##### Update Properties
+
+{% highlight sql %}
+ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...);
+{% endhighlight %}
+
+##### Update Owner
+
+{% highlight sql %}
+ALTER (DATABASE|SCHEMA) database_name SET OWNER [USER|ROLE] user_or_role;
+{% endhighlight %}
+
+##### Update Location
+
+{% highlight sql %}
+ALTER (DATABASE|SCHEMA) database_name SET LOCATION fs_path;
+{% endhighlight %}
+
+#### Drop
+
+{% highlight sql %}
+DROP (DATABASE|SCHEMA) [IF EXISTS] database_name [RESTRICT|CASCADE];
+{% endhighlight %}
+
+#### Use
+
+{% highlight sql %}
+USE database_name;
+{% endhighlight %}
+
+### TABLE
+
+#### Show
+
+{% highlight sql %}
+SHOW TABLES;
+{% endhighlight %}
+
+#### Create
+
+{% highlight sql %}
+CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name
+  [(col_name data_type [column_constraint] [COMMENT col_comment], ... [table_constraint])]
+  [COMMENT table_comment]
+  [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
+  [
+    [ROW FORMAT row_format]
+    [STORED AS file_format]
+  ]
+  [LOCATION fs_path]
+  [TBLPROPERTIES (property_name=property_value, ...)]
+  
+row_format:
+  : DELIMITED [FIELDS TERMINATED BY char [ESCAPED BY char]] [COLLECTION ITEMS TERMINATED BY char]
+      [MAP KEYS TERMINATED BY char] [LINES TERMINATED BY char]
+      [NULL DEFINED AS char]
+  | SERDE serde_name [WITH SERDEPROPERTIES (property_name=property_value, ...)]
+  
+file_format:
+  : SEQUENCEFILE
+  | TEXTFILE
+  | RCFILE
+  | ORC
+  | PARQUET
+  | AVRO
+  | INPUTFORMAT input_format_classname OUTPUTFORMAT output_format_classname
+  
+column_constraint:
+  : NOT NULL [[ENABLE|DISABLE] [VALIDATE|NOVALIDATE] [RELY|NORELY]]
+  
+table_constraint:
+  : [CONSTRAINT constraint_name] PRIMARY KEY (col_name, ...) [[ENABLE|DISABLE] [VALIDATE|NOVALIDATE] [RELY|NORELY]]
+{% endhighlight %}
+
+#### Alter
+
+##### Rename
+
+{% highlight sql %}
+ALTER TABLE table_name RENAME TO new_table_name;
+{% endhighlight %}
+
+##### Update Properties
+
+{% highlight sql %}
+ALTER TABLE table_name SET TBLPROPERTIES (property_name = property_value, property_name = property_value, ... );
+{% endhighlight %}
+
+##### Update Location
+
+{% highlight sql %}
+ALTER TABLE table_name [PARTITION partition_spec] SET LOCATION fs_path;
+{% endhighlight %}
+
+The `partition_spec`, if present, needs to be a full spec, i.e. has values for all partition columns. And when it's
+present, the operation will be applied to the corresponding partition instead of the table.
+
+##### Update File Format
+
+{% highlight sql %}
+ALTER TABLE table_name [PARTITION partition_spec] SET FILEFORMAT file_format;
+{% endhighlight %}
+
+The `partition_spec`, if present, needs to be a full spec, i.e. has values for all partition columns. And when it's
+present, the operation will be applied to the corresponding partition instead of the table.
+
+##### Update SerDe Properties
+
+{% highlight sql %}
+ALTER TABLE table_name [PARTITION partition_spec] SET SERDE serde_class_name [WITH SERDEPROPERTIES serde_properties];
+ 
+ALTER TABLE table_name [PARTITION partition_spec] SET SERDEPROPERTIES serde_properties;
+ 
+serde_properties:
+  : (property_name = property_value, property_name = property_value, ... )
+{% endhighlight %}
+
+The `partition_spec`, if present, needs to be a full spec, i.e. has values for all partition columns. And when it's
+present, the operation will be applied to the corresponding partition instead of the table.
+
+##### Add Partitions
+
+{% highlight sql %}
+ALTER TABLE table_name ADD [IF NOT EXISTS] (PARTITION partition_spec [LOCATION fs_path])+;
+{% endhighlight %}
+
+##### Drop Partitions
+
+{% highlight sql %}
+ALTER TABLE table_name DROP [IF EXISTS] PARTITION partition_spec[, PARTITION partition_spec, ...];
+{% endhighlight %}
+
+##### Add/Replace Columns
+
+{% highlight sql %}
+ALTER TABLE table_name
+  ADD|REPLACE COLUMNS (col_name data_type [COMMENT col_comment], ...)
+  [CASCADE|RESTRICT]
+{% endhighlight %}
+
+##### Change Column
+
+{% highlight sql %}
+ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name column_type
+  [COMMENT col_comment] [FIRST|AFTER column_name] [CASCADE|RESTRICT];
+{% endhighlight %}
+
+#### Drop
+
+{% highlight sql %}
+DROP TABLE [IF EXISTS] table_name;
+{% endhighlight %}
+
+### VIEW
+
+#### Create
+
+{% highlight sql %}
+CREATE VIEW [IF NOT EXISTS] view_name [(column_name, ...) ]
+  [COMMENT view_comment]
+  [TBLPROPERTIES (property_name = property_value, ...)]
+  AS SELECT ...;
+{% endhighlight %}
+
+#### Alter
+
+##### Rename
+
+{% highlight sql %}
+ALTER VIEW view_name RENAME TO new_view_name;
+{% endhighlight %}
+
+##### Update Properties
+
+{% highlight sql %}
+ALTER VIEW view_name SET TBLPROPERTIES (property_name = property_value, ... );
+{% endhighlight %}
+
+##### Update As Select
+
+{% highlight sql %}
+ALTER VIEW view_name AS select_statement;
+{% endhighlight %}
+
+#### Drop
+
+{% highlight sql %}
+DROP VIEW [IF EXISTS] view_name;
+{% endhighlight %}
+
+### FUNCTION
+
+#### Show
+
+{% highlight sql %}
+SHOW FUNCTIONS;
+{% endhighlight %}
+
+#### Create
+
+{% highlight sql %}
+CREATE FUNCTION function_name AS class_name;
+{% endhighlight %}
+
+#### Drop
+
+{% highlight sql %}
+DROP FUNCTION [IF EXISTS] function_name;
+{% endhighlight %}
+
+## DML
+
+### INSERT
+
+{% highlight sql %}
+INSERT (INTO|OVERWRITE) [TABLE] table_name [PARTITION partition_spec] SELECT ...;
+{% endhighlight %}
+
+The `partition_spec`, if present, can be either a full spec or partial spec. If the `partition_spec` is a partial
+spec, the dynamic partition column names can be omitted.
+
+## DQL
+
+At the moment, Hive dialect supports the same syntax as Flink SQL for DQLs. Refer to
+[Flink SQL queries]({{ site.baseurl }}/dev/table/sql/queries.html) for more details. And it's recommended to switch to
+`default` dialect to execute DQLs.
+
+## Notice
+
+Some things to notice when using the Hive dialect.
+

Review comment:
       The following are some precautions for using using the Hive dialect.




----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     }, {
       "hash" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "status" : "SUCCESS",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565",
       "triggerID" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "triggerType" : "PUSH"
     }, {
       "hash" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "status" : "PENDING",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2794",
       "triggerID" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   * 723262421f8fbf9a4b86639ef8be6d6651f26bba Azure: [SUCCESS](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565) 
   * d7de89b8333fd9e073f6a329e2ba641a2d71f26e Azure: [PENDING](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2794) 
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     }, {
       "hash" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "status" : "DELETED",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565",
       "triggerID" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "triggerType" : "PUSH"
     }, {
       "hash" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "status" : "DELETED",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2794",
       "triggerID" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "triggerType" : "PUSH"
     }, {
       "hash" : "31b991e463168e16cc3400c1df3e06cb28a8a917",
       "status" : "FAILURE",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2900",
       "triggerID" : "31b991e463168e16cc3400c1df3e06cb28a8a917",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   * 31b991e463168e16cc3400c1df3e06cb28a8a917 Azure: [FAILURE](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2900) 
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     }, {
       "hash" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "status" : "DELETED",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565",
       "triggerID" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "triggerType" : "PUSH"
     }, {
       "hash" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "status" : "SUCCESS",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2794",
       "triggerID" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   * d7de89b8333fd9e073f6a329e2ba641a2d71f26e Azure: [SUCCESS](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2794) 
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     }, {
       "hash" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "status" : "DELETED",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2565",
       "triggerID" : "723262421f8fbf9a4b86639ef8be6d6651f26bba",
       "triggerType" : "PUSH"
     }, {
       "hash" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "status" : "SUCCESS",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2794",
       "triggerID" : "d7de89b8333fd9e073f6a329e2ba641a2d71f26e",
       "triggerType" : "PUSH"
     }, {
       "hash" : "31b991e463168e16cc3400c1df3e06cb28a8a917",
       "status" : "PENDING",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2900",
       "triggerID" : "31b991e463168e16cc3400c1df3e06cb28a8a917",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   * d7de89b8333fd9e073f6a329e2ba641a2d71f26e Azure: [SUCCESS](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2794) 
   * 31b991e463168e16cc3400c1df3e06cb28a8a917 Azure: [PENDING](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=2900) 
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot commented on pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
flinkbot commented on pull request #12439:
URL: https://github.com/apache/flink/pull/12439#issuecomment-637513668


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "a8e8962ad90eaaaa67b78240a2a9023e15dec1df",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * a8e8962ad90eaaaa67b78240a2a9023e15dec1df UNKNOWN
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] JingsongLi merged pull request #12439: [FLINK-17776][hive][doc] Add documentation for DDL&DML in hive dialect

Posted by GitBox <gi...@apache.org>.
JingsongLi merged pull request #12439:
URL: https://github.com/apache/flink/pull/12439


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org