You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by GitBox <gi...@apache.org> on 2021/11/13 06:00:47 UTC

[GitHub] [drill-site] luocooong commented on a change in pull request #13: zh-tutorial-translation

luocooong commented on a change in pull request #13:
URL: https://github.com/apache/drill-site/pull/13#discussion_r748686328



##########
File path: _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md
##########
@@ -6,28 +6,21 @@ lang: "zh"
 ---
 ## Goal

Review comment:
       Goal > 目标

##########
File path: _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md
##########
@@ -313,13 +284,13 @@ supports the creation of metadata in the file system.
     |----------|-------------------|-----------|----------|--------|----------|-------------|
     1 row selected
 
-Once the users know what data is available by exploring it directly from the file system, views can be used as a way to read the data into downstream tools such as Tableau and MicroStrategy for analysis and visualization. For these tools, a view appears simply as a “table” with selectable “columns” in it.
+用户可以直接从文件系统中探索来了解哪些数据可用,视图可以将数据读入下游工具进行分析和可视化,就像 Tableau 和 MicroStrategy 一样。对于这些工具,视图仅显示为“表格”,其中包含可选择的“列”。

Review comment:
       "用户可以直接从文件系统中探索可用的数据"

##########
File path: _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md
##########
@@ -94,14 +84,13 @@ is a reserved word in SQL.
     |-----------|--------|---------|
     20 rows selected 
 
-Note the alias for the result of the SUM function. Drill supports column
-aliases and table aliases.
+请注意 SUM 函数结果的别名。Drill 支持列别名和表别名。
 
-## HAVING Clause
+## HAVING 子句
 
-This query uses the HAVING clause to constrain an aggregate result.
+此查询使用 HAVING 子句来约束聚合结果。
 
-### Set the workspace to dfs.clicks
+### 将工作区设置为 dfs.clicks

Review comment:
       Missing the `:` at the end of line.
   And more, please check the title below.

##########
File path: _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md
##########
@@ -6,28 +6,21 @@ lang: "zh"
 ---
 ## Goal
 
-This lesson shows how to do some standard SQL analysis in Apache Drill: for
-example, summarizing data by using simple aggregate functions and connecting
-data sources by using joins. Note that Apache Drill provides ANSI SQL support,
-not a “SQL-like” interface.
+本课展示了如何在 Apache Drill 中进行一些标准的 SQL 分析:例如,使用简单的聚合函数汇总数据以及联接不同数据源。请注意,Apache Drill 提供 ANSI SQL 支持,而不是 “SQL-like” 的接口。
 
-## Queries in This Lesson
+## 本课中的查询示例
 
-Now that you know what the data sources look like in their raw form, using
-select * queries, try running some simple but more useful queries on each data
-source. These queries demonstrate how Drill supports ANSI SQL constructs and
-also how you can combine data from different data sources in a single SELECT
-statement.
+假设用户知道数据源的原始形式,使用 select * 查询,尝试对每个数据源进行一些简单却实用的查询。这些查询展示了 Drill 如何支持 ANSI SQL 结构,以及如何在单个 SELECT 语句中组合来自不同数据源的数据。
 
-  * Show an aggregate query on a single file or table. Use GROUP BY, WHERE, HAVING, and ORDER BY clauses.
-  * Perform joins between Hive, MapR-DB, and file system data sources.
-  * Use table and column aliases.
-  * Create a Drill view.
+* 对单个文件或表的聚合查询。使用 GROUP BY、WHERE、HAVING 和 ORDER BY 子句。
+* 联接 Hive、MapR-DB 和文件系统数据源。
+* 使用表和列的别名。
+* 创建 Drill 视图。
 
-## Aggregation
+## 聚合
 
 
-### Set the schema to hive:
+### 设定 hive 的 schema

Review comment:
       Missing the `:` at the end of line.




-- 
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: dev-unsubscribe@drill.apache.org

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