implydata / Plyql
Licence: apache-2.0
MySQL-like queries for Druid built on top of Plywood
Stars: ✭ 148
Programming Languages
typescript
32286 projects
Projects that are alternatives of or similar to Plyql
Superboot
随着技术日新月异，新技术新平台不断出现，对现如今的开发人员来说选择快速高效的框架进行项目开发，既能提高产出，又能节约时间。本框架无需开发即可实现服务注册、服务发现、负载均衡、服务网关、配置中心、API管理、分布式事务、支撑平台、集成框架、数据传输加密等功能，是学习SpringCloud整体业务模式的完整示例，并且可以直接用于生产环境
Stars: ✭ 341 (+130.41%)
Mutual labels: sql, druid
Maha
A framework for rapid reporting API development; with out of the box support for high cardinality dimension lookups with druid.
Stars: ✭ 101 (-31.76%)
Mutual labels: sql, druid
Dbr
Additions to Go's database/sql for super fast performance and convenience. (fork of gocraft/dbr)
Stars: ✭ 140 (-5.41%)
Mutual labels: sql
Prometheus Sql
Service that exposes Prometheus metrics for a SQL result set.
Stars: ✭ 140 (-5.41%)
Mutual labels: sql
Efcore.bulkextensions
Entity Framework Core Bulk Batch Extensions for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, SQLite
Stars: ✭ 2,295 (+1450.68%)
Mutual labels: sql
Skill6 Website Backend
java进阶开发，高级版web项目。基于dubbo实现分布式微服务架构，基于spring boot、spring mvc、mybatis、docker、ELK、redis、vue.js、node.js等技术实现的技术分享交流网站。网站名称：技术流，英文名：skill6。主要功能有：登录注册、单点登录、restful设计、文章及评论、代码及资源下载、主题讨论等。持续更新中...
Stars: ✭ 140 (-5.41%)
Mutual labels: druid
Opentick
A fast tick database for financial timeseries data, built on FoundationDB with simplified SQL layer
Stars: ✭ 144 (-2.7%)
Mutual labels: sql
Data Science Question Answer
A repo for data science related questions and answers
Stars: ✭ 2,000 (+1251.35%)
Mutual labels: sql
Laravel Db Profiler
Database Profiler for Laravel Web and Console Applications.
Stars: ✭ 141 (-4.73%)
Mutual labels: sql
Stampede
The ToroDB solution to provide better analytics on top of MongoDB and make it easier to migrate from MongoDB to SQL
Stars: ✭ 1,754 (+1085.14%)
Mutual labels: sql
Builder
Lightweight and fast SQL builder for Go language, moved to https://gitea.com/xorm/builder
Stars: ✭ 140 (-5.41%)
Mutual labels: sql
Django Sql Explorer
Easily share data across your company via SQL queries. From Grove Collab.
Stars: ✭ 1,958 (+1222.97%)
Mutual labels: sql
Mi S
基于SpringBoot+SpringCloud+Mybatis主流框架搭建的分布式敏捷开发系统架构，为中、小型项目打造企业级基础开发多种解决方案。
Stars: ✭ 140 (-5.41%)
Mutual labels: druid
Sqlcell
SQLCell is a magic function for the Jupyter Notebook that executes raw, parallel, parameterized SQL queries with the ability to accept Python values as parameters and assign output data to Python variables while concurrently running Python code. And *much* more.
Stars: ✭ 145 (-2.03%)
Mutual labels: sql
Sequelize Ui
Browser-based GUI for previewing and generating Sequelize project files.
Stars: ✭ 142 (-4.05%)
Mutual labels: sql
[ DEPRECATED ] PlyQL
A SQL-like interface to plywood
⛔️ This project has been deprecated due to SQL support in Druid.
Installation
PlyQL is built on top of node so make sure you have node >= 4.x.x installed.
npm install -g plyql
The global install will make the plyql command available system wide.
Usage
Currently only queries to Druid are supported. More support will come in the future.
The CLI supports the following options:
| Option | Description |
|---|---|
--help |
print this help message |
--version |
display the version number |
-v, --verbose
|
display the queries that are being made |
-h, --host
|
the host to connect to |
-s, --source
|
use this source for the query (supersedes FROM clause) |
-i, --interval
|
add (AND) a __time filter between NOW-INTERVAL and NOW |
-tz, --timezone
|
the default timezone |
-q, --query
|
the query to run |
-o, --output
|
specify the output format. Possible values: json (default), csv, tsv, flat
|
-a, --allow
|
enable a behaviour that is turned off by default eternity allow queries not filtered on time select allow select queries |
-t, --timeout
|
the time before a query is timed out in ms (default: 60000) |
-r, --retry
|
the number of tries a query should be attempted on error, 0 = unlimited, (default: 2) |
-c, --concurrent
|
the limit of concurrent queries that could be made simultaneously, 0 = unlimited, (default: 2) |
--rollup |
use rollup mode [COUNT() -> SUM(count)] |
--druid-version |
Assume this is the Druid version and do not query for it |
--skip-cache |
disable Druid caching |
--introspection-strategy |
Druid introspection strategy. Use --help for possible values |
--force-time |
force a column to be interpreted as a time column |
--force-string |
force a column to be interpreted as a string column |
--force-boolean |
force a column to be interpreted as a boolean column |
--force-number |
force a column to be interpreted as a number column |
--force-unique |
force a column to be interpreted as a hyperLogLog uniques |
--force-theta |
force a column to be interpreted as a theta sketch |
--force-histogram |
force a column to be interpreted as an approximate histogram (for quantiles) |
For information on specific operators and functions supported by PlyQL please see: PlyQL language reference.
Examples
For an introduction and examples please see: PlyQL language reference.
Roadmap
Here is a list of features that is not currently supported that are in the works:
- Query simulation - preview the queries that will be run without running them
- Sub-queries in WHERE clauses
- JOIN support
- Window functions
Questions & Support
For updates about new and upcoming features follow @implydata on Twitter.
Please file bugs and feature requests by opening and issue on GitHub and direct all questions to our user groups.
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].