You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Joris Van den Bossche (Jira)" <ji...@apache.org> on 2020/09/02 12:36:00 UTC
[jira] [Resolved] (ARROW-7226) [JSON][Python] Json loader fails on
example in documentation.
[ https://issues.apache.org/jira/browse/ARROW-7226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Joris Van den Bossche resolved ARROW-7226.
------------------------------------------
Fix Version/s: 2.0.0
Resolution: Fixed
Issue resolved by pull request 8055
[https://github.com/apache/arrow/pull/8055]
> [JSON][Python] Json loader fails on example in documentation.
> -------------------------------------------------------------
>
> Key: ARROW-7226
> URL: https://issues.apache.org/jira/browse/ARROW-7226
> Project: Apache Arrow
> Issue Type: Bug
> Components: Python
> Reporter: Rinke Hoekstra
> Assignee: Andrew Wieteska
> Priority: Major
> Labels: pull-request-available
> Fix For: 2.0.0
>
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> I was just trying this with the example found in the pyarrow docs at [http://arrow.apache.org/docs/python/json.html]
> The documented example does not work. Is this related to this issue, or is it another matter?
> It says to load the following JSON file:
> {{{"a": [1, 2], "b": {"c": true, "d": "1991-02-03"}}}}
> {{{"a": [3, 4, 5], "b": {"c": false, "d": "2019-04-01"}}}}
> I fixed this to make it valid JSON (It is valid [JSON Lines|[http://jsonlines.org/]], but that's another issue):
> {{[{"a": [1, 2], "b": {"c": true, "d": "1991-02-03"}},}}
> {{{"a": [3, 4, 5], "b": {"c": false, "d": "2019-04-01"}}]}}
> Then reading the JSON from a file called `my_data.json`:
> {{from pyarrow import json}}
> {{table = json.read_json("my_data.json")}}
> Gives the following error:
> {code:java}
> ---------------------------------------------------------------------------}}
> ArrowInvalid Traceback (most recent call last)
> <ipython-input-69-f974c21f0941> in <module>()
> 1 from pyarrow import json
> ----> 2 table = json.read_json('test.json')
> ~/.local/share/virtualenvs/parquet-ifRxINoC/lib/python3.7/site-packages/pyarrow/_json.pyx in pyarrow._json.read_json()
> ~/.local/share/virtualenvs/parquet-ifRxINoC/lib/python3.7/site-packages/pyarrow/error.pxi in pyarrow.lib.check_status()
> ArrowInvalid: JSON parse error: A column changed from object to array
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)