You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2019/02/19 20:06:25 UTC
[drill] branch gh-pages updated: edit convert_from example to show
correct results
This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
The following commit(s) were added to refs/heads/gh-pages by this push:
new 89427d5 edit convert_from example to show correct results
89427d5 is described below
commit 89427d5b2a68a5d4162ea0c82b705db126804fb1
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Tue Feb 19 12:03:49 2019 -0800
edit convert_from example to show correct results
---
.../sql-functions/020-data-type-conversion.md | 17 ++++++++---------
1 file changed, 8 insertions(+), 9 deletions(-)
diff --git a/_docs/sql-reference/sql-functions/020-data-type-conversion.md b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
index 9ce1081..675ebc3 100644
--- a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
+++ b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
@@ -1,6 +1,6 @@
---
title: "Data Type Conversion"
-date: 2018-12-20
+date: 2019-02-19
parent: "SQL Functions"
---
Drill supports the following functions for casting and converting data types:
@@ -243,15 +243,14 @@ This example uses a list of BIGINT data as input and returns a repeated list of
+------------+
1 row selected (0.054 seconds)
-This example uses a map as input to return a repeated list vector (JSON).
+This example uses a map as input to return a repeated list vector (JSON).
- SELECT CONVERT_FROM('[{a : 100, b: 200}, {a:300, b: 400}]' ,'JSON') AS MYCOL1 FROM (VALUES(1));
- +--------------------+
- | MYCOL1 |
- +--------------------+
- | [[1,2],[3,4],[5]] |
- +--------------------+
- 1 row selected (0.141 seconds)
+ SELECT CONVERT_FROM('[{a : 100, b: 200}, {a:300, b: 400}]' ,'JSON') AS MYCOL1 FROM (VALUES(1));
+ +----------------------------------------+
+ | MYCOL1 |
+ +----------------------------------------+
+ | [{"a":100,"b":200},{"a":300,"b":400}] |
+ +----------------------------------------+
### Set Up a Storage Plugin for Working with HBase