drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3929) Support the ability to query database tables using external indices
Date Mon, 16 Nov 2015 04:41:10 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15006219#comment-15006219

Aman Sinha commented on DRILL-3929:

Sorry I could not respond sooner .. I was caught up with few other Drill issues.  [~julianhyde],
I am afraid I would have to disagree;  Index selection is part of physical database design
and is a core step in access path selection which occurs at physical planning stage.    Are
you suggesting that relational database systems are wrong in doing that ?  

While some indexes could be modeled as MVs, I don't see how all indexes can be modeled as
such.  Indexes have different physical implementations too: hash index will *not* have collation
whereas a clustered index will. So how can N different physical implementations be modeled
through logical planning ?   

> Support the ability to query database tables using external indices           
> ------------------------------------------------------------------------------
>                 Key: DRILL-3929
>                 URL: https://issues.apache.org/jira/browse/DRILL-3929
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Execution - Relational Operators, Query Planning & Optimization
>            Reporter: Aman Sinha
>            Assignee: Aman Sinha
> This is a placeholder for adding support in Drill to query database tables using external
indices.  I will add more details about the use case and a preliminary design proposal.  

This message was sent by Atlassian JIRA

View raw message