{"id":3651,"date":"2024-03-13T07:15:52","date_gmt":"2024-03-13T07:15:52","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/"},"modified":"2025-07-30T19:18:25","modified_gmt":"2025-07-30T19:18:25","slug":"does-kylin-support-sql-interface","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/","title":{"rendered":"Kylin SQL Interface Explained"},"content":{"rendered":"<p>Yes, Kylin supports SQL interface. It provides a RESTful API that allows users to access and manipulate data in Kylin through SQL queries. Users can write queries using standard SQL syntax, send query requests through the API, and retrieve result sets. Kylin also offers some extended SQL syntax to support more complex OLAP query operations. With the SQL interface, users can easily use Kylin for data analysis and OLAP processing.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yes, Kylin supports SQL interface. It provides a RESTful API that allows users to access and manipulate data in Kylin through SQL queries. Users can write queries using standard SQL syntax, send query requests through the API, and retrieve result sets. Kylin also offers some extended SQL syntax to support more complex OLAP query operations. [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[897,302,2278,2281,2280],"class_list":["post-3651","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-apache-kylin","tag-big-data","tag-olap","tag-restful-api","tag-sql-interface"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Kylin SQL Interface Explained - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Discover how Apache Kylin supports SQL queries via RESTful API. Learn about standard &amp; extended OLAP SQL capabilities.\" \/>\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.silicloud.com\/blog\/does-kylin-support-sql-interface\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kylin SQL Interface Explained\" \/>\n<meta property=\"og:description\" content=\"Discover how Apache Kylin supports SQL queries via RESTful API. Learn about standard &amp; extended OLAP SQL capabilities.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-13T07:15:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-30T19:18:25+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sophia Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"Kylin SQL Interface Explained\",\"datePublished\":\"2024-03-13T07:15:52+00:00\",\"dateModified\":\"2025-07-30T19:18:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/\"},\"wordCount\":74,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Apache Kylin\",\"Big Data\",\"OLAP\",\"RESTful API\",\"SQL Interface\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/\",\"name\":\"Kylin SQL Interface Explained - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-13T07:15:52+00:00\",\"dateModified\":\"2025-07-30T19:18:25+00:00\",\"description\":\"Discover how Apache Kylin supports SQL queries via RESTful API. Learn about standard & extended OLAP SQL capabilities.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kylin SQL Interface Explained\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Kylin SQL Interface Explained - Blog - Silicon Cloud","description":"Discover how Apache Kylin supports SQL queries via RESTful API. Learn about standard & extended OLAP SQL capabilities.","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.silicloud.com\/blog\/does-kylin-support-sql-interface\/","og_locale":"en_US","og_type":"article","og_title":"Kylin SQL Interface Explained","og_description":"Discover how Apache Kylin supports SQL queries via RESTful API. Learn about standard & extended OLAP SQL capabilities.","og_url":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-13T07:15:52+00:00","article_modified_time":"2025-07-30T19:18:25+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"Kylin SQL Interface Explained","datePublished":"2024-03-13T07:15:52+00:00","dateModified":"2025-07-30T19:18:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/"},"wordCount":74,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Apache Kylin","Big Data","OLAP","RESTful API","SQL Interface"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/","url":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/","name":"Kylin SQL Interface Explained - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-13T07:15:52+00:00","dateModified":"2025-07-30T19:18:25+00:00","description":"Discover how Apache Kylin supports SQL queries via RESTful API. Learn about standard & extended OLAP SQL capabilities.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/does-kylin-support-sql-interface\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Kylin SQL Interface Explained"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/3651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=3651"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/3651\/revisions"}],"predecessor-version":[{"id":148310,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/3651\/revisions\/148310"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=3651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=3651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=3651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}