Collects the parts specified by JSONPath s from a JSON column. For those parts that cannot be found or have incompatible types, missing values will be returned.

Example input table:

column name	path	type
bookyear	$.book[*].year	List(Double)
invalidyear	$.book[2].year	Double
timeline	$.book[?(@.year==1999)].title	String
paths	$..*	List(Path)

Example input:

{"book": [
  {"year": 1999,
   "title": "Timeline",
   "author": "Michael Crichton"},
  {"year": 2000,
   "title": "Plain Truth",
   "author": "Jodi Picoult"}
]}

The results look like this:

bookyear	invalidyear	timeline
{1999, 2000}	?	Timeline

The paths column contains the following values (String list): $['book'] , $['book'][0] , $['book'][1] , $['book'][0]['year'] , $['book'][0]['title'] , $['book'][0]['author'] , $['book'][1]['year'] , $['book'][1]['title'] , $['book'][1]['author']