{"repo":"junqiangChi/es-sql","free":true,"listed":false,"github":"https://github.com/junqiangChi/es-sql","clone":"git clone https://github.com/junqiangChi/es-sql.git","description":"Using SQL to operate Elasticsearch","language":"Java","stars":10,"topics":["antlr4","druid","elasticsearch","sql","high-level-rest-client"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Es Sql Introduction Es SQL is a project that uses SQL syntax to operate Elasticsearch , with Antlr4 component used for syntax parsing and Druid for database connection pooling Builds Elasticsearch Plugin Plugin Install Plugin Usage Plugin Execute Page After installing the plugin and restarting Elasticsearch, you can proceed to the following page to perform SQL queries EsJdbcConfig Configuration parameters that can be set when using jdbc connection key default type description -------------------- --------- --------- -------------------------------------------- user (none) String Elasticsearch username password (none) String Elasticsearch password url (none) String Url eg：jdbc:elasticsearch://localhost:9200 include.index.name false Boolean The query result include the index name include.doc.id false Boolean The query result include the docId include.type false Boolean The query result include the type include.score false Boolean The query result include the score SQL Supported Features - ✅ SELECT - ✅ FiELD ALIAS - ✅ CONSTANT FIELD - ✅ OPTIONAL FIELD - id : DOC ID - index : INDEX NAME - type : INDEX TYPE - score : DOC SCORE - ✅ NESTED FIELD - select f1.f2 from my index - Nested fields do not support aggregation functions - ✅ FUNCTION - ✅LENGTH() - ✅LOWER() - ✅UPPER() - ✅SUBSTRING() SUBSTR() - ✅TRIM() - ✅CONCAT() CONCAT WS() - ✅REPLACE() - ✅ABS() - ✅CEIL() - ✅FLOOR() - ✅ROUND() - ✅MOD() - ✅POW() - ✅SQRT() - ✅RAND() - ✅CASE WHEN THEN ELSE END - ✅IF() - ✅IFNULL() - ✅COALESCE() - ✅","default_branch":null,"files":null,"tree":[],"storefront":"/r/junqiangChi","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/junqiangChi/es-sql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}