Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

EXTRACTJSONFIELD JSON array support #523

Closed
joewood opened this issue Dec 13, 2017 · 2 comments
Closed

EXTRACTJSONFIELD JSON array support #523

joewood opened this issue Dec 13, 2017 · 2 comments

Comments

@joewood
Copy link

joewood commented Dec 13, 2017

It seems that the EXTRACTJSONFIELD function doesn't support array extraction, for example the following doesn't work:

EXTRACTJSONFIELD(myfield,'$[0].subfield')

When myfield is [ { "subfield":"blah"} ]
@satybald
Copy link
Contributor

satybald commented Jan 7, 2018 •
edited
Loading

@joewood you need extract object in the column i.e. myfield[0].

EXTRACTJSONFIELD(myfield[0],'$.subfield')

@robert2d robert2d mentioned this issue Jan 10, 2018
Merged
@apurvam
Copy link
Contributor

apurvam commented Jan 31, 2018 •
edited
Loading

Just merged #610 . Closing this out.

@apurvam apurvam closed this as completed Jan 31, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@apurvam @joewood @satybald