https://sparkfunctions.com/_next/static/chunks/pages/json_object_keys-1d2c3f0f2d6d46b2.js

1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[8368],{7410:function(e,a,t){(window.__NEXT_P=window.__NEXT_P||[]).push(["/json_object_keys",function(){return t(81278)}])},24165:function(e,a,t){"use strict";var n=t(11527),r=t(38962),i=t(86452),d=t.n(i),o=t(34627);let s={head:()=>{let{asPath:e,defaultLocale:a,locale:t}=(0,r.useRouter)(),{frontMatter:i}=(0,o.ZR)(),d="https://sparkfunctions.com"+(a===t?e:"/".concat(t).concat(e));return(0,n.jsxs)(n.Fragment,{children:[(0,n.jsx)("meta",{property:"og:url",content:d}),(0,n.jsx)("meta",{property:"og:title",content:i.title||"数据仓库技术"}),(0,n.jsx)("meta",{property:"og:description",content:i.description||"数据仓库技术相关知识"}),(0,n.jsx)("meta",{name:"keywords",content:i.keywords||"sql,数据仓库技术"})]})},logo:(0,n.jsx)("b",{children:"Spark Functions"}),project:{link:"https://www.sparkfunctions.com/"},search:{placeholder:"Search"},sidebar:{toggleButton:!0},toc:{backToTop:!0,extraContent:(0,n.jsx)(()=>(0,n.jsx)(n.Fragment,{children:(0,n.jsxs)("div",{class:"flex flex-col items-center",children:[(0,n.jsx)(d(),{src:"/wx.jpeg",className:"mb-4 rounded-md shadow-lg",alt:"扫码备注 “数据仓库” 加入数据仓库技术交流群",width:100,height:100}),(0,n.jsxs)("p",{class:"nx-text-xs font-bold text-center",children:["扫码备注 “数据仓库” ",(0,n.jsx)("br",{}),"加入数据仓库技术交流群"]}),(0,n.jsx)(d(),{src:"/gzh.jpeg",className:"mb-4 rounded-md shadow-lg",alt:"扫码关注“数据仓库技术”公众号",width:100,height:100}),(0,n.jsx)("p",{class:"nx-text-xs font-bold text-center",children:"扫码关注“数据仓库技术”公众号"})]})}),{}),float:!0},feedback:{content:null},editLink:{component:null},useNextSeoProps(){let{asPath:e}=(0,r.useRouter)();return"/"===e?{titleTemplate:"Spark Functions"}:{titleTemplate:"Spark Functions-%s"}},gitTimestamp:null,footer:{text:(0,n.jsxs)("span",{children:[(0,n.jsx)("div",{children:(0,n.jsx)("a",{href:"https://beian.miit.gov.cn/#/Integrated/index",target:"_blank",children:"备案号:京ICP备2024043387号-2"})}),(0,n.jsx)("div",{children:(0,n.jsx)("a",{href:"https://sparkfunctions.com",target:"_blank",children:"京公网安备11011402053813号"})}),(0,n.jsx)("div",{children:(0,n.jsx)("a",{href:"https://sparkfunctions.com/privacy",target:"_blank",children:"privacy"})}),(0,n.jsx)("div",{children:(0,n.jsx)("a",{href:"https://dwsql.com",target:"_blank",children:"数据仓库技术"})}),(0,n.jsx)("div",{children:(0,n.jsx)("a",{href:"https://quizecho.com",target:"_blank",children:"趣测"})})]})},sidebar:{titleComponent(e){let{title:a,type:t}=e;return"separator"===t?(0,n.jsx)("div",{style:{background:"cyan",textAlign:"center"},children:a}):"About"===a?(0,n.jsxs)(n.Fragment,{children:["❓ ",a]}):(0,n.jsxs)(n.Fragment,{children:[" ",a," "]})}}};a.Z=s},81278:function(e,a,t){"use strict";t.r(a),t.d(a,{__toc:function(){return s}});var n=t(11527),r=t(94568),i=t(34627),d=t(24165);t(25113);var o=t(44910);let s=[{depth:2,value:"json_object_keys 介绍",id:"json_object_keys-介绍"}];function _(e){let a=Object.assign({h1:"h1",h2:"h2",p:"p",strong:"strong",ul:"ul",li:"li",pre:"pre",code:"code",span:"span"},(0,o.a)(),e.components);return(0,n.jsxs)(n.Fragment,{children:[(0,n.jsx)(a.h1,{children:"json_object_keys"}),"\n",(0,n.jsx)(a.h2,{id:"json_object_keys-介绍",children:"json_object_keys 介绍"}),"\n",(0,n.jsx)(a.p,{children:"json_object_keys(json_object) - 返回最外层 JSON 对象的所有键作为一个数组。"}),"\n",(0,n.jsx)(a.p,{children:(0,n.jsx)(a.strong,{children:"参数："})}),"\n",(0,n.jsxs)(a.ul,{children:["\n",(0,n.jsx)(a.li,{children:"json_object - 一个 JSON 对象。如果提供了有效的 JSON 对象，将返回最外层对象的所有键作为一个数组。如果输入是任何其他有效的 JSON 字符串、无效的 JSON 字符串或空字符串，则函数返回 null。"}),"\n"]}),"\n",(0,n.jsx)(a.p,{children:(0,n.jsx)(a.strong,{children:"Examples:"})}),"\n",(0,n.jsx)(a.pre,{"data-language":"sql","data-theme":"default",children:(0,n.jsxs)(a.code,{"data-language":"sql","data-theme":"default",children:[(0,n.jsxs)(a.span,{className:"line",children:[(0,n.jsx)(a.span,{style:{color:"var(--shiki-token-keyword)"},children:">"}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:" "}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-token-keyword)"},children:"SELECT"}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:" json_object_keys("}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-token-string-expression)"},children:"'{}'"}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:");"})]}),"\n",(0,n.jsx)(a.span,{className:"line",children:(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:"  []"})}),"\n",(0,n.jsxs)(a.span,{className:"line",children:[(0,n.jsx)(a.span,{style:{color:"var(--shiki-token-keyword)"},children:">"}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:" "}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-token-keyword)"},children:"SELECT"}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:" json_object_keys("}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-token-string-expression)"}

1,children:'\'{"key": "value"}\''}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:");"})]}),"\n",(0,n.jsx)(a.span,{className:"line",children:(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:'  ["key"]'})}),"\n",(0,n.jsxs)(a.span,{className:"line",children:[(0,n.jsx)(a.span,{style:{color:"var(--shiki-token-keyword)"},children:">"}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:" "}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-token-keyword)"},children:"SELECT"}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:" json_object_keys("}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-token-string-expression)"},children:'\'{"f1":"abc","f2":{"f3":"a", "f4":"b"}}\''}),(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:");"})]}),"\n",(0,n.jsx)(a.span,{className:"line",children:(0,n.jsx)(a.span,{style:{color:"var(--shiki-color-text)"},children:'  ["f1","f2"]'})})]})}),"\n",(0,n.jsx)(a.p,{children:"Since: 3.1.0"})]})}let m={MDXContent:function(){let e=arguments.length>0&&void 0!==arguments[0]?arguments[0]:{},{wrapper:a}=Object.assign({},(0,o.a)(),e.components);return a?(0,n.jsx)(a,{...e,children:(0,n.jsx)(_,{...e})}):_(e)},pageOpts:{filePath:"src/pages/json_object_keys.mdx",route:"/json_object_keys",pageMap:[{kind:"Meta",data:{index:"spark functions",about:{title:"About",type:"page"},privacy:{title:"Privacy",type:"page",display:"hidden"},abs:"abs",acos:"acos",acosh:"acosh",add_months:"add_months",aes_decrypt:"aes_decrypt",aes_encrypt:"aes_encrypt",aggregate:"aggregate",and:"and",any:"any",any_value:"any_value",approx_count_distinct:"approx_count_distinct",approx_percentile:"approx_percentile",array:"array",array_agg:"array_agg",array_append:"array_append",array_compact:"array_compact",array_contains:"array_contains",array_distinct:"array_distinct",array_except:"array_except",array_insert:"array_insert",array_intersect:"array_intersect",array_join:"array_join",array_max:"array_max",array_min:"array_min",array_position:"array_position",array_prepend:"array_prepend",array_remove:"array_remove",array_repeat:"array_repeat",array_size:"array_size",array_sort:"array_sort",array_union:"array_union",arrays_overlap:"arrays_overlap",arrays_zip:"arrays_zip",ascii:"ascii",asin:"asin",asinh:"asinh",assert_true:"assert_true",atan:"atan",atan2:"atan2",atanh:"atanh",avg:"avg",base64:"base64",between:"between",bigint:"bigint",bin:"bin",binary:"binary",bit_and:"bit_and",bit_count:"bit_count",bit_get:"bit_get",bit_length:"bit_length",bit_or:"bit_or",bit_xor:"bit_xor",bitmap_bit_position:"bitmap_bit_position",bitmap_bucket_number:"bitmap_bucket_number",bitmap_construct_agg:"bitmap_construct_agg",bitmap_count:"bitmap_count",bitmap_or_agg:"bitmap_or_agg",bool_and:"bool_and",bool_or:"bool_or",boolean:"boolean",bround:"bround",btrim:"btrim",cardinality:"cardinality",case:"case",cast:"cast",cbrt:"cbrt",ceil:"ceil",ceiling:"ceiling",char:"char",char_length:"char_length",character_length:"character_length",chr:"chr",coalesce:"coalesce",collect_list:"collect_list",collect_set:"collect_set",concat:"concat",concat_ws:"concat_ws",contains:"contains",conv:"conv",convert_timezone:"convert_timezone",corr:"corr",cos:"cos",cosh:"cosh",cot:"cot",count:"count",count_if:"count_if",count_min_sketch:"count_min_sketch",covar_pop:"covar_pop",covar_samp:"covar_samp",crc32:"crc32",csc:"csc",cume_dist:"cume_dist",curdate:"curdate",current_catalog:"current_catalog",current_database:"current_database",current_date:"current_date",current_schema:"current_schema",current_timestamp:"current_timestamp",current_timezone:"current_timezone",current_user:"current_user",date:"date",date_add:"date_add",date_diff:"date_diff",date_format:"date_format",date_from_unix_date:"date_from_unix_date",date_part:"date_part",date_sub:"date_sub",date_trunc:"date_trunc",dateadd:"dateadd",datediff:"datediff",datepart:"datepart",day:"day",dayofmonth:"dayofmonth",dayofweek:"dayofweek",dayofyear:"dayofyear",decimal:"decimal",decode:"decode",degrees:"degrees",dense_rank:"dense_rank",div:"div",double:"double",e:"e",element_at:"element_at",elt:"elt",encode:"encode",endswith:"endswith",equal_null:"equal_null",every:"every",exists:"exists",exp:"exp",explode:"explode",explode_outer:"explode_outer",expm1:"expm1",extract:"extract",factorial:"factorial",filter:"filter",find_in_set:"find_in_set",first:"first",first_value:"first_value",flatten:"flatten",float:"float",floor:"floor",forall:"forall",format_number:"format_number",format_string:"format_string",from_csv:"from_csv",from_json:"from_json",from_unixtime:"from_unixtime",from_utc_timestamp:"from_utc_timestamp",get:"get",get_json_object:"get_json_object",getbit:"getbit",greatest:"greatest",grouping:"grouping",grouping_id:"grouping_id",hash:"hash",hex:"hex",histogram_numeric:"histogram_numeric",hll_sketch_agg:"hll_sketch_agg",hll_sketch_estimate:"hll_sketch_estimate",hll_union:"hll_union",hll_union_agg:"hll_union_agg",hour:"hour",hypot:"hypot",if:"if",ifnull:"ifnull",ilike:"ilike",in:"in",initcap:"initcap",inline:"inline",inline_outer:"inline_outer",input_file_block_length:"input_file_block_length",input_file_block_start:"input_file_block_start",input_file_name:"input_file_name",instr:"instr",int:"int",isnan:"isnan",isnotnull:"isnotnull",isnull:"isnull",java_method:"java_method",json_array_length:"json_array_length",json_object_keys:"json_object_keys",json_tuple:"json_tuple",kurtosis:"kurtosis",lag:"lag",last:"last",last_day:"last_day",last_value:"last_value",lcase:"lcase",lead:"lead",least:"least",left:"left",len:"len",length:"length",levenshtein:"levenshtein",like:"like",ln:"ln",localtimestamp:"localtimestamp",locate:"locate",log:"log",log10:"log10",log1p:"log1p",log2:"log2",lower:"lower",lpad:"lpad",ltrim:"ltrim",luhn_check:"luhn_check",make_date:"make_date",make_dt_interval:"make_dt_interval",make_interval:"make_interval",make_timestamp:"make_timestamp",make_timestamp_ltz:"make_timestamp_ltz",make_timestamp_ntz:"make_timestamp_ntz",make_ym_interval:"make_ym_interval",map:"map",map_concat:"map_concat",map_contains_key:"map_contains_key",map_entries:"map_entries",map_filter:"map_filter",map_from_arrays:"map_from_arrays",map_from_entries:"map_from_entries",map_keys:"map_keys",map_values:"map_values",map_zip_with:"map_zip_with",mask:"mask",max:"max",max_by:"max_by",md5:"md5",mean:"mean",median:"median",min:"min",min_by:"min_by",minute:"minute",mod:"mod",mode:"mode",monotonically_increasing_id:"monotonically_increasing_id",month:"month",months_between:"months_between",named_struct:"named_struct",nanvl:"nanvl",negative:"negative",next_day:"next_day",not:"not",now:"now",nth_value:"nth_value",ntile:"ntile",nullif:"nullif",nvl:"nvl",nvl2:"nvl2",octet_length:"octet_length",or:"or",overlay:"overlay",parse_url:"parse_url",percent_rank:"percent_rank",percentile:"percentile",percentile_approx:"percentile_approx",pi:"pi",pmod:"pmod",posexplode:"posexplode",posexplode_outer:"posexplode_outer",position:"position",positive:"positive",pow:"pow",power:"power",printf:"printf",quarter:"quarter",radians:"radians",raise_error:"raise_error",rand:"rand",randn:"randn",random:"random",rank:"rank",reduce:"reduce",reflect:"reflect",regexp:"regexp",regexp_count:"regexp_count",regexp_extract:"regexp_extract",regexp_extract_all:"regexp_extract_all",regexp_instr:"regexp_instr",regexp_like:"regexp_like",regexp_replace:"regexp_replace",regexp_substr:"regexp_substr",regr_avgx:"regr_avgx",regr_avgy:"regr_avgy",regr_count:"regr_count",regr_intercept:"regr_intercept",regr_r2:"regr_r2",regr_slope:"regr_slope",regr_sxx:"regr_sxx",regr_sxy:"regr_sxy",regr_syy:"regr_syy",repeat:"repeat",replace:"replace",reverse:"reverse",right:"right",rint:"rint",rlike:"rlike",round:"roun

1d",row_number:"row_number",rpad:"rpad",rtrim:"rtrim",schema_of_csv:"schema_of_csv",schema_of_json:"schema_of_json",sec:"sec",second:"second",sentences:"sentences",sequence:"sequence",session_window:"session_window",sha:"sha",sha1:"sha1",sha2:"sha2",shiftleft:"shiftleft",shiftright:"shiftright",shiftrightunsigned:"shiftrightunsigned",shuffle:"shuffle",sign:"sign",signum:"signum",sin:"sin",sinh:"sinh",size:"size",skewness:"skewness",slice:"slice",smallint:"smallint",some:"some",sort_array:"sort_array",soundex:"soundex",space:"space",spark_partition_id:"spark_partition_id",split:"split",split_part:"split_part",sqrt:"sqrt",stack:"stack",startswith:"startswith",std:"std",stddev:"stddev",stddev_pop:"stddev_pop",stddev_samp:"stddev_samp",str_to_map:"str_to_map",string:"string",struct:"struct",substr:"substr",substring:"substring",substring_index:"substring_index",sum:"sum",tan:"tan",tanh:"tanh",timestamp:"timestamp",timestamp_micros:"timestamp_micros",timestamp_millis:"timestamp_millis",timestamp_seconds:"timestamp_seconds",tinyint:"tinyint",to_binary:"to_binary",to_char:"to_char",to_csv:"to_csv",to_date:"to_date",to_json:"to_json",to_number:"to_number",to_timestamp:"to_timestamp",to_timestamp_ltz:"to_timestamp_ltz",to_timestamp_ntz:"to_timestamp_ntz",to_unix_timestamp:"to_unix_timestamp",to_utc_timestamp:"to_utc_timestamp",to_varchar:"to_varchar",transform:"transform",transform_keys:"transform_keys",transform_values:"transform_values",translate:"translate",trim:"trim",trunc:"trunc",try_add:"try_add",try_aes_decrypt:"try_aes_decrypt",try_avg:"try_avg",try_divide:"try_divide",try_element_at:"try_element_at",try_multiply:"try_multiply",try_subtract:"try_subtract",try_sum:"try_sum",try_to_binary:"try_to_binary",try_to_number:"try_to_number",try_to_timestamp:"try_to_timestamp",typeof:"typeof",ucase:"ucase",unbase64:"unbase64",unhex:"unhex",unix_date:"unix_date",unix_micros:"unix_micros",unix_millis:"unix_millis",unix_seconds:"unix_seconds",unix_timestamp:"unix_timestamp",upper:"upper",url_decode:"url_decode",url_encode:"url_encode",user:"user",uuid:"uuid",var_pop:"var_pop",var_samp:"var_samp",variance:"variance",version:"version",weekday:"weekday",weekofyear:"weekofyear",when:"when",width_bucket:"width_bucket",window:"window",window_time:"window_time",xpath:"xpath",xpath_boolean:"xpath_boolean",xpath_double:"xpath_double",xpath_float:"xpath_float",xpath_int:"xpath_int",xpath_long:"xpath_long",xpath_number:"xpath_number",xpath_short:"xpath_short",xpath_string:"xpath_string",xxhash64:"xxhash64",year:"year",zip_with:"zip_with"}},{kind:"MdxPage",name:"about",route:"/about"},{kind:"MdxPage",name:"abs",route:"/abs"},{kind:"MdxPage",name:"acos",route:"/acos"},{kind:"MdxPage",name:"acosh",route:"/acosh"},{kind:"MdxPage",name:"add_months",route:"/add_months"},{kind:"MdxPage",name:"aes_decrypt",route:"/aes_decrypt"},{kind:"MdxPage",name:"aes_encrypt",route:"/aes_encrypt"},{kind:"MdxPage",name:"aggregate",route:"/aggregate"},{kind:"MdxPage",name:"and",route:"/and"},{kind:"MdxPage",name:"any",route:"/any"},{kind:"MdxPage",name:"any_value",route:"/any_value"},{kind:"MdxPage",name:"approx_count_distinct",route:"/approx_count_distinct"},{kind:"MdxPage",name:"approx_percentile",route:"/approx_percentile"},{kind:"MdxPage",name:"array",route:"/array"},{kind:"MdxPage",name:"array_agg",route:"/array_agg"},{kind:"MdxPage",name:"array_append",route:"/array_append"},{kind:"MdxPage",name:"array_compact",route:"/array_compact"},{kind:"MdxPage",name:"array_contains",route:"/array_contains"},{kind:"MdxPage",name:"array_distinct",route:"/array_distinct"},{kind:"MdxPage",name:"array_except",route:"/array_except"},{kind:"MdxPage",name:"array_insert",route:"/array_insert"},{kind:"MdxPage",name:"array_intersect",route:"/array_intersect"},{kind:"MdxPage",name:"array_join",route:"/array_join"},{kind:"MdxPage",name:"array_max",route:"/array_max"},{kind:"MdxPage",name:"array_min",route:"/array_min"},{kind:"MdxPage",name:"array_position",route:"/array_position"},{kind:"MdxPage",name:"array_prepend",route:"/array_prepend"},{kind:"MdxPage",name:"array_remove",route:"/array_remove"},{kind:"MdxPage",name:"array_repeat",route:"/array_repeat"},{kind:"MdxPage",name:"array_size",route:"/array_size"},{kind:"MdxPage",name:"array_sort",route:"/array_sort"},{kind:"MdxPage",name:"array_union",route:"/array_union"},{kind:"MdxPage",name:"arrays_overlap",route:"/arrays_overlap"},{kind:"MdxPage",name:"arrays_zip",route:"/arrays_zip"},{kind:"MdxPage",name:"ascii",route:"/ascii"},{kind:"MdxPage",name:"asin",route:"/asin"},{kind:"MdxPage",name:"asinh",route:"/asinh"},{kind:"MdxPage",name:"assert_true",route:"/assert_true"},{kind:"MdxPage",name:"atan",route:"/atan"},{kind:"MdxPage",name:"atan2",route:"/atan2"},{kind:"MdxPage",name:"atanh",route:"/atanh"},{kind:"MdxPage",name:"avg",route:"/avg"},{kind:"MdxPage",name:"base64",route:"/base64"},{kind:"MdxPage",name:"between",route:"/between"},{kind:"MdxPage",name:"bigint",route:"/bigint"},{kind:"MdxPage",name:"bin",route:"/bin"},{kind:"MdxPage",name:"binary",route:"/binary"},{kind:"MdxPage",name:"bit_and",route:"/bit_and"}

1,{kind:"MdxPage",name:"bit_count",route:"/bit_count"},{kind:"MdxPage",name:"bit_get",route:"/bit_get"},{kind:"MdxPage",name:"bit_length",route:"/bit_length"},{kind:"MdxPage",name:"bit_or",route:"/bit_or"},{kind:"MdxPage",name:"bit_xor",route:"/bit_xor"},{kind:"MdxPage",name:"bitmap_bit_position",route:"/bitmap_bit_position"},{kind:"MdxPage",name:"bitmap_bucket_number",route:"/bitmap_bucket_number"},{kind:"MdxPage",name:"bitmap_construct_agg",route:"/bitmap_construct_agg"},{kind:"MdxPage",name:"bitmap_count",route:"/bitmap_count"},{kind:"MdxPage",name:"bitmap_or_agg",route:"/bitmap_or_agg"},{kind:"MdxPage",name:"bool_and",route:"/bool_and"},{kind:"MdxPage",name:"bool_or",route:"/bool_or"},{kind:"MdxPage",name:"boolean",route:"/boolean"},{kind:"MdxPage",name:"bround",route:"/bround"},{kind:"MdxPage",name:"btrim",route:"/btrim"},{kind:"MdxPage",name:"cardinality",route:"/cardinality"},{kind:"MdxPage",name:"case",route:"/case"},{kind:"MdxPage",name:"cast",route:"/cast"},{kind:"MdxPage",name:"cbrt",route:"/cbrt"},{kind:"MdxPage",name:"ceil",route:"/ceil"},{kind:"MdxPage",name:"ceiling",route:"/ceiling"},{kind:"MdxPage",name:"char",route:"/char"},{kind:"MdxPage",name:"char_length",route:"/char_length"},{kind:"MdxPage",name:"character_length",route:"/character_length"},{kind:"MdxPage",name:"chr",route:"/chr"},{kind:"MdxPage",name:"coalesce",route:"/coalesce"},{kind:"MdxPage",name:"collect_list",route:"/collect_list"},{kind:"MdxPage",name:"collect_set",route:"/collect_set"},{kind:"MdxPage",name:"concat",route:"/concat"},{kind:"MdxPage",name:"concat_ws",route:"/concat_ws"},{kind:"MdxPage",name:"contains",route:"/contains"},{kind:"MdxPage",name:"conv",route:"/conv"},{kind:"MdxPage",name:"convert_timezone",route:"/convert_timezone"},{kind:"MdxPage",name:"corr",route:"/corr"},{kind:"MdxPage",name:"cos",route:"/cos"},{kind:"MdxPage",name:"cosh",route:"/cosh"},{kind:"MdxPage",name:"cot",route:"/cot"},{kind:"MdxPage",name:"count",route:"/count"},{kind:"MdxPage",name:"count_if",route:"/count_if"},{kind:"MdxPage",name:"count_min_sketch",route:"/count_min_sketch"},{kind:"MdxPage",name:"covar_pop",route:"/covar_pop"},{kind:"MdxPage",name:"covar_samp",route:"/covar_samp"},{kind:"MdxPage",name:"crc32",route:"/crc32"},{kind:"MdxPage",name:"csc",route:"/csc"},{kind:"MdxPage",name:"cume_dist",route:"/cume_dist"},{kind:"MdxPage",name:"curdate",route:"/curdate"},{kind:"MdxPage",name:"current_catalog",route:"/current_catalog"},{kind:"MdxPage",name:"current_database",route:"/current_database"},{kind:"MdxPage",name:"current_date",route:"/current_date"},{kind:"MdxPage",name:"current_schema",route:"/current_schema"},{kind:"MdxPage",name:"current_timestamp",route:"/current_timestamp"},{kind:"MdxPage",name:"current_timezone",route:"/current_timezone"},{kind:"MdxPage",name:"current_user",route:"/current_user"},{kind:"MdxPage",name:"date",route:"/date"},{kind:"MdxPage",name:"date_add",route:"/date_add"},{kind:"MdxPage",name:"date_diff",route:"/date_diff"},{kind:"MdxPage",name:"date_format",route:"/date_format"},{kind:"MdxPage",name:"date_from_unix_date",route:"/date_from_unix_date"},{kind:"MdxPage",name:"date_part",route:"/date_part"},{kind:"MdxPage",name:"date_sub",route:"/date_sub"},{kind:"MdxPage",name:"date_trunc",route:"/date_trunc"},{kind:"MdxPage",name:"dateadd",route:"/dateadd"},{kind:"MdxPage",name:"datediff",route:"/datediff"},{kind:"MdxPage",name:"datepart",route:"/datepart"},{kind:"MdxPage",name:"day",route:"/day"},{kind:"MdxPage",name:"dayofmonth",route:"/dayofmonth"},{kind:"MdxPage",name:"dayofweek",route:"/dayofweek"},{kind:"MdxPage",name:"dayofyear",route:"/dayofyear"},{kind:"MdxPage",name:"decimal",route:"/decimal"},{kind:"MdxPage",name:"decode",route:"/decode"},{kind:"MdxPage",name:"degrees",route:"/degrees"},{kind:"MdxPage",name:"dense_rank",route:"/dense_rank"},{kind:"MdxPage",name:"div",route:"/div"},{kind:"MdxPage",name:"double",route:"/double"},{kind:"MdxPage",name:"e",route:"/e"},{kind:"MdxPage",name:"element_at",route:"/element_at"},{kind:"MdxPage",name:"elt",route:"/elt"},{kind:"MdxPage",name:"encode",route:"/encode"},{kind:"MdxPage",name:"endswith",route:"/endswith"},{kind:"MdxPage",name:"equal_null",route:"/equal_null"},{kind:"MdxPage",name:"every",route:"/every"},{kind:"MdxPage",name:"exists",route:"/exists"},{kind:"MdxPage",name:"exp",route:"/exp"},{kind:"MdxPage",name:"explode",route:"/explode"},{kind:"MdxPage",name:"explode_outer",route:"/explode_outer"},{kind:"MdxPage",name:"expm1",route:"/expm1"},{kind:"MdxPage",name:"extract",route:"/extract"},{kind:"MdxPage",name:"factorial",route:"/factorial"},{kind:"MdxPage",name:"filter",route:"/filter"},{kind:"MdxPage",name:"find_in_set",route:"/find_in_set"},{kind:"MdxPage",name:"first",route:"/first"},{kind:"MdxPage",name:"first_value",route:"/first_value"},{kind:"MdxPage",name:"flatten",route:"/flatten"},{kind:"MdxPage",name:"float",route:"/float"},{kind:"MdxPage",name:"floor",route:"/floor"},{kind:"MdxPage",name:"forall",route:"/forall"},{kind:"MdxPage",name:"format_number",route:"/format_number"},{kind:"MdxPage",name:"format_string",route:"/format_string"},{kind:"MdxPage",name:"from_csv",route:"/from_csv"},{kind:"MdxPage",name:"from_json",route:"/from_json"},{kind:"MdxPage",name:"from_unixtime",route:"/from_unixtime"},{kind:"MdxPage",name:"from_utc_timestamp",route:"/from_utc_timestamp"},{kind:"MdxPage",name:"get",route:"/get"},{kind:"MdxPage",name:"get_json_object",route:"/get_json_object"},{kind:"MdxPage",name:"getbit",route:"/getbit"},{kind:"MdxPage",name:"greatest",route:"/greatest"},{kind:"MdxPage",name:"grouping",route:"/grouping"},{kind:"MdxPage",name:"grouping_id",route:"/grouping_id"},{kind:"MdxPage",name:"hash",route:"/hash"},{kind:"MdxPage",name:"hex",route:"/hex"},{kind:"MdxPage",name:"histogram_numeric",route:"/histogram_numeric"},{kind:"MdxPage",name:"hll_sketch_agg",route:"/hll_sketch_agg"},{kind:"MdxPage",name:"hll_sketch_estimate",route:"/hll_sketch_estimate"},{kind:"MdxPage",name:"hll_union",route:"/hll_union"},{kind:"MdxPage",name:"hll_union_agg",route:"/hll_union_agg"},{kind:"MdxPage",name:"hour",route:"/hour"}

1,{kind:"MdxPage",name:"hypot",route:"/hypot"},{kind:"MdxPage",name:"if",route:"/if"},{kind:"MdxPage",name:"ifnull",route:"/ifnull"},{kind:"MdxPage",name:"ilike",route:"/ilike"},{kind:"MdxPage",name:"in",route:"/in"},{kind:"MdxPage",name:"index",route:"/",frontMatter:{title:"Spark Functions",description:"介绍Spark内置函数，并提供各函数使用方法及案例",keywords:["sql","collect_list","sql row_number","sql rank","datediff","datediff sql","sql 窗口函数","开窗函数","窗口函数","SQL面试题","数仓面试SQL"]}},{kind:"MdxPage",name:"initcap",route:"/initcap"},{kind:"MdxPage",name:"inline",route:"/inline"},{kind:"MdxPage",name:"inline_outer",route:"/inline_outer"},{kind:"MdxPage",name:"input_file_block_length",route:"/input_file_block_length"},{kind:"MdxPage",name:"input_file_block_start",route:"/input_file_block_start"},{kind:"MdxPage",name:"input_file_name",route:"/input_file_name"},{kind:"MdxPage",name:"instr",route:"/instr"},{kind:"MdxPage",name:"int",route:"/int"},{kind:"MdxPage",name:"isnan",route:"/isnan"},{kind:"MdxPage",name:"isnotnull",route:"/isnotnull"},{kind:"MdxPage",name:"isnull",route:"/isnull"},{kind:"MdxPage",name:"java_method",route:"/java_method"},{kind:"MdxPage",name:"json_array_length",route:"/json_array_length"},{kind:"MdxPage",name:"json_object_keys",route:"/json_object_keys"},{kind:"MdxPage",name:"json_tuple",route:"/json_tuple"},{kind:"MdxPage",name:"kurtosis",route:"/kurtosis"},{kind:"MdxPage",name:"lag",route:"/lag"},{kind:"MdxPage",name:"last",route:"/last"},{kind:"MdxPage",name:"last_day",route:"/last_day"},{kind:"MdxPage",name:"last_value",route:"/last_value"},{kind:"MdxPage",name:"lcase",route:"/lcase"},{kind:"MdxPage",name:"lead",route:"/lead"},{kind:"MdxPage",name:"least",route:"/least"},{kind:"MdxPage",name:"left",route:"/left"},{kind:"MdxPage",name:"len",route:"/len"},{kind:"MdxPage",name:"length",route:"/length"},{kind:"MdxPage",name:"levenshtein",route:"/levenshtein"},{kind:"MdxPage",name:"like",route:"/like"},{kind:"MdxPage",name:"ln",route:"/ln"},{kind:"MdxPage",name:"localtimestamp",route:"/localtimestamp"},{kind:"MdxPage",name:"locate",route:"/locate"},{kind:"MdxPage",name:"log",route:"/log"},{kind:"MdxPage",name:"log10",route:"/log10"},{kind:"MdxPage",name:"log1p",route:"/log1p"},{kind:"MdxPage",name:"log2",route:"/log2"},{kind:"MdxPage",name:"lower",route:"/lower"},{kind:"MdxPage",name:"lpad",route:"/lpad"},{kind:"MdxPage",name:"ltrim",route:"/ltrim"},{kind:"MdxPage",name:"luhn_check",route:"/luhn_check"},{kind:"MdxPage",name:"make_date",route:"/make_date"},{kind:"MdxPage",name:"make_dt_interval",route:"/make_dt_interval"},{kind:"MdxPage",name:"make_interval",route:"/make_interval"},{kind:"MdxPage",name:"make_timestamp",route:"/make_timestamp"},{kind:"MdxPage",name:"make_timestamp_ltz",route:"/make_timestamp_ltz"},{kind:"MdxPage",name:"make_timestamp_ntz",route:"/make_timestamp_ntz"},{kind:"MdxPage",name:"make_ym_interval",route:"/make_ym_interval"},{kind:"MdxPage",name:"map",route:"/map"},{kind:"MdxPage",name:"map_concat",route:"/map_concat"},{kind:"MdxPage",name:"map_contains_key",route:"/map_contains_key"},{kind:"MdxPage",name:"map_entries",route:"/map_entries"},{kind:"MdxPage",name:"map_filter",route:"/map_filter"},{kind:"MdxPage",name:"map_from_arrays",route:"/map_from_arrays"},{kind:"MdxPage",name:"map_from_entries",route:"/map_from_entries"},{kind:"MdxPage",name:"map_keys",route:"/map_keys"},{kind:"MdxPage",name:"map_values",route:"/map_values"},{kind:"MdxPage",name:"map_zip_with",route:"/map_zip_with"},{kind:"MdxPage",name:"mask",route:"/mask"},{kind:"MdxPage",name:"max",route:"/max"},{kind:"MdxPage",name:"max_by",route:"/max_by"},{kind:"MdxPage",name:"md5",route:"/md5"},{kind:"MdxPage",name:"mean",route:"/mean"},{kind:"MdxPage",name:"median",route:"/median"},{kind:"MdxPage",name:"min",route:"/min"},{kind:"MdxPage",name:"min_by",route:"/min_by"},{kind:"MdxPage",name:"minute",route:"/minute"},{kind:"MdxPage",name:"mod",route:"/mod"},{kind:"MdxPage",name:"mode",route:"/mode"},{kind:"MdxPage",name:"monotonically_increasing_id",route:"/monotonically_increasing_id"},{kind:"MdxPage",name:"month",route:"/month"},{kind:"MdxPage",name:"months_between",route:"/months_between"},{kind:"MdxPage",name:"named_struct",route:"/named_struct"},{kind:"MdxPage",name:"nanvl",route:"/nanvl"},{kind:"MdxPage",name:"negative",route:"/negative"},{kind:"MdxPage",name:"next_day",route:"/next_day"},{kind:"MdxPage",name:"not",route:"/not"},{kind:"MdxPage",name:"now",route:"/now"},{kind:"MdxPage",name:"nth_value",route:"/nth_value"},{kind:"MdxPage",name:"ntile",route:"/ntile"},{kind:"MdxPage",name:"nullif",route:"/nullif"},{kind:"MdxPage",name:"nvl",route:"/nvl"},{kind:"MdxPage",name:"nvl2",route:"/nvl2"},{kind:"MdxPage",name:"octet_length",route:"/octet_length"},{kind:"MdxPage",name:"or",route:"/or"},{kind:"MdxPage",name:"overlay",route:"/overlay"},{kind:"MdxPage",name:"parse_url",route:"/parse_url"},{kind:"MdxPage",name:"percent_rank",route:"/percent_rank"},{kind:"MdxPage",name:"percentile",route:"/percentile"},{kind:"MdxPage",name:"percentile_approx",route:"/percentile_approx"},{kind:"MdxPage",name:"pi",route:"/pi"},{kind:"MdxPage",name:"pmod",route:"/pmod"},{kind:"MdxPage",name:"posexplode",route:"/posexplode"},{kind:"MdxPage",name:"posexplode_outer",route:"/posexplode_outer"},{kind:"MdxPage",name:"position",route:"/position"},{kind:"MdxPage",name:"positive",route:"/positive"},{kind:"MdxPage",name:"pow",route:"/pow"},{kind:"MdxPage",name:"power",route:"/power"},{kind:"MdxPage",name:"printf",route:"/printf"},{kind:"MdxPage",name:"privacy",route:"/privacy"},{kind:"MdxPage",name:"quarter",route:"/quarter"},{kind:"MdxPage",name:"radians",route:"/radians"},{kind:"MdxPage",name:"raise_error",route:"/raise_error"},{kind:"MdxPage",name:"rand",route:"/rand"},{kind:"MdxPage",name:"randn",route:"/randn"},{kind:"MdxPage",name:"random",route:"/random"},{kind:"MdxPage",name:"rank",route:"/rank"},{kind:"MdxPage",name:"reduce",route:"/reduce"},{kind:"MdxPage",name:"reflect",route:"/reflect"},{kind:"MdxPage",name:"regexp",route:"/regexp"},{kind:"MdxPage",name:"regexp_count",route:"/regexp_count"},{kind:"MdxPage",name:"regexp_extract",route:"/regexp_extract"},{kind:"MdxPage",name:"regexp_extract_all",route:"/regexp_extract_all"},{kind:"MdxPage",name:"regexp_instr",route:"/regexp_instr"},{kind:"MdxPage",name:"regexp_like",route:"/regexp_like"},{kind:"MdxPage",name:"regexp_replace",route:"/regexp_replace"},{kind:"MdxPage",name:"regexp_substr",route:"/regexp_substr"},{kind:"MdxPage",name:"regr_avgx",route:"/regr_avgx"},{kind:"MdxPage",name:"regr_avgy",route:"/regr_avgy"},{kind:"MdxPage",name:"regr_count",route:"/regr_count"},{kind:"MdxPage",name:"regr_intercept",route:"/regr_intercept"},{kind:"MdxPage",name:"regr_r2",route:"/regr_r2"},{kind:"MdxPage",name:"regr_slope",route:"/regr_slope"},{kind:"MdxPage",name:"regr_sxx",route:"/regr_sxx"},{kind:"MdxPage",name:"regr_sxy",route:"/regr_sxy"},{kind:"MdxPage",name:"regr_syy",route:"/regr_syy"},{kind:"MdxPage",name:"repeat",route:"/repeat"},{kind:"MdxPage",name:"replace",route:"/replace"},{kind:"MdxPage",name:"reverse",route:"/reverse"},{kind:"MdxPage",name:"right",route:"/right"},{kind:"MdxPage",name:"rint",route:"/rint"},{kind:"MdxPage",name:"rlike",route:"/rlike"},{kind:"MdxPage",name:"round",route:"/round"}

1,{kind:"MdxPage",name:"row_number",route:"/row_number"},{kind:"MdxPage",name:"rpad",route:"/rpad"},{kind:"MdxPage",name:"rtrim",route:"/rtrim"},{kind:"MdxPage",name:"schema_of_csv",route:"/schema_of_csv"},{kind:"MdxPage",name:"schema_of_json",route:"/schema_of_json"},{kind:"MdxPage",name:"sec",route:"/sec"},{kind:"MdxPage",name:"second",route:"/second"},{kind:"MdxPage",name:"sentences",route:"/sentences"},{kind:"MdxPage",name:"sequence",route:"/sequence"},{kind:"MdxPage",name:"session_window",route:"/session_window"},{kind:"MdxPage",name:"sha",route:"/sha"},{kind:"MdxPage",name:"sha1",route:"/sha1"},{kind:"MdxPage",name:"sha2",route:"/sha2"},{kind:"MdxPage",name:"shiftleft",route:"/shiftleft"},{kind:"MdxPage",name:"shiftright",route:"/shiftright"},{kind:"MdxPage",name:"shiftrightunsigned",route:"/shiftrightunsigned"},{kind:"MdxPage",name:"shuffle",route:"/shuffle"},{kind:"MdxPage",name:"sign",route:"/sign"},{kind:"MdxPage",name:"signum",route:"/signum"},{kind:"MdxPage",name:"sin",route:"/sin"},{kind:"MdxPage",name:"sinh",route:"/sinh"},{kind:"MdxPage",name:"size",route:"/size"},{kind:"MdxPage",name:"skewness",route:"/skewness"},{kind:"MdxPage",name:"slice",route:"/slice"},{kind:"MdxPage",name:"smallint",route:"/smallint"},{kind:"MdxPage",name:"some",route:"/some"},{kind:"MdxPage",name:"sort_array",route:"/sort_array"},{kind:"MdxPage",name:"soundex",route:"/soundex"},{kind:"MdxPage",name:"space",route:"/space"},{kind:"MdxPage",name:"spark_partition_id",route:"/spark_partition_id"},{kind:"MdxPage",name:"split",route:"/split"},{kind:"MdxPage",name:"split_part",route:"/split_part"},{kind:"MdxPage",name:"sqrt",route:"/sqrt"},{kind:"MdxPage",name:"stack",route:"/stack"},{kind:"MdxPage",name:"startswith",route:"/startswith"},{kind:"MdxPage",name:"std",route:"/std"},{kind:"MdxPage",name:"stddev",route:"/stddev"},{kind:"MdxPage",name:"stddev_pop",route:"/stddev_pop"},{kind:"MdxPage",name:"stddev_samp",route:"/stddev_samp"},{kind:"MdxPage",name:"str_to_map",route:"/str_to_map"},{kind:"MdxPage",name:"string",route:"/string"},{kind:"MdxPage",name:"struct",route:"/struct"},{kind:"MdxPage",name:"substr",route:"/substr"},{kind:"MdxPage",name:"substring",route:"/substring"},{kind:"MdxPage",name:"substring_index",route:"/substring_index"},{kind:"MdxPage",name:"sum",route:"/sum"},{kind:"MdxPage",name:"tan",route:"/tan"},{kind:"MdxPage",name:"tanh",route:"/tanh"},{kind:"MdxPage",name:"timestamp",route:"/timestamp"},{kind:"MdxPage",name:"timestamp_micros",route:"/timestamp_micros"},{kind:"MdxPage",name:"timestamp_millis",route:"/timestamp_millis"},{kind:"MdxPage",name:"timestamp_seconds",route:"/timestamp_seconds"},{kind:"MdxPage",name:"tinyint",route:"/tinyint"},{kind:"MdxPage",name:"to_binary",route:"/to_binary"},{kind:"MdxPage",name:"to_char",route:"/to_char"},{kind:"MdxPage",name:"to_csv",route:"/to_csv"},{kind:"MdxPage",name:"to_date",route:"/to_date"},{kind:"MdxPage",name:"to_json",route:"/to_json"},{kind:"MdxPage",name:"to_number",route:"/to_number"},{kind:"MdxPage",name:"to_timestamp",route:"/to_timestamp"},{kind:"MdxPage",name:"to_timestamp_ltz",route:"/to_timestamp_ltz"},{kind:"MdxPage",name:"to_timestamp_ntz",route:"/to_timestamp_ntz"},{kind:"MdxPage",name:"to_unix_timestamp",route:"/to_unix_timestamp"},{kind:"MdxPage",name:"to_utc_timestamp",route:"/to_utc_timestamp"},{kind:"MdxPage",name:"to_varchar",route:"/to_varchar"},{kind:"MdxPage",name:"transform",route:"/transform"},{kind:"MdxPage",name:"transform_keys",route:"/transform_keys"},{kind:"MdxPage",name:"transform_values",route:"/transform_values"},{kind:"MdxPage",name:"translate",route:"/translate"},{kind:"MdxPage",name:"trim",route:"/trim"},{kind:"MdxPage",name:"trunc",route:"/trunc"},{kind:"MdxPage",name:"try_add",route:"/try_add"},{kind:"MdxPage",name:"try_aes_decrypt",route:"/try_aes_decrypt"},{kind:"MdxPage",name:"try_avg",route:"/try_avg"},{kind:"MdxPage",name:"try_divide",route:"/try_divide"},{kind:"MdxPage",name:"try_element_at",route:"/try_element_at"},{kind:"MdxPage",name:"try_multiply",route:"/try_multiply"},{kind:"MdxPage",name:"try_subtract",route:"/try_subtract"},{kind:"MdxPage",name:"try_sum",route:"/try_sum"},{kind:"MdxPage",name:"try_to_binary",route:"/try_to_binary"},{kind:"MdxPage",name:"try_to_number",route:"/try_to_number"},{kind:"MdxPage",name:"try_to_timestamp",route:"/try_to_timestamp"},{kind:"MdxPage",name:"typeof",route:"/typeof"},{kind:"MdxPage",name:"ucase",route:"/ucase"},{kind:"MdxPage",name:"unbase64",route:"/unbase64"},{kind:"MdxPage",name:"unhex",route:"/unhex"},{kind:"MdxPage",name:"unix_date",route:"/unix_date"},{kind:"MdxPage",name:"unix_micros",route:"/unix_micros"},{kind:"MdxPage",name:"unix_millis",route:"/unix_millis"},{kind:"MdxPage",name:"unix_seconds",route:"/unix_seconds"},{kind:"MdxPage",name:"unix_timestamp",route:"/unix_timestamp"},{kind:"MdxPage",name:"upper",route:"/upper"},{kind:"MdxPage",name:"url_decode",route:"/url_decode"},{kind:"MdxPage",name:"url_encode",route:"/url_encode"},{kind:"MdxPage",name:"user",route:"/user"},{kind:"MdxPage",name:"uuid",route:"/uuid"},{kind:"MdxPage",name:"var_pop",route:"/var_pop"},{kind:"MdxPage",name:"var_samp",route:"/var_samp"},{kind:"MdxPage",name:"variance",route:"/variance"},{kind:"MdxPage",name:"version",route:"/version"},{kind:"MdxPage",name:"weekday",route:"/weekday"},{kind:"MdxPage",name:"weekofyear",route:"/weekofyear"},{kind:"MdxPage",name:"when",route:"/when"}

1,{kind:"MdxPage",name:"width_bucket",route:"/width_bucket"},{kind:"MdxPage",name:"window",route:"/window"},{kind:"MdxPage",name:"window_time",route:"/window_time"},{kind:"MdxPage",name:"xpath",route:"/xpath"},{kind:"MdxPage",name:"xpath_boolean",route:"/xpath_boolean"},{kind:"MdxPage",name:"xpath_double",route:"/xpath_double"},{kind:"MdxPage",name:"xpath_float",route:"/xpath_float"},{kind:"MdxPage",name:"xpath_int",route:"/xpath_int"},{kind:"MdxPage",name:"xpath_long",route:"/xpath_long"},{kind:"MdxPage",name:"xpath_number",route:"/xpath_number"},{kind:"MdxPage",name:"xpath_short",route:"/xpath_short"},{kind:"MdxPage",name:"xpath_string",route:"/xpath_string"},{kind:"MdxPage",name:"xxhash64",route:"/xxhash64"},{kind:"MdxPage",name:"year",route:"/year"},{kind:"MdxPage",name:"zip_with",route:"/zip_with"}],flexsearch:{codeblocks:!0},title:"json_object_keys",headings:s},pageNextRoute:"/json_object_keys",nextraLayout:i.ZP,themeConfig:d.Z};a.default=(0,r.j)(m)},45184:function(){}},function(e){e.O(0,[2461,9774,2888,179],function(){return e(e.s=7410)}),_N_E=e.O()}]);