Apache Drill and missing add Criteria on Microsoft Query

2016-01-23 Thread Paolo Spanevello 
Dear all,
i'm drilling with ODBC on microsoft Excel and I need to add criteria like
in the link above:

https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed

How is this possible enable?

Best regards,
Paolo

Re: Apache Drill and missing add Criteria on Microsoft Query

2016-02-06 Thread Paolo Spanevello 
Dear All,

nobody as an answer about it. this feature could be really helpful.

Best,
Paolo


Dear all,
i'm drilling with ODBC on microsoft Excel and I need to add criteria like
in the link above:

https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed

How is this possible enable?

Best regards,
Paolo

2016-01-23 21:01 GMT+01:00 Paolo Spanevello :

> Dear all,
> i'm drilling with ODBC on microsoft Excel and I need to add criteria like
> in the link above:
>
>
> https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
>
> How is this possible enable?
>
> Best regards,
> Paolo
>

Re: Apache Drill and missing add Criteria on Microsoft Query

2016-02-14 Thread Paolo Spanevello 
Dear All,

this feature could be really helpful.

I add this image to help to understand what I would like to say.

[image: Immagine incorporata 1]


Best,
Paolo

2016-02-06 17:54 GMT+01:00 Paolo Spanevello :

> Dear All,
>
> nobody as an answer about it. this feature could be really helpful.
>
> Best,
> Paolo
>
>
> Dear all,
> i'm drilling with ODBC on microsoft Excel and I need to add criteria like
> in the link above:
>
>
> https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
>
> How is this possible enable?
>
> Best regards,
> Paolo
>
> 2016-01-23 21:01 GMT+01:00 Paolo Spanevello :
>
>> Dear all,
>> i'm drilling with ODBC on microsoft Excel and I need to add criteria like
>> in the link above:
>>
>>
>> https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
>>
>> How is this possible enable?
>>
>> Best regards,
>> Paolo
>>
>
>

Re: Apache Drill and missing add Criteria on Microsoft Query

2016-02-14 Thread Andries Engelbrecht 
Pictures don't show on the email list, you may point to a link.


In regards to the original question. The application manages the criteria to be 
inserted in the SQL  to send to Drill via the ODBC driver. Example is that 
MicroStrategy allows you to do FreeForm SQL where you can add criteria that are 
added to the query before sending to Drill. In this case you may want to look 
into the MS Query/Excel features available. This really needs to be managed by 
the application and not the ODBC driver.

The ODBC driver does ship with Drill Explorer to help you do data discovery 
from a more GUI interface, but likely not exactly what you are looking for.

--Andries

> On Feb 14, 2016, at 2:56 AM, Paolo Spanevello  wrote:
> 
> Dear All,
> 
> this feature could be really helpful.
> 
> I add this image to help to understand what I would like to say.
> 
> 
> 
> 
> Best,
> Paolo
> 
> 2016-02-06 17:54 GMT+01:00 Paolo Spanevello  >:
> Dear All,
> 
> nobody as an answer about it. this feature could be really helpful.
> 
> Best,
> Paolo
> 
> 
> Dear all,
> i'm drilling with ODBC on microsoft Excel and I need to add criteria like in 
> the link above:
> 
> https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
>  
> 
> 
> How is this possible enable?
> 
> Best regards,
> Paolo
> 
> 2016-01-23 21:01 GMT+01:00 Paolo Spanevello  >:
> Dear all,
> i'm drilling with ODBC on microsoft Excel and I need to add criteria like in 
> the link above:
> 
> https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
>  
> 
> 
> How is this possible enable?
> 
> Best regards,
> Paolo
> 
>

Re: Apache Drill and missing add Criteria on Microsoft Query

2016-02-14 Thread Paolo Spanevello 
Dear all,
I saw that is not free for the community. Anyway i wrote to the author of
the article below to suggest to develop this feature.
https://www.mapr.com/blog/brief-overview-performance-enhancements-apache-drill-14

Best,
Paolo

2016-02-14 19:20 GMT+01:00 Andries Engelbrecht :

> Pictures don't show on the email list, you may point to a link.
>
>
> In regards to the original question. The application manages the criteria
> to be inserted in the SQL  to send to Drill via the ODBC driver. Example is
> that MicroStrategy allows you to do FreeForm SQL where you can add criteria
> that are added to the query before sending to Drill. In this case you may
> want to look into the MS Query/Excel features available. This really needs
> to be managed by the application and not the ODBC driver.
>
> The ODBC driver does ship with Drill Explorer to help you do data
> discovery from a more GUI interface, but likely not exactly what you are
> looking for.
>
> --Andries
>
> > On Feb 14, 2016, at 2:56 AM, Paolo Spanevello 
> wrote:
> >
> > Dear All,
> >
> > this feature could be really helpful.
> >
> > I add this image to help to understand what I would like to say.
> >
> > 
> >
> >
> > Best,
> > Paolo
> >
> > 2016-02-06 17:54 GMT+01:00 Paolo Spanevello  >:
> > Dear All,
> >
> > nobody as an answer about it. this feature could be really helpful.
> >
> > Best,
> > Paolo
> >
> >
> > Dear all,
> > i'm drilling with ODBC on microsoft Excel and I need to add criteria
> like in the link above:
> >
> >
> https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
> <
> https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
> >
> >
> > How is this possible enable?
> >
> > Best regards,
> > Paolo
> >
> > 2016-01-23 21:01 GMT+01:00 Paolo Spanevello  >:
> > Dear all,
> > i'm drilling with ODBC on microsoft Excel and I need to add criteria
> like in the link above:
> >
> >
> https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
> <
> https://support.office.com/en-us/article/Use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
> >
> >
> > How is this possible enable?
> >
> > Best regards,
> > Paolo
> >
> >
>
>