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)