You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2022/06/30 02:26:00 UTC
[GitHub] [dolphinscheduler] zhongjiajie commented on a diff in pull request #10685: [Doc]: add doc for pre-sql and post-sql
zhongjiajie commented on code in PR #10685:
URL: https://github.com/apache/dolphinscheduler/pull/10685#discussion_r910549939
##########
docs/docs/en/guide/task/sql.md:
##########
@@ -43,6 +43,12 @@ Log in to the bigdata cluster and use 'hive' command or 'beeline' or 'JDBC' and
+### Use Pre-SQL and Post-SQL
Review Comment:
It is seem this use case is not related to above, can we and the other section for above docs? I mean we should
```diff
+ ### Hive Table Create Example
+
- ### Create a Temporary Table in Hive and Write Data
+ #### Create a Temporary Table in Hive and Write Data
This example creates a temporary table `tmp_hello_world` in Hive and writes a row of data. Before creating a temporary table, we need to ensure that the table does not exist. So we use custom parameters to obtain the time of the day as the suffix of the table name every time we run, this task can run every different day. The format of the created table name is: `tmp_hello_world_{yyyyMMdd}`.
- ### After Running the Task Successfully, Query the Results in Hive
+ #### After Running the Task Successfully, Query the Results in Hive
Log in to the bigdata cluster and use 'hive' command or 'beeline' or 'JDBC' and other methods to connect to the 'Apache Hive' for the query. The query SQL is `select * from tmp_hello_world_{yyyyMMdd}`, please replace `{yyyyMMdd}` with the date of the running day. The following shows the query screenshot:
```
--
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.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org