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/10/27 13:54:24 UTC
[GitHub] [superset] farming4rd opened a new issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
farming4rd opened a new issue #17247:
URL: https://github.com/apache/superset/issues/17247
A clear and concise description of what the bug is.
#### How to reproduce the bug
1. clone repository for docker-compose from https://github.com/nielsen-oss/superset and **docker-compose -f <file.yml> -up** (**with condition setting nginx reversproxy**)
2. got to path or cd to helm/superset/ "https://github.com/nielsen-oss/superset/tree/master/helm/superset" and **helm install superset helm/superset/**
3. Activate your jinja context in superset/docker/pythonpath_dev/superset_config.py by adding "ENABLE_TEMPLATE_PROCESSING" : True in dictionary of FEATURE_FLAGS
4. Go to sqllab (with condition we have setting datasets our chart)
5. Create sql with filters for specific coloumn and save chart
6. embed code and adding filter "**&billing_date=2021-09-15**" in url exmpl https://IP_URL/superset/explore/?r=57&standalone=1&height=400&billing_date=2021-09-15 and enter
7. inspect > network > file **data?form_data=** > preview > drop down tab and look row **query: "SELECT**
### Expected results #### Screenshots
resault inspect browser (**different chart but same query**)
from combination\n where billing_date = '2021-09-15') AS virtual_table\nGROUP BY paid_hour,\n
### Actual results#### Screenshots
resault inspect browser (**defferent chart but same query**)
from combination) AS virtual_table\nGROUP BY paid_hour,\n
### Environment
(please complete the following information):
- browser type and version chroome lates
- kubernetes version
Client Version: version.Info{Major:"1", Minor:"19", GitVersion:"v1.19.2", GitCommit:"f5743093fd1c663cb0cbc89748f730662345d44d", GitTreeState:"clean", BuildDate:"2020-09-16T13:41:02Z", GoVersion:"go1.15", Compiler:"gc", Platform:"linux/amd64"}
Server Version: version.Info{Major:"1", Minor:"19", GitVersion:"v1.19.3", GitCommit:"1e11e4a2108024935ecfcb2912226cedeafd99df", GitTreeState:"clean", BuildDate:"2020-10-14T12:41:49Z", GoVersion:"go1.15.2", Compiler:"gc", Platform:"linux/amd64"}
- helm version
version.BuildInfo{Version:"v3.4.0", GitCommit:"7090a89efc8a18f3d8178bf47d2462450349a004", GitTreeState:"clean", GoVersion:"go1.14.10"}
- superset version: `superset 1.3.2`
- python version: `Python 3.7.9`
- any feature flags active: : /app/pythonpathcreated/superset_config.py created templates/_helpers.tpl
- FEATURE_FLAGS = {
"DYNAMIC_PLUGINS": True,
"ENABLE_TEMPLATE_PROCESSING": True
}
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [v] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [v] I have reproduced the issue with at least the latest released version of superset.
- [v] I have checked the issue tracker for the same issue and I haven't found one similar.
--
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] farming4rd commented on issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd commented on issue #17247:
URL: https://github.com/apache/superset/issues/17247#issuecomment-958641576
done, i create my own superset-deployment, and run well
--
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] farming4rd commented on issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd commented on issue #17247:
URL: https://github.com/apache/superset/issues/17247#issuecomment-958641576
done, i create my own superset-deployment, and run well
--
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] farming4rd closed issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd closed issue #17247:
URL: https://github.com/apache/superset/issues/17247
--
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] farming4rd commented on issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd commented on issue #17247:
URL: https://github.com/apache/superset/issues/17247#issuecomment-958641576
done, i create my own superset-deployment, and run well
--
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] farming4rd closed issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd closed issue #17247:
URL: https://github.com/apache/superset/issues/17247
--
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] farming4rd commented on issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd commented on issue #17247:
URL: https://github.com/apache/superset/issues/17247#issuecomment-958641576
done, i create my own superset-deployment, and run well
--
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] farming4rd closed issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd closed issue #17247:
URL: https://github.com/apache/superset/issues/17247
--
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] farming4rd commented on issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd commented on issue #17247:
URL: https://github.com/apache/superset/issues/17247#issuecomment-954628990
> @farming4rd please add a redacted copy of your original query including the jinja expression. Also, it is very helpful if you can create a reproducible example using the example datasets/charts/dashboards.
hear my original query
{% if url_param('target_date') != None %}
{% set selected_date = url_param('target_date') %}
{% else %}
{% set selected_date = "" %}
{% endif %}
with planned_bookings as (
select scp.br_code, scp.br_name, scp.cl_code, scp.cl_name,
to_char(scp.target_date, 'YYYY-MM-DD') as target_date, scp.start_time, scp.end_time,
scp.target_sum as plan_book, scp.target_amount as plan_amount
from superset_schema.sic_collection_plan scp
order by scp.br_name, scp.cl_name, scp.target_date, scp.start_time
)
{% if selected_date != "" %}
select * from planned_bookings
where target_date = '{{selected_date}}'
{% else %}
select * from planned_bookings
{% endif %}
thank you v@villebro
--
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 #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #17247:
URL: https://github.com/apache/superset/issues/17247#issuecomment-954531791
@farming4rd please add a redacted copy of your original query including the jinja expression. Also, it is very helpful if you can create a reproducible example using the example datasets/charts/dashboards.
--
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] farming4rd closed issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd closed issue #17247:
URL: https://github.com/apache/superset/issues/17247
--
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] farming4rd edited a comment on issue #17247: Unable to Use Jinja Filters for a Specific Column in k8s with helm template but running well with docker.
Posted by GitBox <gi...@apache.org>.
farming4rd edited a comment on issue #17247:
URL: https://github.com/apache/superset/issues/17247#issuecomment-954628990
> @farming4rd please add a redacted copy of your original query including the jinja expression. Also, it is very helpful if you can create a reproducible example using the example datasets/charts/dashboards.
hear my original query
```
{% if url_param('target_date') != None %}
{% set selected_date = url_param('target_date') %}
{% else %}
{% set selected_date = "" %}
{% endif %}
with planned_bookings as (
select scp.br_code, scp.br_name, scp.cl_code, scp.cl_name,
to_char(scp.target_date, 'YYYY-MM-DD') as target_date, scp.start_time, scp.end_time,
scp.target_sum as plan_book, scp.target_amount as plan_amount
from superset_schema.sic_collection_plan scp
order by scp.br_name, scp.cl_name, scp.target_date, scp.start_time
)
{% if selected_date != "" %}
select * from planned_bookings
where target_date = '{{selected_date}}'
{% else %}
select * from planned_bookings
{% endif %}
```
thank you v@villebro
--
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