You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/09/14 06:54:56 UTC
[GitHub] [incubator-superset] reesezxf opened a new issue #10856: superset clickhouse load Nullable(String) columns as UNKOWN type
reesezxf opened a new issue #10856:
URL: https://github.com/apache/incubator-superset/issues/10856
I use tablemodelview/add a clickhouse table, its DDL:
```
CREATE TABLE business.tCompany_dim_all
(
`cID` String,
`chsynDate` Date,
`cCreateTime` Nullable(DateTime),
`cUpdateTime` DateTime,
`cName` Nullable(String)
)
ENGINE = Distributed('cluster_test',
'business',
'tTestTable',
cityHash64(cID))
```
but in tablecolumns, cCreateTime ,cName type is UNKOWN
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] reesezxf closed issue #10856: superset clickhouse load Nullable(String) columns as UNKOWN type
Posted by GitBox <gi...@apache.org>.
reesezxf closed issue #10856:
URL: https://github.com/apache/incubator-superset/issues/10856
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #10856: superset clickhouse load Nullable(String) columns as UNKOWN type
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10856:
URL: https://github.com/apache/incubator-superset/issues/10856#issuecomment-691856183
Issue Label Bot is not confident enough to auto-label this issue. See [dashboard](https://mlbot.net/data/apache/incubator-superset) for more details.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] zhaoyongjie commented on issue #10856: superset clickhouse load Nullable(String) columns as UNKOWN type
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #10856:
URL: https://github.com/apache/incubator-superset/issues/10856#issuecomment-691892379
Hi, @reesezxf , Clickhouse has some specify column type
1. please use ansi-SQL column type
2. override 'db_column_types' attribute in superset.db_engine_specs.ClickHouseEngineSpec
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] commented on issue #10856: superset clickhouse load Nullable(String) columns as UNKOWN type
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10856:
URL: https://github.com/apache/incubator-superset/issues/10856#issuecomment-734495340
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] zhaoyongjie edited a comment on issue #10856: superset clickhouse load Nullable(String) columns as UNKOWN type
Posted by GitBox <gi...@apache.org>.
zhaoyongjie edited a comment on issue #10856:
URL: https://github.com/apache/incubator-superset/issues/10856#issuecomment-691892379
Hi, @reesezxf , Clickhouse has some specific column type
1. using ansi-SQL column type
2. override 'db_column_types' attribute in superset.db_engine_specs.ClickHouseEngineSpec
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] zhaoyongjie edited a comment on issue #10856: superset clickhouse load Nullable(String) columns as UNKOWN type
Posted by GitBox <gi...@apache.org>.
zhaoyongjie edited a comment on issue #10856:
URL: https://github.com/apache/incubator-superset/issues/10856#issuecomment-691892379
Hi, @reesezxf , Clickhouse has some specific column type
1. please use ansi-SQL column type
2. override 'db_column_types' attribute in superset.db_engine_specs.ClickHouseEngineSpec
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org