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 2021/07/26 04:21:28 UTC
[GitHub] [superset] lijc210 opened a new issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
lijc210 opened a new issue #15892:
URL: https://github.com/apache/superset/issues/15892
superset==1.2.0
clickhouse error: 'NoneType' object has no attribute 'startswith'
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] lijc210 edited a comment on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
lijc210 edited a comment on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886506222
superset==1.2.0
clickhouse-sqlalchemy 0.1.6
clickhouse://ck_readonly:XXXXXXXXXX@xxx.xxx.xxx.xxx:8123/ads?secure=true
If the data from SQL query contains NULL, an error will be reported

2021-07-26 16:51:49,314:DEBUG:urllib3.connectionpool:http://114.116.224.81:8123 "POST /?query_id=300ae6b2-a582-4280-be3b-8f37cd1f9cea&database=ads HTTP/1.1" 200 None
Query 8: <class 'AttributeError'>
2021-07-26 16:51:49,314:ERROR:superset.sql_lab:Query 8: <class 'AttributeError'>
clickhouse error: 'NoneType' object has no attribute 'startswith'
2021-07-26 16:51:49,331:WARNING:superset.views.base:clickhouse error: 'NoneType' object has no attribute 'startswith'
The above is the error report log. You can't locate the line where the error is reported. Can you tell me how to print the call chain related to the error report
In addition, the page does not display the correct field name, and the first row of data will be used as the field name
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] lijc210 edited a comment on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
lijc210 edited a comment on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886506222
superset==1.2.0
clickhouse-sqlalchemy 0.1.6
clickhouse://ck_readonly:XXXXXXXXXX@xxx.xxx.xxx.xxx:8123/ads?secure=true
If the data from SQL query contains NULL, an error will be reported

2021-07-26 16:51:49,314:DEBUG:urllib3.connectionpool:http://114.116.224.81:8123 "POST /?query_id=300ae6b2-a582-4280-be3b-8f37cd1f9cea&database=ads HTTP/1.1" 200 None
Query 8: <class 'AttributeError'>
2021-07-26 16:51:49,314:ERROR:superset.sql_lab:Query 8: <class 'AttributeError'>
clickhouse error: 'NoneType' object has no attribute 'startswith'
2021-07-26 16:51:49,331:WARNING:superset.views.base:clickhouse error: 'NoneType' object has no attribute 'startswith'
The above is the error report log. I can't locate the line where the error is reported. Can you tell me how to print the call chain related to the error report
In addition, the page does not display the correct field name, and the first row of data will be used as the field name

--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] lijc210 commented on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
lijc210 commented on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-887542910
@zhaoyongjie
I solved this problem
I used this connection before
clickhouse://ck_readonly:XXXXXXXXXX@xxx.xxx.xxx.xxx:8123/ads?secure=true
Now use this connection,It works normally
clickhouse+native://ck_readonly:XXXXXXXXXX@xxx.xxx.xxx.xxx:9000/ads
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] lijc210 commented on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
lijc210 commented on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886512805
CK version 21.3.14.1
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] lijc210 edited a comment on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
lijc210 edited a comment on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886506222
superset==1.2.0
clickhouse-sqlalchemy 0.1.6
clickhouse://ck_readonly:XXXXXXXXXX@xxx.xxx.xxx.xxx:8123/ads?secure=true
If the data from SQL query contains NULL, an error will be reported

2021-07-26 16:51:49,314:DEBUG:urllib3.connectionpool:http://114.116.224.81:8123 "POST /?query_id=300ae6b2-a582-4280-be3b-8f37cd1f9cea&database=ads HTTP/1.1" 200 None
Query 8: <class 'AttributeError'>
2021-07-26 16:51:49,314:ERROR:superset.sql_lab:Query 8: <class 'AttributeError'>
clickhouse error: 'NoneType' object has no attribute 'startswith'
2021-07-26 16:51:49,331:WARNING:superset.views.base:clickhouse error: 'NoneType' object has no attribute 'startswith'
The above is the error report log. You can't locate the line where the error is reported. Can you tell me how to print the call chain related to the error report
In addition, the page does not display the correct field name, and the first row of data will be used as the field name

