This is an automated email from the ASF dual-hosted git repository.
luoc pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/master by this push:
new 978466b Update 060-text-files-csv-tsv-psv.md
978466b is described below
commit 978466b07f2b026e1a50584dceee7d1e7fbd69ff
Author: Kai Yen <[email protected]>
AuthorDate: Sat Apr 2 09:04:08 2022 -0400
Update 060-text-files-csv-tsv-psv.md
Fixed typo in link to COLUMNS[n] documentation
---
_docs/en/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git
a/_docs/en/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
b/_docs/en/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
index 501706c..774a23a 100644
--- a/_docs/en/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
+++ b/_docs/en/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
@@ -12,7 +12,7 @@ Best practices for reading text files are:
## Select Data from Particular Columns
-Converting text files to another format, such as Parquet, using the CTAS
command and a SELECT * statement is not recommended. Instead, you should select
data from particular columns. If your text files have no headers, use the
[COLUMN[n] syntax]({{site.baseurl}}/docs/querying-plain-text-files), and then
assign meaningful column names using aliases. For example:
+Converting text files to another format, such as Parquet, using the CTAS
command and a SELECT * statement is not recommended. Instead, you should select
data from particular columns. If your text files have no headers, use the
[COLUMNS[n] syntax]({{site.baseurl}}/docs/querying-plain-text-files), and then
assign meaningful column names using aliases. For example:
CREATE TABLE parquet_users AS SELECT CAST(COLUMNS[0] AS INT) AS user_id,
COLUMNS[1] AS username, CAST(COLUMNS[2] AS TIMESTAMP) AS registration_date
