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 2023/01/03 20:38:32 UTC

[GitHub] [superset] stephanclaus opened a new issue, #22574: Filter for datetime value returns "Cannot compile Column object until its 'name' is assigned."

stephanclaus opened a new issue, #22574:
URL: https://github.com/apache/superset/issues/22574

A clear and concise description of what the bug is.

#### How to reproduce the bug

1. Build a chart on a data set that contains a datetime column
2. Add this chart to a dashboard
3. add a dashboard filter on the datetime column
4. apply the filter
5. See error

### Expected results

the chart is filtered by the value

### Actual results

An error is raised:

Cannot compile Column object until its 'name' is assigned.

This may be triggered by:
Issue 1011 - Superset encountered an unexpected error.

#### Screenshots

### Environment

(please complete the following information):

- Chrome Version 108.0.5359.124 (Official Build) (x86_64)
- superset version: `2.0.0`
- connecting to snowflake database

### Checklist

Make sure to follow these steps before submitting your issue - thank you!

- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.

### Additional context

Superset 2.0.0 and snowflake/sqlalchemy seems to have more problems with date time handling. The same approach is working fine if the filter column is a date field.

--
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.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 #22574: Filter for datetime value returns "Cannot compile Column object until its 'name' is assigned."

Posted by "zhaoyongjie (via GitHub)" <gi...@apache.org>.

zhaoyongjie commented on issue #22574:
URL: https://github.com/apache/superset/issues/22574#issuecomment-1404910585

   Hi @stephanclaus, I can't reproduce this issue when I use `orders` table on the TPCH in the Snowflaks. Would you mind adding more details for our reproduce it.
   
   <img width="1265" alt="image" src="https://user-images.githubusercontent.com/2016594/214831410-3666424d-1cc5-4d5f-bfde-89d37dd4b07d.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] villebro commented on issue #22574: Filter for datetime value returns "Cannot compile Column object until its 'name' is assigned."

Posted by "villebro (via GitHub)" <gi...@apache.org>.

villebro commented on issue #22574:
URL: https://github.com/apache/superset/issues/22574#issuecomment-1405456538

   Closed by #22872


-- 
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] villebro closed issue #22574: Filter for datetime value returns "Cannot compile Column object until its 'name' is assigned."

Posted by "villebro (via GitHub)" <gi...@apache.org>.

villebro closed issue #22574: Filter for datetime value returns "Cannot compile Column object until its 'name' is assigned."
URL: https://github.com/apache/superset/issues/22574


-- 
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] michael-s-molina commented on issue #22574: Filter for datetime value returns "Cannot compile Column object until its 'name' is assigned."

Posted by "michael-s-molina (via GitHub)" <gi...@apache.org>.

michael-s-molina commented on issue #22574:
URL: https://github.com/apache/superset/issues/22574#issuecomment-1404533789

   @geido @kgabryje This may be related to the bug we were investigating with drill to detail and Snowflake.


-- 
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 #22574: Filter for datetime value returns "Cannot compile Column object until its 'name' is assigned."

Posted by "zhaoyongjie (via GitHub)" <gi...@apache.org>.

zhaoyongjie commented on issue #22574:
URL: https://github.com/apache/superset/issues/22574#issuecomment-1405015770

   yes, it does. `o_orderdate` is a DateTime column in standard TPCH.


-- 
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] stephanclaus commented on issue #22574: Filter for datetime value returns "Cannot compile Column object until its 'name' is assigned."

Posted by "stephanclaus (via GitHub)" <gi...@apache.org>.

stephanclaus commented on issue #22574:
URL: https://github.com/apache/superset/issues/22574#issuecomment-1404934258

   Hi, so the column you are using the the order_date column? Is this a datetime data type actually? 


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