使用的环境是python3.6
1、安装pip必要包
pip install kylinpy
pip install sqlalchemy
2、
查询代码:
import sqlalchemy as sa
def kylin_query(conn_str,query_sql):
#查看表(我没跑通)
kylin_engine = sa.create_engine(conn_str)
kylin_engine.table_names()
results = kylin_engine.execute(query_sql)
return results
def kylin_query_show(conn_str,query_sql):
#查询并输出结果
kylin_engine = sa.create_engine(conn_str)
results = kylin_engine.execute(query_sql)
for line in results:
i = 1
for col in line:
if (i != len(line)):
print(col, end='\t')
else:
print(col)
i = i + 1
conn_str = 'kylin://username:password@ip:7070/projectname?version=v1'
query_sql = "select c1,sum(c2) sma from database_name.table_name group by c1 order by c1"
kylin_query_show(conn_str,query_sql)
#kylin_query(conn_str,query_sql)