存档

文章标签 ‘superset’

superset SQL生成的研究

2018年3月15日 admin 没有评论

superset类似系统,一期实现不要实现这么复杂的SQL拼接: SELECT state AS state, job_date AS __timestamp, sum(job_num) AS sum_job_num FROM (select count(1) as job_num, state, job_date from job_info group by state, job_date) AS expr_qry INNER JOIN (SELECT state AS state__, sum(job_num) AS mme_inner__ FROM (select count(1) as job_num, state, job_date from job_info group by state, job_date) AS expr_qry WHERE job_date >= STR_TO_DATE('2017-12-05 00:00:00', '%%Y-%%m-%%

分类: Java 标签:

superset能否连接ElasticSearch

2017年12月22日 admin 没有评论

找到一个组件,还没来得及看呢 https://pypi.python.org/pypi/sqlalchemy-elasticquery/

分类: Java 标签: