Boaz Ben-Zvi created DRILL-4993:
-----------------------------------
Summary: Documentation: Wrong output displayed for convert_from()
with a map
Key: DRILL-4993
URL: https://issues.apache.org/jira/browse/DRILL-4993
Project: Apache Drill
Issue Type: Bug
Components: Documentation
Affects Versions: 1.8.0
Reporter: Boaz Ben-Zvi
Priority: Trivial
Fix For: 1.9.0
In the Drill docs:
SQL REFERENCE -> SQL FUNCTIONS -> DATA TYPE CONVERSION
The output for the example shown for convert_from() with a map into JSON is
wrong:
------------------------- BEGIN EXCERPT
---------------------------------------------------------------------
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)
------------------------- END ----------------------------------------------
The correct output should be:
---------------------------------------
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}] |
+----------------------------------------+
1 row selected (2.618 seconds)
The error probably resulted from copying the output of the previous example.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
