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
   ![微信截图_20210726165241](https://user-images.githubusercontent.com/10651081/126962083-56d75e91-4fb8-4ea2-aede-e1c69ac61d09.png)
   
   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
   ![微信截图_20210726165241](https://user-images.githubusercontent.com/10651081/126962083-56d75e91-4fb8-4ea2-aede-e1c69ac61d09.png)
   
   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
   
   ![微信图片_20210726170029111](https://user-images.githubusercontent.com/10651081/126963049-46f98f21-1c99-4f50-88ec-5aaafc27aa2b.png)
   
   
   
   
   


-- 
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
   ![微信截图_20210726165241](https://user-images.githubusercontent.com/10651081/126962083-56d75e91-4fb8-4ea2-aede-e1c69ac61d09.png)
   
   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
   ![微信图片_20210726170029111](https://user-images.githubusercontent.com/10651081/126963049-46f98f21-1c99-4f50-88ec-5aaafc27aa2b.png)
   
   
   
   
   


-- 
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
   ![微信截图_20210726165241](https://user-images.githubusercontent.com/10651081/126962083-56d75e91-4fb8-4ea2-aede-e1c69ac61d09.png)
   
   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
   
   ![微信图片_20210726170029111](https://user-images.githubusercontent.com/10651081/126963049-46f98f21-1c99-4f50-88ec-5aaafc27aa2b.png)
   
   
   
   
   


-- 
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