{"id":2118,"date":"2017-01-03T02:39:56","date_gmt":"2017-01-03T02:39:56","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2118"},"modified":"2023-06-22T06:08:19","modified_gmt":"2023-06-22T13:08:19","slug":"query-json-sql-couchbase-query-workbench-coffee-on-couchbase","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/","title":{"rendered":"CouchBase \ucffc\ub9ac \uc6cc\ud06c\ubca4\uce58\uc5d0\uc11c SQL\uc744 \uc0ac\uc6a9\ud558\uc5ec JSON \ucffc\ub9ac\ud558\uae30 - Coffee on CouchBase"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13553\" src=\"\/wp-content\/original-assets\/coffee-on-couchbase.png\" alt=\"coffee-on-couchbase\" width=\"484\" height=\"125\" \/><\/p>\n<p>SQL\uacfc \uc720\uc0ac\ud55c \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec JSON \ubb38\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucffc\ub9ac\ud558\uace0 \uc2f6\uc73c\uc2e0\uac00\uc694? \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc5d0\ub294 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/products\/n1ql\/\">N1QL<\/a> \uc0ac\uc6a9\uc790\ub97c \uc704\ud574.<\/p>\n<p class=\"left\"><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/n1ql\/\">N1QL<\/a> \uc740 JSON\uc6a9 SQL\uc744 \ud655\uc7a5\ud558\ub294 \uc120\uc5b8\uc801 \ucffc\ub9ac \uc5b8\uc5b4\uc785\ub2c8\ub2e4. \uae30\ubcf8 \ud504\ub808\uc784\uc6cc\ud06c \ubc0f \uc5b8\uc5b4 \ud1b5\ud569, \uc720\ucc3d\ud55c API \ub610\ub294 JDBC\/ODBC \ub4dc\ub77c\uc774\ubc84\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p class=\"left\">N1QL\uc744 \uc0ac\uc6a9\ud558\uba74 \ud55c \ubc88\uc758 \ucffc\ub9ac\ub85c \ub370\uc774\ud130\ub97c \uc815\ub82c, \ud544\ud130\ub9c1, \ubcc0\ud658, \uadf8\ub8f9\ud654, \uacb0\ud569\ud558\ub294 \ub4f1 \uc81c\ud55c \uc5c6\uc774 JSON \ubb38\uc11c\ub97c \ucffc\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9de\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <u>\uacb0\ud569<\/u> \uc5ec\ub7ec \ubb38\uc11c\uc5d0\uc11c <b>JOIN<\/b>. \uc57d\uc18d\ud588\ub358 \uadf8 \uc720\uc5f0\ud55c \ub370\uc774\ud130 \ubaa8\ub378? \ubc14\ub85c \uc774\uac83\uc785\ub2c8\ub2e4. \ub354 \uc774\uc0c1 '\ub2e8\uc77c \ud14c\uc774\ube14' \ubc0f '\ucffc\ub9ac\ubcc4 \ud14c\uc774\ube14' \ub370\uc774\ud130 \ubaa8\ub378\uc5d0 \uad6d\ud55c\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p class=\"left\"><a href=\"https:\/\/query.pub.couchbase.com\/tutorial\/#1\">N1QL \ud29c\ud1a0\ub9ac\uc5bc<\/a> \uc740 SQL\uacfc \uc720\uc0ac\ud55c \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec JSON \ubb38\uc11c\ub97c \ucffc\ub9ac\ud558\ub294 \uac1c\ub150\uc744 \ubc30\uc6b8 \uc218 \uc788\ub294 \ud6cc\ub96d\ud55c \ub9ac\uc18c\uc2a4\uc785\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uba87 \uac00\uc9c0 \uc608\uc2dc\uc785\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default decode:true\">SELECT children[0].fname AS cname\r\n    FROM tutorial\r\n       WHERE fname='Dave'<\/pre>\n<p>\ub610\ub294<\/p>\n<pre class=\"lang:default decode:true\">SELECT fname, age, age\/7 AS age_dog_years \r\n    FROM tutorial \r\n        WHERE fname = 'Dave'<\/pre>\n<p>\ub610\ub294<\/p>\n<pre class=\"lang:default decode:true\">SELECT relation, COUNT(*) AS count\r\n    FROM tutorial\r\n        GROUP BY relation\r\n            HAVING COUNT(*) &gt; 1<\/pre>\n<p>\ub610\ub294<\/p>\n<pre class=\"lang:default decode:true\">SELECT t.relation, COUNT(*) AS count, AVG(c.age) AS avg_age\r\n    FROM tutorial t\r\n    UNNEST t.children c\r\n    WHERE c.age &gt; 10\r\n    GROUP BY t.relation\r\n    HAVING COUNT(*) &gt; 1\r\n    ORDER BY avg_age DESC\r\n    LIMIT 1 OFFSET 1<\/pre>\n<p>\ub610\ub294<\/p>\n<pre class=\"lang:default decode:true\">SELECT\r\nproduct.name, \r\nCOUNT(reviews) AS reviewCount,\r\nROUND(AVG(reviews.rating),1) AS AvgRating,\r\ncategory \r\n FROM reviews AS reviews\r\nJOIN product AS product \r\n ON KEYS reviews.productId\r\nUNNEST product.categories AS category\r\nWHERE category = \"Appliances\"\r\nGROUP BY category, product\r\nORDER BY AvgRating \r\nDESC LIMIT 3<\/pre>\n<p>N1QL\uc744 \uc2e4\ud5d8\ud574 \ubcfc \uc900\ube44\uac00 \ub418\uc168\ub098\uc694? \ud655\uc2e4\ud788 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.1\/cli\/cbq-tool.html\">CBQ \ub3c4\uad6c<\/a>. \ub610\ub294 \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.1\/developer-guide\/query-workbench-intro.html\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ucffc\ub9ac \uc6cc\ud06c\ubca4\uce58<\/a>. \ucffc\ub9ac \uc6cc\ud06c\ubca4\uce58\ub294 \uac04\ub2e8\ud55c \ucffc\ub9ac\ubd80\ud130 \ubcf5\uc7a1\ud55c N1QL \ucffc\ub9ac\ub97c \uc900\ube44\ud558\uace0 \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \ud48d\ubd80\ud55c \uadf8\ub798\ud53d \uc0ac\uc6a9\uc790 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. N1QL \ubb38\uc744 \ucc3e\uc544\ubcf4\uace0, \ub9cc\ub4e4\uace0, \uc2e4\ud589\ud558\uace0, \uacb0\uacfc\ub97c \ubcfc \uc218 \uc788\ub3c4\ub85d \ud558\uc5ec \ucffc\ub9ac \uac1c\ubc1c\uc744 \ud3b8\ub9ac\ud558\uac8c \uc218\ud589\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc2dc\uc791\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uace0 \uc2f6\uc73c\uc2e0\uac00\uc694? \uc5d0\ubca4 \ud558\ubc84\uc640 \ud568\uaed8\ud558\ub294 \uc774 \uac04\ub2e8\ud55c \uc138\uc158\uc5d0\uc11c \uc774\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \uac83\uc744 \uc54c\uc544\ubcf4\uc138\uc694:<\/p>\n<p>\ub2e4\uc74c \uc8fc\uc18c\ub85c \uc9c8\ubb38\ud558\uc138\uc694. <a href=\"https:\/\/stackoverflow.com\/questions\/tagged\/couchbase\">\uc2a4\ud0dd \uc624\ubc84\ud50c\ub85c<\/a> \ub610\ub294 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/forums\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ud3ec\ub7fc<\/a>.<\/p>\n<p>\ub2e4\uc74c \ub9c1\ud06c\uc5d0\uc11c \ud314\ub85c\uc6b0\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/twitter.com\/couchbasedev\">@couchbasedev<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/twitter.com\/couchbase\">@couchbase<\/a>. \uc990\uae30\uc138\uc694!<\/p>","protected":false},"excerpt":{"rendered":"<p>You&#8217;d like to query JSON document database using SQL-like syntax? Couchbase has N1QL for you. N1QL is a declarative query language that extends SQL for JSON. You can query data via native framework and language integration, a fluent API, or [&hellip;]<\/p>","protected":false},"author":58,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"ppma_author":[8933],"class_list":["post-2118","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.8 (Yoast SEO v25.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Query JSON using SQL with Couchbase Query Workbench - Coffee on Couchbase - The Couchbase Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Query JSON using SQL with Couchbase Query Workbench - Coffee on Couchbase\" \/>\n<meta property=\"og:description\" content=\"You&#8217;d like to query JSON document database using SQL-like syntax? Couchbase has N1QL for you. N1QL is a declarative query language that extends SQL for JSON. You can query data via native framework and language integration, a fluent API, or [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-03T02:39:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-22T13:08:19+00:00\" \/>\n<meta name=\"author\" content=\"Arun Gupta, VP, Developer Advocacy, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@arungupta\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Arun Gupta, VP, Developer Advocacy, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/\"},\"author\":{\"name\":\"Arun Gupta, VP, Developer Advocacy, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/39d8caed0f536489b6aa6e8d31ee631f\"},\"headline\":\"Query JSON using SQL with Couchbase Query Workbench &#8211; Coffee on Couchbase\",\"datePublished\":\"2017-01-03T02:39:56+00:00\",\"dateModified\":\"2023-06-22T13:08:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/\"},\"wordCount\":246,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/\",\"name\":\"Query JSON using SQL with Couchbase Query Workbench - Coffee on Couchbase - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2017-01-03T02:39:56+00:00\",\"dateModified\":\"2023-06-22T13:08:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Query JSON using SQL with Couchbase Query Workbench &#8211; Coffee on Couchbase\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/39d8caed0f536489b6aa6e8d31ee631f\",\"name\":\"Arun Gupta, VP, Developer Advocacy, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8900a75409c646948fe0bd80f6240337\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f912e10b5f39748ee4f1a0b0da6f42747f0b3a94fe7acb511791468656f5e726?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f912e10b5f39748ee4f1a0b0da6f42747f0b3a94fe7acb511791468656f5e726?s=96&d=mm&r=g\",\"caption\":\"Arun Gupta, VP, Developer Advocacy, Couchbase\"},\"description\":\"Arun Gupta is the vice president of developer advocacy at Couchbase. He has built and led developer communities for 10+ years at Sun, Oracle, and Red Hat. He has deep expertise in leading cross-functional teams to develop and execute strategy, planning and execution of content, marketing campaigns, and programs. Prior to that he led engineering teams at Sun and is a founding member of the Java EE team. Gupta has authored more than 2,000 blog posts on technology. He has extensive speaking experience in more than 40 countries on myriad topics and is a JavaOne Rock Star for three years in a row. Gupta also founded the Devoxx4Kids chapter in the US and continues to promote technology education among children. An author of several books on technology, an avid runner, a globe trotter, a Java Champion, a JUG leader, NetBeans Dream Team member, and a Docker Captain, he is easily accessible at @arungupta.\",\"sameAs\":[\"https:\/\/x.com\/arungupta\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/arun-gupta\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Query JSON using SQL with Couchbase Query Workbench - Coffee on Couchbase - The Couchbase Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/","og_locale":"ko_KR","og_type":"article","og_title":"Query JSON using SQL with Couchbase Query Workbench - Coffee on Couchbase","og_description":"You&#8217;d like to query JSON document database using SQL-like syntax? Couchbase has N1QL for you. N1QL is a declarative query language that extends SQL for JSON. You can query data via native framework and language integration, a fluent API, or [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/","og_site_name":"The Couchbase Blog","article_published_time":"2017-01-03T02:39:56+00:00","article_modified_time":"2023-06-22T13:08:19+00:00","author":"Arun Gupta, VP, Developer Advocacy, Couchbase","twitter_card":"summary_large_image","twitter_creator":"@arungupta","twitter_misc":{"Written by":"Arun Gupta, VP, Developer Advocacy, Couchbase","Est. reading time":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/"},"author":{"name":"Arun Gupta, VP, Developer Advocacy, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/39d8caed0f536489b6aa6e8d31ee631f"},"headline":"Query JSON using SQL with Couchbase Query Workbench &#8211; Coffee on Couchbase","datePublished":"2017-01-03T02:39:56+00:00","dateModified":"2023-06-22T13:08:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/"},"wordCount":246,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["Uncategorized"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/","url":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/","name":"Query JSON using SQL with Couchbase Query Workbench - Coffee on Couchbase - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2017-01-03T02:39:56+00:00","dateModified":"2023-06-22T13:08:19+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/query-json-sql-couchbase-query-workbench-coffee-on-couchbase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Query JSON using SQL with Couchbase Query Workbench &#8211; Coffee on Couchbase"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/39d8caed0f536489b6aa6e8d31ee631f","name":"Arun Gupta, \uac1c\ubc1c\uc790 \uc9c0\uc6d0 \ubd80\ubb38 \ubd80\uc0ac\uc7a5, Couchbase","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8900a75409c646948fe0bd80f6240337","url":"https:\/\/secure.gravatar.com\/avatar\/f912e10b5f39748ee4f1a0b0da6f42747f0b3a94fe7acb511791468656f5e726?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f912e10b5f39748ee4f1a0b0da6f42747f0b3a94fe7acb511791468656f5e726?s=96&d=mm&r=g","caption":"Arun Gupta, VP, Developer Advocacy, Couchbase"},"description":"Arun Gupta is the vice president of developer advocacy at Couchbase. He has built and led developer communities for 10+ years at Sun, Oracle, and Red Hat. He has deep expertise in leading cross-functional teams to develop and execute strategy, planning and execution of content, marketing campaigns, and programs. Prior to that he led engineering teams at Sun and is a founding member of the Java EE team. Gupta has authored more than 2,000 blog posts on technology. He has extensive speaking experience in more than 40 countries on myriad topics and is a JavaOne Rock Star for three years in a row. Gupta also founded the Devoxx4Kids chapter in the US and continues to promote technology education among children. An author of several books on technology, an avid runner, a globe trotter, a Java Champion, a JUG leader, NetBeans Dream Team member, and a Docker Captain, he is easily accessible at @arungupta.","sameAs":["https:\/\/x.com\/arungupta"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/arun-gupta\/"}]}},"authors":[{"term_id":8933,"user_id":58,"is_guest":0,"slug":"arun-gupta","display_name":"Arun Gupta, VP, Developer Advocacy, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/f912e10b5f39748ee4f1a0b0da6f42747f0b3a94fe7acb511791468656f5e726?s=96&d=mm&r=g","author_category":"","last_name":"Gupta","first_name":"Arun","job_title":"","user_url":"","description":"\uc544\ub8ec \uad7d\ud0c0\ub294 Couchbase\uc758 \uac1c\ubc1c\uc790 \uc9c0\uc6d0 \ub2f4\ub2f9 \ubd80\uc0ac\uc7a5\uc785\ub2c8\ub2e4. \uadf8\ub294 Sun, Oracle, Red Hat\uc5d0\uc11c 10\ub144 \uc774\uc0c1 \uac1c\ubc1c\uc790 \ucee4\ubba4\ub2c8\ud2f0\ub97c \uad6c\ucd95\ud558\uace0 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. \uadf8\ub294 \ucf58\ud150\uce20, \ub9c8\ucf00\ud305 \ucea0\ud398\uc778 \ubc0f \ud504\ub85c\uadf8\ub7a8\uc758 \uc804\ub7b5, \uacc4\ud68d \ubc0f \uc2e4\ud589\uc744 \uac1c\ubc1c \ubc0f \uc2e4\ud589\ud558\ub294 \uad50\ucc28 \uae30\ub2a5 \ud300\uc744 \uc774\ub044\ub294 \ub370 \uc788\uc5b4 \uae4a\uc740 \uc804\ubb38\uc131\uc744 \ubcf4\uc720\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8 \uc804\uc5d0\ub294 Sun\uc5d0\uc11c \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1 \ud300\uc744 \uc774\ub04c\uc5c8\uc73c\uba70 Java EE \ud300\uc758 \ucc3d\ub9bd \uba64\ubc84\uc785\ub2c8\ub2e4.\r\n\r\nGupta\ub294 \uae30\uc220\uc5d0 \uad00\ud55c \ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c\uc744 2,000\uac1c \uc774\uc0c1 \uc791\uc131\ud588\uc2b5\ub2c8\ub2e4. 40\uc5ec \uac1c\uad6d\uc5d0\uc11c \uc218\ub9ce\uc740 \uc8fc\uc81c\uc5d0 \ub300\ud574 \uad11\ubc94\uc704\ud55c \uac15\uc5f0 \uacbd\ud5d8\uc744 \uac00\uc9c0\uace0 \uc788\uc73c\uba70, 3\ub144 \uc5f0\uc18d JavaOne Rock Star\ub85c \uc120\uc815\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub610\ud55c \ubbf8\uad6d\uc5d0\uc11c Devoxx4Kids \uc9c0\ubd80\ub97c \uc124\ub9bd\ud558\uc5ec \uc5b4\ub9b0\uc774\ub97c \ub300\uc0c1\uc73c\ub85c \ud55c \uae30\uc220 \uad50\uc721\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \uc7a5\ub824\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uae30\uc220\uc5d0 \uad00\ud55c \uc5ec\ub7ec \uad8c\uc758 \ucc45\uc744 \uc800\uc220\ud588\uc73c\uba70, \uc5f4\ub82c\ud55c \ub9c8\ub77c\ud1a0\ub108\uc774\uc790 \uc9c0\uad6c\ub97c \ud6a1\ub2e8\ud558\ub294 \uc0ac\ub78c, Java \ucc54\ud53c\uc5b8, JUG \ub9ac\ub354, NetBeans \ub4dc\ub9bc\ud300 \uba64\ubc84, Docker \ucea1\ud2f4\uc774\uae30\ub3c4 \ud55c \uadf8\ub294 @arungupta\uc5d0\uc11c \uc27d\uac8c \ub9cc\ub098\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=2118"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2118\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=2118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=2118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=2118"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=2118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}