great thanks!!

On 21/04/15 12:35 pm, Rajat Khandelwal wrote:
This issue is somewhat related to LENS-198. I'm picking that up for 2.2. Will try to cover your scenario as well.

On Tue, Apr 21, 2015 at 11:11 AM Rajat Khandelwal <[email protected] <mailto:[email protected]>> wrote:

    Hi Pranav

    This issue doesn't cover your requirement. I'll update it in a
    short while. Let's follow up on dev.

    That said, I think the best approach here would be to run a custom
    partitioner on your data and partition it by at least year (or a
    finer granularity if it suits you), and then try queries. I'm
    assuming there is on time column on which you can partition. This
    approach would allow lens to restrict the data processed for a
    single query. And since the time column is already there, you can
    add extra conditions in the where clause for that column.

    You can choose to not run any partitioner, register a dummy time
    partition, pass that dummy value in the query's time_range_in
    clause and keep extra where conditions in the query.

    Regarding this, maybe we can park a ticket for lens to add the
    extra where clauses in case the finer granularity partitions don't
    exist. e.g. partitions are only on YEARLY level and time range
    queried is June to August, in that case lens should choose the
    partition of the particular year and add additional where
    conditions to comply with the restriction of June to August. Right
    now it'll fail saying no update periods for given range.

    Thoughts?


    On Tue, Apr 21, 2015 at 10:11 AM Pranav Kumar Agarwal
    <[email protected] <mailto:[email protected]>> wrote:

        Hi Rajat,

        I hope you are doing well.

        Can you please update the Jira LENS-451 with more details.

        I was wondering if there is a fact that has multiple years of
        data, however its not partitioned, then to be able to query it
        we might have to add artificial partitions. Is this issue to
        support no partitions and still make it queryable?

        If you can please provide more details in the Jira for this
        bug and if it doesn't matches to what I'm looking for then
        I'll followup in dev mailing list.

        Regards,
        -Pranav.


        -------- Forwarded Message --------
        Subject:        [jira] [Updated] (LENS-451) Make choosing of
        timeline implementation configurable via xml
        Date:   Mon, 20 Apr 2015 16:57:59 +0000 (UTC)
        From:   Amareshwari Sriramadasu (JIRA) <[email protected]>
        <mailto:[email protected]>
        Reply-To:       [email protected]
        <mailto:[email protected]>
        To:     [email protected]
        <mailto:[email protected]>



              
[https://issues.apache.org/jira/browse/LENS-451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
  ]

        Amareshwari Sriramadasu updated LENS-451:
        -----------------------------------------
             Issue Type: Improvement  (was: Sub-task)
                 Parent:     (was: LENS-280)

        > Make choosing of timeline implementation configurable via xml
        > -------------------------------------------------------------
        >
        >                 Key: LENS-451
        >                 URL:https://issues.apache.org/jira/browse/LENS-451
        >             Project: Apache Lens
        >          Issue Type: Improvement
        >          Components: cube
        >            Reporter: Rajat Khandelwal
        >            Assignee: Rajat Khandelwal
        >             Fix For: 2.2
        >
        >




        --
        This message was sent by Atlassian JIRA
        (v6.3.4#6332)



Reply via email to