wxiang7 / pykylin Goto Github PK
View Code? Open in Web Editor NEWPython DBAPI Driver and Sqlalchemy Dialect for Apache Kylin, the "Extreme OLAP Engine for Big Data"
Python DBAPI Driver and Sqlalchemy Dialect for Apache Kylin, the "Extreme OLAP Engine for Big Data"
Pip cannot find pykylin, is it still being maintenanced?
When creating a new table by "sources"- > tables , it gives "get_table_names() takes at most 3 arguments (4 given)".
Kylin version 2.1
superset 0.20.4
kylin 0.0.1
NO1. click the tablename occurs the following errors in logs
ERROR:root:'NoneType' object has no attribute 'sqla_col'
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/caravel/views.py", line 1183, in explore
viz_obj.get_json(),
File "/usr/local/lib/python2.7/site-packages/caravel/viz.py", line 318, in get_json
'data': self.get_data(),
File "/usr/local/lib/python2.7/site-packages/caravel/viz.py", line 448, in get_data
df = self.get_df()
File "/usr/local/lib/python2.7/site-packages/caravel/viz.py", line 440, in get_df
df = super(TableViz, self).get_df(query_obj)
File "/usr/local/lib/python2.7/site-packages/caravel/viz.py", line 165, in get_df
self.results = self.datasource.query(**query_obj)
File "/usr/local/lib/python2.7/site-packages/caravel/models.py", line 794, in query
metrics_exprs = [metrics_dict.get(m).sqla_col for m in metrics]
No2. the project maybe not fit some datatypes in kylin :like the type decimal(19,4) or timestamp(0)
superset不支持kylin中的数据为null的数据类型,该如何解决
Hello!@wxiang7.
I encountered a problem using pykylin
2016-12-22 15:50:41,229:ERROR:root:u'TIMESTAMP(0)' Traceback (most recent call last): File "/usr/local/bin/python27/lib/python2.7/site-packages/superset/views.py", line 694, in pre_add table.get_sqla_table_object() File "/usr/local/bin/python27/lib/python2.7/site-packages/superset/models.py", line 1176, in get_sqla_table_object return self.database.get_table(self.table_name, schema=self.schema) File "/usr/local/bin/python27/lib/python2.7/site-packages/superset/models.py", line 835, in get_table autoload_with=self.get_sqla_engine()) File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 416, in __new__ metadata._remove_table(name, schema) File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 411, in __new__ table._init(name, metadata, *args, **kw) File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 484, in _init self._autoload(metadata, autoload_with, include_columns) File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 496, in _autoload self, include_columns, exclude_columns File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1972, in run_callable return conn.run_callable(callable_, *args, **kwargs) File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1477, in run_callable return callable_(self, *args, **kwargs) File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 364, in reflecttable return insp.reflecttable(table, include_columns, exclude_columns) File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py", line 563, in reflecttable table_name, schema, **table.dialect_kwargs): File "/usr/local/bin/python27/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py", line 369, in get_columns **kw) File "/usr/local/bin/python27/lib/python2.7/site-packages/pykylin-0.0.1-py2.7.egg/pykylin/dialect.py", line 158, in get_columns return [self._map_column_type(c) for c in cols] File "/usr/local/bin/python27/lib/python2.7/site-packages/pykylin-0.0.1-py2.7.egg/pykylin/dialect.py", line 172, in _map_column_type tpe = KYLIN_TYPE_MAP[tpe_NAME]
KYLIN_TYPE_MAP not find TIMESTAMP TYPE!
How to fix it?
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.