Amruth,
The spec looks fine. I see they are orthogonal to prepared queries, but
should be documented well for user to understand. Please go ahead and
create a 'New Feature' jira.
Thanks
Amareshwari
On Mon, Aug 10, 2015 at 3:20 PM, Amruth Sampath <amrut...@flipkart.com>
wrote:
> Hi all,
>
> We are planning to take up saved queries and parameterisation use case in
> lens. First of all I would like to know if there is any WIP item towards
> this.
>
> We have identified a bunch of use cases -
>
> - User should be able to save a query parameterising parts of it.
> - User should be able to list all saved queries that are created by him and
> shared with him.
> - User should be able to share a query with other people with privileges.
> - User should be able to execute a saved query if his privilege allows
> (READ, EXECUTE).
> - User should be able to clone a saved query (READ).
> *Additional use-cases *
> - User should be able to choose from a list of values to resolve a
> parameter.
> Eg. there could be a parameter called 'city_name'. The ad-hoc query UI can
> probably show the list of values for the city to help resolving the
> parameter. All user might have to do is at the time of saving a query, he
> can optionally associate the parameter with a dimension level.
>
> *Parameterisation :*
>
> Parameterisation can be applicable to various clauses
> *- where *:
> select col1 from table *where col=$(param_name); *
> select col2 from table where *time_range between now,
> now-$(last_n_days_param)*
> *- groupBy :*
> select *$(group_by_col)*, sum(measure) from table group by
> *$(group_by_col)*
> *- orderBy : *
> select col1, col2 from table *order by $(order_by_col)* ASC
> *- orderByType : *
> select col1, col2 from table *order by col1 $(order_by_type)*
> *- limit : *
> select col1, col2 from table order by col1 ASC
> *limit ${no_of_rows}*
>
> Let us know your thoughts and suggestions around this.
>
> Thanks,
> --
> Amruth S
> (09486075517)
>
> --
>
>
>
> ------------------------------------------------------------------------------------------------------------------------------------------
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the system manager.
> This message contains confidential information and is intended only for the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and
> delete this e-mail from your system. If you are not the intended recipient
> you are notified that disclosing, copying, distributing or taking any
> action in reliance on the contents of this information is strictly
> prohibited. Although Flipkart has taken reasonable precautions to ensure no
> viruses are present in this email, the company cannot accept responsibility
> for any loss or damage arising from the use of this email or attachments
>