--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] zhaoyongjie commented on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886395952
@lijc210, Please fill up the origianl issue template. How to reproduce this issue? How do you config Clickhouse? How do you connect from Superset to Clickhouse?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] lijc210 edited a comment on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
lijc210 edited a comment on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886506222
superset==1.2.0
clickhouse-sqlalchemy 0.1.6
clickhouse://ck_readonly:XXXXXXXXXX@xxx.xxx.xxx.xxx:8123/ads?secure=true
If the data from SQL query contains NULL, an error will be reported
clickhouse error: 'NoneType' object has no attribute 'startswith'
In addition, the page does not display the correct field name, and the first row of data will be used as the field name
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] lijc210 edited a comment on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
lijc210 edited a comment on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886506222
superset==1.2.0
clickhouse-sqlalchemy 0.1.6
clickhouse://ck_readonly:XXXXXXXXXX@xxx.xxx.xxx.xxx:8123/ads?secure=true
If the data from SQL query contains Null, an error will be reported
clickhouse error: 'NoneType' object has no attribute 'startswith'
In addition, the page does not display the correct field name, and the first row of data will be used as the field name
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] junlincc closed issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
junlincc closed issue #15892:
URL: https://github.com/apache/superset/issues/15892
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] lijc210 edited a comment on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
lijc210 edited a comment on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886506222
superset==1.2.0
clickhouse-sqlalchemy 0.1.6
clickhouse://ck_readonly:XXXXXXXXXX@xxx.xxx.xxx.xxx:8123/ads?secure=true
If the data from SQL query contains NULL, an error will be reported

2021-07-26 16:51:49,314:DEBUG:urllib3.connectionpool:http://114.116.224.81:8123 "POST /?query_id=300ae6b2-a582-4280-be3b-8f37cd1f9cea&database=ads HTTP/1.1" 200 None
Query 8: <class 'AttributeError'>
2021-07-26 16:51:49,314:ERROR:superset.sql_lab:Query 8: <class 'AttributeError'>
clickhouse error: 'NoneType' object has no attribute 'startswith'
2021-07-26 16:51:49,331:WARNING:superset.views.base:clickhouse error: 'NoneType' object has no attribute 'startswith'
The above is the error report log. I can't locate the line where the error is reported. Can you tell me how to print the call chain related to the error report,I want to fix this bug quickly
In addition, the page does not display the correct field name, and the first row of data will be used as the field name

--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] lijc210 commented on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
lijc210 commented on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886506222
superset==1.2.0
clickhouse-sqlalchemy 0.1.6
clickhouse://ck_readonly:XXXXXXXXXX@xxx.xxx.xxx.xxx:8123/ads?secure=true
If the data from SQL query contains none, an error will be reported
clickhouse error: 'NoneType' object has no attribute 'startswith'
In addition, the page does not display the correct field name, and the first row of data will be used as the field name
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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] [superset] zhaoyongjie commented on issue #15892: clickhouse error: 'NoneType' object has no attribute 'startswith'
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #15892:
URL: https://github.com/apache/superset/issues/15892#issuecomment-886508709
Which version of CK are you using?
On Mon, Jul 26, 2021 at 4:48 PM sampan ***@***.***> wrote:
> superset==1.2.0
> clickhouse-sqlalchemy 0.1.6
>
> ***@***.***:8123/ads?secure=true
>
> If the data from SQL query contains none, an error will be reported
>
> clickhouse error: 'NoneType' object has no attribute 'startswith'
>
> In addition, the page does not display the correct field name, and the
> first row of data will be used as the field name
>
> —
> You are receiving this because you commented.
> Reply to this email directly, view it on GitHub
> <https://github.com/apache/superset/issues/15892#issuecomment-886506222>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AAPMKURKL4F5QEYUU5LGA53TZUOMXANCNFSM5A7JJN3A>
> .
>
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
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