sql - Issues with JSON_EXTRACT in Presto for keys containing ' ' character -


i'm using presto(0.163) query data , trying extract fields json.

i have json 1 given below, present in column 'style_attributes':

"attributes": {     "brand fit name": "regular fit",     "fabric": "cotton",     "fit": "regular",     "neck or collar": "round neck",     "occasion": "casual",     "pattern": "striped",     "sleeve length": "short sleeves",     "tshirt type": "t-shirt" }

i'm unable extract field 'short sleeves'. below query i'm using:

select json_extract(style_attributes,'$.attributes.sleeve length') length table;

the query fails following error- invalid json path: '$.attributes.sleeve length'

for fields without ' '(space), query running fine.

i tried find resolution in presto documentation, no success.

presto:default> select json_extract_scalar('{"attributes":{"sleeve length": "short sleeves"}}','$.attributes["sleeve length"]');      _col0 ---------------  short sleeves

or

presto:default> select json_extract_scalar('{"attributes":{"sleeve length": "short sleeves"}}','$["attributes"]["sleeve length"]');      _col0 ---------------  short sleeves

json function changes

the :func:json_extract , :func:json_extract_scalar functions support square bracket syntax:

select json_extract(json, '$.store[book]');  select json_extract(json,'$.store["book name"]');

as part of change, set of characters allowed in non-bracketed path segment has been restricted alphanumeric, underscores , colons. additionally, colons cannot used in un-quoted bracketed path segment. use new bracket syntax quotes match elements contain special characters.

https://github.com/prestodb/presto/blob/c73359fe2173e01140b7d5f102b286e81c1ae4a8/presto-docs/src/main/sphinx/release/release-0.75.rst


Comments

Post a Comment

Popular posts from this blog

Command prompt result in label. Python 2.7 -

i want put result(output) of shell command label. command works, label shows "0", however, in command prompt, result shown correctly, need showed in label. doing ubuntu. myg1 = button(root, text="rodyti informacija", command=lambda: gauti()) myg1.pack(side=bottom) def gauti(): imti = tekstas.get("1.0", "end-1c") info = subprocess.call("id '{imti}' ".format(imti=imti), shell=true) w = label(root, text= info) w.pack(side = bottom) subprocess.call() returns exit code of process created (in case 0 success). if want text output of process, should instead call subprocess.check_output() .
Read more

javascript - How do I use URL parameters to change link href on page? -

i change href value of link using url parameters. example: default <a id="dlink" href="link-1">link</a> but, when user goes https://url.com/?dlink=link-2 it swaps out link new link <a id="dlink" href="link-2">link</a> first need value url. if you're not using javascript framework can create function using jquery. please check get url parameter jquery or how query string values in js it. after that, element "a" id , set value there. $("#dlink").attr("href", hreffromparam);
Read more

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -

so have domain nameservers pointed aws route 53. site hosted on ec2 instance , reachable resolves site.com, if input www.site.com. i'm curious how site resolve www.site.com. have under route53 domains hosted zone 2 additional record sets outside of ns , soa: a site.com ec2 elastic ip cname www.site.com ec2 public dns i can reach site using both site.com , www.site.com, resolve site.com. there way make if enter either, resolves www.site.com? at first, both should record set. a site.com ec2 elastic ip www.site.com ec2 elastic ip and need redirect setting in web server (nginx, apache, ..) following. (source: how redirect www non-www nginx on centos 7 ) redirect non-www www if want redirect users plain, non-www domain www domain, add server block: server { server_name example.com; return 301 $scheme://www.example.com$request_uri; } save , exit. configures nginx redirect requests "example.com" "www.example.com". not...
Read more